Emails are not sent/received from a Plesk server with Plesk Email Security installed. The following messages appear in
amavis: (03486-01) (!)connect_to_sql: unable to connect to DSN 'DBI:mysql:database=emailsecurity;host=127.0.0.1;port=3306': Access denied for user '<database_name>'@'127.0.0.1' (using password: YES)
amavis: (03486-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 132) line 253.
amavis: (03486-01) (!)Requesting process rundown after fatal error
#EXTCERT-3178 "Reverted the hostname in the Amavis configuration file to localhost and enabled httpd_can_network_connect_db policy for SELinux. If you still encounter database connection issues, then disable enforcing mode in SELinux."
- Plesk Email Security 1.1.9 09 November 2020 (Linux)
If update is not possible for some reason you may try the following
Apply the following workaround:
Connect to the Plesk server via SSH.
Open the MySQL configuration file
my.cnfin a text editor. In this example, we are using the vi editor:
on CentOS/RHEL-based distributions:
# vi /etc/my.cnf
on Debian/Ubuntu-based distributions:
# vi /etc/mysql/my.cnf
Comment out the
skip_name_resolvedirective by placing a # (hash) character at the beginning of the line:
Save the changes and close the file.
Restart the MySQL service:
# service mariadb restart || service mysql restart
Resend emails from the mail queue:
# postsuper -r ALL