[rt-users] RT 3.6.1 install question

[Andrew Nicols]

On 9/7/06, Frank Saxton <frankie at easyrider.com> wrote:
>
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20060907/a4cde40c/attachment.htm>