Max User Connection error

[vidmarc]

And their reply:

Thank you for contacting us. If you are referring to multiple user name
and passwords to access a database then the answer is no. You only have
one username and password to access the MSSQL Database from your web
space. However you can have multiple applications accessing the
database using the same user name and password.

[Marco van Herwaarden]

And their reply:

Thank you for contacting us. If you are referring to multiple user name
and passwords to access a database then the answer is no. You only have
one username and password to access the MSSQL Database from your web
space. However you can have multiple applications accessing the
database using the same user name and password.

In that case you are out of luck, or at least i don't know of a workaround.

The directory you should specify should have read-write access for the webserver. It could be located outside your webroot (security). It can be any directoryname that you create, as long as you specify the full path to it.

[EdQ]

What is the work around? Becuase I can use more than one username to access the DB

[Marco van Herwaarden]

If your host allow multiple users for each database, then you can use the following trick:

*** Please note that avoiding a limit set by your hosting company, could get you into trouble with them ***

1. Create additional user(s)
Create more MySQL user/password's and give these full permissions to your database.

2. Edit you config.php, and locate the following lines (they should alerady contain the user/password for your current setup):

 // ****** 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'] = 'root';
$config['MasterServer']['password'] = ''; 

After the first 3 comment lines, add the following:

$dbusers = array(
array('user' => 'mysql_username_1', 'password' => 'mysql_password_1') // First MySQL user/password combination
, array('user' => 'mysql_username_2', 'password' => 'mysql_password_2') // Second MySQL user/password combination
, array('user' => 'mysql_username_3', 'password' => 'mysql_password_3') // Third MySQL user/password combination
);
$mysql_user = $dbusers[rand(0, count($dbusers) - 1)]; 

Edit mysql_username_X and mysql_password_X to have valid MySQL username/password combinations. If you need more then 3 combination, just duplicate the third line. If you are only using 2 combinations, remove the third combination.

3. Now edit the lines that configure your username password (they will probably already contain the info for the first MySQL user).
find:

$config['MasterServer']['username'] = 'root';
$config['MasterServer']['password'] = ''; 

and replace them with:

$config['MasterServer']['username'] = $mysql_user['user'];
$config['MasterServer']['password'] = $mysql_user['password']; 

4. Check your edits, the complete block should look something like:

 // ****** MASTER DATABASE USERNAME & PASSWORD ******
// This is the username and password you use to access MySQL.
// These must be obtained through your webhost.
$dbusers = array(
array('user' => 'mysql_username_1', 'password' => 'mysql_password_1') // First MySQL user/password combination
, array('user' => 'mysql_username_2', 'password' => 'mysql_password_2') // Second MySQL user/password combination
, array('user' => 'mysql_username_3', 'password' => 'mysql_password_3') // Third MySQL user/password combination
);
$mysql_user = $dbusers[rand(0, count($dbusers) - 1)];
$config['MasterServer']['username'] = $mysql_user['user'];
$config['MasterServer']['password'] = $mysql_user['password']; 

5. Save and upload your config.php. Finished.

Everytime a page is opened, 1 of the defined username/password combinations will be choosen at random, and by this reducing the number of connections for each user.

[Steve Machol]

I would caution that if your host finds out that you are bypassing their restrictions, your account may be jeopardized.

[EdQ]

Thanks, this is just to get by while we find another host.

[Marco van Herwaarden]

I would caution that if your host finds out that you are bypassing their restrictions, your account may be jeopardized.

Thanks Steve, added that warning to my original post.

[taydu]

i tried that on 3.6.8 and it doesn't work any idea ?

[Jose Amaral Rego]

i tried that on 3.6.8 and it doesn't work any idea ?

It is still what is set on the server you are on, you still would need to request your host to increase the amount of allowable connection or find another host with more connections. It just maybe you are having growing pains and do not wish to invest in more money to get dedicated server.

Plus taydu, you should post in forums for your version and start your own thread and have it link to any posting in this thread. It so you do not loose track on your issues and not to confuse the thread start or others, as everyone has a slightly different problem.

[mecho]

I'm sorry to bump the very old thread . i just found this link via google so i just wondering to know that is this trick that we have in this reply , is still working with newest version of vb and mysql ?

Thanks

[peterska2]

Please start your own thread in the relevant forum for the version of vBulletin that you are running. Thank you.

[Jeff G]

Worked like a charm thank you!.

I have been trying to figure out how to do this.

Powweb has set their limit to 50,000 an hour. but......
The maximum number of concurrent MySQL connections per user is 10.

So I am assuming if I set up 9 more connection names equaling -10-
I can get 500,000 Queries per hour?

It's what I have it set for now, and so far board is running way better than before... & powweb has not complained about it..

[badheeu]

Its not working 3.8.1, need help

[Zachery]

The code works just fine.

[Raptor]

thanks