Database password not updating correctly when enabling Virtual Server

Submitted by CooLMinE on Wed, 12/07/2016 - 05:45

I've noticed that when I disable a Virtual Server then re-enable it, the database connection always fails (for that particular Virtual Server).

The password seems to be the same in the mysql.user table (the authentication_string does not change) but the user will not be able to connect to the database until he/she changes the password.

The weird part is, going to "Virtualmin -> Edit databases -> Passwords -> Custom password" and setting the password as it was before does not help. You first need to put a different password and then input the same one as it was before (double update) in order for it to work.

This issue has been replicated on 4 different servers without any additional steps other than disabling and re-enabling the virtual server.

Status: 
Closed (fixed)

Comments

Submitted by antioch on Mon, 12/12/2016 - 14:36

just came here to report the exact same thing. +1

Submitted by JamieCameron on Mon, 12/12/2016 - 15:11

This may be related to a known issue with some MySQL versions which changed the semantics of the "set password" command.

Which release of MySQL are you running there?

Submitted by CooLMinE on Tue, 12/13/2016 - 13:17

mysql Ver 14.14 Distrib 5.7.16, for Linux (x86_64) using EditLine wrapper (current latest version)

Submitted by JamieCameron on Tue, 12/13/2016 - 17:47

Ok, this will be fixed in the next release of Virtualmin (5.06).

Submitted by JamieCameron on Tue, 12/13/2016 - 17:48

Status: Active ยป Fixed

Submitted by CooLMinE on Wed, 12/14/2016 - 00:42

Thanks JamieCameron.

I will take a look at the fix tonight and I will let you know if it resolves the problem.