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
Submitted by andreychek on Sun, 02/24/2019 - 08:27 Comment #1
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 Comment #2
hi, my database version is 10.3.13-MariaDB
Submitted by JamieCameron on Sun, 02/24/2019 - 22:59 Comment #3
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 Comment #4
thanks, when you say shortly, do you mean weeks or days :) is there an alternative ? can i have 2 database servers ?
Submitted by JamieCameron on Mon, 02/25/2019 - 23:41 Comment #5
Days. If you need a quicker fix, you can apply this patch : https://github.com/virtualmin/virtualmin-gpl/commit/a45a2b839bc3ffc80f25...
Submitted by sinisham82 on Wed, 02/27/2019 - 22:44 Comment #6
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 Comment #7
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.
Patching is not necessary. The new version 6.06-2 is out.
Submitted by sinisham82 on Thu, 02/28/2019 - 16:15 Comment #9
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 Comment #10
Automatically closed - issue fixed for 2 weeks with no activity.