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

[Nathaniel P. <np...@te...>]

I don't run MySQL, but there are two things you might look at:

First, check to make sure that you have MySQL configured to accept more than
30 (or whatever) connections. The relavent documentation appears to be here
(look for the max_user_connections configuration option):
http://www.mysql.com/doc/en/System_Variables.html
http://www.mysql.com/doc/en/SET_OPTION.html
and possibly here:
http://www.mysql.com/doc/en/User_resources.html

However, if you don't administer your own database, you'll probably have to
talk to your system administrator to be able to change these settings.

Second, check to see if there is any PHP configuration options that limit
the number of concurrent connections. There is a list of options that can be
configured for PHP's MySQL support here (you can find out what these options
are set to on your server with the phpinfo() function):
http://www.php.net/manual/en/ref.mysql.php

Hope this helps...
_________________________________
Nathaniel Price <np...@te...>
Webmaster

----- Original Message -----
From: <so...@gm...>
To: <php...@li...>
Sent: Wednesday, February 19, 2003 8:27 AM
Subject: [Phplib-users] SQL: more than 'max_user_connections'


> 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.
>
>
> problem seems to appear with 30 or more users online at the same time.
>
> Is this a SQL related problem (bad config) or possibly within PHP?
p