470,619 Members | 1,979 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,619 developers. It's quick & easy.

SQL Socket Error

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

Jul 20 '05 #1
6 2055
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


Jul 20 '05 #2
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


Jul 20 '05 #3
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.
Jul 20 '05 #4
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.
Jul 20 '05 #5
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.


Jul 20 '05 #6
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.


Jul 20 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Robert A. van Ginkel | last post: by
2 posts views Thread by Droopy | last post: by
2 posts views Thread by Rene Sørensen | last post: by
7 posts views Thread by | last post: by
10 posts views Thread by Hendrik van Rooyen | last post: by
2 posts views Thread by manasap | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.