RE: Error: Can't connect to local MySQL server (resolved)

Hi Steven,
On Thu, Sep 25, 2003 at 12:54:07AM -0500, Steven Casey wrote:
Mandrake Linux 9.1 MySQL 4.0.14 Apache1.3.28 (mod_perl 1.x) otrs-1.1.3-01
I've installed otrs several times on different machines and haven't had
this
problem. I'm not sure where to go to fix it. I can plug in the url: http://servername/otrs/installer.pl and I can create the db fine. When I go to index.pl, I get: Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock (2). It's no wonder since I don't have that directory. The /etc/my.cnf only lists /tmp/mysql.sock for both the client and the server. What's happening? Thanks in advance.
http://servername/otrs/installer.pl is using the mysql shell (till OTRS 1.2).
http://servername/otrs/index.pl is using DBD::mysql (Perl DBI driver). In your case it looks like DBD::mysql isn't compiled for your dist. or on your machine. However, it should work if you create an link from /var/lib/mysql/mysql.sock to /tmp/mysql.sock in your filesystem.
Steven Casey Systems Engineer scasey2@tampabay.rr.com
Martin
-- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "The number of Unix installations has grown to 10, with more expected." The Unix Programmer's Manual, 2nd Edition, June 1972
Thanks for the reply Martin, but I think something else is happening. I didn't do anything with the modules (nor did I create any sym links to the mysql.sock) and merely shut the web services down and restarted ( about 7 times), then, for some reason, I got my login screen. That's the good news...the bad news is that I can't login as any user with or without a password.....checking the archives again....
ok, maybe 4:30 in the morning isn't the best time to tackle things, but what I forgot to do was login as suggested with root@localhost/root My problem was my root account has a different password which was what I was trying to use...duh! Once I used the correct login, everything was fine. Maybe for setup, the initial login would default to the root@localhost/root combo? Just a thought.
participants (1)
-
Steven Casey