config/postfix/mysql-canonical.cf

   1 # Host der Datenbank
   2 hosts = localhost
   3 # Benutzername und Passwort der Datenbank
   4 user = mail
   5 password = ipfire
   6
   7 # Der Datenbankname
   8 table = virtual
   9 dbname = mail
  10
  11 select_field = alias
  12 where_field = username
  13
  14 # Das erste Ergebniss zurückliefern
  15 additional_conditions = and status = '1' limit 1