Error adding new User with Database privileges

2 posts / 0 new
Last post
#1 Thu, 07/25/2019 - 08:25
dcmoody

Error adding new User with Database privileges

This is a sub-server if it makes any difference. 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', password('v4NGCo3mzCXdLF6HzVqQy')) 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

Wed, 08/14/2019 - 13:00
tpnsolutions
tpnsolutions's picture

Hi,

Where are you adding the new user from? Need to clarify this before I can give you assistance.

Best Regards,
Peter Knowles | TPN Solutions
Email: pknowles@tpnsolutions.com | Skype: tpnassist
Topic locked