Apparantly when installing ISPConfig it assumes my external IP to be used for a bunch of services. In this case Amavis and Postfix. How can I get it to connect with MySQL? For Postfix I know I can alter 20 postfix mysql.cf files but it feels wrong. Its the same stuff in all those files anyway. When I change host ip in all those files still the amavis error occurs and I get new ones about cant send data. I have no clue where the amavis conf files is reciding. I also havent messed with anything it was this way from the start after installing ISPConfig 3 =). maillog Code: Mar 22 17:19:29 arty postfix/pickup[7824]: 41E772A0878B: uid=5005 from=<web3> Mar 22 17:19:29 arty postfix/proxymap[11922]: warning: connect to mysql server 79.99.2.34: Can't connect to MySQL server on '79.*.2.*' (111) Mar 22 17:19:29 arty postfix/cleanup[11921]: 41E772A0878B: message-id=<[email protected]> Mar 22 17:19:29 arty postfix/qmgr[7823]: 41E772A0878B: from=<[email protected]>, size=841, nrcpt=1 (queue active) Mar 22 17:19:29 arty amavis[9442]: (09442-01) (!)connect_to_sql: unable to connect to DSN 'DBI:mysql:database=dbispconfig;host=79.*.2.*;port=3306': Can't connect to MySQL server on '79.*.2.*' (111) Mar 22 17:19:29 arty amavis[9442]: (09442-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 86) line 244, <GEN24> line 3. Mar 22 17:19:29 arty amavis[9442]: (09442-01) (!)Requesting process rundown after fatal error Mar 22 17:19:29 arty postfix/smtp[11924]: 41E772A0878B: to=<[email protected]>, relay=127.0.0.1[127.0.0.1]:10024, delay=0.24, delays=0.03/0/0.01/0.2, 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)) Mar 22 17:19:29 arty postfix/smtp[11924]: warning: connect to mysql server 79.*.2.*: Can't connect to MySQL server on '79.*.2.*' (111) Mar 22 17:19:29 arty postfix/smtp[11924]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem Mar 22 17:19:30 arty postfix/qmgr[7823]: warning: private/amavis socket: malformed response Mar 22 17:19:30 arty postfix/qmgr[7823]: warning: transport amavis failure -- see a previous warning/fatal/panic logfile record for the problem description Mar 22 17:19:30 arty postfix/master[7822]: warning: process /usr/lib/postfix/smtp pid 11924 exit status 1 Mar 22 17:19:30 arty postfix/master[7822]: warning: /usr/lib/postfix/smtp: bad command startup -- throttling Mar 22 17:19:30 arty postfix/error[11930]: 41E772A0878B: to=<[email protected]>, relay=none, delay=1.3, delays=0.03/1.2/0/0.01, dsn=4.3.0, status=deferred (unknown mail transport error) Mar 22 17:19:30 arty postfix/error[11930]: warning: connect to mysql server 79.*.2.*: Can't connect to MySQL server on '79.*.2.*' (111) Mar 22 17:19:30 arty postfix/error[11930]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem Mar 22 17:19:31 arty postfix/qmgr[7823]: warning: private/retry socket: malformed response Mar 22 17:19:31 arty postfix/qmgr[7823]: warning: transport retry failure -- see a previous warning/fatal/panic logfile record for the problem description Mar 22 17:19:31 arty postfix/master[7822]: warning: process /usr/lib/postfix/error pid 11930 exit status 1 Mar 22 17:19:31 arty postfix/master[7822]: warning: /usr/lib/postfix/error: bad command startup -- throttling Mar 22 17:19:31 arty postfix/qmgr[7823]: 41E772A0878B: to=<[email protected]>, relay=none, delay=2.3, delays=0.03/2.2/0/0, dsn=4.3.0, status=deferred (unknown mail transport error) Mar 22 17:19:31 arty postfix/qmgr[7823]: warning: connect to mysql server 79.*.2.*: Can't connect to MySQL server on '79.*.2.*' (111) Mar 22 17:19:31 arty postfix/qmgr[7823]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem Mar 22 17:19:32 arty postfix/master[7822]: warning: process /usr/lib/postfix/qmgr pid 7823 exit status 1 netstat -tap Code: Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 127.0.0.1:10025 *:* LISTEN 7822/master tcp 0 0 127.0.0.1:mysql *:* LISTEN 7681/mysqld tcp 0 0 127.0.0.1:spamd *:* LISTEN 3611/spamd.pid tcp 0 0 *:webcache *:* LISTEN 9969/apache2 tcp 0 0 *:www *:* LISTEN 9969/apache2 tcp 0 0 *:tproxy *:* LISTEN 9969/apache2 tcp 0 0 *:ftp *:* LISTEN 10017/pure-ftpd (SE tcp 0 0 *:smtp *:* LISTEN 7822/master tcp 0 0 *:https *:* LISTEN 9969/apache2 tcp 0 0 127.0.0.1:10024 *:* LISTEN 7887/amavisd (maste tcp 0 0 arty.example:44051 arty.example.s:www TIME_WAIT - tcp 0 0 arty.example.s:ftp arty.example:50359 TIME_WAIT - tcp6 0 0 [::]:pop3 [::]:* LISTEN 9866/couriertcpd tcp6 0 0 [::]:imap2 [::]:* LISTEN 9756/couriertcpd tcp6 0 0 [::]:ftp [::]:* LISTEN 10017/pure-ftpd (SE tcp6 0 0 [::]:ssh [::]:* LISTEN 3393/sshd tcp6 0 0 [::]:imaps [::]:* LISTEN 9849/couriertcpd tcp6 0 0 [::]:pop3s [::]:* LISTEN 9891/couriertcpd tcp6 0 1968 arty.example.s:ssh h86n2c1o1100.bred:56059 ESTABLISHED 32461/1 postconf -n Code: alias_database = hash:/etc/aliases alias_maps = hash:/etc/aliases append_dot_mydomain = no biff = no body_checks = regexp:/etc/postfix/body_checks broken_sasl_auth_clients = yes config_directory = /etc/postfix content_filter = amavis:[127.0.0.1]:10024 header_checks = regexp:/etc/postfix/header_checks html_directory = /usr/share/doc/postfix/html inet_interfaces = all mailbox_size_limit = 0 message_size_limit = 0 mime_header_checks = regexp:/etc/postfix/mime_header_checks mydestination = arty.example.se, localhost, localhost.localdomain myhostname = arty.example.se mynetworks = 127.0.0.0/8 [::1]/128 myorigin = /etc/mailname nested_header_checks = regexp:/etc/postfix/nested_header_checks proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps $virtual_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps $recipient_canonical_maps $relocated_maps $transport_maps $mynetworks $virtual_mailbox_limit_maps readme_directory = /usr/share/doc/postfix receive_override_options = no_address_mappings recipient_delimiter = + relay_domains = mysql:/etc/postfix/mysql-virtual_relaydomains.cf relay_recipient_maps = mysql:/etc/postfix/mysql-virtual_relayrecipientmaps.cf relayhost = smtp_tls_session_cache_database = btree:${data_directory}/smtp_scache smtpd_banner = $myhostname ESMTP $mail_name (Ubuntu) smtpd_client_restrictions = check_client_access mysql:/etc/postfix/mysql-virtual_client.cf smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, check_recipient_access mysql:/etc/postfix/mysql-virtual_recipient.cf, reject_unauth_destination smtpd_sasl_auth_enable = yes smtpd_sasl_authenticated_header = yes smtpd_sender_restrictions = check_sender_access mysql:/etc/postfix/mysql-virtual_sender.cf smtpd_tls_cert_file = /etc/postfix/smtpd.cert smtpd_tls_key_file = /etc/postfix/smtpd.key smtpd_tls_security_level = may smtpd_tls_session_cache_database = btree:${data_directory}/smtpd_scache smtpd_use_tls = yes transport_maps = proxy:mysql:/etc/postfix/mysql-virtual_transports.cf virtual_alias_domains = virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf virtual_gid_maps = static:5000 virtual_mailbox_base = /var/vmail virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf virtual_transport = maildrop virtual_uid_maps = static:5000
Firstm check your /etc/hosts file and make sure that the IP 127.0.0.1 is set to resolve to localhost and that no other Ip resolves to localhost. Then uninstall ispconfig by using the uninstall.php script which is in the same folder then the install.php script in the ispconfig tar.gz file. Then install ispconfig again and make sure that you enter "localhost" when the installer asks for the mysql hostname.
The /etc/hosts file is autogenerated by the VPS hotell. It is reseted whenever the VPS is rebooted. Its default is myip servername etc 79.*.2.* arty localhost localhost.localdomain I've altered it because hostname was always arty otherwise, no FQDM 79.*.2.* arty.mydomain.com arty localhost localhost.localdomain How would the hosts file be constructed then given the default values? Also don't remember writing anything when it asked for mysql server. I think the default said localhost though.
Ok everything works fine now. Had one error left about the system couldnt send DATA which apparantly was due to low amount of free RAM but that was easy to fix. Thx for the help Till.
