View Single Post
  #1  
Old 5th August 2011, 01:15
lezelf lezelf is offline
Junior Member
 
Join Date: Aug 2011
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
Default Sending email issue

Hi,

I used this tutorial:
http://www.howtoforge.com/perfect-se...er-ispconfig-3

EDIT: Wrong Link, i used this one: http://www.howtoforge.com/perfect-se...ot-ispconfig-3

And i got some issue. My webs applications are sending mails, but those mails stay local.

-On isp config 3, i can found every mail in the queue tab.
-error tab:

Code:
Aug 4 16:35:11 server postfix/smtp[9320]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug 4 16:35:12 server postfix/smtp[9403]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug 4 16:35:12 server postfix/error[9411]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug 4 16:35:12 server postfix/error[9412]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug 4 16:35:12 server postfix/error[9413]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug 4 16:35:12 server postfix/error[9414]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug 4 16:35:12 server postfix/error[9415]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug 4 16:35:59 server postfix/smtpd[9463]: fatal: no SASL authentication mechanisms
warning-tab:

Code:
Aug 4 17:52:20 server postfix/qmgr[12515]: warning: private/retry socket: malformed response
Aug 4 17:52:20 server postfix/qmgr[12515]: warning: transport retry failure -- see a previous warning/fatal/panic logfile record for the problem description
Aug 4 17:52:20 server postfix/master[3594]: warning: process /usr/lib/postfix/error pid 14349 exit status 1
Aug 4 17:52:20 server postfix/master[3594]: warning: process /usr/lib/postfix/error pid 14350 exit status 1
Aug 4 17:52:20 server postfix/master[3594]: warning: process /usr/lib/postfix/error pid 14351 exit status 1
Aug 4 17:52:20 server postfix/master[3594]: warning: process /usr/lib/postfix/error pid 14352 exit status 1
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 4AD584C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 5A8AA4C79F6: virtual_alias_maps map lookup problem for root@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 5AC5E4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 55E184C79F7: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 6A85B4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 6B0FD4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 765894C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 7A4F04C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 7AEAC4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 7BC674C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 7DA944C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 7E42A4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 80B264C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 814594C79F6: virtual_alias_maps map lookup problem for www-data@mydomnain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 81CC84C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 826164C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 82EF24C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 840034C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 848E74C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 8517F4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 85B384C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 864394C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 86A0B4C79F7: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 876634C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 883EB4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 891944C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 89ECB4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 8A7D84C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 8B1114C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 8BA654C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 8C75D4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 8D3AF4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 8E45A4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 8EAE54C79F7: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 901C74C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 90B0A4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 914604C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 91DFC4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 9311B4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 93A754C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 946E64C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 953BB4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 965184C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: 9AC474C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: 9D5EA4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: 9DEC14C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: A28A84C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: A31FB4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: A3B074C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: A47E14C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: A501E4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: A90A34C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: A9A4A4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: AA4304C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: AB5DA4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: ABF514C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: AC7FC4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: AD20B4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: AE3DC4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14360]: warning: AEC774C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: AF5674C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: B154E4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: B1E564C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: B42014C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: B4B134C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/qmgr[12515]: warning: private/retry socket: malformed response
Aug 4 17:52:21 server postfix/qmgr[12515]: warning: transport retry failure -- see a previous warning/fatal/panic logfile record for the problem description
Aug 4 17:52:21 server postfix/cleanup[14358]: warning: B541F4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/qmgr[12515]: warning: private/retry socket: malformed response
Aug 4 17:52:21 server postfix/qmgr[12515]: warning: transport retry failure -- see a previous warning/fatal/panic logfile record for the problem description
Aug 4 17:52:21 server postfix/qmgr[12515]: warning: private/retry socket: malformed response
Aug 4 17:52:21 server postfix/qmgr[12515]: warning: transport retry failure -- see a previous warning/fatal/panic logfile record for the problem description
Aug 4 17:52:21 server postfix/cleanup[14353]: warning: B61DA4C79F6: virtual_alias_maps map lookup problem for www-data@mydomain.com
Aug 4 17:52:21 server postfix/qmgr[12515]: warning: private/retry socket: malformed response
Aug 4 17:52:21 server postfix/qmgr[12515]: warning: transport retry failure -- see a previous warning/fatal/panic logfile record for the problem description
Aug 4 17:52:55 server amavis[10580]: (10580-12) (!)rw_loop: leaving rw loop, no progress
Aug 4 17:52:55 server amavis[10580]: (10580-12) (!)FWD via SMTP: -> , 451 4.5.0 From MTA([127.0.0.1]:10025) during fwd-connect (Negative greeting: at (eval 84) line 555, line 868.): id=10580-12
Aug 4 17:52:55 server postfix/smtp[14340]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug 4 17:52:55 server postfix/smtp[14340]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug 4 17:52:56 server postfix/master[3594]: warning: process /usr/lib/postfix/smtp pid 14340 exit status 1
Aug 4 17:52:56 server postfix/qmgr[12515]: warning: private/amavis socket: malformed response
Aug 4 17:52:56 server postfix/qmgr[12515]: warning: transport amavis failure -- see a previous warning/fatal/panic logfile record for the problem description
Aug 4 17:53:00 server amavis[10580]: (10580-12) (!)rw_loop: leaving rw loop, no progress
Aug 4 17:53:00 server postfix/smtpd[14406]: warning: SASL: Connect to private/auth failed: Connection refused
Aug 4 17:53:00 server postfix/smtpd[14406]: fatal: no SASL authentication mechanisms
Aug 4 17:53:01 server postfix/master[3594]: warning: process /usr/lib/postfix/smtpd pid 14406 exit status 1
Aug 4 17:53:01 server postfix/master[3594]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling
Aug 4 17:53:18 server postfix/smtpd[14413]: warning: SASL: Connect to private/auth failed: Connection refused
Aug 4 17:53:18 server postfix/smtpd[14413]: fatal: no SASL authentication mechanisms
Aug 4 17:53:19 server postfix/master[3594]: warning: process /usr/lib/postfix/smtpd pid 14413 exit status 1
Aug 4 17:53:19 server postfix/master[3594]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling
If look for solutions on the forum, but none seems to be working.
If it can help, my postfix/main.conf :
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
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 = server.mydomain.com
alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
myorigin = /etc/mailname
mydestination = server.mydomain.com, localhost, localhost.localdomain
relayhost =
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
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_canon$
smtpd_sender_restrictions = check_sender_access mysql:/etc/postfix/mysql-virtual_sender.cf
# 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
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 = server.mydomain.com
alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
myorigin = /etc/mailname
mydestination = server.mydomain.com, localhost, localhost.localdomain
relayhost =
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
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_canon$
smtpd_sender_restrictions = check_sender_access mysql:/etc/postfix/mysql-virtual_sender.cf
and
Code:
telnet localhost 25
doesn't work instead of
Code:
telnet 127.0.0.1 25

could you please help me? It would be really apreciated.

Last edited by lezelf; 5th August 2011 at 20:02.
Reply With Quote
Sponsored Links