[rt-users] Upgrading DB for RT-3.2.2

leon at iwa-solutions.com leon at iwa-solutions.com
Mon Jan 3 17:35:20 EST 2005

I want to clairfy this before putting my system in production.  I am 
upgrading from RT-3.0.6 to RT-3.2.2.  No apparent errors in running the 
upgrade.  But at the end are instructions for upgrading the database:
For each item in that directory whose name is greater than
your previously installed RT version, run:
            /usr/local/rt3/sbin/rt-setup-database --dba root 
--prompt-for-dba-password --action schema --datadir etc/upgrade/<version>
            /usr/local/rt3/sbin/rt-setup-database --dba root 
--prompt-for-dba-password --action acl --datadir etc/upgrade/<version>
            /usr/local/rt3/sbin/rt-setup-database --dba root 
--prompt-for-dba-password --action insert --datadir etc/upgrade/<version>

The upgrade direction shows:
ls -l
total 12
drwxrwxr-x  2 1000 1000 4096 Sep 27 13:20 3.1.0
drwxrwxr-x  2 1000 1000 4096 Sep 27 13:20 3.1.15
drwxrwxr-x  2 1000 1000 4096 Sep 27 13:20 3.1.17

This runs just fine for 3.1.0 but fails on 3.1.15.  I tried restarting 
Apache (and thereby RT) but no success.  I can log into the web 
interface.  Doing searches and resolving tickets seems to work.  But the 
instructions seems to imply that I should be running the commands on 3.1.15 
and 3.1.17 also.
The error I get is:
  /usr/local/rt3/sbin/rt-setup-database --dba root 
--prompt-for-dba-password --action schema --datadir etc/upgrade/3.1.15
In order to create a new database and grant RT access to that database,
this script needs to connect to your mysql instance on iwapps6.iwapps.com 
as root.
Please specify that user's database password below. If the user has no database
password, just press return.

Password: Creating database schema.
Couldn't find schema file for mysql
Do I have a error or just a misunderstanding of the instructions?

More information about the rt-users mailing list