Submitted by clwheatley on Wed, 12/15/2010 - 15:58
After changing a sub-server into an stand alone domain I immediately had issues with the original parent server no longer having MySQL access. The original user name and password are correct but will not connect. Creating a new user with database privileges does get around the issue.
I attempted to change the password for the domain admin of the parent domain but received what appears to be a truncated error message: Failed to modify server : A target server must have email enabled if any aliases do
So, I enabled email, changed the password, and then tried to disable email again. No luck. I am stuck getting the same error message and I need to disable email for this domain because their mail is hosted elsewhere.
Where's this coming from?
Status:
Closed (fixed)
Comments
Submitted by JamieCameron on Wed, 12/15/2010 - 16:54 Comment #1
The MySQL change is expected - if you convert a sub-server into a top-level virtual server, it will get its own new login that applies for SSH, FTP, Virtualmin and MySQL.
Regarding the second issue, does this virtual server have any alias domains?
Submitted by clwheatley on Thu, 12/16/2010 - 12:38 Comment #2
I don't understand why the MySQL change is expected - unless, perhaps I wasn't entirely clear. The top level domain's MySQL access for the domain administrator stopped working when the sub-server was moved. How should moving the sub-server affect the parent server's MySQL access?
The top lever server does have domain aliases.
Submitted by JamieCameron on Thu, 12/16/2010 - 13:14 Comment #3
Do you mean the original top-level domain admin lost access via MySQL to databases that were not in the moved domain?
Submitted by clwheatley on Thu, 12/16/2010 - 14:02 Comment #4
That is correct
Submitted by JamieCameron on Fri, 12/17/2010 - 15:09 Comment #5
Ok, I see the bug that is causing this now - the old top-level server's password for MySQL gets incorrectly changes to the password of the server you split off! The fix is to change the top-level server's password to something different, then change it back again.
The next Virtualmin release (3.84) will have a fix for this bug.
Submitted by clwheatley on Thu, 12/23/2010 - 13:07 Comment #6
Interesting. I'll see about confirming that on my system and will let you know the result. Thanks as always.
Submitted by clwheatley on Thu, 12/23/2010 - 13:13 Comment #7
Ok, I changed the password for the domain administrator account for the original top-level server and then changed it back. That account still does not have access to MySQL.
Submitted by JamieCameron on Thu, 12/23/2010 - 15:35 Comment #8
If you go to Webmin -> Servers -> MySQL Database -> User Permissions, does the domain's mysql account appear?
If so, does it appear on the Database Permissions page, also in the MySQL module?
Finally, if you validate the domain (at Limits and Validation -> Validate Virtual Servers), does it report any errors?
Submitted by Issues on Thu, 01/06/2011 - 18:22 Comment #9
Automatically closed -- issue fixed for 2 weeks with no activity.