This website is deprecated, and remains online only for historic access to old issues and docs for historic versions of Virtualmin. It has been unmaintained for several years, and should not be relied on for up-to-date information. Please visit www.virtualmin.com instead.

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

7 posts / 0 new

Topic locked

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

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

#2 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

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

#4 Tue, 07/30/2019 - 17:05

Jfro

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

#5 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

#6 Tue, 09/17/2019 - 23:15

IliyaHristov

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

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

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