Sql error Please help

[jovigirl]

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]

tried rebooting your server?

[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).

[pantymaniac]

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]

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]

Originally posted by loverboy
tried rebooting your server?

linux doesnt need hourly reboots like windows

[JDog]

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