Issues with new server and MariaDB 10.3.18

Submitted by dragos@dall.ro on Wed, 09/18/2019 - 05:16

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

Submitted by dragos@dall.ro on Wed, 09/18/2019 - 05:21

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

Submitted by dragos@dall.ro on Wed, 09/18/2019 - 07:21

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

Submitted by andreychek on Wed, 09/18/2019 - 09:20

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!

Submitted by dragos@dall.ro on Wed, 09/18/2019 - 09:47

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