View Full Version : Fighting this PROBLEM !!
DieselMinded
06-26-2008, 03:18 PM
I havent had a DB error in 6 mths probably , I sent a mass email out at About 2:40AM and i got 15 Database errors
Database error in vBulletin :
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections
/home/dieselminded/dieselbombers.com/html/includes/class_core.php on line 311
MySQL Error :
Error Number :
Request Date : Thursday, June 26th 2008 @ 02:41:15 AM
Error Date : Thursday, June 26th 2008 @ 02:41:15 AM
Script : http://www.dieselbombers.com/
Referrer : http://www.dieselbombers.com/
IP Address : *********************
Username :
Classname : vB_Database
MySQL Version :
What do i do about it
Dismounted
06-27-2008, 10:17 AM
This is because you are hitting the database with too many connections. To get rid of the error, up the max_connections value in my.cnf.
DieselMinded
06-27-2008, 09:17 PM
I have already increased this ,
This is from my Host
You will need to find out which scripts was using up all your MySQL connections. You can see the processlist of your MySQL through the shell access by running "mysqladmin processlist", when the connections are all used up. The list will show you the database user, database name for each connections. Once you found which of your scripts are making the connection, you will need to fix/troubleshoot the script.
Im not sure how to do this and what risks i take by doing it on a live board
Dismounted
06-28-2008, 05:09 AM
Running those commands will not risk anything...
DieselMinded
07-05-2008, 10:10 PM
How do i do it ?
--------------- Added 1215323975 at 1215323975 ---------------
Well I got over 1000 Database errors Too many Connections today , they came from 2 diffrent ips , i went threw my logs and they matched with the last time this happened so i banned them ,
Now my VPS host says
It seems some other people are trying to connect to your mysql remotely. Since you only need the mysql server working remotely, you can close on your mysql ports using firewall to prevent any remote mysql connection. We have an article on our knowledgebase that describes how to install a firewall on a linux VPS using iptables;
Is there anyset back to using iptables with Vbulletin?
TIA
Dismounted
07-06-2008, 06:33 AM
As said, vBulletin does not require remote MySQL connections to be allowed. In fact, they should be disabled and blocked on any server by default unless you need it.
DieselMinded
07-06-2008, 07:06 AM
I had my host install a firewall on my VPS thanks
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.