As the title says, we are experiencing an issue when attempting to update a global virtual server password whilst MariaDB is enabled.
After going into Edit Virtual Server > Configurable Settings > Password and setting it to a new value, the save operation completes successfully with no errors reported by Virtualmin. However, the WordPress installation on the virtual server still works even though it has not been updated to use the new password we just set, which was our first clue that something was going wrong.
When we updated WordPress to use the new password, it failed to connect to the database, which tells us that Virtualmin reported a false positive success message when in fact it did not change the database password at all (as the old password still works at this point).
Going into Webmin > Servers > MySQL Database Server > User Permissions, clicking on the username in question, and changing the password from that interface (rather than from the Edit Virtual Server interface) results in the following error: Column "select_priv" is not updatable.
We are running MariaDB 10.4.8 on the latest CentOS 7 x64 operating system with the latest release of Virtualmin (6.08 Professional) and Webmin (1.941). I thought Virtualmin had compatibility with MariaDB 10.4.x? Is there a way we can resolve this issue? Because of the nature of this bug we are currently unable to reliably change any virtual server passwords. This presents a possible security risk if we ever need to change virtual server passwords for reasons of a compromise or other related issue.
Thanks for any assistance provided! -Logan