max_user_connections / Mysql Errors?

[Nathan Malone]

I'm getting an error message on one of my sites that says the following:

Warning: mysql_connect(): User asdf_user has already more than 'max_user_connections' active connections in /home/asdf/public_html/forum/db/mysql4.php on line 48

Is this something that I am doing wrong (it's a phpBB forum) or is it just a temporary server error?

[GatorBrent]

the error means you are having more than 20 sql connections in few seconds period. I would take a look at your coding there is most likely some type of problem.

[Andeavour]

Two of my clients running osCommerce have started getting the exact same error this morning. One of the sites has been running happily for weeks, the other for months without producing any errors.

[Nathan Malone]

Originally Posted by GatorBrent

the error means you are having more than 20 sql connections in few seconds period. I would take a look at your coding there is most likely some type of problem.

Everything's working now but I'll check out the coding again to see if there is anything that I can improve.

BTW, this is the first server-related error I have gotten since switching to HostGator and it isn't even necessarily a problem with the server. I have been very pleased with the hosting / support here...

[Andeavour]

I have had no problems with Hostgator prior to this... The two sites having the problem are the only 2 sites (out of over 50 we host with Hostgator) that are having a problem, and they are also the only 2 running the CRELoaded version of osCommerce rather than the standard version.

Brent, would it be possible to up the max_connections in php.ini to 100 to try and clear this problem. It may be that the CRELoaded model requires more than 20 concurrnet connections?

I should point out that the sites in question only recently switched to the CRELoaded installation of osCommerce.

[amartins]

Dunno much about that version of OSCommerce but could this issue possibly have anything to do with persistent connections being enabled? I recall the setup mentioning that that would not be an appropriate choice for shared servers.

Antonio

[Andeavour]

With the help of Chad at Hostgator we got it sorted. He restarted the MySQL service to clear out the connections and I got the client to disable persistant connections.
I'd just like to thank Chad for his help as the client in question actually found Hostgator's number and rang them direct whilst I was on LiveChat trying to get things sorted, and I believe spoke to Chad (ironic eh?).

[o0CAPPI0o]

Hiya i and another site simular to mine are also getting these errors i thought creating new usernames to the databases would resolve the issue and it did for a little while but the problem is back, like yourselves i have had my hostgator package and my site online now for over a year it must be and this is the first time this has become a problem, if i need to disable this "allow persistant connections" where can i find it? i dont remember seeing it anywhere on my site or in cpanel also is this a result of something recently being implimented with Hostgator?

all help greatly appreciated

[amartins]

in your config file for OSCommerce edit from true to false like so:

define('USE_PCONNECT', 'false');


HTH

Antonio

[o0CAPPI0o]

as far as i know i do not have that module installed, i am running phpnuke platinum (7.6) i cannot see OSCommerce in the modules list anywhere

[amartins]

Sorry my mistake, this threas mentioned OSCommerce so I assumed that was your issue too.

You need to check on ther error message you get to pinpoint if it's a module or phpnuke itself.. maybe if you showed your error message more help would be forthcomming.

Antonio

[vtrain]

How do I check if i-m using persistent mysql connecting with phpBB?
I'm using a default instalation ... so i think it shouldn't but...

cheers,

[dannydp]

I am not getting this on all of my accounts on bentley. Definetly not a issue with the accounts more likely one with the total limit

[oats]

I read somewhere else that Hostgator had reduced the number of concurrent connections allowed as a protection against something (can't remember what now).

I had the same problem in a site with a phpbb (so will happen in a nuke too). It IS to do with persistent connections. If you can spot the error being displayed it will show you which file (and possibly even line number) where the error occurs. You will see something like the error in the original post "home/asdf/public_html/forum/db/mysql4.php on line 48" but this goes on to show something with 'pconnect' in it.

You need to open that file and change the 'pconnect' to 'connect'. This drops the connection (i.e. NOT persistent) as soon as the user logs out, so should cure the problem.

I found 2 files with this in them over a couple of weeks. Once I made the changes the problem cleared. You may need to ask Hostgator to restart MySQL after you have fixed the problems (probably essential in fact, but it's no big deal - they'll do it if you tell them you've just fixed some code to clear the persistent connection problem).

If you can't see the file or line number in the error message do a search in ftp for 'pconnect'. If you know the right file you'll fix the problem in less than a minute. If you have to check all/lots of files it'll be a bit of a drag obviously, but it WILL work.

I got this error aswell, on linerider.org

[PAGENET]

It appears MAX_USER_CONNECTIONS is limited to 25 at HostGator.

According to vBulletin.com, this is an extremely low limit. Most hosts are set at 100 and some you can find set to 500.

Even with persistent connections turned off, my forum is showing errors.

Same problem here with a CMS Made Simple site. I had it with another provider and the client wanted to move to HostGator, as soon as we moved the max_user_connections error started showing. With the previous provider this error never showed.
I have a dedicated server so I presume I can set this value at my discretion, just don't now where to set it in the WHM or the cPanel. Anybody have any ideas?