Can't create mysql database

[fleksi]

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

[perfect-games]

i having this issue as well
think this may be cpanel bug

Steve

[JayAtjeu]

One of my clients is having a similar issue. Am yet to find the cause.

[perfect-games]

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

[MN-Robert]

i having this issue as well
think this may be cpanel bug

Steve

What's new LOL!

[Jesse J]

Any word on this??

[perfect-games]

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:hpHandler() 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

[Jesse J]

Not seeing the Horde issue here.. just the MySql one. Anyone else?

[AndyReed]

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]

I have set the account quota to use a finite number rather than unlimited but still no luck.

Please help me

[otsh]

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]

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]

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]

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]

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.