Sorry, you have exceeded the maximum allowed databases on unlimited account

xneme

Registered
Nov 14, 2006
3
0
151
Hi I have a
WHM 11.28.86
CENTOS 5.5 i686 standard on hosting5

I try add new database by cpanel on account which created by root (not reseler).
This account has a unlimited sql databases and i get

"Sorry, you have exceeded the maximum allowed databases. "

I try to change limit from unlimited to high limit (1000 databases)

And stil problem occure. Account has a 58 databases;

Any ideas?
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
If you have root SSH access, please tail the cPanel error log when trying to add a database for that account:

Code:
tail -f /usr/local/cpanel/logs/error_log
Please note any errors here that appear there.
 

xneme

Registered
Nov 14, 2006
3
0
151
only this

Can't use string ("otwarte") as a HASH ref while "strict refs" in use at /usr/local/cpanel/Cpanel/DB.pm line 45.
[2011-03-14 21:23:54 +0100] warn [cpanel] Cpanel::AdminBin::adminrun(mysql) set error in context mysql
Can't use string ("otwarte") as a HASH ref while "strict refs" in use at /usr/local/cpanel/Cpanel/DB.pm line 45.
[2011-03-14 21:23:54 +0100] warn [cpanel] Cpanel::AdminBin::adminrun(mysql) set error in context mysql
[2011-03-14 21:23:54 +0100] warn [mysql::adddb] Encountered error in mysql::adddb: Sorry, you have exceeded the maximum allowed databases.
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
Per tickets I've found in our system where this error was occurring, please try running a forced cPanel update:

Code:
/scripts/upcp --force
If you notice it lock on yum update due to another yum process locking the update, please kill off any previously running yum or rpm processes:

Code:
ps aux | grep yum
ps aux | grep rpm
In almost all tickets where this occurred, it was due to yum being locked and not allowing cPanel updates to totally complete properly. The error for yum was something like the following:

Another app is currently holding the yum lock; waiting for it to exit...
 

duranduran

Well-Known Member
Apr 30, 2004
198
0
166
I have the same problema here, i have tried:

/scripts/upcp --force
/scripts/mysqlup --force
/scripts/checkperlmodules

Using X3 or any other cpanel theme, any user/account with 4 diferent servers, same error "Sorry, you have exceeded the maximum allowed databases on unlimited account" :

Can't use string ("aluguel") as a HASH ref while "strict refs" in use at /usr/local/cpanel/Cpanel/DB.pm line 45.
[2011-03-16 12:27:20 -0300] warn [cpanel] Cpanel::AdminBin::adminrun(mysql) set error in context mysql
[2011-03-16 12:27:20 -0300] warn [mysql::adddb] Encountered error in mysql::adddb: Desculpe, você excedeu o máximo de banco de dados permitidos.
Can't use string ("aluguel") as a HASH ref while "strict refs" in use at /usr/local/cpanel/Cpanel/DB.pm line 45.
Can't use string ("diegowap") as a HASH ref while "strict refs" in use at /usr/local/cpanel/Cpanel/DB.pm line 45.
Can't use string ("diegowap") as a HASH ref while "strict refs" in use at /usr/local/cpanel/Cpanel/DB.pm line 45.
[2011-03-16 12:35:56 -0300] warn [cpanel] Cpanel::AdminBin::adminrun(mysql) set error in context mysql
Can't use string ("diegowap") as a HASH ref while "strict refs" in use at /usr/local/cpanel/Cpanel/DB.pm line 45.
[2011-03-16 12:35:57 -0300] warn [cpanel] Cpanel::AdminBin::adminrun(mysql) set error in context mysql
[2011-03-16 12:35:57 -0300] warn [mysql::adddb] Encountered error in mysql::adddb: Desculpe, você excedeu o máximo de banco de dados permitidos.

Any FIX ?

ps: i do not have any yum problemas or related error messages.
 
Last edited:

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
Please open up a ticket in WHM > Support Center > Contact cPanel or using the link in my signature. Please provide the ticket number here upon opening one.

There are fixes provided here based on that exact same error noted. If they don't work, then the option is always to open up a ticket.
 

duranduran

Well-Known Member
Apr 30, 2004
198
0
166
Please open up a ticket in WHM > Support Center > Contact cPanel or using the link in my signature. Please provide the ticket number here upon opening one.

There are fixes provided here based on that exact same error noted. If they don't work, then the option is always to open up a ticket.
Hi,

Support Request Id 1287661 - Mysql error
 

Kent Brockman

Well-Known Member
PartnerNOC
Jan 20, 2008
1,287
64
178
Buenos Aires, Argentina
cPanel Access Level
Root Administrator
Hi, diging more in cpanel's forums i foud teh solution (i bealive):

Code:
mv /usr/local/cpanel/base/frontend/x3 /usr/local/cpanel/base/frontend/x3.bak
/scripts/upcp --force
The mysql creating dbs are fine now.

Thanks

Hello, can anyone in cPanel staff confirm if this is a good solution? may be caused by error in updated X3 template?

I didn't turned off db prefixing, but when trying to create a db in any panel, I've noticed that since 11.28.86, it is not showing the html with the username prefix for that db. May be a bug in the last update? or just the X3 template?
 

Attachments

Kent Brockman

Well-Known Member
PartnerNOC
Jan 20, 2008
1,287
64
178
Buenos Aires, Argentina
cPanel Access Level
Root Administrator
Hi, diging more in cpanel's forums i foud teh solution (i bealive):

Code:
mv /usr/local/cpanel/base/frontend/x3 /usr/local/cpanel/base/frontend/x3.bak
/scripts/upcp --force
The mysql creating dbs are fine now.

Thanks
Hello people. I tried this and it seems to work just fine. The problem is in a bad upgrade of the X3 template.

cPanel staff: please check this out as this issue comes to be the third time I had to upgrade using "--force" parameter to get a complete upgrade.