[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