Re: [Phplib-users] SQL: more than 'max_user_connections'

[Peter C. <li...@kr...>]

Hi

To maybe help answer a future FAQs about this, I've put a quick note about the latest version of db_mysql and the mysql_connect() workaround in:
http://www.sanisoft.com/phplib/manual/DB_sql.php

Peter


At 13:16 20/02/03 +0100, Giancarlo wrote:
>You have to lower the mysql wait_timeout value from the default 8 h to 1-5 minutes mas, so stale persistent connections will be freed
>This is a FAQ.
>
>Gian
>
>Lindsay Haisley wrote:
>>Thus spake so...@gm... on Wed, Feb 19, 2003 at 10:27:31AM CST
>>
>>>hello,
>>>
>>>I keep getting the following mistake from my site:
>>>
>>>
>>>Warning: User net@localhost has already more than 'max_user_connections'
>>>active connections in /home/www/net/phplib_lablue/db_mysql.inc on line 73
>>>
>>>Warning: MySQL Connection Failed: User net@localhost has already more
>>>than 'max_user_connections' active connections in
>>>/home/www/net/phplib_lablue/db_mysql.inc on line 73
>>>Database error: pconnect(localhost, net, $Password) failed.
>>>MySQL Error: ()
>>>Session halted.
>>
>>This is a mysql issue.  You can change max_user_connections in your my.cnf
>>file.  Do a locate for it on your system.  This is often set to 0 (no limit)
>>but may be set to a specific value which is too low for your situation.  You
>>can see the current setting by logging in to mysql with the mysql client and
>>giving the 'show variables;' command.
>>To set max_user_connections, edit my.cnf and under the [mysqld] section, put
>>the following line.
>>set-variable    = max_user_connections=0  
>>                                        
>>Restart the mysql server and the problem should go away.
>>This assumes that you administer your own server.  If not, you'll need to   
>>get the server admins to take care of the issue.