Good day everyone
I have to migrate an old install of Virtualmin to a new one
Hence we have created a new machine with CentOS Linux release 7.7.1908, default install of Virtualmin, upgraded PHP to version 7.3.9 and MariaDb from 5.5 to 10.3.18 - the old servers have MariaDB 10.3.18 without any issue
If I'm trying to set a new password for an already created domain I'm stuck in the following error:
Changing MySQL password .. .. MySQL database failed! : mysql::execute_sql_logged failed : SQL set password for 'somedomain'@'127.0.0.1' = 'password' failed : Password hash should be a 41-digit hexadecimal number at /usr/libexec/webmin/web-lib-funcs.pl line 1477.
Using the workaround from https://sourceforge.net/p/webadmin/bugs/5285/ by setting "Password hashing mode" to "Old" did not worked
Webmin version 1.930 Usermin version 1.780 Virtualmin version 6.07 Authentic theme version 19.39-2
What can I do please ?
P.S the other problem faced on this new machine was : Creating MySQL login .. .. MySQL database failed! : mysql::execute_sql_logged failed : SQL insert into user (host, user, ssl) But it was solved temporarily by changing : sql_mode = NO_ENGINE_SUBSTITUTION in my.cnf