MySQL database failed! ............. The target table user of the INSERT is not insertable-into at ...

Virtualmin
1

*** Virtualmin ERROR >> … MySQL database failed! : mysql::execute_sql_logged failed : SQL insert into user (host, user, ssl_type, ssl_cipher, x509_issuer, x509_subject) values (‘localhost’, ‘place’, ‘’, ‘’, ‘’, ‘’) failed : The target table user of the INSERT is not insertable-into at /usr/libexec/webmin/web-lib-funcs.pl line 1476. ***

My mysql is Ver 15.1 Distrib 10.4.6-MariaDB, for Linux (x86_64) using readline 5.1
My OS: CentOS 7 + Virtualmin version: 6.07, Webmin version: 1.921, Usermin version: 1.771

PLEASE can anyone help i try almost everything but i cant create a database for domain also i cant install scripts …

  1. STRICT_TRANS_TABLES from sql_mode in /etc/my.cnf ------------------->> NOT WORKING
  2. The Quick fix for MariaDB 10.1 systems https://github.com/virtualmin/virtualmin-gpl/commit/a45a2b839bc3ffc80f2562d51b89c98e37ee4d2e ------------->> NOT WORKING …
  3. my.conf, sql_mode = NO_ENGINE_SUBSTITUTION, restart MariaDB from http://www.webhostingtalk.com/showthread.php?t=1752876 ------------------->> NOT WORKING …
2

tried this solution? http://www.webhostingtalk.com/showthread.php?t=1752876

at the bottom, my.conf, sql_mode = NO_ENGINE_SUBSTITUTION, restart MariaDB

3

Dear friend thank you so much for your answer yes i also try this but … NOT WORKING :frowning:

I forget to put in list …

4

did YOU READ PROBLEMS WITH mARIADB 10.4X AND VIRTUALMIN HERE ?
https://www.virtualmin.com/node/66717

5

QuickFix for the great Virtualmin and MariaDB 10.2 - 10.4.6

https://www.virtualmin.com/node/66733

regards to all !!!

6

Hi all,
the complete and easiest solution that I’ve found was :

  1. Make a backup of file feature-mysql.pl :
    mv /usr/share/webmin/virtual-server/feature-mysql.pl /usr/share/webmin/virtual-server/feature-mysql.pl.bak

  2. Get the latest feature-mysql.pl from here :
    https://github.com/virtualmin/virtualmin-gpl/blob/master/feature-mysql.pl

then put it in /usr/share/webmin/virtual-server/

That’s all :wink:

7

Wow. You are my hero. This was stressing me out so much! I tried EVERYTHING!