On Tue, Feb 16, 2016 at 11:44:30AM +0100, Christian Loos wrote: > I think the reason for your problems are your wrong upgrade steps. > You missed to read this: > > https://www.bestpractical.com/docs/rt/4.2/UPGRADING.mysql.html > > You have to upgrade to 3.7.87, then run the queries from > upgrade-mysql-schema.pl, and then upgrade to 4.2.12.
Ok, I missed this point. I retry with the following steps, but this does not fix this issue: a/ mysqladmin create rt4 b/ mysql --default-character-set=binary rt4 < /var/tmp/rt3-hex-bin.sql c/ /usr/local/sbin/rt-setup-database --action upgrade --datadir /usr/local/share/doc/rt42/upgrade --upgrade-from 3.6.5 --upgrade-to 3.7.87 |& tee /tmp/upgrade1.trace => no error or warning d/ perl /usr/local/share/doc/rt42/upgrade/upgrade-mysql-schema.pl rt4 > /var/tmp/queries.sql mysql rt4 < /var/tmp/queries.sql e/ /usr/local/sbin/rt-setup-database --action upgrade --datadir /usr/local/share/doc/rt42/upgrade --upgrade-from 3.7.87 |& tee /tmp/upgrade2.trace On this step I got many warnings and errors that I don't understand . f/ perl /usr/local/share/doc/rt42/upgrade/upgrade-articles g/ perl /usr/local/share/doc/rt42/upgrade/vulnerable-passwords --fix And at the end, the rt root account still has lost its admin privileges. An other weird thing is that during the "Processing 3.8.0" and before "Processing 3.8.1" there are warnings and errors from upgrade/3.9.1/... and upgrade/4.1.5/... directories. How can I fix this issue and what did I do wrong this time ? Warnings/Errors from step e/ : Proceed [y/N]:Processing 3.8.0 [25052] [Mon Feb 22 15:10:46 2016] [warning]: Going to add [OLD] prefix to all templates in approvals queue. If you have never used approvals, you can safely delete all the templates with the [OLD] prefix. Leave the new Approval templates because you may eventually want to start using approvals. (/usr/local/share/doc/rt42/upgrade/3.8.2/content:16) [25052] [Mon Feb 22 15:10:46 2016] [warning]: IMPORTANT: We're going to delete all scrips in Approvals queue and save them in 'rt-approvals-scrips-8ME7' file. (/usr/local/share/doc/rt42/upgrade/3.8.2/content:191) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Couldn't validate right name 'ExecuteCode' for object of RT::System class (/usr/local/lib/perl5/site_perl/RT/ACE.pm:254) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Unable to grant ExecuteCode on principal 30: Invalid right (/usr/local/share/doc/rt42/upgrade/3.9.1/content:63) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Couldn't validate right name 'ExecuteCode' for object of RT::System class (/usr/local/lib/perl5/site_perl/RT/ACE.pm:254) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Unable to grant ExecuteCode on principal 29: Invalid right (/usr/local/share/doc/rt42/upgrade/3.9.1/content:63) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Couldn't validate right name 'ExecuteCode' for object of RT::System class (/usr/local/lib/perl5/site_perl/RT/ACE.pm:254) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Unable to grant ExecuteCode on principal 32: Invalid right (/usr/local/share/doc/rt42/upgrade/3.9.1/content:63) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Couldn't validate right name 'ExecuteCode' for object of RT::System class (/usr/local/lib/perl5/site_perl/RT/ACE.pm:254) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Unable to grant ExecuteCode on principal 31: Invalid right (/usr/local/share/doc/rt42/upgrade/3.9.1/content:63) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Couldn't validate right name 'ExecuteCode' for object of RT::System class (/usr/local/lib/perl5/site_perl/RT/ACE.pm:254) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Unable to grant ExecuteCode on principal 9: Invalid right (/usr/local/share/doc/rt42/upgrade/3.9.1/content:63) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Couldn't validate right name 'ExecuteCode' for object of RT::System class (/usr/local/lib/perl5/site_perl/RT/ACE.pm:254) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Unable to grant ExecuteCode on principal 8: Invalid right (/usr/local/share/doc/rt42/upgrade/3.9.1/content:63) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Couldn't validate right name 'ExecuteCode' for object of RT::System class (/usr/local/lib/perl5/site_perl/RT/ACE.pm:254) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Unable to grant ExecuteCode on principal 6: Invalid right (/usr/local/share/doc/rt42/upgrade/3.9.1/content:63) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Couldn't validate right name 'ExecuteCode' for object of RT::System class (/usr/local/lib/perl5/site_perl/RT/ACE.pm:254) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Unable to grant ExecuteCode on principal 30: Invalid right (/usr/local/share/doc/rt42/upgrade/3.9.1/content:63) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Couldn't validate right name 'ExecuteCode' for object of RT::System class (/usr/local/lib/perl5/site_perl/RT/ACE.pm:254) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Unable to grant ExecuteCode on principal 29: Invalid right (/usr/local/share/doc/rt42/upgrade/3.9.1/content:63) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Couldn't validate right name 'ExecuteCode' for object of RT::System class (/usr/local/lib/perl5/site_perl/RT/ACE.pm:254) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Unable to grant ExecuteCode on principal 32: Invalid right (/usr/local/share/doc/rt42/upgrade/3.9.1/content:63) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Couldn't validate right name 'ExecuteCode' for object of RT::System class (/usr/local/lib/perl5/site_perl/RT/ACE.pm:254) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Unable to grant ExecuteCode on principal 31: Invalid right (/usr/local/share/doc/rt42/upgrade/3.9.1/content:63) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Couldn't validate right name 'ExecuteCode' for object of RT::System class (/usr/local/lib/perl5/site_perl/RT/ACE.pm:254) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Unable to grant ExecuteCode on principal 9: Invalid right (/usr/local/share/doc/rt42/upgrade/3.9.1/content:63) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Couldn't validate right name 'ExecuteCode' for object of RT::System class (/usr/local/lib/perl5/site_perl/RT/ACE.pm:254) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Unable to grant ExecuteCode on principal 8: Invalid right (/usr/local/share/doc/rt42/upgrade/3.9.1/content:63) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Couldn't validate right name 'ExecuteCode' for object of RT::System class (/usr/local/lib/perl5/site_perl/RT/ACE.pm:254) [25052] [Mon Feb 22 15:10:46 2016] [warning]: Unable to grant ExecuteCode on principal 6: Invalid right (/usr/local/share/doc/rt42/upgrade/3.9.1/content:63) [25052] [Mon Feb 22 15:10:50 2016] [error]: We found RTFM tables in your database. Checking for content. (/usr/local/share/doc/rt42/upgrade/3.9.8/content:17) [25052] [Mon Feb 22 15:10:50 2016] [error]: You appear to have RTFM Articles. You can upgrade using the /opt/rt4/etc/upgrade/upgrade-articles script. Read more about it in docs/UPGRADING-4.0 (/usr/local/share/doc/rt42/upgrade/3.9.8/content:22) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'AdminAllPersonalGroups' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'AdminAllPersonalGroups' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'AdminAllPersonalGroups' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'AdminAllPersonalGroups' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'AdminAllPersonalGroups' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'AdminAllPersonalGroups' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'AdminAllPersonalGroups' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'AdminAllPersonalGroups' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'AdminAllPersonalGroups' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'AdminAllPersonalGroups' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'AdminAllPersonalGroups' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'AdminAllPersonalGroups' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'AdminOwnPersonalGroups' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'AdminOwnPersonalGroups' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'AdminOwnPersonalGroups' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'AdminOwnPersonalGroups' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'AdminOwnPersonalGroups' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'AdminOwnPersonalGroups' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'AdminOwnPersonalGroups' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'AdminOwnPersonalGroups' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'AdminOwnPersonalGroups' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'AdminOwnPersonalGroups' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'AdminOwnPersonalGroups' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'AdminOwnPersonalGroups' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456)[25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'DelegateRights' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'DelegateRights' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'DelegateRights' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'DelegateRights' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'DelegateRights' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'DelegateRights' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'DelegateRights' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'DelegateRights' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'DelegateRights' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'DelegateRights' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'DelegateRights' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:50 2016] [error]: Invalid right. Couldn't canonicalize right 'DelegateRights' (/usr/local/lib/perl5/site_perl/RT/ACE.pm:456) [25052] [Mon Feb 22 15:10:52 2016] [error]: Scrip #2 has template set to #3, but it's not in DB, setting it 'Blank' (/usr/local/share/doc/rt42/upgrade/4.1.5/content:22) [25052] [Mon Feb 22 15:10:52 2016] [error]: Scrip #4 has template set to #3, but it's not in DB, setting it 'Blank' (/usr/local/share/doc/rt42/upgrade/4.1.5/content:22) [25052] [Mon Feb 22 15:10:55 2016] [info]: Going to delete all SMIMEKeyNotAfter attributes (/usr/local/share/doc/rt42/upgrade/4.1.22/content:61) Now inserting data. Processing 3.8.1 Now inserting data. Processing 3.8.2 Now inserting data. ... no more warning/error after. Regards, -- Laurent Frigault | Free.org --------- RT 4.4 and RTIR Training Sessions (http://bestpractical.com/services/training.html) * Hamburg Germany - March 14 & 15, 2016 * Washington DC - May 23 & 24, 2016
