Warning: mysql_connect(): User sugarcrm has already more than 'max_user_connection

[caojianhua]

Help needed.

I've new in SugarCRM, and just installed V4.5.

I got frequently the following message :
Warning: mysql_connect(): User sugarcrmhas already more than 'max_user_connections' active connections

can anyone help me?

Many thanks.
Jian

[stevec]

Yes - you need to edit the mysql config file (my.ini or my.cnf depending on the platform) and up the value for the 'max_user_connections' variable. Don't forget to restart mysql after the change.

[caojianhua]

Thanks for your response. I will ask my host provider to change the config.

However, it's quite strange that another program running on the same env. with different users and multiple connections works fine, while the SugarCRM test has been just setup and nobody else was connected apart from my own admin connection.

Is there a bug or something wrong here ?

Many thanks for your help.
Jian

[caojianhua]

Still need help !!!

The max_user_connections has been increased to 30, but still get the same problem, can't even logout.

Thx.

[kpit]

SugarCRM uses persistant connections by default. You can change it by editing config.php in you SugarCRM directory.

look for the following in config.php:

  'dbconfigoption' =>
  array (
	'persistent' => true,


Change the line for 'persistent' to the following

'persistent' => false,

This will usually allow you to run in restrictive environments. but if you have a lot of users at one time you may still hit this problem. Also your host may be running out of max_connections. This may be especially true on a shared hosting connection. Try the above setting. this may solve your problems.

[caojianhua]

REsolved.

This is a known bug with V4.5RC1 by Sugar support, and fixed in V4.5 .

I made the changed in config.php , and so far works fine, I will get 3 or 4 users to test, hope it will be ok.

Many thanks for your help.
Jian