- Plesk for Linux
Emails are not sent/received from a Plesk server with Plesk Email Security installed. The following messages appear in
CONFIG_TEXT: 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
Due to the
skip_name_resolve MySQL directive defined in
127.0.0.1 cannot be resolved into
This is a Plesk Email Security bug with ID EXTCERT-3178, which will be fixed in future extension updates.
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