Errors is Server Log

[CenturyPerf]

I'm getting ridiculous numbers of these errors, more than a couple a minute. I found these today after repeated disconnects (timouts) in the traffic monitor:


[Sat Apr 7 15:08:57 2007] [error] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User xxxxx has already more than 'max_user_connections' active connections in /x/x/x/livehelper/admin/db_mysql.php on line 45


Any ideas, suggestions, or fixes? I'm the ONLY one logged in to the chat client.

I've been using Firefox ... since phpLiveHelper is still not coded to work in Internet Explorer 7 :confused:. After seeing these errors in the logs I am using AvantBrowser today to see if it is just a browser issue.

Pretty sure it is NOT a server issue ... a whole 4 sites on a 3060 Conroe with 4 GB DDR2 RAM and 4x500 SATA II drives in a RAID 10. :cool:

I'm not too thrilled with this latest version, and lazy/late bug fixes.

[CenturyPerf]

Let's add a few more .... :mad:

Where is this called from (which FILE) in the program so that I cann comment it out?


[Sat Apr 7 20:17:01 2007] [error] [client 24.182.52.126] File does not exist: /xxxx/xxxxx/xxxxx/livehelper/admin/menu/ColorPicker2.js

[TWT-Chris]

Well to start your this is a server issue. The max_user_connections setting is set on the server side and is set by your hosting company. If it is set low then you will be limited to the number of connections you can use to the database. Your alternative would be to use pconnect in the mysql_db.php to fix this issue or ask your hosting company to up this setting.

The seocnd issue you are seeing is related to something else. Is this a fresh install or did you upgrade?

[CenturyPerf]

Well Chris,

There is no connect limit set on the server. The host has not limited any connections. This is happening even with NO ONE logged in as a user/admin. Only people visiting the website, at least until this error causes the pages to hang. Plus, your software is already calling out to use pconnect:

}

function connect() {
global $usepconnect;
if ($this->my[link_id] == 0) {
if ($this->my[password] == "") {
if ($usepconnect == 1)
$this->my[link_id]=mysql_pconnect($this->my[server],$this->my[user]);
else
$this->my[link_id]=mysql_connect($this->my[server],$this->my[user]);
} else {
if ($usepconnect == 1)
$this->my[link_id]=mysql_pconnect($this->my[server],$this->my[user],$this->my[password]);
else
$this->my[link_id]=mysql_connect($this->my[server],$this->my[user],$this->my[password]);
}
if (!$this->my[link_id])
$this->halt("Link-ID == false, connect failed");
if ($this->my[database] != "")
if(!mysql_select_db($this->my[database], $this->my[link_id]))
$this->halt("cannot use database ".$this->my[database]);
}

-------------------------
And the second issue ... FRESH INSTALL

[TWT-Chris]

If you are getting that error then it is definently setting a max connections. Also, it doesnt use pconnect by default. You have to set it in the config.php.

Add this to your config:

$usepconnect = 1;

[CenturyPerf]

Where am I adding this?

[TWT-Chris]

In the config.php in between the PHP tags.

[CenturyPerf]

Added it under the language_file variable, before the ?> tag.

-----------------

Still getting the error .... server is set to 100 max_users

max_user_connections=100
max_connections=500
max_connect_errors=20
max_allowed_packet=16M
max_allowed_packet=16M


[Mon Apr 9 00:22:14 2007] [error] PHP Warning: mysql_pconnect() [<a href='function.mysql-pconnect'>function.mysql-pconnect</a>]: User xxxxxxxxx has already more than 'max_user_connections' active connections in /xxxxx/xxxxx/xxxxx/livehelper/admin/db_mysql.php on line 43

[TWT-Chris]

This cant be right then... try this... change the lines in the db_mysql.php that read like:

$this->my[link_id]=mysql_connect

to

$this->my[link_id]=mysql_pconnect

just to make sure we are forcing the pconnect... then restart mysql if you can.

[TWT-Chris]

Did the solution above fix your issue?