I was confused when it came to setting up the mysql database
stuff. I got error messages because it didn't like the password but
it seems to have gotten over it. /var/lib/mysql/rt3 has what looks
like everything in it but I cannot log in as root. No matter what I
give it, I get a "username or password incorrect" message.
Check the Apache logs to see what it's rejecting on. The default username and password are root/password just in case something's misplaced on the wiki. If you can't log on to a fresh RT install, there may be something missing.
This is not a huge problem (I don't think) because I have 3.0.1
running on another LInux box and what I'd really like to do is just
copy over all of the accounts, tickets, settings, etc from that
environment and put them on the new box.
Someone advised me on how to do this a year or so ago and it was very
simple. So simple, that I've forgotten what to do. I tried a tar of
everything on the only /var/lib/mysql/rt3 onto the new machine but
then I get text instead of the GUI when I try to bring up RT.
I think if someone can just tell what to copy to the new machine to
make it just like the old RT server, I should be good to go. TIA!
If you have a look at the RT Tarball, there are some upgrade instructions. Your best bet is to have a look at the INSTALL file. From memory it's about point 6 or 7 on there.
There are a few changes from 3.0 to 3.6.1 but they're relatively easy to apply. Just a case of running:
% rt-setup-database --datadir /path/to/etc/upgrade/<ver> --dba dbuser --dba-password dbpass --action insert/act/schema
Sadly you've got 6 version updates to do from 3.0, so they'll be something like:
% rt-setup-database --datadir /etc/request-tracker3.6/upgrade/3.1.0 --dba dbuser --dba-password dbpass --action insert
% rt-setup-database --datadir /etc/request-tracker3.6/upgrade/3.1.0 --dba dbuser --dba-password dbpass --action acl
% rt-setup-database --datadir /etc/request-tracker3.6/upgrade/3.1.0 --dba dbuser --dba-password dbpass --action schema
for each folder. The instructions in the INSTALL file explain it a bit better than me.
That's it :)
Obviously, make sure you backup first, but you'll be doing that anyway if you're migrating to a new server.
Good luck,
--
Regards,
Andrew Nicols
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
