Issues with new server and MariaDB 10.3.18

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

Many thanks

Status: 
Active

Comments

The only difference between another functioning server with MariaDB 10.3.18and this new one is the kernel version

Old functioning : Linux 3.10.0-957.27.2.el7.x86_64 on x86_64 New one with issues: Linux 3.10.0-1062.1.1.el7.x86_64 on x86_64

Thank you

Unfortunately no

Once I put that file I lost the bottom part of the page - that one where I was supposed to save the modifications

So - this is not the option

Thank you

Howdy -- thanks for contacting us!

Jamie is currently working on our MariaDB 10.3 support... that's unfortunately not a database we're able to support just yet.

We hope to be releasing support for that soon though!

Hello Andrey

Thank you for feedback

What is weird is the fact that on a bunch of some other old Virtualmin machines ( which already have about 1-2 years, but with Centos 7 ) and same Virtualmin version, everything is ok.

For now, I will have to create from the beginning the right password, in every virtual server I'm about to create and migrate. If by any chance, later I will have to change the Mysql pass for a domain I believe it can be done via CLI directly in MariaDB

We'll see

Thank you