virtualmin not creating mysql database for new virtual servers

Submitted by sinisham82 on Sun, 02/24/2019 - 02:39

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

Submitted by andreychek on Sun, 02/24/2019 - 08:27

Howdy -- thanks for contacting us!

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

Submitted by sinisham82 on Sun, 02/24/2019 - 22:17

hi, my database version is 10.3.13-MariaDB

Submitted by JamieCameron on Sun, 02/24/2019 - 22:59

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..

Submitted by sinisham82 on Mon, 02/25/2019 - 01:05

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

Submitted by sinisham82 on Wed, 02/27/2019 - 22:44

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

Submitted by andreychek on Thu, 02/28/2019 - 08:51

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.

Submitted by sinisham82 on Thu, 02/28/2019 - 16:15

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

Submitted by IssueBot on Thu, 03/14/2019 - 17:30

Status: Fixed ยป Closed (fixed)

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