Sql error Please help - GoFuckYourself.com

jovigirl · 06-03-2003, 11:27 AM

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /usr2/mydomain.com/web/pp-inc.php on line 58
I cannot connect to the PhotoPost database. [$php_errormsg]

Anyone knows how to solve this?
Im getting stuck

loverboy · 06-03-2003, 11:33 AM

tried rebooting your server?

scooby doo as scooby does · 06-03-2003, 11:40 AM

On the 'corruption' front, could be a million and one things.

On the 'settings' front, most likely (duh!) you have too many SQL connections open.
Is it a busy site ? Are connections set to 'persistant' ?
Has the default max number of 100 been reduced ?

I would check running processes (mysqladmin proc) to see how many are using sql. Compare to your max connections setting (mysqladmin var).

You may wanna reboot b4 you change anything, or restart mysql. Then you could try increasing the number of max connections set in my.cnf then restart mysql. (dont increase beyond your systems capacity).

pantymaniac · 06-03-2003, 11:42 AM

your hosting mysql server is fucked up , contact to them if you get this message after some working days , if not , if you got this message first time you install , it can be your fault about configuring . open with txt editor and check line 58

jovigirl · 06-03-2003, 12:39 PM

Quote:

Originally posted by scooby doo as scooby does
On the 'corruption' front, could be a million and one things.

On the 'settings' front, most likely (duh!) you have too many SQL connections open.
Is it a busy site ? Are connections set to 'persistant' ?
Has the default max number of 100 been reduced ?

I would check running processes (mysqladmin proc) to see how many are using sql. Compare to your max connections setting (mysqladmin var).

You may wanna reboot b4 you change anything, or restart mysql. Then you could try increasing the number of max connections set in my.cnf then restart mysql. (dont increase beyond your systems capacity).

Thx its working now

Why · 06-03-2003, 12:42 PM

Quote:

Originally posted by loverboy
tried rebooting your server?

linux doesnt need hourly reboots like windows

JDog · 06-03-2003, 12:54 PM

Quote:

Originally posted by scooby doo as scooby does
On the 'corruption' front, could be a million and one things.

On the 'settings' front, most likely (duh!) you have too many SQL connections open.
Is it a busy site ? Are connections set to 'persistant' ?
Has the default max number of 100 been reduced ?

Wouldn't be a too many connections - cuz you would get error connecting to mysql server - too many connections. I would recommend restarting mysql before rebooting, because rebooting could cause more problems.

jDoG

06-03-2003, 11:27 AM	#1
jovigirl Confirmed User Join Date: Apr 2003 Location: On the edge Posts: 1,796	Sql error Please help Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /usr2/mydomain.com/web/pp-inc.php on line 58 I cannot connect to the PhotoPost database. [$php_errormsg] Anyone knows how to solve this? Im getting stuck __________________ ICQ :333-548-380

06-03-2003, 11:40 AM	#3
scooby doo as scooby does Confirmed User Join Date: Nov 2002 Location: A deep dark place. Posts: 314	On the 'corruption' front, could be a million and one things. On the 'settings' front, most likely (duh!) you have too many SQL connections open. Is it a busy site ? Are connections set to 'persistant' ? Has the default max number of 100 been reduced ? I would check running processes (mysqladmin proc) to see how many are using sql. Compare to your max connections setting (mysqladmin var). You may wanna reboot b4 you change anything, or restart mysql. Then you could try increasing the number of max connections set in my.cnf then restart mysql. (dont increase beyond your systems capacity). __________________ In 1904, Charles Newman-Berry connected two abacus's together using specially enhanced GrapeVine thus inventing the first Internet connection. NEWMAN-BERRY CASH Paying webmaster since 1904

06-03-2003, 11:42 AM	#4
pantymaniac Confirmed User Join Date: Feb 2003 Location: In Your GF's Panty. Posts: 1,192	your hosting mysql server is fucked up , contact to them if you get this message after some working days , if not , if you got this message first time you install , it can be your fault about configuring . open with txt editor and check line 58 __________________ This place is for RENT

06-03-2003, 11:33 AM	#2
loverboy When it rains, it pours Industry Role: Join Date: May 2003 Posts: 20,609	tried rebooting your server?