ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: usbodyart on February 17, 2007, 07:04:50 pm

Title: Question about error_log
Post by: usbodyart on February 17, 2007, 07:04:50 pm

Hello, new user and first time poster...

I must say I really like LMP...

I do have one question...  I am seeing a bunch of the following line in the error_log file and it is a bit concerning because I believe it may be causing people who are trying to access my tracked links or remove themself from being unsuccessful...

The log has a bunch of these:

Code: [Select]

[17-Feb-2007 20:52:27] PHP Warning:  mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User everyone_lm has already more than 'max_user_connections' active connections in /home/everyone/public_html/lm/admin.php on line 2946


Does anyone else see this problem?

Thanks for any help.

Regards,
Scott
http://www.4everyone.com/

Title: Question about error_log
Post by: DW on February 19, 2007, 08:54:19 pm

Hi Scott,

Did you, perhaps, modify ListMail's PHP mysql_connect() function to read mysql_pconnect()?

I have not heard any other complaints in many years about the number of connections required by ListMail.  You may need to speak with your host about raising your MySQL connection limit somewhat.

Regards

Title: Question about error_log
Post by: usbodyart on February 20, 2007, 10:05:24 am

Quote from: "DW"

Hi Scott,

Did you, perhaps, modify ListMail's PHP mysql_connect() function to read mysql_pconnect()?

I have not heard any other complaints in many years about the number of connections required by ListMail.  You may need to speak with your host about raising your MySQL connection limit somewhat.

Regards

I didn't change that...

I have a dedicated server...and a ~200K list

by chance do you know what the line that needs to be changed in the my.cfg file?

Thanks.

Scott

Title: Question about error_log
Post by: DW on February 20, 2007, 05:58:32 pm

Hi Scott,

I believe it will be the "max_connections" or "max_user_connections" variable.

This page might help:
http://www.linuxweblog.com/node/231

Note that the format for setting vars in MySQL 3.23 is not the same as in 4+

Please let me know if I can be of further assistance. :)

Regards

Title: Question about error_log
Post by: usbodyart on February 21, 2007, 07:21:46 am

Thanks...

I had a look at the config and it seemed that cpanel had reverted back to the following setting:

max_user_connections=30

I have adjusted this and will report if it corrects the problem...

Thanks.

Scott

Title: Question about error_log
Post by: usbodyart on February 22, 2007, 09:29:21 am

Quote from: "usbodyart"

Thanks...

I had a look at the config and it seemed that cpanel had reverted back to the following setting:

max_user_connections=30

I have adjusted this and will report if it corrects the problem...

Thanks.

Scott

This seems to have fixed it..

Regards,
Scott