Prev Previous Post   Next Post Next
  #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
 

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.