View Single Post
  #1  
Old 4th October 2010, 03:25
DKLeader DKLeader is offline
Senior Member
 
Join Date: Sep 2010
Location: Ishoej, Denmark
Posts: 119
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