[Postfixbuch-users] Virtual mailbox domains und Cyrus Imap

[Holm Kapschitzki]

Ralf Hildebrandt schrieb:

>* Holm Kapschitzki <holm at oleco.net>:
>
>  
>
>>myhostname = srv01.avox.org
>>mydestination = mysql:/etc/postfix/mysql-mydestination.cf
>>myorigin = $mydomain
>>    
>>
>
>Und woher kommen die local_recipient_maps?
>
>  
>
srv01:~# postconf -n
broken_sasl_auth_clients = yes
command_directory = /usr/sbin
config_directory = /etc/postfix
content_filter = amavis:[127.0.0.1]:10024
daemon_directory = /usr/lib/postfix
inet_interfaces = all
mailbox_size_limit = 0
mailbox_transport = cyrus
mydestination = mysql:/etc/postfix/mysql-mydestination.cf
myhostname = srv01.avox.org
mynetworks = 127.0.0.0/8
myorigin = $mydomain
receive_override_options = no_address_mappings
sender_canonical_maps = mysql:/etc/postfix/mysql-canonical.cf
smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
smtpd_recipient_restrictions = permit_sasl_authenticated,           
permit_mynet                                                              
works,           reject_unauth_destination
smtpd_sasl_auth_enable = yes
smtpd_sasl_local_domain =
smtpd_sasl_security_options = noanonymous
smtpd_tls_CAfile = /etc/postfix/mailserver.cert
smtpd_tls_cert_file = /etc/postfix/mailserver.cert
smtpd_tls_key_file = /etc/postfix/mailserver.key
smtpd_use_tls = yes
virtual_alias_maps = mysql:/etc/postfix/mysql-virtual.cf


etc/postfix/mysql-virtual.cf:

#
# mysql config file for alias lookups on postfix
# comments are ok.
#
# the user name and password to log into the mysql server
hosts = localhost
user = mail
password = secret
# the database name on the servers
dbname = mail
# the table name
table = virtual
select_field = dest
where_field = alias
additional_conditions = and status = '1'

/etc/postfix/mysql-canonical.cf:

# mysql config file for canonical lookups on postfix
# comments are ok.
#
# the user name and password to log into the mysql server
hosts = localhost
user = mail
password = secret
# the database name on the servers
dbname = mail
# the table name
table = virtual
select_field = alias
where_field = username
additional_conditions = and status = '1' limit 1

/etc/postfix/mysql-mydestination.cf:

# mysql config file for local domain (like sendmail's sendmail.cw) lookups on postfix
# comments are ok.
#
# the user name and password to log into the mysql server
hosts = localhost
user = mail
password = secret
# the database name on the servers
dbname = mail
# the table name
table = domain
select_field = domain_name
where_field = domain_name

Gruß Holm