cPanel 10.9.0-C28 - UNLIMITED MySQL Databases Broken For All

nat

Well-Known Member
Jan 16, 2003
210
0
166
There may be a problem with the latest cPanel 10.9.0-C28 that prevents everyone from adding addiational databases.

Problem 1: All current accounts setup with a package that has "unlimited" mysql databases can't add databases.

Problem 2: Everytime you setup a new account that has a package that uses "unlimited" mysql databases, users won't be able to add databases.


To test....

1. Login to WebHost Manager
2. Click "Add Packages "
3. Complete form with...

a. New Package Name: packagetest
b. Max Databsaes: unlimited
(should already be unlimited)
c. Quota: 250
d. Bandwidth: 10240

4. Click Add

----

5. Click "Create A New Account"

6. Fill out form with...

a. Domain: testing.com
b. User: ting
c. Pass: whatever
d. Select Package: packagetest

7. Click Create

----

8. Login to cpanel for testing.com

9. Notice it says 0/unlimited

10. Click MySQL Databases

11. Try to add a database.

12. Error:
"Database Created
Added the database test1. Sorry, you have exceeded the maximum allowed
databases. "

----


All of my servers are like this. I can't beleive I'm the only one and there aren't more posts. Please test current 28 to see if your users that use a package that has "unlimited" mysql database can add databases.


----

Resolution: Yeah, yeah click "Modify and account" and change it to 999.

Problem 1: I don't want to do that for thousands of current accounts.

Problem 2: If that resolution can be automated with a script, then it still is a problem becasue all new accounts that are setup will be jacked up until script is ran again.
 
Last edited:

Shrek

Active Member
Sep 6, 2004
43
0
156
Arkansas, USA
I did find this morning that 'editing' the package is a quick fix for all accounts on the package with the problems (yes it is the ones with unlimited indeed), but the problem with editing the package is it also changes the cpanel skin (rvskins in my case), to the default and some users save the cpanel url with their theme in the favorites url which then shows the cpanel as unavailable because they don't know it is changed back.
Not a huge problem, but it's a hassle to deal with when it's 100's (not yet thousands), calling or emailing about this problem or anything else stemming from it.

Ahhhhhhhhhhhhh life as a server admin is not always boring. :rolleyes:
 

nat

Well-Known Member
Jan 16, 2003
210
0
166
Some additional problems with editing the package to fix...

1. If you have 10's of servers and about 60 packages on each server, that would suck.

2. UPGRADES! - All upgrades would get reset back to the package default.


Examples:

An account ordered 100 MBs of extra disk space - reset back to package default.

An account ordered additional subdomains - reset back to package default.

An account ordered additional add-on domains - reset back to package default.

An account ordered additional park domains - reset back to package default.


3. When a new account is setup, you will need to edit the package again becuase new accounts that are setup don't work.
 
Last edited:

david.roman

Member
PartnerNOC
Jan 16, 2006
12
0
151
Same with WHM 10.8.0 cPanel 10.9.0-C27

The same happens with WHM 10.8.0 cPanel 10.9.0-C27

Regards
 

Pat H

Member
Oct 28, 2005
9
0
151
Canada
cPanel Access Level
Root Administrator
I can confirm that this is present on C21 for new accounts, however existing accounts do appear fine.

Has anyone put in a bug report yet?

Edit: You can also use an existing package if the databases are set to unlimited, as long as it's a new account.
 
Last edited:

Pat H

Member
Oct 28, 2005
9
0
151
Canada
cPanel Access Level
Root Administrator
webtiva said:
Something similar (seems in same vain, so might need to be added to the report) is here.
I don't think it's related since that was regarding databases showing up in phpMyAdmin (root) but not under phpMyAdmin (client).

I have put a ticket in with support although I suspect I may be asked to open a bug report.
 

j2001m

Member
Sep 18, 2006
6
0
151
i have a very crap fix for this
setup a database using fantastico script
then you can add databases from you contol panel
(this may work with scripts library but i have not tryed it)
but it a work around
if you can not change you package
 

nat

Well-Known Member
Jan 16, 2003
210
0
166
MySQL fixed but.....

Subdomains broke.

1. Login to WebHost Manager
2. Click Add Package
3. Fill out form
4. Insure unlimited is listed for subdomains
5. Click Add

---

6. Click Create A New Account
7. Setup Domains
Domain: testing1.com
User: ting1
Pass: whatever
8. Select the package setup in step 3-5
9. Click Create

10. Login to Cpanel for testing1.com

Notice:
Subdomains 0/0

11. Try to setup a subdomain.

Error from domain wrapper: Sorry, you have exceeded the maximum allowed subdomains.
 
Last edited:

cPanelNick

Administrator
Staff member
Mar 9, 2015
3,488
35
158
cPanel Access Level
DataCenter Provider
As part of the security update the max mysql databases is now assumed to be zero if its not set in the cpanel users file instead of unlimited. If the concenses is that people would prefer to give out unlimited by default we can change it back.
 

cPanelNick

Administrator
Staff member
Mar 9, 2015
3,488
35
158
cPanel Access Level
DataCenter Provider
nat said:
Either way is fine for me. But if it is going to be change, there needs to be a migration manager that migrates all of the existing customers that suppose to have unlimited to the new scheme. My current clients that suppose to have unlimited subdomain can't setup any subdomains.

This only affected mysql.

What does MAXSUB= in /var/cpanel/users/username ? for this customer ?
 

nat

Well-Known Member
Jan 16, 2003
210
0
166
cpanelnick said:
As part of the security update the max mysql databases is now assumed to be zero if its not set in the cpanel users file instead of unlimited. If the concenses is that people would prefer to give out unlimited by default we can change it back.
Either way is fine for me. But if it is going to be change, there needs to be a migration manager that migrates all of the existing customers that suppose to have unlimited whatever to the /var/cpanel/user/USERS-FILE. My current clients that suppose to have unlimited subdomain can't setup any subdomains.
 
Last edited:

Shrek

Active Member
Sep 6, 2004
43
0
156
Arkansas, USA
cpanelnick said:
As part of the security update the max mysql databases is now assumed to be zero if its not set in the cpanel users file instead of unlimited. If the concenses is that people would prefer to give out unlimited by default we can change it back.
Well I for one prefer it to be unlimited. I advertise that, always have. I don't like a change made that affects my users and my company without any warning. I would prefer a tick box or something that allows unlimited... many companies offer this. some don't. I do.
 

cPanelNick

Administrator
Staff member
Mar 9, 2015
3,488
35
158
cPanel Access Level
DataCenter Provider
Shrek said:
Well I for one prefer it to be unlimited. I advertise that, always have. I don't like a change made that affects my users and my company without any warning. I would prefer a tick box or something that allows unlimited... many companies offer this. some don't. I do.

The devloper concenses is to make it unlimited and make sure its always explicitly set when creating an account so there is no question in the future. c29 coming up :)
 

Shrek

Active Member
Sep 6, 2004
43
0
156
Arkansas, USA
cpanelnick said:
The devloper concenses is to make it unlimited and make sure its always explicitly set when creating an account so there is no question in the future. c29 coming up :)

:D Thank you so very much!
 

mydomain

Well-Known Member
Aug 10, 2003
138
0
166
Hi Nick,

Upgrading to CURRENT a few releases back caused all our domains that previously had unlimited mysql databases to show up as zero, then if you edited the package, didnt change the package limits and then saved it, it went back to unlimited but they couldnt add any further databases due to reaching the limit (although set to unlimited)...same with subdomains and email accounts - has this been reported as a bug or is this related and fixed in C29, and when can we expect C29 to be available?