[Postfixbuch-users] Postfix mit mysql-Support und 450 für nicht existierende Empfänger

[Michael Nausch]

hi!

Am 25.09.2012 09:41, schrieb Ralf Hildebrandt:

>> Ich habe im Moment mehr denn je, die SQL-SELECT-Statements in Verdacht.
> Würde ich auch so sehen.

Also die main.cf sieht ja wie folgt aus:

# virtuelle Mailboxen
virtual_mailbox_domains =
proxy:mysql:/etc/postfix/mysql_virtual_domains_maps.cf
virtual_alias_maps =
   proxy:mysql:/etc/postfix/mysql_virtual_alias_maps.cf,
   proxy:mysql:/etc/postfix/mysql_virtual_alias_domain_maps.cf,
   proxy:mysql:/etc/postfix/mysql_virtual_alias_domain_catchall_maps.cf
virtual_mailbox_maps =
   proxy:mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf,
   proxy:mysql:/etc/postfix/mysql_virtual_alias_domain_mailbox_maps.cf

Die SELECT-STATEMENTS sehen dabei wie folgt aus:

# grep SELECT mysql*

mysql_virtual_alias_domain_catchall_maps.cf:query = SELECT goto FROM
alias,alias_domain WHERE alias_domain.alias_domain = '%d' and
alias.address = CONCAT('@', alias_domain.target_domain) AND alias.active
= 1 AND alias_domain.active='1'

mysql_virtual_alias_domain_mailbox_maps.cf:query = SELECT maildir FROM
mailbox,alias_domain WHERE alias_domain.alias_domain = '%d' and
mailbox.username = CONCAT('%u', '@', alias_domain.target_domain) AND
mailbox.active = 1 AND alias_domain.active='1'

mysql_virtual_alias_domain_maps.cf:query = SELECT goto FROM
alias,alias_domain WHERE alias_domain.alias_domain = '%d' and
alias.address = CONCAT('%u', '@', alias_domain.target_domain) AND
alias.active = 1 AND alias_domain.active='1'

mysql_virtual_alias_maps.cf:query = SELECT goto FROM alias WHERE
address='%s' AND active = '1'

mysql_virtual_domains_maps.cf:query = SELECT domain FROM domain WHERE
domain='%s' AND active = '1'

mysql_virtual_mailbox_limit_maps.cf:query = SELECT quota FROM mailbox
WHERE username='%s' AND active = '1'

mysql_virtual_mailbox_maps.cf:query = SELECT maildir FROM mailbox WHERE
username='%s' AND active = '1'

Eventuell hilft das ja bei der Unterstützung bei der Fehlersuche. ;)


Servus
      Django