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@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@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.