virtualmin not creating mysql database for new virtual servers

HI there, for some reason when i create new virtual server, virtualmin does not create mysql database even though ive selected it from the list, it gives this error

This script cannot be installed, as this virtual server does not meet its requirements : A MySQL database is needed

when i go to edit virtual server and tick mysql again it gives this error.

Creating MySQL login .. .. MySQL database failed! : mysql::execute_sql_logged failed : SQL insert into user (host, user, ssl_type, ssl_cipher, x509_issuer, x509_subject) values ('localhost', 'hostmax', '', '', '', '') failed : Field 'authentication_string' doesn't have a default value at /usr/libexec/webmin/web-lib-funcs.pl line 1478. apparently from what ive gathered it is a problem with version of virtualmin, at the moment i am using 6.0.6 pro thanks in advance

Status: 
Closed (fixed)

Comments

Howdy -- thanks for contacting us!

What MySQL or MariaDB version is it that you're using there?

hi, my database version is 10.3.13-MariaDB

This does look like a known problem with Virtualmin 6.06 with MariaDB 10.2 and above.

We are going to release a fix for this shortly..

thanks, when you say shortly, do you mean weeks or days :) is there an alternative ? can i have 2 database servers ?

thanks for your reply, can you please provide some info on how to apply this patch?!

A simple way to do that would be to edit /usr/libexec/webmin/virtual-server/feature-mysql.pl, and remove the lines listed as red in the patch, and replace them with the lines listed in green.

You should just be removing two lines, and replacing them with four lines.

After doing that, restart Webmin.

Joe's picture
Submitted by Joe on Thu, 02/28/2019 - 09:01 Pro Licensee

Patching is not necessary. The new version 6.06-2 is out.

hi, i still cant see the new version, will it show up in virtualmin package updates?

Status: Fixed ยป Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.