[rt-users] RT upgrade problem ver 3.2.1. to 3.4.5

himira ratnatilake hratnatilake at openworld.org
Wed Jul 5 23:53:00 EDT 2006


Hi, 
I manage to do 2 steps of upgrading the pg database. But in the 
"insert" section it gives following errors.
---------------------------------------------------------------------------
#/var/www/localhost/rt/rt-3.4.5/sbin/rt-setup-database --action insert
--datadir /var/www/localhost/rt/rt-3.4.5/upgrade/3.3.0 --dba rtuser

DBD::Pg::st execute failed: ERROR:  permission denied for relation users
RT::Handle=HASH(0x8953f2c) couldn't execute the query 'SELECT  * FROM
Users WHERE LOWER(Name) = LOWER(?)'
at /usr/lib/perl5/vendor_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line
506

DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x8953f2c)',
'SELECT  * FROM Users WHERE LOWER(Name) = LOWER(?)', 'RT_System') called
at /usr/lib/perl5/vendor_perl/5.8.6/DBIx/SearchBuilder/Record.pm line
1218

DBIx::SearchBuilder::Record::_LoadFromSQL('RT::CurrentUser=HASH(0x8b88368)', 'SELECT  * FROM Users WHERE LOWER(Name) = LOWER(?)', 'RT_System') called at /usr/lib/perl5/vendor_perl/5.8.6/DBIx/SearchBuilder/Record.pm line 1133

DBIx::SearchBuilder::Record::LoadByCols('RT::CurrentUser=HASH(0x8b88368)', 'LOWER(Name)', 'HASH(0x8b8844c)') called at /usr/lib/perl5/vendor_perl/5.8.6/DBIx/SearchBuilder/Record/Cachable.pm line 137

DBIx::SearchBuilder::Record::Cachable::LoadByCols('RT::CurrentUser=HASH(0x8b88368)', 'LOWER(Name)', 'HASH(0x8b8844c)') called at //usr/share/webapps/rt/3.4.5/hostroot/rt-3.4.5/lib/RT/Record.pm line 392
        RT::Record::LoadByCols('RT::CurrentUser=HASH(0x8b88368)',
'Name', 'RT_System') called
at /usr/lib/perl5/vendor_perl/5.8.6/DBIx/SearchBuilder/Record.pm line
1078

DBIx::SearchBuilder::Record::LoadByCol('RT::CurrentUser=HASH(0x8b88368)', 'Name', 'RT_System') called at //usr/share/webapps/rt/3.4.5/hostroot/rt-3.4.5/lib/RT/CurrentUser.pm line 254
        RT::CurrentUser::LoadByName('RT::CurrentUser=HASH(0x8b88368)',
'RT_System') called
at //usr/share/webapps/rt/3.4.5/hostroot/rt-3.4.5/lib/RT.pm line 153
        RT::Init() called
at /var/www/localhost/rt/rt-3.4.5/sbin/rt-setup-database line 435

main::insert_data('/var/www/localhost/rt/rt-3.4.5/upgrade/3.3.0/content') called at /var/www/localhost/rt/rt-3.4.5/sbin/rt-setup-database line 100
DBD::Pg::st execute failed: ERROR:  permission denied for relation users
RT::Handle=HASH(0x8953f2c) couldn't execute the query 'SELECT  * FROM
Users WHERE LOWER(Name) = LOWER(?)'
at /usr/lib/perl5/vendor_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line
506

DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x8953f2c)',
'SELECT  * FROM Users WHERE LOWER(Name) = LOWER(?)', 'Nobody') called
at /usr/lib/perl5/vendor_perl/5.8.6/DBIx/SearchBuilder/Record.pm line
1218

DBIx::SearchBuilder::Record::_LoadFromSQL('RT::CurrentUser=HASH(0x8b884dc)', 'SELECT  * FROM Users WHERE LOWER(Name) = LOWER(?)', 'Nobody') called at /usr/lib/perl5/vendor_perl/5.8.6/DBIx/SearchBuilder/Record.pm line 1133

DBIx::SearchBuilder::Record::LoadByCols('RT::CurrentUser=HASH(0x8b884dc)', 'LOWER(Name)', 'HASH(0x8b88524)') called at /usr/lib/perl5/vendor_perl/5.8.6/DBIx/SearchBuilder/Record/Cachable.pm line 137

DBIx::SearchBuilder::Record::Cachable::LoadByCols('RT::CurrentUser=HASH(0x8b884dc)', 'LOWER(Name)', 'HASH(0x8b88524)') called at //usr/share/webapps/rt/3.4.5/hostroot/rt-3.4.5/lib/RT/Record.pm line 392
        RT::Record::LoadByCols('RT::CurrentUser=HASH(0x8b884dc)',
'Name', 'Nobody') called
at /usr/lib/perl5/vendor_perl/5.8.6/DBIx/SearchBuilder/Record.pm line
1078

DBIx::SearchBuilder::Record::LoadByCol('RT::CurrentUser=HASH(0x8b884dc)', 'Name', 'Nobody') called at //usr/share/webapps/rt/3.4.5/hostroot/rt-3.4.5/lib/RT/CurrentUser.pm line 254
        RT::CurrentUser::LoadByName('RT::CurrentUser=HASH(0x8b884dc)',
'Nobody') called
at //usr/share/webapps/rt/3.4.5/hostroot/rt-3.4.5/lib/RT.pm line 157
        RT::Init() called
at /var/www/localhost/rt/rt-3.4.5/sbin/rt-setup-database line 435

main::insert_data('/var/www/localhost/rt/rt-3.4.5/upgrade/3.3.0/content') called at /var/www/localhost/rt/rt-3.4.5/sbin/rt-setup-database line 100
-----------------------------------------------------------------------------

Can anybody guess what may be the problem?

Thanks..
/himira

On Wed, 2006-07-05 at 06:41 +0200, Quentin Garnier wrote:
> On Wed, Jul 05, 2006 at 09:44:04AM +0600, himira ratnatilake wrote:
> > Olnly versions 3.1.0/  3.1.15/ 3.1.17/ 3.3.0/  3.3.11/ are in
> > the /etc/upgrade. No schema/acl for 3.2.1
> > I thought no need of db upgrade, but it seems need to upgrade as
> > when I create new db with rt-3.4.5 it works perfectly, problem
> > comes with the previous db(3.2.1)
> 
> Excerpt from README:
>      For each item in that directory whose name is greater than
>      your previously installed RT version, run:
> 
> 3.2.1 < 3.3.0 < 3.3.11
> 
> The versions listed in that directory are the ones when the database
> schema changed, not anything else.
> 
> > On Tue, 2006-07-04 at 08:43 +0200, Quentin Garnier wrote:
> > > On Tue, Jul 04, 2006 at 10:58:47AM +0600, himira ratnatilake wrote:
> > > > I have tried to upgrade rt from 3.2.1 to 3.4.5 in a gentoo system. I
> > > > didn't change anything on the database. When I try to import the
> > > > previous db it gives so many errors. 
> > > > Then I remove the db and directly import the db. Then rt doesn't work 
> > > > correctly it gives error like  
> > > 
> > > Well, you *do* have to change the database.  Look at the README file,
> > > step 7 of the section "GENERAL INSTALLATION".
> 



CONFIDENTIALITY NOTICE The information contained in this message is
confidential, intended only for the use of the individual or the entity
named as recipient. If the reader of this message is not that recipient,
you are notified that any dissemination, distribution or copy of this
message is strictly prohibited. If you have received this message in
error, please immediately notify us by telephone on the number above.
Your co-operation is appreciated.



More information about the rt-users mailing list