Hello Wietse, when I do a postmap -q domain.com mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf
I get back the ID of my Domain-Entry in the Mysql-DB. So I think the domain is found. Regards Daniel > -----Ursprüngliche Nachricht----- > Von: owner-postfix-us...@postfix.org [mailto:owner-postfix- > us...@postfix.org] Im Auftrag von Wietse Venema > Gesendet: Samstag, 24. Oktober 2009 21:15 > An: Postfix users > Betreff: Re: virtual-mailbox-domain: Loops back zo myself > > Daniel Spannbauer: > > Hello, > > > > I searched a lot and tried to find out why my postfix loops to > hisself. > > The mail loops, because the domain is not found in > virtual_alias_domains, > in virtual_mailbox_domains, or in mydestination, because if it did, > the mail would not be giben to the Postfix SMTP client. > > http://www.postfix.org/ADDRESS_CLASS_README.html has the details. > > To test your lookup tables, execute: > > postmap -q example.com maptype:mapname > > where maptype:mapname is your sql table. > > If it produces no output and no error messages, then the domain is > not found. If it does produce output (but no error message) then > the domain is found. > > http://www.postfix.org/DATABASE_README.html#preparing has more advice > on how to develop *Sql tables. > > Wietse > > > I use Postfix 2.5.5 on a Host with openSuSE 11.1. I want to deliver > Mails > > with Dovecot into maildir using sieve. > > > > Here is the postconf -n: > > > > alias_maps = hash:/etc/aliases > > biff = no > > canonical_maps = hash:/etc/postfix/canonical > > command_directory = /usr/sbin > > config_directory = /etc/postfix > > content_filter = amavisfeed:[127.0.0.1]:10024 > > daemon_directory = /usr/lib/postfix > > debug_peer_level = 6 > > defer_transports = > > delay_warning_time = 1h > > disable_dns_lookups = no > > disable_mime_output_conversion = no > > html_directory = /usr/share/doc/packages/postfix-doc/html > > inet_interfaces = all > > inet_protocols = all > > mail_owner = postfix > > mail_spool_directory = /var/mail > > mailbox_command = /usr/lib/dovecot/deliver > > mailbox_size_limit = 0 > > mailbox_transport = > > mailq_path = /usr/bin/mailq > > manpage_directory = /usr/share/man > > masquerade_classes = envelope_sender, header_sender, header_recipient > > masquerade_domains = > > masquerade_exceptions = root > > message_size_limit = 10240000 > > message_strip_characters = \0 > > mydestination = $myhostname, localhost.$mydomain > > myhostname = mail.domain.com > > mynetworks = 127.0.0.0/8 > > mynetworks_style = subnet > > myorigin = hondapower.de > > newaliases_path = /usr/bin/newaliases > > queue_directory = /var/spool/postfix > > readme_directory = /usr/share/doc/packages/postfix-doc/README_FILES > > receive_override_options = no_address_mappings > > relayhost = > > relocated_maps = hash:/etc/postfix/relocated > > sample_directory = /usr/share/doc/packages/postfix-doc/samples > > sender_canonical_maps = hash:/etc/postfix/sender_canonical > > sendmail_path = /usr/sbin/sendmail > > setgid_group = maildrop > > smtp_sasl_auth_enable = no > > smtp_use_tls = no > > smtpd_client_restrictions = > > smtpd_delay_reject = yes > > smtpd_helo_required = no > > smtpd_helo_restrictions = > > smtpd_recipient_restrictions = > > permit_mynetworks,permit_sasl_authenticated,reject_unauth_destination > > smtpd_sasl_auth_enable = yes > > smtpd_sasl_path = private/auth > > smtpd_sasl_type = dovecot > > smtpd_sender_restrictions = hash:/etc/postfix/access > > smtpd_tls_auth_only = yes > > smtpd_tls_cert_file = /etc/postfix/smtpd.cert > > smtpd_tls_key_file = /etc/postfix/smtpd.key > > smtpd_use_tls = no > > strict_8bitmime = no > > strict_rfc821_envelopes = no > > transport_maps = hash:/etc/postfix/transport > > unknown_local_recipient_reject_code = 450 > > virtual_alias_maps = > > mysql:/etc/postfix/mysql-virtual-alias- > maps.cf,mysql:/etc/postfix/mysql-emai > > l2email.cf > > virtual_gid_maps = static:5000 > > virtual_mailbox_base = /var/mail > > virtual_mailbox_domains = > > mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf > > virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual-mailbox- > maps.cf > > virtual_transport = dovecot > > virtual_uid_maps = static:5000 > > > > My script mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf: > > > > user = mailuser > > password = somepassword > > hosts = 127.0.0.1 > > dbname = mailserver > > query = SELECT 1 FROM virtual_domains WHERE name='%s' > > > > If I do a postmap -q domain.com > > :/etc/postfix/mysql-virtual-mailbox-domains.cf I get back the ID of > > domain.com. > > > > When I send a Mail from my server, everything seems to be ok, but > when I > > send a mail from a MDA over smtp, I get the Mail back with the > messages that > > it loops back to the server. > > > > Can anybody help me to find the error? I search for a week now and > can't > > find it. > > > > Regards > > > > Daniel > > > > > > > > __________ Hinweis von ESET NOD32 Antivirus, Signaturdatenbank- > Version 4538 > > (20091024) __________ > > > > E-Mail wurde gepruft mit ESET NOD32 Antivirus. > > > > http://www.eset.com > > > > > > > > > > > > __________ Hinweis von ESET NOD32 Antivirus, Signaturdatenbank-Version > 4539 (20091024) __________ > > E-Mail wurde geprüft mit ESET NOD32 Antivirus. > > http://www.eset.com > __________ Hinweis von ESET NOD32 Antivirus, Signaturdatenbank-Version 4539 (20091024) __________ E-Mail wurde geprüft mit ESET NOD32 Antivirus. http://www.eset.com