[Postfixbuch-users] virtual_mailbox_maps

[Maximilian Thoma]

Christian Stüben schrieb:
> Hallo,
> 
> ich betreibe unter  Debian (sarge) Postfix (+ mysql +
> courier)...leider klappt's mit den Weiterleitungen nicht...anbei ein
> Auszug aus meiner Konfiguration + Logdateien...
> 
> Wenn ich alles richtig deute, dann wird zwar laut Log das
> (exisierende) Zielpostfach in der MySQL-DB gefunden, aber 'virtual'
> bekommt aus irgendeinem Grund diese Information nicht mitgeteilt...
> 
> Wo steh' ich auf dem Schlauch bzw. wer kann mir 'nen Tipp geben?
> 
> -> MySQL-Zugriff / Zugangsdaten habe ich erfolgreich getestet
> -> Ziel-Postfächer existieren lokal (POP-Zugriff funktioniert auch)
> -> Zustellung an Postfächer funktioniert (nur eben die Weiterleitungen nicht)
> 
> ---
> alias_database = hash:/etc/aliases
> alias_maps = hash:/etc/aliases
> append_dot_mydomain = no
> biff = no
> broken_sasl_auth_clients = yes
> config_directory = /etc/postfix
> debug_peer_list = 127.0.0.1,X.X.X.X
> inet_interfaces = all
> mailbox_command = procmail -a "$EXTENSION"
> mailbox_size_limit = 160000000
> message_size_limit = 20000000
> mydestination = HOST.DOMAIN.TLD, localhost
> myhostname = HOST.DOMAIN.TLD
> mynetworks = 127.0.0.0/8, X.X.X.X
> myorigin = /etc/mailname
> notify_classes =
> receive_override_options = no_address_mappings
> recipient_delimiter = +
> relayhost =
> smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
> smtpd_recipient_restrictions = permit_sasl_authenticated,
> permit_mynetworks,      reject_non_fqdn_hostname,
> reject_non_fqdn_sender,    reject_non_fqdn_recipient,
> reject_unauth_destination,      reject_unauth_pipelining,
> reject_invalid_hostname,        reject_rbl_client zen.spamhaus.org,
>     reject_rbl_client dnsbl.sorbs.net,      reject_rbl_client
> list.dsbl.org,        reject_rbl_client bl.spamcop.net,
> reject_rbl_client sbl-xbl.spamhaus.org
> smtpd_sasl_auth_enable = yes
> smtpd_sasl_local_domain =
> smtpd_sasl_security_options = noanonymous
> smtpd_sender_restrictions = permit_sasl_authenticated, permit_mynetworks
> smtpd_tls_cert_file = /etc/postfix/smtpd.cert
> smtpd_tls_key_file = /etc/postfix/smtpd.key
> smtpd_use_tls = yes
> virtual_alias_domains =
> virtual_alias_maps = mysql:/etc/postfix/mysql-virtual_forwardings.cf
> mysql:/etc/postfix/mysql-virtual_email2email.cf
> virtual_gid_maps = static:5000
> virtual_mailbox_base = /home/vmail
> virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual_domains.cf
> virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual_mailboxes.cf
> virtual_uid_maps = static:5000
> ---
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: < unknown[XX.XX.XX.XX]:
> RCPT TO:<zm_info at DOMAIN.TLD>
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: extract_addr: input:
> <zm_info at DOMAIN.TLD>
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: smtpd_check_addr:
> addr=zm_info at zylmann.de
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: send attr address =
> zm_info at DOMAIN.TLD
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: input attribute value:
> zm_info at DOMAIN.TLD
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: rewrite_clnt: canonicalize:
> zm_info at DOMAIN.TLD -> zm_info at DOMAIN.TLD
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: send attr address =
> zm_info at DOMAIN.TLD
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: input attribute value: DOMAIN.TLD
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: input attribute value:
> zm_info at DOMAIN.TLD
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: resolve_clnt:
> `zm_info at DOMAIN.TLD' -> transp=`virtual' host=`DOMAIN.TLD'
> rcpt=`zm_info at DOMAIN.TLD' flags= class=virtual
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: ctable_locate: install
> entry key zm_info at DOMAIN.TLD
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: extract_addr: result:
> zm_info at DOMAIN.TLD
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: ctable_locate: leave
> existing entry key zm_info at DOMAIN.TLD
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: maps_find:
> recipient_canonical_maps: zm_info at DOMAIN.TLD: not found
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: match_string: DOMAIN.TLD ~?
> HOST.DOAMIN.TLD
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: match_string: DOMAIN.TLD ~? localhost
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: match_list_match:
> DOMAIN.TLD: no match
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: maps_find:
> recipient_canonical_maps: @DOMAIN.TLD: not found
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: mail_addr_find:
> zm_info at DOMAIN.TLD -> (not found)
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: maps_find: canonical_maps:
> zm_info at DOMAIN.TLD: not found
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: match_string: DOMAIN.TLD ~?
> HOST.DOMAIN.TLD
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: match_string: DOMAIN.TLD ~? localhost
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: match_list_match:
> DOMAIN.TLD: no match
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: maps_find: canonical_maps:
> @DOMAIN.TLD: not found
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: mail_addr_find:
> zm_info at DOMAIN.TLD -> (not found)
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: dict_mysql_lookup using sql
> query: select destination from forwardings where source =
> 'zm_info at DOMAIN.TLD'
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: dict_mysql_lookup:
> retrieved field: 0: info at DOMAIN.TLD
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: maps_find:
> virtual_alias_maps:
> mysql:/etc/postfix/mysql-virtual_forwardings.cf(0,100):
> zm_info at DOMAIN.TLD = info at DOMAIN.TLD
> Oct 26 10:13:23 mehl postfix/smtpd[23254]: mail_addr_find:
> zm_info at DOMAIN.TLD -> info at DOMAIN.TLD
> Oct 26 10:13:24 mehl postfix/virtual[23357]: E283460047A:
> to=<zm_info at DOMAIN.TLD>, relay=virtual, delay=1, status=bounced
> (unknown user: "zm_info at DOMAIN.TLD")
> ---
> 
> Gruß aus Flensburg
> 
> Christian Stueben

hast du schon mal:

postmap -q zm_info at zylmann.de
mysql:/etc/postfix/mysql-virtual_forwardings.cf

getestet ob da eine antwort kommt ???

bsp:
root at mailx /etc/postfix # postmap -q nospam at thoma.cc
mysql:/etc/postfix/mysql-virtual_alias.cf
nospam at thoma.cc


wenn das nicht geht dann stimmt was mit deiner sql tabelle / connector
nicht.

wie sieht /etc/postfix/mysql-virtual_alias.cf aus ?

Gruß


Maximilian

-- 
                                                     \\|//
                                                     (o o)
--------------------------------------------------ooO-(_)-Ooo---
Maximilian Thoma
Resistance is futile ...
Do not use my spamtrap: spamtrap at thoma.cc - Thanks!    Ooo.
-------------------------------------------------.ooO----(  )---
                                                 (  )    (_/
                                                  \_)