Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 4th October 2010, 02:25
DKLeader DKLeader is offline
Senior Member
 
Join Date: Sep 2010
Location: Ishoej, Denmark
Posts: 115
Thanks: 7
Thanked 0 Times in 0 Posts
Default Mail send/recieve problem

I have been searching for some help to my problem without any luck.

I have used the guide on multiserver for Debian Lenny (5) during my installation. (ISPConfig 3)

I have no problems creating mail users and if I test them from Outlook the pop3 part goes fine, but I get an error during the send part.

A bit on my setup :
web server : IP 92.62.196.69 / 192.168.90
mail server : IP 92.62.196.69 / 192.168.60 (postfix / dovecot)
db server : IP 92.62.196.69 / 192.168.40
ns1 and ns2 are on 92.62.196.66 / 67 (bind9)

All servers are controlled and hosted by me.

Ports opened on the router : 25, 110, 587 and 143 to IP 192.168.60

My mysql-virtual_relaydomains.cf :
Quote:
user = ispconfig
password = something
dbname = dbispconfig
table = mail_transport
select_field = domain
where_field = domain
additional_conditions = and active = 'y'
hosts = localhost
Should the last line be hosts = localhost ?

This is from the mail warn log :
Quote:
Oct 4 02:04:18 superweb postfix/trivial-rewrite[873]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 02:04:19 superweb postfix/smtpd[32578]: warning: problem talking to service rewrite: Connection reset by peer
Oct 4 02:04:19 superweb postfix/smtpd[483]: warning: problem talking to service rewrite: Success
Oct 4 02:04:19 superweb postfix/master[32327]: warning: process /usr/lib/postfix/trivial-rewrite pid 871 exit status 1
Oct 4 02:04:19 superweb postfix/master[32327]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
Oct 4 02:04:19 superweb postfix/smtpd[496]: warning: problem talking to service rewrite: Success
Oct 4 02:04:19 superweb postfix/master[32327]: warning: process /usr/lib/postfix/trivial-rewrite pid 872 exit status 1
Oct 4 02:04:19 superweb postfix/smtpd[32362]: warning: problem talking to service rewrite: Connection reset by peer
Oct 4 02:04:19 superweb postfix/smtpd[832]: warning: problem talking to service rewrite: Connection reset by peer
Oct 4 02:04:19 superweb postfix/smtpd[831]: warning: problem talking to service rewrite: Connection reset by peer
Oct 4 02:04:19 superweb postfix/smtpd[32655]: warning: problem talking to service rewrite: Success
Oct 4 02:04:19 superweb postfix/master[32327]: warning: process /usr/lib/postfix/trivial-rewrite pid 873 exit status 1
and in the mail error log :
Quote:
Oct 4 02:09:23 superweb postfix/trivial-rewrite[972]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 02:09:23 superweb postfix/smtp[827]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 02:09:24 superweb postfix/error[975]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 02:09:24 superweb postfix/error[976]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 02:09:25 superweb postfix/trivial-rewrite[974]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
I have checked on the mail server that the info in the mysql-virtual_relaydomains.cf does work
Quote:
mail:/# mysql -h localhost -u ispconfig -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12462
Server version: 5.0.51a-24+lenny4 (Debian)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
If I do a postconf -n I get :
Quote:
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
inet_protocols = ipv4
mailbox_command = procmail -a "$EXTENSION"
mailbox_size_limit = 0
message_size_limit = 0
mime_header_checks = regexp:/etc/postfix/mime_header_checks
mydestination = mail.superweb.dk, localhost, localhost.localdomain
myhostname = mail.superweb.dk
mynetworks = localhost
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 (Debian/GNU)
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_sasl_path = private/auth
smtpd_sasl_type = dovecot
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 = dovecot
virtual_uid_maps = static:5000
In Monitor on the homepage I get services on 2 of the servers listed as offline.
It is the mail server (192.168.1.60) and my db server (192.168.1.60).
I have created a db and that works without any problems. Also once in a while the db server shows as being online.

Anyone got any ideas to what I can test / change to get my email system up running?

// DKLeader
Reply With Quote
Sponsored Links
  #2  
Old 4th October 2010, 10:15
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,340
Thanks: 810
Thanked 5,171 Times in 4,055 Posts
Default

Quote:
Should the last line be hosts = localhost ?
Yes. All services connact to the local mysql database, not to a remote database.

Quote:
Anyone got any ideas to what I can test / change to get my email system up running?
Restart postfix on the mail server. Do you get any errors on restart on the shell or in the log file?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 4th October 2010, 16:13
DKLeader DKLeader is offline
Senior Member
 
Join Date: Sep 2010
Location: Ishoej, Denmark
Posts: 115
Thanks: 7
Thanked 0 Times in 0 Posts
Default

This is what I get when I restart postfix

Quote:
mail:~# /etc/init.d/postfix restart
Stopping Postfix Mail Transport Agent: postfix.
Starting Postfix Mail Transport Agent: postfix.
mail:~#
From my mail.err
Quote:
Oct 4 13:51:03 superweb postfix/trivial-rewrite[2878]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 13:51:03 superweb postfix/trivial-rewrite[2877]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 13:51:10 superweb postfix/smtpd[25554]: fatal: watchdog timeout
Oct 4 13:51:10 superweb postfix/smtpd[25555]: fatal: watchdog timeout
Oct 4 13:52:04 superweb postfix/trivial-rewrite[2888]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 13:52:04 superweb postfix/trivial-rewrite[2891]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
From my mail.warn
Quote:
Oct 4 14:02:33 superweb postfix/trivial-rewrite[3242]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 14:02:34 superweb postfix/smtpd[3103]: warning: problem talking to service rewrite: Success
Oct 4 14:02:34 superweb postfix/master[3092]: warning: process /usr/lib/postfix/trivial-rewrite pid 3242 exit status 1
Oct 4 14:02:34 superweb postfix/master[3092]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
Oct 4 14:03:22 superweb amavis[29382]: (29382-07) (!)rw_loop: leaving rw loop, no progress
Oct 4 14:03:22 superweb amavis[29382]: (29382-07) (!)FWD via SMTP: <root@superweb.dk> -> <root@superweb.dk>,BODY=7BIT 451 4.5.0 No resp. to MAIL FROM, id=29382-07, from MTA([12$
Oct 4 14:03:22 superweb postfix/smtp[3100]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Oct 4 14:03:22 superweb postfix/smtp[3100]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 14:03:23 superweb postfix/qmgr[3099]: warning: private/amavis socket: malformed response
Oct 4 14:03:23 superweb postfix/qmgr[3099]: warning: transport amavis failure -- see a previous warning/fatal/panic logfile record for the problem description
Oct 4 14:03:23 superweb postfix/master[3092]: warning: process /usr/lib/postfix/smtp pid 3100 exit status 1
Oct 4 14:03:23 superweb postfix/master[3092]: warning: /usr/lib/postfix/smtp: bad command startup -- throttling
Oct 4 14:03:23 superweb postfix/error[3251]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Oct 4 14:03:23 superweb postfix/error[3251]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 14:03:24 superweb postfix/qmgr[3099]: warning: private/retry socket: malformed response
Oct 4 14:03:24 superweb postfix/qmgr[3099]: warning: transport retry failure -- see a previous warning/fatal/panic logfile record for the problem description
Oct 4 14:03:24 superweb postfix/master[3092]: warning: process /usr/lib/postfix/error pid 3251 exit status 1
Oct 4 14:03:24 superweb postfix/master[3092]: warning: /usr/lib/postfix/error: bad command startup -- throttling
Oct 4 14:03:34 superweb postfix/trivial-rewrite[3252]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.so$
Oct 4 14:03:34 superweb postfix/trivial-rewrite[3252]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 14:03:35 superweb postfix/smtpd[3103]: warning: problem talking to service rewrite: Success
Oct 4 14:03:35 superweb postfix/master[3092]: warning: process /usr/lib/postfix/trivial-rewrite pid 3252 exit status 1
Oct 4 14:03:35 superweb postfix/master[3092]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
From my mail.info
Quote:
Oct 4 14:02:34 superweb postfix/master[3092]: warning: process /usr/lib/postfix/trivial-rewrite pid 3242 exit status 1
Oct 4 14:02:34 superweb postfix/master[3092]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
Oct 4 14:03:22 superweb amavis[29382]: (29382-07) (!)rw_loop: leaving rw loop, no progress
Oct 4 14:03:22 superweb amavis[29382]: (29382-07) Negative SMTP resp. to DATA:
Oct 4 14:03:22 superweb amavis[29382]: (29382-07) (!)FWD via SMTP: <root@superweb.dk> -> <root@superweb.dk>,BODY=7BIT 451 4.5.0 No resp. to MAIL FROM, id=29382-07, from MTA([12$
Oct 4 14:03:22 superweb amavis[29382]: (29382-07) Blocked MTA-BLOCKED, <root@superweb.dk> -> <root@superweb.dk>, Message-ID: <20101003060248.980B4190184@coolride.dk>, mail_id: $
Oct 4 14:03:22 superweb postfix/smtp[3100]: 980B4190184: to=<root@superweb.dk>, orig_to=<root>, relay=127.0.0.1[127.0.0.1]:10024, delay=108034, delays=107494/0.01/0/540, dsn=4.$
Oct 4 14:03:22 superweb postfix/smtp[3100]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Oct 4 14:03:22 superweb postfix/smtp[3100]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 14:03:23 superweb postfix/qmgr[3099]: warning: private/amavis socket: malformed response
Oct 4 14:03:23 superweb postfix/qmgr[3099]: warning: transport amavis failure -- see a previous warning/fatal/panic logfile record for the problem description
Oct 4 14:03:23 superweb postfix/master[3092]: warning: process /usr/lib/postfix/smtp pid 3100 exit status 1
Oct 4 14:03:23 superweb postfix/master[3092]: warning: /usr/lib/postfix/smtp: bad command startup -- throttling
Oct 4 14:03:23 superweb postfix/error[3251]: 980B4190184: to=<root@superweb.dk>, orig_to=<root>, relay=none, delay=108035, delays=107494/541/0/0, dsn=4.3.0, status=deferred (un$
Oct 4 14:03:23 superweb postfix/error[3251]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Oct 4 14:03:23 superweb postfix/error[3251]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 14:03:24 superweb postfix/qmgr[3099]: warning: private/retry socket: malformed response
Oct 4 14:03:24 superweb postfix/qmgr[3099]: warning: transport retry failure -- see a previous warning/fatal/panic logfile record for the problem description
Oct 4 14:03:24 superweb postfix/master[3092]: warning: process /usr/lib/postfix/error pid 3251 exit status 1
Oct 4 14:03:24 superweb postfix/master[3092]: warning: /usr/lib/postfix/error: bad command startup -- throttling
Oct 4 14:03:24 superweb postfix/qmgr[3099]: 980B4190184: to=<root@superweb.dk>, orig_to=<root>, relay=none, delay=108036, delays=107494/542/0/0, dsn=4.3.0, status=deferred (unk$
Oct 4 14:03:34 superweb postfix/trivial-rewrite[3252]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.so$
Oct 4 14:03:34 superweb postfix/trivial-rewrite[3252]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 14:03:35 superweb postfix/smtpd[3103]: warning: problem talking to service rewrite: Success
Oct 4 14:03:35 superweb postfix/master[3092]: warning: process /usr/lib/postfix/trivial-rewrite pid 3252 exit status 1
Oct 4 14:03:35 superweb postfix/master[3092]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
Oct 4 14:04:35 superweb postfix/trivial-rewrite[3260]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.so$
Oct 4 14:04:35 superweb postfix/trivial-rewrite[3260]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 14:04:36 superweb postfix/smtpd[3103]: warning: problem talking to service rewrite: Success
Oct 4 14:04:36 superweb postfix/master[3092]: warning: process /usr/lib/postfix/trivial-rewrite pid 3260 exit status 1
Oct 4 14:04:36 superweb postfix/master[3092]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
Oct 4 14:05:36 superweb postfix/trivial-rewrite[3295]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.so$
Oct 4 14:05:36 superweb postfix/trivial-rewrite[3295]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 14:05:37 superweb postfix/smtpd[3103]: warning: problem talking to service rewrite: Success
From my auth.log
Quote:
Oct 4 13:55:14 superweb dovecot-auth: pam_unix(dovecot:auth): check pass; user unknown
Oct 4 13:55:14 superweb dovecot-auth: pam_unix(dovecot:auth): authentication failure; logname= uid=0 euid=0 tty=dovecot ruser=support@coolride.dk rhost=148.122.180.7
Does this tell anything that might help solve the problem?

Last edited by DKLeader; 4th October 2010 at 22:29.
Reply With Quote
  #4  
Old 5th October 2010, 18:16
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,715 Times in 2,557 Posts
Default

It seems as if your Postfix has no MySQL support. Are you sure you followed the tutorial to the letter?

What's the output of
Code:
netstat -tap
?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 5th October 2010, 20:13
DKLeader DKLeader is offline
Senior Member
 
Join Date: Sep 2010
Location: Ishoej, Denmark
Posts: 115
Thanks: 7
Thanked 0 Times in 0 Posts
Default

Yes I followed this one from start to end :
Code:
mail:~# netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address           Foreign Address         State                                                                                                         PID/Program name
tcp        0      0 *:imaps                 *:*                     LISTEN                                                                                                        3440/imap-login
tcp        0      0 *:pop3s                 *:*                     LISTEN                                                                                                        6945/pop3-login
tcp        0      0 :10024                  *:*                     LISTEN                                                                                                        13507/amavisd (mast
tcp        0      0 :10025                  *:*                     LISTEN                                                                                                        739/smtpd
tcp        0      0 *:mysql                 *:*                     LISTEN                                                                                                        9503/mysqld
tcp        0      0 *:submission            *:*                     LISTEN                                                                                                        3092/master
tcp        0      0 *:pop3                  *:*                     LISTEN                                                                                                        6945/pop3-login
tcp        0      0 *:imap2                 *:*                     LISTEN                                                                                                        3440/imap-login
tcp        0      0 *:sunrpc                *:*                     LISTEN                                                                                                        1902/portmap
tcp        0      0 *:ftp                   *:*                     LISTEN                                                                                                        29666/pure-ftpd (SE
tcp        0      0 :ipp                    *:*                     LISTEN                                                                                                        2288/cupsd
tcp        0      0 *:24                    *:*                     LISTEN                                                                                                        2259/sshd
tcp        0      0 *:smtp                  *:*                     LISTEN                                                                                                        1704/smtpd
tcp        0      0 *:36958                 *:*                     LISTEN                                                                                                        1913/rpc.statd
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:1232    ESTABLISHED 7371/pop3-login
tcp        0     18 mail.superweb.dk:pop3   178.162.190.134:2081    LAST_ACK    -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:1567    ESTABLISHED 7526/pop3-login
tcp        1      0 :10025                  :57745                  CLOSE_WAIT  8292/smtpd
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:1175    ESTABLISHED 7335/pop3-login
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:1215    ESTABLISHED 7462/pop3-login
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:1060    ESTABLISHED 7295/pop3-login
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:1606    ESTABLISHED 7376/pop3-login
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:1283    ESTABLISHED 7445/pop3-login
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:1120    ESTABLISHED 7455/pop3-login
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:1405    ESTABLISHED 7142/pop3-login
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:1580    ESTABLISHED 7506/pop3-login
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2048    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2487    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2183    ESTABLISHED -
tcp        1      0 mail.superweb.dk:smtp   ip-79-111-210-98.b:7661 CLOSE_WAIT  16276/smtpd
tcp        7      0 :10025                  :44974                  CLOSE_WAIT  17348/smtpd
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2241    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2067    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2556    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2534    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2570    ESTABLISHED -
tcp        0     18 mail.superweb.dk:pop3   178.162.190.134:3484    LAST_ACK    -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2486    ESTABLISHED -
tcp        1     18 mail.superweb.dk:pop3   178.162.190.134:3485    LAST_ACK    -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2595    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2163    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2519    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2537    ESTABLISHED -
tcp        7      0 :10025                  :57744                  CLOSE_WAIT  8258/smtpd
tcp        1      0 mail.superweb.dk:smtp   mail8.surf-town.n:57739 CLOSE_WAIT  31284/smtpd
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:bgpd    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2193    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2489    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.:rtcm-sc104 ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2567    ESTABLISHED -
tcp        1     18 mail.superweb.dk:pop3   178.162.190.134:4497    LAST_ACK    -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2470    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2381    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2091    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2103    ESTABLISHED -
tcp        0     18 mail.superweb.dk:pop3   178.162.190.134:1455    LAST_ACK    -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2522    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:mon     ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2274    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2503    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2419    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2224    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2383    ESTABLISHED -
tcp        1      0 mail.superweb.dk:smtp   mail11.surf-town.:33243 CLOSE_WAIT  10077/smtpd
tcp        0      0 :58133                  :10025                  FIN_WAIT2   -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2297    ESTABLISHED -
tcp        0     18 mail.superweb.dk:pop3   178.162.190.134:2290    LAST_ACK    -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2219    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2399    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2551    ESTABLISHED -
tcp        0     18 mail.superweb.dk:pop3   178.162.190.134:2314    LAST_ACK    -
tcp        0     18 mail.superweb.dk:pop3   178.162.190.134:1419    LAST_ACK    -
tcp        7      0 :10025                  :44973                  CLOSE_WAIT  17307/smtpd
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2345    ESTABLISHED -
tcp        1     18 mail.superweb.dk:pop3   178.162.190.134:1625    CLOSING     -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2116    ESTABLISHED -
tcp        0     18 mail.superweb.dk:pop3   178.162.190.134:3364    LAST_ACK    -
tcp        0     18 mail.superweb.dk:pop3   178.162.190.134:4556    LAST_ACK    -
tcp        7      0 :10025                  :56001                  CLOSE_WAIT  30729/smtpd
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2207    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:1970    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2173    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2127    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2564    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2161    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2546    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2594    ESTABLISHED -
tcp        0     18 mail.superweb.dk:pop3   178.162.190.134:3832    LAST_ACK    -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2242    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2467    ESTABLISHED -
tcp        0      5 mail.superweb.dk:pop3   178.162.190.134:2617    ESTABLISHED -
tcp        0      0 mail.superweb.dk:56742  web.superweb.dk:mysql   TIME_WAIT   -
tcp        1      0 mail.superweb.dk:smtp   mail11.surf-town.:46638 CLOSE_WAIT  23503/smtpd
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2155    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2165    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2478    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2255    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2504    ESTABLISHED -
tcp        0     18 mail.superweb.dk:pop3   178.162.190.134:3732    LAST_ACK    -
tcp        1      0 mail.superweb.dk:smtp   mail12.surf-town.:34291 CLOSE_WAIT  16799/smtpd
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2528    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2365    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2549    ESTABLISHED -
tcp        1     18 mail.superweb.dk:pop3   178.162.190.134:3914    LAST_ACK    -
tcp        0     18 mail.superweb.dk:pop3   178.162.190.134:2842    LAST_ACK    -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2541    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2465    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2465    ESTABLISHED -
tcp        1     18 mail.superweb.dk:pop3   178.162.190.134:4480    LAST_ACK    -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2149    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2113    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2158    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2102    ESTABLISHED -
tcp        0     18 mail.superweb.dk:pop3   178.162.190.134:2317    LAST_ACK    -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2189    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2199    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2491    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2496    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2202    ESTABLISHED -
tcp        0     18 mail.superweb.dk:pop3   178.162.190.134:3674    LAST_ACK    -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2108    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2498    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2017    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2055    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2204    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2185    ESTABLISHED -
tcp        0   9012 mail.superweb.dk:24     148.122.180.7:10102     ESTABLISHED 28457/0
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2184    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2589    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2529    ESTABLISHED -
tcp        1     18 mail.superweb.dk:pop3   178.162.190.134:1684    LAST_ACK    -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:ripd    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2112    ESTABLISHED -
tcp        0     18 mail.superweb.dk:pop3   178.162.190.134:1568    LAST_ACK    -
tcp        0     18 mail.superweb.dk:pop3   178.162.190.134:2873    LAST_ACK    -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:3298    ESTABLISHED -
tcp        0     18 mail.superweb.dk:pop3   178.162.190.134:2317    LAST_ACK    -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2991    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:icpv2   ESTABLISHED -
tcp        0     18 mail.superweb.dk:pop3   178.162.190.134:3674    LAST_ACK    -
tcp        0   1236 mail.superweb.dk:24     148.122.180.7:10102     ESTABLISHED 28457/0
tcp        0     18 mail.superweb.dk:pop3   178.162.190.134:2863    LAST_ACK    -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:2833    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:3175    ESTABLISHED -
tcp        1     18 mail.superweb.dk:pop3   178.162.190.134:1684    LAST_ACK    -
tcp        0     18 mail.superweb.dk:pop3   178.162.190.134:3008    LAST_ACK    -
tcp        0     18 mail.superweb.dk:pop3   178.162.190.134:2886    LAST_ACK    -
tcp        0     18 mail.superweb.dk:pop3   178.162.190.134:1568    LAST_ACK    -
tcp        0     18 mail.superweb.dk:pop3   178.162.190.134:2853    LAST_ACK    -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:3315    ESTABLISHED -
tcp        0      0 mail.superweb.dk:pop3   178.162.190.134:3200    ESTABLISHED -
tcp        0     18 mail.superweb.dk:pop3   178.162.190.134:4959    LAST_ACK    -
tcp        0     18 mail.superweb.dk:pop3   178.162.190.134:3031    LAST_ACK    -
tcp        0     18 mail.superweb.dk:pop3   178.162.190.134:2874    LAST_ACK    -
tcp        1     18 mail.superweb.dk:pop3   178.162.190.134:3335    CLOSING     -
tcp6       0      0 [::]:www                [::]:*                  LISTEN      9189/apache2
tcp6       0      0 [::]:ftp                [::]:*                  LISTEN      29666/pure-ftpd (SE
tcp6       0      0 [::]:5910               [::]:*                  LISTEN      2918/vino-server
tcp6       0      0 localhost:ipp           [::]:*                  LISTEN      2288/cupsd
tcp6       0      0 [::]:24                 [::]:*                  LISTEN      2259/sshd
tcp6       0      0 [::]:https              [::]:*                  LISTEN      9189/apache2
Reply With Quote
  #6  
Old 6th October 2010, 14:45
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,715 Times in 2,557 Posts
Default

Are you sure the package postfix-mysql is installed?

What's in /etc/postfix/main.cf and /etc/postfix/master.cf?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #7  
Old 6th October 2010, 16:28
DKLeader DKLeader is offline
Senior Member
 
Join Date: Sep 2010
Location: Ishoej, Denmark
Posts: 115
Thanks: 7
Thanked 0 Times in 0 Posts
Default

Yes I am sure it is installed - but checked anyway :
Quote:
mail:~# apt-get install postfix-mysql
Reading package lists... Done
Building dependency tree
Reading state information... Done
postfix-mysql is already the newest version.
The following packages were automatically installed and are no longer required:
shtool courier-ssl
Use 'apt-get autoremove' to remove them.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
mail:~#
My main.cf :
I have tried with both mynetworks shown in mu main.cf (of course one at a time )
Code:
# See /usr/share/postfix/main.cf.dist for a commented, more complete version


# Debian specific:  Specifying a file name will cause the first
# line of that file to be used as the name.  The Debian default
# is /etc/mailname.
#myorigin = /etc/mailname

smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
biff = no

# appending .domain is the MUA's job.
append_dot_mydomain = no

# Uncomment the next line to generate "delayed mail" warnings
#delay_warning_time = 4h

readme_directory = /usr/share/doc/postfix

# TLS parameters
# TLS parameters
smtpd_tls_cert_file = /etc/postfix/smtpd.cert
smtpd_tls_key_file = /etc/postfix/smtpd.key
smtpd_use_tls = yes
smtpd_tls_session_cache_database = btree:${data_directory}/smtpd_scache
smtp_tls_session_cache_database = btree:${data_directory}/smtp_scache

# See /usr/share/doc/postfix/TLS_README.gz in the postfix-doc package for
# information on enabling SSL in the smtp client.

myhostname = mail.superweb.dk
alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
myorigin = /etc/mailname
mydestination = mail.superweb.dk, localhost, localhost.localdomain
relayhost =
mynetworks = localhost
# mynetworks = 127.0.0.0/8 [::1]/128
mailbox_command = procmail -a "$EXTENSION"
mailbox_size_limit = 0
recipient_delimiter = +
inet_interfaces = all
html_directory = /usr/share/doc/postfix/html
virtual_alias_domains =
virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf
virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf
virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf
virtual_mailbox_base = /var/vmail
virtual_uid_maps = static:5000
virtual_gid_maps = static:5000
smtpd_sasl_auth_enable = yes
broken_sasl_auth_clients = yes
smtpd_sasl_authenticated_header = yes
smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, check_recipient_access mysql:/etc/postfix/mysql-virtual_recipient.cf, reject_unauth_destination
smtpd_tls_security_level = may
transport_maps = proxy:mysql:/etc/postfix/mysql-virtual_transports.cf
relay_domains = mysql:/etc/postfix/mysql-virtual_relaydomains.cf
relay_recipient_maps = mysql:/etc/postfix/mysql-virtual_relayrecipientmaps.cf
virtual_create_maildirsize = yes
virtual_maildir_extended = yes
virtual_mailbox_limit_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailbox_limit_maps.cf
virtual_mailbox_limit_override = yes                                            
virtual_maildir_limit_message = "The user you are trying to reach is over quota."
virtual_overquota_bounce = yes                                                  
proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps $virtual_mailbox_domains $relays $virtual_mailbox_limit_maps
smtpd_sender_restrictions = check_sender_access mysql:/etc/postfix/mysql-virtual_sender.cf
smtpd_client_restrictions = check_client_access mysql:/etc/postfix/mysql-virtual_client.cf
maildrop_destination_concurrency_limit = 1
maildrop_destination_recipient_limit = 1
virtual_transport = dovecot
header_checks = regexp:/etc/postfix/header_checks
mime_header_checks = regexp:/etc/postfix/mime_header_checks
nested_header_checks = regexp:/etc/postfix/nested_header_checks
body_checks = regexp:/etc/postfix/body_checks
dovecot_destination_recipient_limit = 1
smtpd_sasl_type = dovecot
smtpd_sasl_path = private/auth
content_filter = amavis:[127.0.0.1]:10024
receive_override_options = no_address_mappings
message_size_limit = 0
inet_protocols = ipv4
And my master.cf
Code:
#                                                                               
# Postfix master process configuration file.  For details on the format         
# of the file, see the master(5) manual page (command: "man 5 master").         
#                                                                               
# Do not forget to execute "postfix reload" after editing this file.            
#                                                                               
# ==========================================================================    
# service type  private unpriv  chroot  wakeup  maxproc command + args          
#               (yes)   (yes)   (yes)   (never) (100)                           
# ==========================================================================    
smtp      inet  n       -       -       -       -       smtpd                   
submission inet n       -       -       -       -       smtpd                   
#  -o smtpd_tls_security_level=encrypt                                          
#  -o smtpd_sasl_auth_enable=yes                                                
#  -o smtpd_client_restrictions=permit_sasl_authenticated,reject                
#  -o milter_macro_daemon_name=ORIGINATING                                      
#smtps     inet  n       -       -       -       -       smtpd                  
#  -o smtpd_tls_wrappermode=yes                                                 
#  -o smtpd_sasl_auth_enable=yes                                                
#  -o smtpd_client_restrictions=permit_sasl_authenticated,reject
#  -o milter_macro_daemon_name=ORIGINATING                                      
#628      inet  n       -       -       -       -       qmqpd                   
pickup    fifo  n       -       -       60      1       pickup                  
cleanup   unix  n       -       -       -       0       cleanup                 
qmgr      fifo  n       -       n       300     1       qmgr                    
#qmgr     fifo  n       -       -       300     1       oqmgr                   
tlsmgr    unix  -       -       -       1000?   1       tlsmgr                  
rewrite   unix  -       -       -       -       -       trivial-rewrite         
bounce    unix  -       -       -       -       0       bounce                  
defer     unix  -       -       -       -       0       bounce
trace     unix  -       -       -       -       0       bounce                  
verify    unix  -       -       -       -       1       verify                  
flush     unix  n       -       -       1000?   0       flush                   
proxymap  unix  -       -       n       -       -       proxymap                
proxywrite unix -       -       n       -       1       proxymap                
smtp      unix  -       -       -       -       -       smtp                    
# When relaying mail as backup MX, disable fallback_relay to avoid MX loops     
relay     unix  -       -       -       -       -       smtp                    
        -o smtp_fallback_relay=                                                 
#       -o smtp_helo_timeout=5 -o smtp_connect_timeout=5       
showq     unix  n       -       -       -       -       showq                   
error     unix  -       -       -       -       -       error                   
retry     unix  -       -       -       -       -       error                   
discard   unix  -       -       -       -       -       discard                 
local     unix  -       n       n       -       -       local                   
virtual   unix  -       n       n       -       -       virtual                 
lmtp      unix  -       -       -       -       -       lmtp                    
anvil     unix  -       -       -       -       1       anvil                   
scache    unix  -       -       -       -       1       scache                  
#
# ==================================================================== 
# Interfaces to non-Postfix software. Be sure to examine the manual 
# pages of the non-Postfix software to find out what options it wants. 
# 
# Many of the following services use the Postfix pipe(8) delivery
# agent.  See the pipe(8) man page for information about ${recipient} 
# and other message envelope options. 
# ====================================================================
# 
# maildrop. See the Postfix MAILDROP_README file for details.
# Also specify in main.cf: maildrop_destination_recipient_limit=1
# 
maildrop  unix  -       n       n       -       -       pipe
  flags=DRhu user=vmail argv=/usr/bin/maildrop -d vmail ${extension} ${recipient} ${user} ${nexthop} ${sender}
# 
# See the Postfix UUCP_README file for configuration details.
# 
uucp      unix  -       n       n       -       -       pipe
  flags=Fqhu user=uucp argv=uux -r -n -z -a$sender - $nexthop!rmail ($recipient)
#
# Other external delivery methods. 
# 
ifmail    unix  -       n       n       -       -       pipe
  flags=F user=ftn argv=/usr/lib/ifmail/ifmail -r $nexthop ($recipient)
bsmtp     unix  -       n       n       -       -       pipe
  flags=Fq. user=bsmtp argv=/usr/lib/bsmtp/bsmtp -t$nexthop -f$sender $recipient
scalemail-backend unix  -       n       n       -       2       pipe
  flags=R user=scalemail argv=/usr/lib/scalemail/bin/scalemail-store ${nexthop} ${user} ${extension}
mailman   unix  -       n       n       -       -       pipe 
  flags=FR user=list argv=/usr/lib/mailman/bin/postfix-to-mailman.py
  ${nexthop} ${user}
 
dovecot   unix  -       n       n       -       -       pipe 
  flags=DRhu user=vmail:vmail argv=/usr/lib/dovecot/deliver -f ${sender} -d ${uuser}@${nexthop}
amavis unix - - - - 2 smtp 
        -o smtp_data_done_timeout=1200 
        -o smtp_send_xforward_command=yes
 
127.0.0.1:10025 inet n - - - - smtpd
        -o content_filter= 
        -o local_recipient_maps= 
        -o relay_recipient_maps= 
        -o smtpd_restriction_classes= 
        -o smtpd_client_restrictions= 
        -o smtpd_helo_restrictions= 
        -o smtpd_sender_restrictions= 
        -o smtpd_recipient_restrictions=permit_mynetworks,reject
        -o mynetworks=127.0.0.0/8 
        -o strict_rfc821_envelopes=yes 
        -o receive_override_options=no_unknown_recipient_checks,no_header_body_checks
        -o smtpd_bind_address=127.0.0.1
Reply With Quote
  #8  
Old 7th October 2010, 14:29
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,715 Times in 2,557 Posts
Default

Can you remove all occurrences of the string "proxy:" from your main.cf and restart Postfix?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #9  
Old 8th October 2010, 12:31
DKLeader DKLeader is offline
Senior Member
 
Join Date: Sep 2010
Location: Ishoej, Denmark
Posts: 115
Thanks: 7
Thanked 0 Times in 0 Posts
Default No change

Removed all proxy: from the main.cf and restarted - got no errors during restart but still it wont send or receive any e-mails

From warn-log :
Quote:
Oct 8 12:19:50 superweb postfix/trivial-rewrite[7466]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Oct 8 12:19:50 superweb postfix/trivial-rewrite[7466]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Oct 8 12:19:50 superweb postfix/trivial-rewrite[7466]: fatal: mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Oct 8 12:19:51 superweb postfix/smtpd[7391]: warning: problem talking to service rewrite: Success
Oct 8 12:19:51 superweb postfix/master[7309]: warning: process /usr/lib/postfix/trivial-rewrite pid 7466 exit status 1
Oct 8 12:19:51 superweb postfix/master[7309]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
From error-log :
Quote:
Oct 8 12:14:45 superweb postfix/trivial-rewrite[7396]: fatal: mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Oct 8 12:15:46 superweb postfix/trivial-rewrite[7431]: fatal: mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Oct 8 12:16:47 superweb postfix/trivial-rewrite[7438]: fatal: mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Oct 8 12:17:48 superweb postfix/trivial-rewrite[7448]: fatal: mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Oct 8 12:18:49 superweb postfix/trivial-rewrite[7459]: fatal: mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Oct 8 12:19:50 superweb postfix/trivial-rewrite[7466]: fatal: mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Checked again with the info from mysql-virtual_domains.cf and can do a mysql login with them.

ISPConfig reports all 3 services (pop3, smtp and imap) to be off-line eventhough they are running.

//DKLeader
Reply With Quote
  #10  
Old 10th October 2010, 19:23
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,715 Times in 2,557 Posts
 
Default

Can you post all the /etc/postfix/mysql-*.cf files?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
sneaking suspicion my postfix config has gone awry mjbarfoot Installation/Configuration 7 24th August 2010 12:23
Why did Squirrelmail, Dovecot/IMAP & Outbound mail break? websissy Technical 4 29th October 2009 22:39
procmail can't write Hellbound General 27 8th June 2009 21:51
Problem with dcc-client installation (Postfix) swap-as Installation/Configuration 9 18th September 2008 20:47
Filtering emails using Spamassassin and Clamav for Exchange 2000 Server Rocky Server Operation 19 11th March 2008 08:27


All times are GMT +2. The time now is 02:30.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.