MySQL problem!! Please help!

[The Chief]

Ok, there have been two problems so far with my MySQl table while I was gone, and I recieved over 100 emails from my vBulletin board telling me that there has been an error.

Here are the 3 emails:

De: <thechief@gamebgs.com>
?: <thechief@gamebgs.com>
Objet: vBulletin Database Error!
Date: November 9, 2005 7:23 PM

Database error in vBulletin :

mysql_connect(): User gamebgs_admin has already more than 'max_user_connections' active connections
/home2/gamebgs/public_html/etalk/forums/includes/class_core.php on line 273

MySQL Error :
Error Number :
Date : Thursday, November 10th 2005 @ 12:23:31 AM
Script : http://etalk.gamebgs.com/forums/index.php
Referrer :
IP Address : 69.230.135.249
Username :
Classname : vb_database


Here is another email...

Database error in vBulletin :

mysql_connect(): Too many connections
/home2/gamebgs/public_html/etalk/forums/includes/class_core.php on line 273

MySQL Error :
Error Number :
Date : Thursday, November 10th 2005 @ 02:01:44 AM
Script : http://etalk.gamebgs.com/forums/index.php
Referrer : http://etalk.gamebgs.com/index.html
IP Address : 205.188.116.10
Username :
Classname : vb_database


And the last one...


Database error in vBulletin :

mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home2/gamebgs/public_html/etalk/forums/includes/class_core.php on line 273

MySQL Error :
Error Number :
Date : Thursday, November 10th 2005 @ 02:10:41 AM
Script : http://etalk.gamebgs.com/forums/index.php
Referrer :
IP Address : 64.12.116.9
Username :
Classname : vb_database




Can some please help me fix this, my users can't login bvecause of this and they keep getting errors!!

Thanks!

[akanevsky]

This is hoster's fault. Tell him about it, as he is the only one who can fix it.

[The Chief]

Well I have contacted them, I really hope they will respond soon, I thought maybe it had something to do with vB???

[stonyarc]

Well it might be

Can you please check your /includes/config.php for this line and tell us what the value is?

If the value is 1 try setting it to 0
// ****** MASTER DATABASE PERSISTENT CONNECTIONS ******
// This option allows you to turn persistent connections to MySQL on or off.
// The difference in performance is negligible for all but the largest boards.
// If you are unsure what this should be, leave it off. (0 = off; 1 = on)
$config['MasterServer']['usepconnect'] = 0;

[The Geek]

Im not a master admin, however unless you have access to your mysql conig file, your host will need to change it. It may also be some rouge script that has hijacked mysql resources. I had this once. Only solution was to periodically reboot which was a serious pain. I eventually moved servers and left behind whatever script caused it (my personal feelings was that it was with a particular email program that plugged into vb).

Personally, I would be my money its a rouge script.

[Marco van Herwaarden]

Using pconnect can also cause these symptoms.

What vB version are you using? If you look at vb.com you will see an increased number of reports on similar errors since 3.5.1