Persistent DB errors

[SwalyAaron]

Not sure if someone is trying to inject my forums on a daily basis basically non stop or something is wrong with my forums, I'm getting a mix of fatal errors, I just recently checked the email I use for vbulletin error reporting. Please check these out I'll try and spoiler them


Error 1 (looks like an injection tbh).

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections
/public_html/forums/includes/class_core.php on line 311

MySQL Error : 
Error Number : 
Request Date : Saturday, October 12th 2013 @ 11:19:14 AM
Error Date : Saturday, October 12th 2013 @ 11:19:14 AM
Script : http://www.mywebsite.org/forums/misc.php?do=form&fid=3%20aNd%20(select%20ASCII(SUBSTRING(name,60,1))%20from%20%5Bmaster%5D..%5Bsysdatabases%5D%20where%20dbid=16)=254
Referrer : 
IP Address : REMOVED
Username : 
Classname : vB_Database
MySQL Version :

Error 2.

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/public_html/forums/includes/class_core.php on line 311

MySQL Error : 
Error Number : 
Request Date : Saturday, October 12th 2013 @ 01:25:53 PM
Error Date : Saturday, October 12th 2013 @ 01:25:54 PM
Script : http://www.mywebsite.org.com/forums/
Referrer : http://www.mywebsite.org/forums/showgroups.php
IP Address : REMOVED
Username : 
Classname : vB_Database
MySQL Version :

Error 3.

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections
/public_html/forums/includes/class_core.php on line 311

MySQL Error : 
Error Number : 
Request Date : Saturday, October 12th 2013 @ 10:25:54 AM
Error Date : Saturday, October 12th 2013 @ 10:25:54 AM
Script : http://www.mywebsite.org/forums/forumdisplay.php?f=0
Referrer : http://www.mywebsite.org/forums/
IP Address : REMOVED
Username : 
Classname : vB_Database
MySQL Version :

[nerbert]

If it's a shared server it could be someone else loading it. In your AdminCP Home page check Server Load Averages. It depends on the number of server cores but the number shouldn't be much bigger than 4 for a 4 core server.

[blind-eddie]

I would say you are getting hammered by bots from the same IP address thus causing to many connections.

[Digital Jedi]

I had to shut down my forums a year ago for the same reason blind-eddie suggests. Of course, at that point, I had no active membership. But even so, the server kept crashing with the same type of database errors above. Too many connections from too many bots trying to see things they shouldn't see.

[SwalyAaron]

Originally Posted by blind-eddie

I would say you are getting hammered by bots from the same IP address thus causing to many connections.

If I can do anything to stop this please give me any suggestion, can I reroute them?

Originally Posted by Digital Jedi

I had to shut down my forums a year ago for the same reason blind-eddie suggests. Of course, at that point, I had no active membership. But even so, the server kept crashing with the same type of database errors above. Too many connections from too many bots trying to see things they shouldn't see.

Ah well I can't shutdown my forums got a nice active community going =] Thanks for the input though.

--------------- Added [DATE]1381651823[/DATE] at [TIME]1381651823[/TIME] ---------------

Originally Posted by nerbert

If it's a shared server it could be someone else loading it. In your AdminCP Home page check Server Load Averages. It depends on the number of server cores but the number shouldn't be much bigger than 4 for a 4 core server.

"Server Load Averages 13.16 13.54 13.45"

[ozzy47]

How many users are on you forms when the load is that high, Active Users X, Guests X?

What is the specs of the serve? Is it a shared, VPS or dedicated?

[Digital Jedi]

Originally Posted by SwalyAaron

Ah well I can't shutdown my forums got a nice active community going =] Thanks for the input though.

Heh, I wasn't suggesting that. Just pointing out that I've run into the same issue, for possibly the same reasons. My community was dead at the time, so I decided to put it off til later. I hate .htaccess, but I was probably going to have to ban some countries for that reason.

[SwalyAaron]

Originally Posted by Digital Jedi

Heh, I wasn't suggesting that. Just pointing out that I've run into the same issue, for possibly the same reasons. My community was dead at the time, so I decided to put it off til later. I hate .htaccess, but I was probably going to have to ban some countries for that reason.

I see, is there any way I can log the requests I'm getting?

[Digital Jedi]

Originally Posted by SwalyAaron

I see, is there any way I can log the requests I'm getting?

You, or your host, should be able to see the raw access logs. If you have cPanel, there should be a place to view those logs as well as bandwidth usage, statistics, etc. Every host is a little different, though

[ForceHSS]

The server has maxed out the number of MySQL connections it allows. This is a server-wide limit, not just your forums. All you can do is ask your host to raise the maximum number of connections they allow.

Here is more info on that error:

http://dev.mysql.com/doc/refman/5.0/...nnections.html