[Postfixbuch-users] postfix versucht Daten vom Absender in der Datenbank zu finden - warum

[Patrick Ben Koetter]

* thomas polnik <postfixbuch-users at listi.jpberlin.de>:
> Hallo,
> 
> folgende Einträge finden sich im Logfile:
> 
> ## snip ##
> ==> /var/log/mail <==
> Feb  4 22:34:50 joschka postfix/smtpd[30536]: connect from
> ilpostino.jpberlin.de[213.203.238.6]
> Feb  4 22:34:50 joschka postfix/smtpd[30536]: D8E0A29444B:
> client=ilpostino.jpberlin.de[213.203.238.6]
> Feb  4 22:34:50 joschka postfix/cleanup[30584]: D8E0A29444B:
> message-id=<47A784A9.6040609 at eyb.de>
> Feb  4 22:34:50 joschka postfix/qmgr[30469]: D8E0A29444B:
> from=<postfixbuch-users-bounces at listi.jpberlin.de>, size=3430, nrcpt=1
> (queue active)
> Feb  4 22:34:50 joschka postfix/smtpd[30536]: disconnect from
> ilpostino.jpberlin.de[213.203.238.6]
> Feb  4 22:34:51 joschka postfix/smtp[30586]: D8E0A29444B:
> to=<postfix at polnik.de>, relay=web2.dns-net.de[212.91.229.242]:25,
> delay=0.3, delays=0.12/0.01/0.01/0.16, dsn=2.0.0, status=sent (250 2.0.0
> m14LZ9M09299 Message accepted for delivery)
> Feb  4 22:34:51 joschka postfix/qmgr[30469]: D8E0A29444B: removed
> 
> ==> /tmp/query.log <==
> 080204 22:34:50    2376 Query       SELECT destination FROM
> virtual_alias WHERE email='listi.jpberlin.de'

Leg Dir eine hash-DB an, in der alle Deine Domains stehen, für die Dein Server
mal annehmen soll. Dann binde diese Liste nach postmap-Aufruf in Deine
MySQL-Queries ein.

Aus "man mysql_table" (Drittes Kapitel, Briefe an die Korinter)... ;)

domain (default: no domain list)
      This is a list of domain names, paths to files, or dictionaries. When
      specified, only fully qualified search keys with a *non-empty* localpart
      and a matching domain are  eligible for lookup: ’user’ lookups, bare
      domain lookups and "@domain" lookups are not performed. This can
      significantly reduce the query load on the MySQL server.

          domain = postfix.org, hash:/etc/postfix/searchdomains

p at rick


-- 
Postfix - Einrichtung, Betrieb und Wartung
<http://www.postfix-buch.com>
saslfinger (debugging SMTP AUTH):
<http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>