[rt-users] Upgrade to 4.01 MySQL questoin

Tue Aug 9 15:27:03 EDT 2011

Thaks Kevin,

I missed that in the output.  Most of it seems OK up until the part where it
processesd 3.9.2 and 3.9.3.:

Processing 3.9.2
Now inserting data.
[Tue Aug  9 02:42:25 2011] [warning]: DBD::mysql::st execute failed: Unknown
column 'main.DelegatedBy' in 'where clause' at
/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 509, <> line
1. (/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:509)
[Tue Aug  9 02:42:25 2011] [warning]: RT::Handle=HASH(0x31c8f18) couldn't
execute the query 'SELECT main.* FROM ACL main  WHERE (main.DelegatedBy >
'0') AND (main.DelegatedFrom > '0') ' at
/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 522
    DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x31c8f18)',
'SELECT main.* FROM ACL main  WHERE (main.DelegatedBy > \'0\')...') called
at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder.pm line 235
    DBIx::SearchBuilder::_DoSearch('RT::ACL=HASH(0x5021070)') called at
/opt/rt4/sbin/../lib/RT/SearchBuilder.pm line 320
    RT::SearchBuilder::_DoSearch('RT::ACL=HASH(0x5021070)') called at
/opt/rt4/sbin/../lib/RT/ACL.pm line 260
    RT::ACL::_DoSearch('RT::ACL=HASH(0x5021070)') called at
/usr/local/share/perl/5.10.1/DBIx/SearchBuilder.pm line 503
    DBIx::SearchBuilder::Next('RT::ACL=HASH(0x5021070)') called at
/opt/rt4/sbin/../lib/RT/ACL.pm line 225
    RT::ACL::Next('RT::ACL=HASH(0x5021070)') called at
./etc/upgrade/3.9.2/content line 19
    RT::Handle::__ANON__() called at /opt/rt4/sbin/../lib/RT/Handle.pm line
767
    eval {...} called at /opt/rt4/sbin/../lib/RT/Handle.pm line 767
    RT::Handle::InsertData('RT::Handle=HASH(0x31c8f18)',
'./etc/upgrade/3.9.2/content', undef) called at
/opt/rt4/sbin/rt-setup-database line 292
    main::action_insert('prompt-for-dba-password', 1, 'datafile', undef,
'action', 'upgrade', 'datadir', './etc/upgrade/3.9.2', 'backcompat', ...)
called at /opt/rt4/sbin/rt-setup-database line 398
    main::action_upgrade('prompt-for-dba-password', 1, 'action', 'upgrade',
'dba', 'root') called at /opt/rt4/sbin/rt-setup-database line 197
(/usr/share/perl/5.10/Carp.pm:47)
[Tue Aug  9 02:42:25 2011] [crit]: _DoSearch is not so successful as it
still needs redo search, won't call _BuildHash
(/opt/rt4/sbin/../lib/RT/ACL.pm:263)
Processing 3.9.3
Now populating database schema.
[Tue Aug  9 02:42:25 2011] [crit]: DBD::mysql::st execute failed: Can't DROP
'DelegatedBy'; check that column/key exists at
/opt/rt4/sbin/../lib/RT/Handle.pm line 517. (/opt/rt4/sbin/../lib/RT.pm:340)
DBD::mysql::st execute failed: Can't DROP 'DelegatedBy'; check that
column/key exists at /opt/rt4/sbin/../lib/RT/Handle.pm line 517.

The complete output is here.:
http://www.paulororke.net/files/rt-setup-database.txt

I see 2 critical errors, need I address the warnings first?  I'm not sure
where to go with tis now...

thanks

Paul

On Mon, Aug 8, 2011 at 3:26 PM, Kevin Falcone <falcone at bestpractical.com>
wrote:
>
> On Mon, Aug 08, 2011 at 03:05:53PM -0700, Paul O'Rorke wrote:
> >    I am migrating from 3.8.4 to 4.01. I have a new server with 4.01
installed and mostly set up
> >    how I want. I have pulled my database dumps into the new instance,
performed the steps in
> >    UPGRADING.mysql and run the script
> >    /opt/rt4/sbin/rt-setup-database --prompt-for-dba-password --action
upgrade
> >
> >    I've missed something and I'm sure I saw it when reading the docs but
now can't figure out
> >    what I missed. After tweaking my set up I've tried restoring from
last nights 3.8.4 instance
> >    mysqldump and I have to manually set the passwords in MySQL to log in
as the RT user. For
> >    example:
> >    UPDATE Users SET Password=md5('password') WHERE Name='user';
> >
> >    This lets the user log in - but only once, after a logout the user
cannot again log in. I
> >    believe there was a change in the hash used for passwords and that
there is a script I need to
> >    run to fix this but I cannot for the life of me find this again.
> >
> >    Am I on the right track and what can I tell you to help figure out
what I missed?
>
> It appears you didn't successfully complete the
>    /opt/rt4/sbin/rt-setup-database --prompt-for-dba-password --action
upgrade
> step, since it will change the size of your Users.Password field (among
lots
> of other changes).  There is also a script to rehash your user
> passwords which was included in our security updates and is documented
> in docs/UPGRADING-3.8, but this bug is more likely to be related to an
> incomplete database upgrade.
>
> -kevin
>
>
> --------
> 2011 Training: http://bestpractical.com/services/training.html
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110809/d5f53102/attachment.htm>