Versions:
Ver 15.1 Distrib 10.2.27-MariaDB
Webmin version 1.942
Usermin version 1.791
Virtualmin version 6.09
Virtualmin host PRETTY_NAME="Debian GNU/Linux 10 (buster)"
Database remote host PRETTY_NAME="Debian GNU/Linux 9 (stretch)"
After installing virtualmin with the install.sh script
wget http://software.virtualmin.com/gpl/scripts/install.sh.
Added the remote MySQL host correclty.
When creating a new virtual server I got the next error:
Failed to create database : SQL insert into db (host, db, user, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Create_tmp_table_priv, Lock_tables_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Execute_priv, Event_priv, Trigger_priv, Delete_history_priv) values ('localhost', 'test3', 'test3', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y') failed : Unknown column 'Delete_history_priv' in 'field list'
However, If i change the MySQL server to the local one it works perfectly, without issues.
Comments
Submitted by JamieCameron on Fri, 06/12/2020 - 21:09 Comment #1
That's an odd error, as Virtualmin should check when creating a user which columns exist. Are you running the standard version of MySQL that was installed by your Linux distribution?
Submitted by randomuser456852 on Sun, 06/14/2020 - 04:03 Comment #2
Ver 15.1 Distrib 10.2.27-MariaDB
That's the version of MariaDB, it's a galera cluster. We have the DB as external DB.
Submitted by randomuser456852 on Sun, 06/14/2020 - 04:04 Comment #3
Submitted by randomuser456852 on Wed, 06/17/2020 - 04:18 Comment #4
Please, anyone?
Submitted by JamieCameron on Fri, 06/19/2020 - 21:35 Comment #5
Is the version of MySQL on your local system different from the remote version?