Can't create mysql database

fleksi

Well-Known Member
Sep 17, 2003
125
0
166
I can't create mysql databases. Message: Sorry, you have exceeded the maximum allowed databases., but I have set unlimited mysql dbs.

General account information shows:

MySQL Databases NA / unlimited
MySQL Disk Space NA Megabytes
MySQL version 4.1.20-standard

But I am use mysql 4.1.21, cpanel CURRENT 10.9.0-CURRENT_6.
Please help me.

Thanks
 
Last edited:

perfect-games

Well-Known Member
Nov 11, 2004
100
0
166
alberta
well for starters i do know it cpanel
i have switched to stable again

but when i was using current was saying something about aprlib needs symblic link

so i yet to check that out when its offpeak

Steve ;)
 

perfect-games

Well-Known Member
Nov 11, 2004
100
0
166
alberta
i also yet to discover the problem gets worse
any of you lot having issues with webmail like horde

this iswhat i getting

Internal Server Error

Unable to open engine binary (php) at cpsrvd-ssl.pl line 4396
main::phpHandler() called at cpsrvd-ssl.pl line 3305
main::dodoc_webmaild() called at cpsrvd-ssl.pl line 637
main::dodoc() called at cpsrvd-ssl.pl line 543



cpsrvd/10.9.6

Steve
 

AndyReed

Well-Known Member
PartnerNOC
May 29, 2004
2,221
4
193
Minneapolis, MN
fleksi said:
I can't create mysql databases. Message: Sorry, you have exceeded the maximum allowed databases., but I have set unlimited mysql dbs.
See if this helps:

cd /var/cpanel/users
Find MAXSQL=
and change the word unlimited to a number, let's say 25
Save the file and then Restart the cpanel
/sbin/service cpanel restart
 

fleksi

Well-Known Member
Sep 17, 2003
125
0
166
I have set the account quota to use a finite number rather than unlimited but still no luck.

Please help me
 

otsh

Member
Sep 9, 2006
7
0
151
having this issue as well mysql maintenance page is just freaking blank, running "current" why it matters i dont know considering rolling back just breaks even more things. I love spending my weekend trying to resolve their problems.
 

otsh

Member
Sep 9, 2006
7
0
151
and let me state before someone suggests it, no the ever so popular "upcp --force" will not work on this one nor will anything else in /scripts. Nothing in the error logs
 

AndyReed

Well-Known Member
PartnerNOC
May 29, 2004
2,221
4
193
Minneapolis, MN
otsh said:
and let me state before someone suggests it, no the ever so popular "upcp --force" will not work on this one nor will anything else in /scripts. Nothing in the error logs
Did you check the uid.gid of the user with MySQL problem? Make sure the ownership and permission are correct on the /var/mysql/USER_DB
Does this happen with all users on your server? Did you try adding a DB to the user with the problem, manually?
 

baohx

Member
Sep 2, 2003
23
0
151
AZ, USA
bug entered

I didn't see a bug for this in bugzilla (at least didn't see one from the bug subjects), so I've entered one. It's 4616.
 

dezignguy

Well-Known Member
Sep 26, 2004
533
0
166
Ok... I found out how to fix this... it's different (on the face, under the hood it's likely related) from the unlimited mysql db issue that the last poster posted the bug for.

I had this issue with a client's account, but I noticed that my account and accounts for other customers worked fine and the mysql page came up in full. The issue seems to stem from accounts that have no existing databases, even though they should be allowed databases. This is probably related to the changes for 'unlimited' databases.

The fix is simple... go into PHPMyAdmin (I used the root WHM PHPMyAdmin, but I assume that the customer's phpmyadmin would likely work as well) and create a database for the client... name the database in this format: accountname_dbname and then your cpanel mysql page will come back and you can add and edit databases again. NOTE: I would add a new database and delete the one you created through phpmyadmin, because if you used the root phpmyadmin it's likely not going to have the user and permissions settings correct.

Someone should go ahead and post a bug for this... I don't have the time right now.
 

WebHostDog

Well-Known Member
Sep 3, 2006
144
1
166
cPanel Access Level
Website Owner
Hello is it any global solution for this ? Cannot go and make a DB for every customer on every CPanel :) ....




Thanks.
 

angelina_holy

Well-Known Member
Aug 6, 2006
113
0
166
What do you see in whm ? Give some finite number in mysql database from whm . restart mysql service and check