[rt-users] MySQL upgrade to 4.0

[Jim Goss]

Hello all,

OK, so I got RT up and running on my Fedora box OK, but was getting
periodic HTTP 500 errors when using the site (about 1 in 5 or 7 hits).
I reviewed the docs and saw that mysql 4.0 was the required version and
fedora was using an older version.  So I installed 4.0 and recompiled
DBD::mysql all successfully.

However, upon restarting mysql then visiting my RT webpage I get a 500
error and my apache error_log shows:

DBI connect('dbname=rt3;host=localhost','rt_user',...) failed: Can't
connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
(2) at /usr/lib/perl5/site_perl/5.8.1/DBIx/SearchBuilder/Handle.pm line
132
[Wed Feb 18 13:54:30 2004] [error] Connect Failed Can't connect to local
MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
 at /opt/rt3/lib/RT.pm line 149


Apparently, the new mysql is using /tmp/mysql.sock instead of
/var/lib/mysql/mysql.sock.  So, for kicks I tried creating a softlink
for /var/lib/mysql/mysql.sock to /tmp/mysql.sock.  However, this either
doesn't work, or there is now some other problem:


DBI connect('dbname=rt3;host=localhost','rt_user',...) failed: Access
denied for user: 'rt_user at localhost' (Using password: YES) at
/usr/lib/perl5/site_perl/5.8.1/DBIx/SearchBuilder/Handle.pm line 132
[Wed Feb 18 13:59:56 2004] [error] Connect Failed Access denied for
user: 'rt_user at localhost' (Using password: YES)
 at /opt/rt3/lib/RT.pm line 149


The user rt_user is properly configured in mysql, as I can log in
manually as that user and navigate the rt3 database.

Does anyone have any thoughts?

Thanks,

Jim Goss
Director of Network Operations
Privacy, Inc.