3.6 to 3.6.5 Upgrade Error (Cannoct connect to MySQL server)

[twilighthush]

Upgrading from vb3.6 to 3.6.5, I received the following error:


Database error in vBulletin :
mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46)
/forums/includes/class_core.php on line 273
MySQL Error :
Error Number :
Date : Wednesday, March 28th 2007 @ 01:46:26 AM
Script : http://www.sugizolove.com/forums/install/upgrade.php
Referrer :
IP Address : 67.84.227.182
Username :
Classname : vb_database

I'm not sure what to do. Please advise?

[Steve Machol]

Please see this page for the causes of this error:

http://www.vbulletin.com/docs/html/cantconnect

[v2neo]

Please see this page for the causes of this error:

http://www.vbulletin.com/docs/html/cantconnect


i have same issue. mysql is running fine according to host and the config.php file is corrrectly setup... any other sugestions?

[Steve Machol]

Nope. Those are all the causes of this problem. It's almost certainly a server issue.

[eva2000]

i have same issue. mysql is running fine according to host and the config.php file is corrrectly setup... any other sugestions?
tried instead of using config.php localhost use mysql server's ip address or vice versa ?

[Zexsi]

This error sounds really familiar, as if there was an error in your /etc/php.ini file not pointing to the same socket location that /etc/my.cnf says the socket file is.

You should compare these two files contents, here is a quick way (the commands after # are what I typed)


]#cat /etc/my.cnf
[mysqld]
socket=/usr/local/mysql/mysql.sock

]#grep default_socket /etc/php.ini
default_socket_timeout = 60
mysql.default_socket = /usr/local/mysql/mysql.sock


btw, I recommend you make your php.ini fit your mysql configuration choices, and not the other way around.