[Postfixbuch-users] mysql_virtual_alias_maps

[Andreas Winkelmann]

Am Friday 14 April 2006 12:15 schrieb Conny Klemm:

> Von wo kommt die Meldung? Poste Logs, poste Deine Config (postconf -n).
> Zeige
> wie die Abfrage nach der Adresse funktioniert (postmap -q info at domain...
> mysql:/...).
>
>
> Hier dir gewünschten Daten
>
> address_verify_map = btree:/var/spool/postfix/verified_senders
> alias_maps = hash:/etc/aliases
> body_checks = regexp:/etc/postfix/filter/body_checks
> broken_sasl_auth_clients = yes
> command_directory = /usr/sbin
> config_directory = /etc/postfix
> content_filter = smtp:127.0.0.1:10025
> daemon_directory = /usr/lib/postfix
> debug_peer_level = 2
> disable_dns_lookups = no
> header_checks = regexp:/etc/postfix/filter/header_checks
> html_directory = /usr/share/doc/packages/postfix/html
> local_transport = local
> mail_owner = postfix
> mailq_path = /usr/bin/mailq
> manpage_directory = /usr/share/man
> message_size_limit = 40960000
> mime_header_checks = regexp:/etc/postfix/mime_header_checks
> mydestination = $myhostname, localhost.$mydomain, localhost
>
> myhostname = mail.domaene.de
> mynetworks = 192.168.128.0/24, 127.0.0.0/8, 192.168.1.0/24, 10.8.0.0/24
> newaliases_path = /usr/bin/newaliases
> queue_directory = /var/spool/postfix
> relocated_maps = hash:/etc/postfix/relocated
> sample_directory = /usr/share/doc/packages/postfix/samples
> sendmail_path = /usr/sbin/sendmail
> setgid_group = maildrop
> smtp_sasl_auth_enable = yes
> smtp_sasl_password_maps = hash:/etc/postfix/sasl/sasl_passwd
> smtp_sasl_security_options = noanonymous
> smtpd_banner = $myhostname ESMTP $mail_name
> smtpd_error_sleep_time = 10s
> smtpd_hard_error_limit = 1
> smtpd_helo_required = yes
> smtpd_recipient_restrictions = permit_mynetworks,
>  check_sender_access regexp:/etc/postfix/filter/sender_access
>  check_helo_access hash:/etc/postfix/filter/helo_checks,
>  check_client_access hash:/etc/postfix/filter/client_access
>  permit_sasl_authenticated,
>  reject_non_fqdn_hostname,
>  reject_non_fqdn_sender,
>  reject_non_fqdn_recipient,
>  reject_unauth_destination,
>  reject_unauth_pipelining,
>  reject_invalid_hostname,
>  reject_rbl_client opm.blitzed.org,
>  reject_rbl_client list.dsbl.org,
>  reject_rbl_client bl.spamcop.net,
>  reject_rbl_client sbl-xbl.spamhaus.org,
>  reject_unverified_sender,
>  smtpd_sasl_auth_enable = yes
>  smtpd_sasl_local_domain = $myhostname
>  smtpd_sasl_security_options = noanonymous
>  smtpd_soft_error_limit = 1
>  strict_rfc821_envelopes = yes
>  transport_maps = hash:/etc/postfix/transport
>  unknown_local_recipient_reject_code = 550
>  virtual_alias_maps = mysql:/etc/postfix/sql/mysql_virtual_alias_maps.cf
>  virtual_gid_maps = static:51
>  virtual_mailbox_base = /usr/local/virtual
>  virtual_mailbox_domains =
> mysql:/etc/postfix/sql/mysql_virtual_domains_maps.cf
>  virtual_mailbox_limit = 51200000
>  virtual_mailbox_maps =
> mysql:/etc/postfix/sql/mysql_virtual_mailbox_maps.cf virtual_minimum_uid =
> 51
>  virtual_transport = virtual
>  virtual_uid_maps = static:51
>
> postmap -q "info at domaene.de"
> mysql:/etc/postfix/sql/mysql_virtual_alias_maps.cf
> sachbearbeiter at domaene.de
>
> /var/log/mail
>
> Apr 14 10:24:25 mailserver postfix/qmgr[16160]: 4A047175C:
> from=<conny.klemm at gmail.com>, size=1247, nrcpt=1 (queue active)
> Apr 14 10:24:25 mailserver postfix/smtpd[24259]: connect from
> localhost[127.0.0.1]
> Apr 14 10:24:25 mailserver postfix/smtpd[24259]: NOQUEUE: reject: RCPT from
> localhost[127.0.0.1]: 550 <info at domaene.de>: Recipient address rejected:
> User unknown in virtual mailbox table; from=<conny.klemm at gmail.com>
> to=info at domaene.de proto=ESMTP helo=<mail.domaene.de>

Ja, Postfix braucht pro Adress-Klasse eine gültige Liste mit Empfängern, damit 
der smtpd sie direkt abweisen kann. Bei $virtual_mailbox_domains ist dies die 
$virtual_mailbox_maps, bei $virtual_alias_domains ist dies die 
$virtual_alias_maps. Da die Domains bei Dir in $virtual_mailbox_domains 
stehen, musst Du auch alle Adressen in $virtual_mailbox_maps einbinden. Und 
wenn es dummy-Einträge sind.

sachbearbeiter at domain.de	mailboxsachbearbeiter/
info at domain.de			dummy

Oder so:

virtual_mailbox_maps = mysql:/etc/postfix/sql/mysql_virtual_mailbox_maps.cf, 				
	$virtual_alias_maps


-- 
	Andreas