max_user_connections error

[joh]

my site keep emailing me this same message over and over

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User nsraweb_joh already has more than 'max_user_connections' active connections
/home/nsraweb/public_html/forums/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Saturday, December 20th 2008 @ 07:26:58 AM
Error Date : Saturday, December 20th 2008 @ 07:26:58 AM
Script : http://www.nsraweb.com/forums/archiv...p?f-8-p-8.html
Referrer :
IP Address : 194.8.75.229
Username :
Classname : vB_Database
MySQL Version :

my host responce was

"The max_user_connections error means you've hit the limit of mysql connections available to shared accounts. The limit is in place to prevent one user account from using all available connections and denying service to other customers on the server. We cannot increase the limit without affecting the server's stability.

vBulletin should have an option to disable persistent connections. Check that to make sure it is disabled- it will ensure that mysql connections are closed after a database query is run.

does vBulletin have the option to disable persistent connections. if so where do i find it?

check for this in the file...

/includes/config.php

$config['MasterServer']['usepconnect'] = 0;

[joh]

I looked in the file and it is set to 0

PHP Code:

// ****** MASTER DATABASE SERVER NAME AND PORT ******  // This is the hostname or IP address and port of the database server.  // If you are unsure of what to put here, leave the default values. $config['MasterServer']['servername'] = 'localhost'; $config['MasterServer']['port'] = 3306; // ****** MASTER DATABASE USERNAME & PASSWORD ******  // This is the username and password you use to access MySQL.  // These must be obtained through your webhost. $config['MasterServer']['username'] = 'nsraweb_ooo0'; $config['MasterServer']['password'] = '00000'; // ****** 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; // ****** SLAVE DATABASE CONFIGURATION ******  // If you have multiple database backends, this is the information for your slave  // server. If you are not 100% sure you need to fill in this information,  // do not change any of the values here. $config['SlaveServer']['servername'] = ''; $config['SlaveServer']['port'] = 3306; $config['SlaveServer']['username'] = ''; $config['SlaveServer']['password'] = ''; $config['SlaveServer']['usepconnect'] = 0; 


so what do i do now?

strange.... really...

[SEOvB]

Originally Posted by joh

I looked in the file and it is set to 0

PHP Code:

// ****** MASTER DATABASE SERVER NAME AND PORT ******  // This is the hostname or IP address and port of the database server.  // If you are unsure of what to put here, leave the default values. $config['MasterServer']['servername'] = 'localhost'; $config['MasterServer']['port'] = 3306; // ****** MASTER DATABASE USERNAME & PASSWORD ******  // This is the username and password you use to access MySQL.  // These must be obtained through your webhost. $config['MasterServer']['username'] = 'nsraweb_ooo0'; $config['MasterServer']['password'] = '00000'; // ****** 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; // ****** SLAVE DATABASE CONFIGURATION ******  // If you have multiple database backends, this is the information for your slave  // server. If you are not 100% sure you need to fill in this information,  // do not change any of the values here. $config['SlaveServer']['servername'] = ''; $config['SlaveServer']['port'] = 3306; $config['SlaveServer']['username'] = ''; $config['SlaveServer']['password'] = ''; $config['SlaveServer']['usepconnect'] = 0; 


so what do i do now?

Disable modifications you don't need, or upgrade hosting, or both.

[badboyz]

ur hosting has proly 100 connections per min ask them ot increase it or some one ddosing u

[Dismounted]

Are you on shared hosting?

[Marco van Herwaarden]

If your server control panel (and your host, which i doubt) allows creating multiple MySQL accounts for the same database, then there might be a trick to raise this limit. Otherwise you will need to reduce the number of connection (users) active or move to a higher hosting plan.

[joh]

I am on a shared hosting.
I think they up my level seen that the error stop when I told them that I was going to move my site to a new host and not one of the big buck plans they had.

thanks for all the help.

[Cla75]

Help me guys, please

about 1 hours continuous receive email (at least 5000) with this error

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User XXXXX already has more than 'max_user_connections' active connections
/var/www/vhosts/XXXXXXXXXX/httpdocs/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Wednesday, February 24th 2010 @ 05:35:49 PM
Error Date : Wednesday, February 24th 2010 @ 05:35:49 PM
Script : http://www.XXXXXXXXXXXXXX.com/index.php
Referrer :
IP Address : XXXXXXXXXXXXXXX
Username :
Classname : vB_Database
MySQL Version :

My hosting service says it can not increase the maximum number of connections and advised me to remove the e-mailing of this error. You know how?

Other tips to solve this problem??

help please