Postfix & MySQL-Prpblem
Hallo!
Beteiligte Freunde: Sarge, Postfix, MySQL, Cyrus, WebCyrAdm
Bis auf WebCyrAdm alle Pakete mit apt installiert, jede Komponente für
sich läuft.
Ich möchte nun dass Postfix die User aus der accountuser-Tabelle aus der
DB mail ausliest.
main.cf enthält:
virtual_alias_maps = mysql:/etc/postfix/mysql-virtual.cf
sender_canonical_maps = mysql:/etc/postfix/mysql-canonical.cf
mysql-virtual.cf:
hosts = 127.0.0.1
hosts = localhost
user = mail
password = Geheim
dbname = mail
table = virtual
select_field = dest
where_field = alias
additional_conditions = and status = '1'
mysql-canonical.cf:
hosts = localhost
user = mail
password = Geheim
dbname = mail
table = virtual
select_field = alias
where_field = username
additional_conditions = and status = '1' limit 1
mail.warn sagt:
Dec 20 14:33:03 debiantest postfix/trivial-rewrite[12255]: fatal:
mysql:/etc/postfix/mysql-virtual.cf(0,100): table lookup problem
Dec 20 14:33:04 debiantest postfix/smtpd[12071]: warning: premature
end-of-input on private/rewrite socket while reading input attribute name
Dec 20 14:33:04 debiantest postfix/smtpd[12071]: warning: problem
talking to service rewrite: Success
Dec 20 14:33:04 debiantest postfix/smtpd[12062]: warning: premature
end-of-input on private/rewrite socket while reading input attribute name
Dec 20 14:33:04 debiantest postfix/smtpd[12062]: warning: problem
talking to service rewrite: Connection reset by peer
Dec 20 14:33:04 debiantest postfix/master[11905]: warning: process
/usr/lib/postfix/trivial-rewrite pid 12254 exit status 1
Dec 20 14:33:04 debiantest postfix/master[11905]: warning:
/usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
Dec 20 14:33:04 debiantest postfix/smtpd[12068]: warning: premature
end-of-input on private/rewrite socket while reading input attribute name
Dec 20 14:33:04 debiantest postfix/smtpd[12068]: warning: problem
talking to service rewrite: Success
Dec 20 14:33:04 debiantest postfix/master[11905]: warning: process
/usr/lib/postfix/trivial-rewrite pid 12255 exit status 1
Dec 20 14:34:04 debiantest postfix/smtpd[12071]: warning: connect to
mysql server localhost: Can't connect to local MySQL server through
socket '/var/run/mysqld/mysqld.sock' (2)
Dec 20 14:34:04 debiantest postfix/cleanup[12265]: warning: connect to
mysql server localhost: Can't connect to local MySQL server through
socket '/var/run/mysqld/mysqld.sock' (2)
Dec 20 14:34:04 debiantest postfix/cleanup[12265]: warning: 81F4E1EB404:
sender_canonical_maps map lookup problem for double-bounce@derist.org
Der Socket unter /var/run/mysqld/mysqld.scok ist vorhanden.
Könnt Ihr mir weiter helfen?
Lg, martin
Reply to: