postfix + mysql

Postfix, QMail, Sendmail, Dovecot, Cyrus, Courier, Anti-Spam
cybermage
Posts: 158
Joined: 2002-12-10 22:10
Location: Ausgburg (Germany)

postfix + mysql

Post by cybermage » 2004-03-13 15:02

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
Posts: 158
Joined: 2002-12-10 22:10
Location: Ausgburg (Germany)

Re: postfix + mysql

Post by cybermage » 2004-03-13 17:11

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??