Submitted by Vince42 on Wed, 01/20/2016 - 16:06 Pro Licensee
Hi,
I had an issue with upgrade scripts (see https://virtualmin.com/node/38019) that you were able to resolve.
It showed some inconsistency between der virtual server password and the password that had been set in the MySQL module. In other words: I used to administer the MySQL passwords for the domains in the MySQL module, but changes that have been made there were obviously not set in the virtual server details, which led to the above mentioned problem.
Status:
Closed (fixed)
Comments
Submitted by JamieCameron on Thu, 01/21/2016 - 21:18 Comment #1
Right, if you change the MySQL password for a domain outside of Virtualmin (even when using another Webmin module), it will cause Virtualmin to lose track of what the actual password is.
Submitted by Vince42 on Fri, 01/22/2016 - 15:25 Pro Licensee Comment #2
Is this something that could / should be fixed? Could Webmin recognize the user account as "virtual domain user" and warn before setting the password in the MySQL module? Any other ideas? The reason why I am asking this is, that I did not do anything wrong by setting the password in the MySQL module and would therefore never thought that this could lead to a problem.
Submitted by JamieCameron on Fri, 01/22/2016 - 23:23 Comment #3
In theory, yes - but even then it would be hard to support properly, as MySQL allows you to have multiple passwords per user depending on where the connection comes from, but Virtualmin only recognizes a single MySQL user per domain. So keeping them in sync would be complex.
Perhaps we could display a warning though..
Submitted by Vince42 on Sat, 01/23/2016 - 06:39 Pro Licensee Comment #4
I guess it is not worth the effort, a warning should suffice ... something like "you are about to change the password for a virtual domain user. unless you have a good reason doing that here, we strongly advise you to rather use Virtualmin, select the domain and change the password in the module blabla ..." :)
Issue closed :)
Submitted by JamieCameron on Sat, 01/23/2016 - 15:54 Comment #5
Yes, I will add a warning about this in the next Webmin release.
Submitted by JamieCameron on Sat, 01/23/2016 - 15:54 Comment #6