On Mon, Apr 27, 2009 at 11:19 AM, Asif Iqbal <vad...@gmail.com> wrote:
>
>
> On Tue, Nov 18, 2008 at 6:33 AM, Tim Cutts <t...@sanger.ac.uk> wrote:
>
>>
>> On 17 Nov 2008, at 10:34 pm, Asif Iqbal wrote:
>>
>> Do I upgrade from RT 3.4.5 to RT 3.8.1 directly? Or there is a roadmap
>>> somewhere?
>>>
>>
>> You can do this in almost one go, yes. It's almost exactly what I'm doing
>> with my production RT, where I'm going from 3.4.2 to 3.8.1
>>
>>
>>> Do I upgrade the mysql 4.0.24 to 4.1 first before upgrading the RT?
>>>
>>
>> Yes. Or at least, here's what I've tested, and seems to work quite well:
>>
>> 1) Set up a new RT box for your new server, so that you can always back
>> out if this goes wrong. On this server, install the new version of MySQL
>> you want to use, and install RT 3.8.1
>>
>> 2) Make a dump of your production MySQL instance, and load it into the
>> new MySQL database.
>>
>> 3) Run the /opt/rt3/sbin/rt-setup-database --action upgrade command as
>> detailed in the RT 3.8.1 README file, but only as far as version 3.8.0
>>
>> 4) Run the MySQL upgrade script, as detailed in UPGRADING.mysql, and
>> apply the SQL statements it wants you to make. This can take a long time;
>> the alter table statements are pretty slow-running.
>>
>> 5) Run the /opt/rt3/sbin/rt-setup-database --action upgrade thing again
>> for the last small changes from 3.8.0 to 3.8.1
>
>
> On my new server (not production yet) the upgrade is failing. I don't want
> to change the ACL on
> the database unless that is harmless, to successfully upgrade
>
> /opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password
> --action upgrade
> In order to create or update your RT database, this script needs to connect
> to your mysql instance on localhost as root
> Please specify that user's database password below. If the user has no
> database
> password, just press return.
>
> Password:
> Working with:
> Type: mysql
> Host: localhost
> Name: rt3
> User: rt_user
> DBA: root
> Enter RT version you're upgrading from: 3.4.5
>
> Going to apply following upgrades:
> * 3.5.1
> * 3.7.1
> * 3.7.3
> * 3.7.10
> * 3.7.15
> * 3.7.19
> * 3.7.81
> * 3.7.82
> * 3.7.85
> * 3.7.86
> * 3.7.87
> * 3.8.0
> * 3.8.1
> * 3.8.2
>
> Enter RT version if you want to stop upgrade at some point,
> or leave it blank if you want apply above upgrades:
>
> IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP
>
> Proceed [y/N]:y
> Processing 3.5.1
> DBI connect('dbname=rt3;host=localhost','rt_user',...) failed: Access
> denied for user 'rt_user'@'localhost' (using password: YES) at
> /opt/csw/share/perl/site_perl/DBIx/SearchBuilder/Handle.pm line 106
> Connect Failed Access denied for user 'rt_user'@'localhost' (using
> password: YES)
> at /opt/rt3/sbin/../lib/RT.pm line 204
>
>
> I can login OK with `mysql -u root -p rt3'
> I failed to login with `mysql -u rt_user -p rt3' using the password I
> have in RT_*Config.pm files (same) for rt_user
>
> The same login attempt works on the original instance of RT (3.4.5)
>
I was experiencing this mysql priv table missing bug
http://bugs.mysql.com/bug.php?id=9934
I needed to run 'mysql_fix_privilege_tables' to fix it and then upgrade is
moving forward again
>
>
>
>>
>>
>> After that, it all seemed to work pretty well.
>>
>> Tim
>>
>>
>> --
>> The Wellcome Trust Sanger Institute is operated by Genome ResearchLimited,
>> a charity registered in England with number 1021457 and acompany registered
>> in England with number 2742969, whose registeredoffice is 215 Euston Road,
>> London, NW1 2BE.
>>
>
>
>
> --
> Asif Iqbal
> PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
> A: Because it messes up the order in which people normally read text.
> Q: Why is top-posting such a bad thing?
>
>
>
--
Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
