Synchronize MySQL root password change [#32316]

Submitted by yngens on Thu, 02/06/2014 - 18:20

If I go to Webmin > Servers > MySQL Database Server > Change Administration Password, change the password and then immediately go to Virtualmin > System Settings > Re-Check Configuration then it gives:

MySQL does not appear to be installed and running on your system, or has not yet been set up properly in Webmin's MySQL Database module. If your system does not use MySQL, it should be disabled in Virtualmin's module configuration page.

So I have to click on an active hyperlink "MySQL Database" in the above message, which is linked to https://xx.xxx.xxx.xx:10000/mysql and enter the same password once again. Only then Virtualmin configuration check passes through.

Is it possible to somehow synchronize MySQL root password change throughout the system to avoid this kind of duplicate actions and confusion?

Thanks!

Status:

Closed (fixed)

Comments

Submitted by JamieCameron on Thu, 02/06/2014 - 20:11 Comment #1

That seems like a bug, as the "Change Administration Password" page is support to change the actual password and what Webmin / Virtualmin uses.

Do you perhaps have multiple MySQL root users?

Submitted by yngens on Thu, 02/06/2014 - 21:52 Comment #2

I don't think so. This is happening on a clean Virtualmin instance. Could you please test on your end on any newly installed Virtualmin?

Submitted by JamieCameron on Fri, 02/07/2014 - 11:51 Comment #3

I tested this, but still couldn't re-produce the issue.

Does your MySQL password perhaps contain any special characters, like quotes?

Also, do you have the DBI and DBD::mysql perl modules installed?

Submitted by yngens on Tue, 02/11/2014 - 00:17 Comment #4

After receiving your last reply and making sure both DBI and DBD::mysql perl modules are present, I recalled I cloned MySQL module in Webmin Configuration once, because needed to make it available in two different places. However, since that was done just for convenience purpose, I've removed the cloned version. And now changing MySQL root password in the original module is correctly synced with Virtualmin Configuration check.

This resolves my issue. However, I'd suggest you to give another thought to this issue as many users might clone some Webmin modules and start using them believing they would behave exactly as the original ones. In fact it appears they don't.

Thanks for helping me to figure out this mystery.