GoFuckYourself.com - Adult Webmaster Forum

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)
-   Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)
-   -   Sql error Please help (https://gfy.com/showthread.php?t=139542)

jovigirl 06-03-2003 11:27 AM

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

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


All times are GMT -7. The time now is 10:39 PM.

Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
©2000-, AI Media Network Inc123