SQL Socket Error

[Alan Powell]

Hello all

I am a newbie to Linux, Apache and mySQL etc. I am running a standard RH9
build with yum updates. All appears to be working ok except one aspect.
Simple database (indexed 2 table)activity works but on a more sophisticated
existing database accessed through a perl script I get this error (taken
from logs): -

[Tue Apr 27 20:22:52 2004] [error] [client 192.168.0.12] [Tue Apr 27
20:22:52 2004] lbf.cgi: DBI
connect('username_disney:localhost','username_lett uce',...) failed: Can't
connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
(13) at /home/username/public_html/dating/cgi-bin/scripts/new_database.pl
line 6, referer: http://www.awebsite.loc/

I have checked that the daemon is up and all standard checks recommended
from the mySQL site show the socket is connecting ok and for TCP/IP on port
3306 etc....

Any ideas please? Thanks in advance

Alan

[Alan Powell]

By the way, my mysql.sock file is 0 bytes! Is this correct???

"Alan Powell" <al*********@assured-design.com> wrote in message
news:cC***************@fe07.usenetserver.com...

Hello all

I am a newbie to Linux, Apache and mySQL etc. I am running a standard RH9
build with yum updates. All appears to be working ok except one aspect.
Simple database (indexed 2 table)activity works but on a more sophisticated existing database accessed through a perl script I get this error (taken
from logs): -

[Tue Apr 27 20:22:52 2004] [error] [client 192.168.0.12] [Tue Apr 27
20:22:52 2004] lbf.cgi: DBI
connect('username_disney:localhost','username_lett uce',...) failed: Can't
connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
(13) at /home/username/public_html/dating/cgi-bin/scripts/new_database.pl
line 6, referer: http://www.awebsite.loc/

I have checked that the daemon is up and all standard checks recommended
from the mySQL site show the socket is connecting ok and for TCP/IP on port 3306 etc....

Any ideas please? Thanks in advance

Alan

[Alan Powell]

By the way, my mysql.sock file is 0 bytes! Is this correct???

"Alan Powell" <al*********@assured-design.com> wrote in message
news:cC***************@fe07.usenetserver.com...

Hello all

I am a newbie to Linux, Apache and mySQL etc. I am running a standard RH9
build with yum updates. All appears to be working ok except one aspect.
Simple database (indexed 2 table)activity works but on a more sophisticated existing database accessed through a perl script I get this error (taken
from logs): -

[Tue Apr 27 20:22:52 2004] [error] [client 192.168.0.12] [Tue Apr 27
20:22:52 2004] lbf.cgi: DBI
connect('username_disney:localhost','username_lett uce',...) failed: Can't
connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
(13) at /home/username/public_html/dating/cgi-bin/scripts/new_database.pl
line 6, referer: http://www.awebsite.loc/

I have checked that the daemon is up and all standard checks recommended
from the mySQL site show the socket is connecting ok and for TCP/IP on port 3306 etc....

Any ideas please? Thanks in advance

Alan

[Aggro]

Alan Powell wrote:

By the way, my mysql.sock file is 0 bytes! Is this correct???

Yes. Sometimes the only information file needs to provide is whether it
exists or not. This is one of those cases.

[Aggro]

Alan Powell wrote:

By the way, my mysql.sock file is 0 bytes! Is this correct???

Yes. Sometimes the only information file needs to provide is whether it
exists or not. This is one of those cases.

[Alan Powell]

Thanks aggro

I have now gotten my server running ok on sockets. I am using webmin to
administer and after some experiments found that I need to set a password
for each user for "localhost" as well as "all".

Problem solved.

"Aggro" <sp**********@yahoo.com> wrote in message
news:Ni***************@read3.inet.fi...

Alan Powell wrote:

By the way, my mysql.sock file is 0 bytes! Is this correct???

Yes. Sometimes the only information file needs to provide is whether it
exists or not. This is one of those cases.

[Alan Powell]

Thanks aggro

I have now gotten my server running ok on sockets. I am using webmin to
administer and after some experiments found that I need to set a password
for each user for "localhost" as well as "all".

Problem solved.

"Aggro" <sp**********@yahoo.com> wrote in message
news:Ni***************@read3.inet.fi...

Alan Powell wrote:

By the way, my mysql.sock file is 0 bytes! Is this correct???

Yes. Sometimes the only information file needs to provide is whether it
exists or not. This is one of those cases.