vBulletin 4.2.3 Database ERRORS driving me crazy

[diysmps]

We are suffering from this issue since we had the VB installed years ago, it used to happen from time to time, without finidng the answer why its happening.

We are unable to find a proper solution to this issue at the VB forums, but hopefully tihis time we will.


Problem is we are getting thousands of emails notifying us with the database errors.

Database error in vBulletin :

mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) /var/www/vhosts/diysmps.com/forums/includes/class_core.php on line 317

MySQL Error :
Error Number :
Request Date : Thursday, December 1st 2016 @ 01:57:40 AM
Error Date : Thursday, December 1st 2016 @ 02:05:54 AM
Script : http://www.diysmps.com/forums/entry.php?126-remodeling-SMPS&goto=newpost
Referrer :
IP Address : 46.229.168.72
Username :
Classname : vB_Database
MySQL Version :

Can any one help us to get rid of this painful problem? COMPLETELY?

In the past we had to change our host from GODADDY to Rackspace, we thought its the HOST.

And its NOT, its the VB itself.

Please help

[Dave]

If you have the MySQL settings in the vBulletin config file correctly configured then it's not a problem with vBulletin, it's a problem with your MySQL server.

Either something happens that causes the MySQL server to crash or the MySQL's ini settings are not right.

Refer to:
http://stackoverflow.com/questions/5376427/cant-connect-to-local-mysql-server-through-socket-var-mysql-mysql-sock-38
http://alvinalexander.com/mysql/mysql_connect-cant-connect-local-mysql-server-socket < definitely look at this.

[RichieBoy67]

It is not Vbulletin. Vbulletin runs on almost any server.

Is that the only error you get and did it just start happening?

If you do not want the emails just remove your email from the config.php file. :)

##I'm not saying to remove your email address and not fix these issues. I am just saying that if you're inbox is getting flooded than you can remove your address from config just until you fix the issues. I'm fairly certain everyone knew this is what I meant but apparently I need to clarify.:D

[Paul M]

And its NOT, its the VB itself.

No, its not.

Thats actually PHP unable to connect to the MySQL server, and has nothing to do with vBulletin at all.

It even tells you that in the error message : mysql_connect(): Can't connect to local MySQL server

[Paul M]

If you do not want the emails just remove your email from the config.php file. :)
Thats not really very good advice, its just ignoring the errors, and hiding any future errors.

[RichieBoy67]

Thats not really very good advice, its just ignoring the errors, and hiding any future errors.
It's not an ultimate fix but rather a temporary fix until issues are taken care of.

[Brandon Sheley]

Thats not really very good advice, its just ignoring the errors, and hiding any future errors.

I agree, should fix the issue, don't just hide the errors ;)
https://www.vbulletin.com/forum/forum/vbulletin-announcements/vbulletin-announcements_aa/4000121-vbulletin-4-2-2-full-has-been-released?p=4000466#post4000466

[RichieBoy67]

Ok, post amended.

Seems pretty obvious that I did not mean to hide the errors and not fix the issues but I added some clarification. :)

[Paul M]

I agree, should fix the issue, don't just hide the errors ;)
https://www.vbulletin.com/forum/forum/vbulletin-announcements/vbulletin-announcements_aa/4000121-vbulletin-4-2-2-full-has-been-released?p=4000466#post4000466
Are you trying to be funny, or just being a jerk ? its hard for me to tell from that.

[Brandon Sheley]

Are you trying to be funny, or just being a jerk ? its hard for me to tell from that.

I was trying to be funny in a smart a$$ way :p

That's the code that I thought of when I first read the reply. I wasn't searching for a post by you, but it's what pulled up first.

I would have rather had the source post from Mark to be honest..lol

Anyways, it was meant to be in good humor :)

[RichieBoy67]

I am going to have to report this to a mod for being off topic! :eek: :D

What happened to the op anyways? My guess is that is was his config.php settings.

[MarkFL]

I am going to have to report this to a mod for being off topic! :eek: :D

What happened to the op anyways? My guess is that is was his config.php settings.

I'm trying to decide what to do about this...

https://vborg.vbsupport.ru/external/2016/12/7.jpg

[RichieBoy67]

I'm trying to decide what to do about this...

https://vborg.vbsupport.ru/external/2016/12/7.jpg
Yep, Ban them.. Lay down the law Mark! lol

[Paul M]

Given that the OP implies the problem to be intermittant, its not likely to be the config file.

Either the MySQL server is unreliable, or they are using a domain name rather than IP address for the server, and dns lookups are sometimes failing (tbh, that would be my guess).

[RichieBoy67]

Given that the OP implies the problem to be intermittant, its not likely to be the config file.

Either the MySQL server is unreliable, or they are using a domain name rather than IP address for the server, and dns lookups are sometimes failing (tbh, that would be my guess).
I didn't realize it was an intermittent problem. With that being the case i totally agree.