postfix + mysql

[cybermage]

mein mailsystem auf debian sarge nach workaround.org vorbild läuft eigentlich wunderbar.
nur seit kurzem kann ich über postfix nichts mehr verschicken:

Code: Select all

Mar 13 14:51:32 wiwi-edv-srv05 postfix/trivial-rewrite[2827]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf: table lookup problem
Mar 13 14:52:33 wiwi-edv-srv05 postfix/trivial-rewrite[2831]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf: table lookup problem
Mar 13 14:53:34 wiwi-edv-srv05 postfix/trivial-rewrite[2837]: fatal: mysql:/etc/postfix/mysql-virtual_alias_maps.cf: table lookup problem

ich kann mir aber auch nicht erklären woher der fehler denn plötzlich kommt. meine config scheint mir soweit ok zu sein:

Code: Select all

myhostname    = wiwi-edv-srv05.wiwi.uni-augsburg.de
mydomain      = wiwi.uni-augsburg.de
mydestination = $myhostname, $mydomain, localhost, localhost.$mydomain
myorigin      = $myhostname
mynetworks    = 127.0.0.0/8, 137.250.47.15

append_dot_mydomain = no
append_at_myorigin  = yes

smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
biff = no

alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
relayhost =
mailbox_command =
mailbox_transport = virtual
mailbox_size_limit = 0

smtpd_recipient_restrictions =
    permit_mynetworks
    permit_sasl_authenticated
    reject_unauth_destination

smtpd_sasl_auth_enable = yes
smtpd_sasl_local_domain = $myhostname
smtpd_sasl_security_options = noanonymous
broken_sasl_auth_clients = yes

virtual_mailbox_base = /var/vmail
virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual_mailbox_domains.cf
virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual_mailbox_maps.cf
virtual_alias_maps = mysql:/etc/postfix/mysql-virtual_alias_maps.cf
virtual_uid_maps = mysql:/etc/postfix/mysql-virtual_uid_maps.cf
virtual_gid_maps = mysql:/etc/postfix/mysql-virtual_gid_maps.cf

virtual_mailbox_limit_maps = mysql:/etc/postfix/mysql-virtual_mailbox_limit_maps.cf
virtual_maildir_extended = yes
virtual_create_maildirsize = yes
virtual_overquota_bounce = yes

mysql-virtual_alias_maps.cf:

Code: Select all

user = root
password = xxx
dbname = provider
table = virtual
select_field = destination
where_field = email
hosts = localhost

ich bin etwas ratlos ... im mysql log fehlt jeglicher eintrag, dass postfix infos aus der db holt

[cybermage]

wenn ich die angeblich fehlerhafte mysql-virtual_alias_maps.cf auskommentiere mekert er über mysql-virtual_mailbox_domains.cf

also er scheint einfach nicht mehr zur db connecten wollen ... hat niemand ne idee??