Fighting this PROBLEM !!

[DieselMinded]

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]

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]

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]

Running those commands will not risk anything...

[DieselMinded]

How do i do it ?

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

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]

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]

I had my host install a firewall on my VPS thanks