HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=4)
-   -   Problem with send/ receive mail in ISPconfig (http://www.howtoforge.com/forums/showthread.php?t=45905)

freesqrt 16th May 2010 13:54

Problem with send/ receive mail in ISPconfig
 
Hi there,

just recently I have installed a fresh ISPcofig 2. everything is ok but no mail is transferred between this and other servers.

I had add these records in dns:

########################
A Record
IP-Adresse Hostname
217.218.11.213 www
217.218.11.213 mx1
217.218.11.213 mail

CNAME
Hostname Target

MX
Mailserver Hostname
mx1.mydomain.com
mail.mydomain.com

SPF
Hostname
mydomain.com
#######################

what you think about the problem?

regards,

falko 17th May 2010 15:27

Any errors in your mail log?

freesqrt 23rd May 2010 09:13

Hi Falko,

here is some of log in /var/log/maillog:

###################################
May 23 10:34:03 mx1 postfix/error[22555]: warning: connect to mysql server 127.0.0.1: Unknown database 'dbispconfig'
May 23 10:34:03 mx1 postfix/error[22555]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
May 23 10:34:03 mx1 postfix/error[22556]: warning: connect to mysql server 127.0.0.1: Unknown database 'dbispconfig'
May 23 10:34:03 mx1 postfix/error[22556]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
May 23 10:34:03 mx1 postfix/error[22557]: warning: connect to mysql server 127.0.0.1: Unknown database 'dbispconfig'
May 23 10:34:03 mx1 postfix/error[22557]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
May 23 10:34:03 mx1 postfix/error[22559]: warning: connect to mysql server 127.0.0.1: Unknown database 'dbispconfig'
May 23 10:34:03 mx1 postfix/error[22559]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
May 23 10:34:04 mx1 postfix/qmgr[22542]: warning: private/retry socket: malformed response
May 23 10:34:04 mx1 postfix/master[30392]: warning: process /usr/libexec/postfix/error pid 22554 exit status 1
May 23 10:34:04 mx1 postfix/qmgr[22542]: warning: transport retry failure -- see a previous warning/fatal/panic logfile record for the problem description
May 23 10:34:04 mx1 postfix/master[30392]: warning: /usr/libexec/postfix/error: bad command startup -- throttling
May 23 10:34:04 mx1 postfix/qmgr[22542]: 925A21D630A: to=<root@mx1.eshtehardpnu.ac.ir>, relay=none, delay=2827904, delays=2827902/2.1/0/0, dsn=4.3.0, status=deferred (unknown mail transport error)
May 23 10:34:04 mx1 postfix/qmgr[22542]: warning: connect to mysql server 127.0.0.1: Unknown database 'dbispconfig'
May 23 10:34:04 mx1 postfix/qmgr[22542]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
May 23 10:34:04 mx1 postfix/master[30392]: warning: process /usr/libexec/postfix/error pid 22555 exit status 1
May 23 10:34:04 mx1 postfix/master[30392]: warning: process /usr/libexec/postfix/error pid 22556 exit status 1
May 23 10:34:04 mx1 postfix/master[30392]: warning: process /usr/libexec/postfix/error pid 22557 exit status 1
May 23 10:34:04 mx1 postfix/master[30392]: warning: process /usr/libexec/postfix/error pid 22559 exit status 1
May 23 10:34:05 mx1 postfix/master[30392]: warning: process /usr/libexec/postfix/qmgr pid 22542 exit status 1
May 23 10:35:01 mx1 postfix/proxymap[22585]: warning: empty macro name: "$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"
May 23 10:35:01 mx1 postfix/proxymap[22585]: fatal: dictionary mail_dict: macro processing error
May 23 10:35:02 mx1 postfix/master[30392]: warning: process /usr/libexec/postfix/proxymap pid 22585 exit status 1
May 23 10:35:02 mx1 postfix/master[30392]: warning: /usr/libexec/postfix/proxymap: bad command startup -- throttling
May 23 10:36:02 mx1 postfix/proxymap[22606]: warning: empty macro name: "$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"
May 23 10:36:02 mx1 postfix/proxymap[22606]: fatal: dictionary mail_dict: macro processing error
May 23 10:36:03 mx1 postfix/master[30392]: warning: process /usr/libexec/postfix/proxymap pid 22606 exit status 1
May 23 10:36:03 mx1 postfix/master[30392]: warning: /usr/libexec/postfix/proxymap: bad command startup -- throttling
#####################################

some fatal errors are in dictionary mail_dict and database.

any idea?

clucian 23rd May 2010 10:15

You have some problems on postfix to connect to mysql.

Check your file configuration /etc/postfix/mysql-virtual_relaydomains.cf or mysql table !

freesqrt 6th June 2010 12:50

Hey Claucian,

yes you were right. there is some misconfig in mysql parameters in postfix.

I have uninstall/reinstall ISPConfig several times. however I change the database name during the installation process, the "dbname" in files mysql-virtual_relaydomains.cf and mysql-virtual_domains.cf are remained "dbispconfig" !!!!!

when a user try to send a mail following log has been generate:

#############################
Jun 6 14:15:47 mx1 dovecot: imap-login: Login: user=<web1_ahb>, method=PLAIN, rip=::ffff:127.0.0.1, lip=::ffff:127.0.0.1, secured
Jun 6 14:15:47 mx1 sendmail[10060]: o569jlha010060: Authentication-Warning: mx1.domainclf.com: admispconfig set sender to ahb@domainclf.com using -f
Jun 6 14:15:47 mx1 sendmail[10060]: o569jlha010060: from=ahb@domainclf.com, size=339, class=0, nrcpts=1, msgid=<4b342ab181545cf6029c092573407fee@localhost> , relay=admispconfig@localhost
Jun 6 14:15:47 mx1 postfix/smtpd[10061]: connect from mx1.domainclf.com[127.0.0.1]
Jun 6 14:15:47 mx1 postfix/smtpd[10061]: setting up TLS connection from mx1.domainclf.com[127.0.0.1]
Jun 6 14:15:47 mx1 sendmail[10060]: STARTTLS=client, relay=[127.0.0.1], version=TLSv1/SSLv3, verify=FAIL, cipher=DHE-RSA-AES256-SHA, bits=256/256
Jun 6 14:15:47 mx1 postfix/smtpd[10061]: Anonymous TLS connection established from mx1.domainclf.com[127.0.0.1]: TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)
Jun 6 14:16:07 mx1 postfix/proxymap[10062]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' to database 'dbispconfig'
Jun 6 14:16:07 mx1 postfix/proxymap[10062]: warning: mysql query failed: Table 'db_ispconfig.mail_domain' doesn't exist
Jun 6 14:16:07 mx1 postfix/trivial-rewrite[10075]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Jun 6 14:16:08 mx1 postfix/smtpd[10061]: warning: problem talking to service rewrite: Connection reset by peer
Jun 6 14:16:08 mx1 postfix/qmgr[10019]: warning: problem talking to service rewrite: Success
Jun 6 14:16:08 mx1 postfix/master[10016]: warning: process /usr/libexec/postfix/trivial-rewrite pid 10075 exit status 1
Jun 6 14:16:08 mx1 postfix/master[10016]: warning: /usr/libexec/postfix/trivial-rewrite: bad command startup -- throttling

Jun 6 14:17:08 mx1 postfix/proxymap[10062]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' to database 'dbispconfig'
Jun 6 14:17:08 mx1 postfix/proxymap[10062]: warning: mysql query failed: Table 'db_ispconfig.mail_domain' doesn't exist
Jun 6 14:17:08 mx1 postfix/trivial-rewrite[10107]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Jun 6 14:17:09 mx1 postfix/qmgr[10019]: warning: problem talking to service rewrite: Success
Jun 6 14:17:09 mx1 postfix/smtpd[10061]: warning: problem talking to service rewrite: Connection reset by peer
Jun 6 14:17:09 mx1 postfix/master[10016]: warning: process /usr/libexec/postfix/trivial-rewrite pid 10107 exit status 1
Jun 6 14:17:09 mx1 postfix/master[10016]: warning: /usr/libexec/postfix/trivial-rewrite: bad command startup -- throttling

#############################

the problem is there is no "mail_domain" table in db_ispconfig!!!!!!

what you think about this misconfig?
Thankyou,

falko 7th June 2010 14:35

Did you install ISPConfig 2 or 3? What's in /etc/postfix/main.cf? Which tutorial (URL) did you use to set up the server?

freesqrt 7th June 2010 14:47

Hey falko,

I'd installed ISpconfig 2. I installed in completely based on "perfect server" manual for fedora 9.

the problem is the ispconfig requests for tables that are not exists for example "mail_transport" !!!!.

the end part of mail.cf is:

##########################
readme_directory = /usr/share/doc/postfix-2.5.6/README_FILES
# Enable IPv4, and IPv6 if supported
inet_protocols = all
myhostname = mx1.eshtehardpnu.ac.ir
mynetworks = 127.0.0.0/8
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_sasl_authenticated,permit_mynetworks,reject _unauth_destination
smtpd_use_tls = yes
smtpd_tls_security_level = may
smtpd_tls_cert_file = /etc/postfix/ssl/smtpd.crt
smtpd_tls_key_file = /etc/postfix/ssl/smtpd.key
transport_maps = proxy:mysql:/etc/postfix/mysql-virtual_transports.cf
#relay_domains = mysql:/etc/postfix/mysql-virtual_relaydomains.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 $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps $recipient_canonical_maps $relocated_maps $transport_maps $mynetworks $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 = maildrop
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
content_filter = amavis:[127.0.0.1]:10024
receive_override_options = no_address_mappings
smtpd_sasl_local_domain =
smtpd_sasl_security_options = noanonymous
smtpd_tls_auth_only = no
smtp_use_tls = yes
smtp_tls_note_starttls_offer = yes
smtpd_tls_CAfile = /etc/postfix/ssl/cacert.pem
smtpd_tls_loglevel = 1
smtpd_tls_received_header = yes
smtpd_tls_session_cache_timeout = 3600s
tls_random_source = dev:/dev/urandom
home_mailbox = Maildir/
mailbox_command =

mydestination = /etc/postfix/local-host-names
relay_domains = $mydestination
virtual_maps = hash:/etc/postfix/virtusertable
#############################

I have remove/install ISPconfig several times but is it usefull to uninstall/ reinstall postfix and ispconfig?

thank you,

falko 8th June 2010 16:46

Somehow your Postfix is configured for virtual users instead of system users, and this setup is incompatible with ISPConfig 2. Is it possible that you accidently used the "Perfect Server" tutorial for ISPConfig 3 instead 2?

freesqrt 12th June 2010 11:28

Hey Falko,

thank you very much. the problem had been solved!!!!:D

I have removed ISPconfig and postfix rpm. then install step 12 of the perfect server manual again.

that was because the first time I had installed ISPconfig 3 and then removed it and installed ISPcnfig 2. but the configuration in /etc/postfix/mysql-virtual_* was remained.
I think the ISPconfig does not completely uninstalled by removing /root/ispconfig and /home/admispconfig !!!

Regards,

m4l41k4t 6th July 2012 07:28

I am having the same problem.
but I have not tried to uninstall / install ISPConfig because of fear of web data that already exist will also be lost (already have 2 web hosting).
Is there any solution other than the Uninstall / Install ISPConfig?

ISPConfig Version: 3.0.4.5
Tutorial :http://www.howtoforge.com/perfect-se...ispconfig-3-p7
OS Ubuntu : 12.04 32 Bit

The following error contained in the tail-f / var / log / mail.log :
Jul 6 00:22:56 test postfix/error[8944]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Jul 6 00:22:56 test postfix/error[8975]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Jul 6 00:22:56 test postfix/error[8987]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Jul 6 00:22:56 test postfix/error[9131]: 8F01ED0BE0E: to=<goosq@yahoo.com.tw>, relay=none, delay=375916, delays=375584/328/0/4.8, dsn=4.3.0, status=deferred (address resolver failure)
Jul 6 00:22:56 test postfix/error[8971]: 6E5A3D0E5DA: to=<dedee@kimo.com.tw>, relay=none, delay=24857, delays=24580/274/0/3.5, dsn=4.4.2, status=deferred (delivery temporarily suspended: lost connection with 127.0.0.1[127.0.0.1] while sending RCPT TO)
Jul 6 00:22:56 test postfix/error[8920]: 53978D074E3: to=<accoutered@kimo.com.tw>, relay=none, delay=31466, delays=31187/274/0/4.4, dsn=4.4.2, status=deferred (delivery temporarily suspended: lost connection with 127.0.0.1[127.0.0.1] while sending RCPT TO)
Jul 6 00:22:56 test postfix/error[9321]: 83230D0DD36: to=<jing84535@yahoo.com.tw>, relay=none, delay=115462, delays=115129/326/0/6.9, dsn=4.3.0, status=deferred (address resolver failure)
Jul 6 00:22:56 test postfix/error[8961]: 8875DD06313: to=<taping55@yahoo.com.tw>, relay=none, delay=32610, delays=32331/273/0/6, dsn=4.4.2, status=deferred (delivery temporarily suspended: lost connection with 127.0.0.1[127.0.0.1] while sending RCPT TO)
Jul 6 00:22:56 test postfix/error[8961]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Jul 6 00:22:56 test postfix/error[8903]: 62FDBD01E2F: to=<mi70369@yahoo.com.tw>, relay=none, delay=150218, delays=149885/325/0/8.1, dsn=4.3.0, status=deferred (address resolver failure)
Jul 6 00:22:56 test postfix/error[8901]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Jul 6 00:22:56 test postfix/error[8901]: warning: 65E8DD0731B: flush service failure
Jul 6 00:22:56 test postfix/error[8958]: 63E1DD1095C: to=<ath@ms43.hinet.net>, relay=none, delay=1970, delays=1691/273/0/6, dsn=4.4.2, status=deferred (delivery temporarily suspended: lost connection with 127.0.0.1[127.0.0.1] while sending RCPT TO)
Jul 6 00:22:56 test postfix/error[8958]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Jul 6 00:22:56 test postfix/error[8958]: warning: 63E1DD1095C: flush service failure
Jul 6 00:22:56 test postfix/error[9321]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Jul 6 00:22:56 test postfix/error[8903]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Jul 6 00:22:56 test postfix/error[8903]: warning: 62FDBD01E2F: flush service failure
Jul 6 00:22:56 test postfix/error[8993]: 8E75AD07148: to=<cymcym@iplus.net.tw>, relay=none, delay=31791, delays=31513/274/0/3.9, dsn=4.4.2, status=deferred (delivery temporarily suspended: lost connection with 127.0.0.1[127.0.0.1] while sending RCPT TO)
Jul 6 00:22:56 test postfix/error[8939]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Jul 6 00:22:56 test postfix/error[8978]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Jul 6 00:22:56 test postfix/error[8971]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Jul 6 00:22:56 test postfix/error[8969]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Jul 6 00:22:56 test postfix/error[9131]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Jul 6 00:22:56 test postfix/error[8991]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Jul 6 00:22:56 test postfix/error[9321]: warning: 83230D0DD36: flush service failure
Jul 6 00:22:56 test postfix/error[8965]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Jul 6 00:22:56 test postfix/error[8993]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Jul 6 00:22:56 test postfix/error[8975]: warning: BEECDD01C34: flush service failure
Jul 6 00:22:56 test postfix/error[8944]: warning: 6BC4AD01968: flush service failure
Jul 6 00:22:56 test postfix/error[8961]: warning: 8875DD06313: flush service failure
Jul 6 00:22:56 test postfix/error[8978]: warning: B1085D0AAFA: flush service failure
Jul 6 00:22:56 test postfix/error[8939]: warning: 6303DD09AEB: flush service failure
Jul 6 00:22:56 test postfix/error[8920]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Jul 6 00:22:56 test postfix/error[9131]: warning: 8F01ED0BE0E: flush service failure
Jul 6 00:22:56 test postfix/error[8987]: warning: 6E237D0366B: flush service failure
Jul 6 00:22:56 test postfix/error[8971]: warning: 6E5A3D0E5DA: flush service failure
Jul 6 00:22:56 test postfix/error[8991]: warning: 578DCD092CC: flush service failure
Jul 6 00:22:56 test postfix/error[8965]: warning: 623C8D071A8: flush service failure
Jul 6 00:22:56 test postfix/error[8969]: warning: 62735D09B6F: flush service failure
Jul 6 00:22:56 test postfix/error[8993]: warning: 8E75AD07148: flush service failure
Jul 6 00:22:56 test postfix/error[8920]: warning: 53978D074E3: flush service failure
Jul 6 00:22:56 test postfix/smtpd[9113]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (111)
Jul 6 00:22:56 test postfix/smtpd[9113]: warning: mysql:/etc/postfix/mysql-virtual_client.cf: table lookup problem
Jul 6 00:22:56 test postfix/smtpd[9113]: NOQUEUE: reject: RCPT from unknown[190.33.184.107]: 451 4.3.5 <unknown[190.33.184.107]>: Client host rejected: Server configuration error; from=<dmmpvwlwcgpdm@gmail.com> to=<venus.h1031@msa.hinet.net> proto=SMTP helo=<124.81.213.252>
Jul 6 00:22:56 test postfix/smtpd[9113]: too many errors after RCPT from unknown[190.33.184.107]
Jul 6 00:22:56 test postfix/trivial-rewrite[9182]: warning: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem
Jul 6 00:22:56 test postfix/smtpd[9113]: disconnect from unknown[190.33.184.107]
Jul 6 00:22:56 test postfix/trivial-rewrite[9182]: warning: virtual_mailbox_domains lookup failure


All times are GMT +2. The time now is 05:50.

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