I get errors on my postfix installation on ISPConfig On others VPS, correct upgrading ISP to 3.1 stable (Centos 7.2) and force reconfigure services. But now not work. Code: Jul 11 15:10:19 kvm471 postfix/smtp[12788]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'127.0.0.1' (using password: YES) Jul 11 15:10:19 kvm471 postfix/smtp[12788]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem Jul 11 15:10:19 kvm471 postfix/smtp[12788]: warning: 753292074880: flush service failure Jul 11 15:10:19 kvm471 postfix/smtp[12790]: 791142074881: to=<[email protected]>, orig_to=<root>, relay=127.0.0.1[127.0.0.1]:10024, delay=329, delays=329/0.03/0.01/0.03, dsn=4.3.2, status=deferred (host 127.0.0.1[127.0.0.1] said: 421 4.3.2 Service shutting down, closing channel (in reply to RCPT TO command)) Jul 11 15:10:19 kvm471 postfix/smtp[12790]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'127.0.0.1' (using password: YES) Jul 11 15:10:19 kvm471 postfix/smtp[12790]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem Jul 11 15:10:19 kvm471 postfix/smtp[12790]: warning: 791142074881: flush service failure Jul 11 15:10:19 kvm471 postfix/qmgr[12787]: E395B26CEEE4: from=<[email protected]>, size=653, nrcpt=1 (queue active) Jul 11 15:10:19 kvm471 amavis[12797]: (12797-01) (!)connect_to_sql: unable to connect to DSN 'DBI:mysql:database=dbispconfig;host=127.0.0.1;port=3306': Access denied for user 'ispconfig'@'127.0.0.1' (using password: YES) Well, try search all files on postfix with password. (note password not real, but all password are same) Code: grep 'password' /etc/postfix/* /etc/postfix/main.cf:# NOTE: if you use this feature for accounts not in the UNIX password /etc/postfix/main.cf:# NOTE: if you use this feature for accounts not in the UNIX password /etc/postfix/main.cf:# NOTE: if you use this feature for accounts not in the UNIX password /etc/postfix/main.cf~2:# NOTE: if you use this feature for accounts not in the UNIX password /etc/postfix/main.cf~2:# NOTE: if you use this feature for accounts not in the UNIX password /etc/postfix/main.cf~2:# NOTE: if you use this feature for accounts not in the UNIX password /etc/postfix/main.cf~3:# NOTE: if you use this feature for accounts not in the UNIX password /etc/postfix/main.cf~3:# NOTE: if you use this feature for accounts not in the UNIX password /etc/postfix/main.cf~3:# NOTE: if you use this feature for accounts not in the UNIX password /etc/postfix/mysql-virtual_client.cf:password = 2ac36hsgBqsgIq8765shwb0e171672df /etc/postfix/mysql-virtual_domains.cf:password = 2ac36hsgBqsgIq8765shwb0e171672df /etc/postfix/mysql-virtual_email2email.cf:password = 2ac36hsgBqsgIq8765shwb0e171672df /etc/postfix/mysql-virtual_forwardings.cf:password = 2ac36hsgBqsgIq8765shwb0e171672df /etc/postfix/mysql-virtual_mailboxes.cf:password = 2ac36hsgBqsgIq8765shwb0e171672df /etc/postfix/mysql-virtual_outgoing_bcc.cf:password = 2ac36hsgBqsgIq8765shwb0e171672df /etc/postfix/mysql-virtual_policy_greylist.cf:password = 2ac36hsgBqsgIq8765shwb0e171672df /etc/postfix/mysql-virtual_recipient.cf:password = 2ac36hsgBqsgIq8765shwb0e171672df /etc/postfix/mysql-virtual_relaydomains.cf:password = 2ac36hsgBqsgIq8765shwb0e171672df /etc/postfix/mysql-virtual_relayrecipientmaps.cf:password = 2ac36hsgBqsgIq8765shwb0e171672df /etc/postfix/mysql-virtual_sender.cf:password = 2ac36hsgBqsgIq8765shwb0e171672df /etc/postfix/mysql-virtual_sender_login_maps.cf:password = 2ac36hsgBqsgIq8765shwb0e171672df /etc/postfix/mysql-virtual_transports.cf:password = 2ac36hsgBqsgIq8765shwb0e171672df Well if try on locahost connect: Code: mysql -u ispconfig -p2ac3621ed334efc7669fbb0e171672df Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 1104 Server version: 10.1.14-MariaDB MariaDB Server Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> I don't understand why it's the problem. Of course, And in anticipation of the typical reply "You must update your ISPConfig" I must say: 1. Download latest stable ISPConfig3-stable 2. Unpack and php -q update.php 3. REINSTALL ALL SERVICIES except apache.
I guess your mysql test command might be wrong, as it does not test a mysql connection trough the IP 127.0.0.1. Try this: mysql -h 127.0.0.1 -u ispconfig -p2ac3621ed334efc7669fbb0e171672df The issues is that mysql does not accpets connections over the localhost network, so it's not a issue in the ispconfig configuration and thats why a reconfigure did not help. Check the mysql config and ensure that you can connect with localhost and 127.0.0.1 to mysql.