Frank Saxton wrote:
This is my fourth or fifth time installing RT and I see that the
process continues to improve! I have it just about installed thanks
to some really good Wiki instructions. I'm just about done but have a
final question or two.
RT 3.6.1 on RHEL 4.0
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.
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!
_______________________________________________
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
My guess by the error you received is that you aren't providing a
password when one is needed. Instead of trying to run mysqladmin to
drop the database try
shell>mysql -u root -p
Enter Password: ***enter either nothing (just hit 'Enter') if you never
set up a root password or enter the password you created when you
installed MySQL***
mysql> drop database rt3;
See if that works.
Mathew Snyder
_______________________________________________
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