Trying to add a new user with database access to a virtual server, and I get this error message:
Failed to save user : SQL insert into user (host, user, ssl_type, ssl_cipher, x509_issuer, x509_subject, plugin, authentication_string) values ('localhost', 'moodlesql.employ', '', '', '', '', 'mysql_native_password', '*59481B563168B888D3A7CC391AEDC93FCEE7F9AB') failed : The target table user of the INSERT is not insertable-into
CentOS Linux release 7.6.1810 (Core)
mysql Ver 15.1 Distrib 10.4.6-MariaDB, for Linux (x86_64) using readline 5.1
Checking Configuration
The status of your system is being checked to ensure that all enabled features are available, that the mail server is properly configured, and that quotas are active ..
Your system has 15.51 GB of memory, which is at or above the Virtualmin recommended minimum of 256 MB.
Mail server Postfix is installed and configured.
Postfix can support per-domain outgoing IP addresses, but is not currently configured to do so. This can be setup in the Postfix Mailserver module.
Apache is installed.
The following PHP versions are available : 5.4.16 (/bin/php-cgi), 7.2.10 (/opt/rh/rh-php72/root/usr/bin/php-cgi), 5.4 (mod_php)
The following PHP-FPM versions are available on this system : 5.4.16 7.2.10
Webalizer is installed.
Apache is configured to host SSL websites.
MySQL is installed and running.
ProFTPD is installed.
Logrotate is installed.
Plugin AWstats reporting is installed OK.
Plugin DAV Login is installed OK.
Plugin Protected web directories is installed OK.
Using network interface eth0 for virtual IPs.
IPv6 addresses are available, using interface eth0.
Both user and group quotas are enabled for home and email directories.
All commands needed to create and restore backups are installed.
The selected package management and update systems are installed OK.
Chroot jails are available on this system
Comments
Submitted by dcmoody on Thu, 07/25/2019 - 08:01 Comment #1
Submitted by JamieCameron on Fri, 07/26/2019 - 00:23 Comment #2
What does the MySQL command
select version()
output on your system?You can also see this at Webmin -> Servers -> MySQL Database, at the top of the page.
Submitted by safepoint on Wed, 09/18/2019 - 05:13 Pro Licensee Comment #3
I have the same problem.
select version() gives back ->
+----------------+ | version() | +----------------+ | 10.4.8-MariaDB | +----------------+ 1 row in set (0.000 sec)
extra info: I can create databases via the Virtualmin in Mariadb without any problems, but when I want to create a database to a website I get an 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', 'fill', '', '', '', '') failed : The target table user of the INSERT is not insertable-into at /usr/libexec/webmin/web-lib-funcs.pl line 1477. Saving server details .. .. done
Submitted by safepoint on Wed, 09/18/2019 - 08:16 Pro Licensee Comment #4
I down graded to MariaDB 10.2.27 , but it made no difference for me. Still the same error message.
Submitted by JamieCameron on Sun, 09/22/2019 - 16:41 Comment #5
Once we release Virtualmin 6.08 it will fix this issue with the MariaDB 10.x series.