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

7 posts / 0 new
Last post
#1 Tue, 07/30/2019 - 10:10
ctflight

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

*** 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/a45a2b839bc3ffc80f25... ------------->> NOT WORKING ....
  3. my.conf, sql_mode = NO_ENGINE_SUBSTITUTION, restart MariaDB from http://www.webhostingtalk.com/showthread.php?t=1752876 ------------------->> NOT WORKING ....
Tue, 07/30/2019 - 10:43
suskozaver

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

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

Tue, 07/30/2019 - 10:48 (Reply to #2)
ctflight

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

I forget to put in list ....

Tue, 07/30/2019 - 17:05
Jfro

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

Wed, 07/31/2019 - 08:37
Christos_Tzeremes

QuickFix for the great Virtualmin and MariaDB 10.2 - 10.4.6

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

regards to all !!!

Christos Tzeremes IT Expert @ nasa.gr Thessalonikh GREECE [MACEDONIA] ctzeremes[at]nasa.gr

Tue, 09/17/2019 - 23:15
IliyaHristov

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 ;)

Fri, 10/04/2019 - 11:31 (Reply to #6)
miklovestech

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

Topic locked