Author Topic: Question about error_log (Read 2093 times)

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/

DW · « **Reply #1 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

usbodyart · « **Reply #2 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

DW · « **Reply #3 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

usbodyart · « **Reply #4 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

usbodyart · « **Reply #5 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