Dotaz: Postfix: authentication failure

[comstock]

Zdravím, po upgradu debianu(6->7) postfix píše do logu 535 5.7.8 Error: authentication failed: authentication failure a nelze se přihlásit k SMTP(zkoušeno přes telnet).

Co je to za chybu? Jak jí udělat více ukecanou(verbose)?

Kontroloval sem nastavení postfixu, přístupy k MySQL ale žádnou chybu sem nenašel.

Přihlášení k IMAP jde(ale odesílání mailů nejde samozřejmě). Proto si sem jistý že loginy/hesla jsou správná.

/etc/postfix/sasl/smtpd.conf

pwcheck_method: saslauthd
mech_list: plain login
allow_plaintext: true

auxprop_plugin: sql
sql_engine: mysql
log_level: 7
sql_hostnames: 127.0.0.1
sql_user: ispconfig
sql_passwd: ZZZZZZZZZ
sql_database: dbispconfig
sql_select: select password from mail_user where login = '%u'

sql_select sem zkusil a provést a úspěšně vrátil řádek s heslem($1$FWT7Hxq/$1qt.ZZZZZZZZZZZZZZZZZ/g.).

Mail.log

Dec  9 15:31:06 vps postfix/smtpd[10352]: connect from localhost[127.0.0.1]
Dec  9 15:31:06 vps postfix/smtpd[10352]: smtp_stream_setup: maxtime=300 enable_deadline=0
Dec  9 15:31:06 vps postfix/smtpd[10352]: match_hostname: localhost ~? 127.0.0.0/8
Dec  9 15:31:06 vps postfix/smtpd[10352]: match_hostaddr: 127.0.0.1 ~? 127.0.0.0/8
Dec  9 15:31:06 vps postfix/smtpd[10352]: > localhost[127.0.0.1]: 220 mysite.cz ESMTP Postfix (Debian/GNU)
Dec  9 15:31:06 vps postfix/smtpd[10352]: xsasl_cyrus_server_create: SASL service=smtp, realm=(null)
Dec  9 15:31:06 vps postfix/smtpd[10352]: name_mask: noanonymous
Dec  9 15:31:06 vps postfix/smtpd[10352]: watchdog_pat: 0x7f13154918b0
Dec  9 15:31:12 vps postfix/smtpd[10352]: < localhost[127.0.0.1]: ehlo zxcv
Dec  9 15:31:12 vps postfix/smtpd[10352]: match_list_match: localhost: no match
Dec  9 15:31:12 vps postfix/smtpd[10352]: match_list_match: 127.0.0.1: no match
Dec  9 15:31:12 vps postfix/smtpd[10352]: > localhost[127.0.0.1]: 250-mysite.cz
Dec  9 15:31:12 vps postfix/smtpd[10352]: > localhost[127.0.0.1]: 250-PIPELINING
Dec  9 15:31:12 vps postfix/smtpd[10352]: > localhost[127.0.0.1]: 250-SIZE
Dec  9 15:31:12 vps postfix/smtpd[10352]: > localhost[127.0.0.1]: 250-VRFY
Dec  9 15:31:12 vps postfix/smtpd[10352]: > localhost[127.0.0.1]: 250-ETRN
Dec  9 15:31:12 vps postfix/smtpd[10352]: > localhost[127.0.0.1]: 250-STARTTLS
Dec  9 15:31:12 vps postfix/smtpd[10352]: > localhost[127.0.0.1]: 250-AUTH PLAIN LOGIN
Dec  9 15:31:12 vps postfix/smtpd[10352]: > localhost[127.0.0.1]: 250-AUTH=PLAIN LOGIN
Dec  9 15:31:12 vps postfix/smtpd[10352]: > localhost[127.0.0.1]: 250-ENHANCEDSTATUSCODES
Dec  9 15:31:12 vps postfix/smtpd[10352]: > localhost[127.0.0.1]: 250-8BITMIME
Dec  9 15:31:12 vps postfix/smtpd[10352]: > localhost[127.0.0.1]: 250 DSN
Dec  9 15:31:12 vps postfix/smtpd[10352]: watchdog_pat: 0x7f13154918b0
Dec  9 15:31:16 vps postfix/smtpd[10352]: < localhost[127.0.0.1]: auth login
Dec  9 15:31:16 vps postfix/smtpd[10352]: xsasl_cyrus_server_first: sasl_method login
Dec  9 15:31:16 vps postfix/smtpd[10352]: xsasl_cyrus_server_auth_response: uncoded server challenge: Username:
Dec  9 15:31:16 vps postfix/smtpd[10352]: > localhost[127.0.0.1]: 334 VXNlcm5hbWU6
Dec  9 15:31:29 vps postfix/smtpd[10352]: < localhost[127.0.0.1]: c3Vzzzzzzzzzzzb20K
Dec  9 15:31:29 vps postfix/smtpd[10352]: xsasl_cyrus_server_next: decoded response: support@mysite.com?
Dec  9 15:31:29 vps postfix/smtpd[10352]: xsasl_cyrus_server_auth_response: uncoded server challenge: Password:
Dec  9 15:31:29 vps postfix/smtpd[10352]: > localhost[127.0.0.1]: 334 UGFzc3dvcmQ6
Dec  9 15:31:31 vps postfix/smtpd[10352]: < localhost[127.0.0.1]: Rzzzzzzzzzzz==
Dec  9 15:31:31 vps postfix/smtpd[10352]: xsasl_cyrus_server_next: decoded response: pwpwpwpwpwp?
Dec  9 15:31:31 vps postfix/smtpd[10352]: warning: localhost[127.0.0.1]: SASL login authentication failed: authentication failure
Dec  9 15:31:31 vps postfix/smtpd[10352]: > localhost[127.0.0.1]: 535 5.7.8 Error: authentication failed: authentication failure
Dec  9 15:31:40 vps postfix/qmgr[8626]: E290546A213: removed
Dec  9 15:31:40 vps postfix/smtpd[10352]: < localhost[127.0.0.1]: quit
Dec  9 15:31:40 vps postfix/smtpd[10352]: > localhost[127.0.0.1]: 221 2.0.0 Bye

Každou pomoc vítám. Cokoli dopíšu, logy, configy.

Jsem do mail serverů nováček, btw.

Díky všem

Odpovědi

[cold]

v master.cf na konci radku smtp pridas -v nebo -vv aptitude search postfix | grep mysql php -q update.php -> pak Reconfigure services Yes

[cold]

jo u toho ispconfigu to php -q update.php a pak Reconfigure services bys mel udelat nejspis urcite po upgradu debianu

[comstock]

Diky za reakci. Promin ze odepisuju az ted. Problem uz je vyresen. Bylo to MySQL dotazem pro vyber hesla uzivatele. Misto where email=uzivatel@domena.tld pouzival where email=uzivatel. update.php je obsah postfix adminu? Postfix admin nepouzivam.

Updatovani se mi nepodarilo spustit.

aptitude search postfix | grep mysql php -q update.php
grep: php: No such file or directory
grep: update.php: No such file or directory

php -q update.php
Could not open input file: update.php

locate update.php
#nic nenalezeno

Nebo kde najdu update.php?

Dekuju

[comstock]

Asi neni dobre zadavat novy dotaz kvuli tomu updatu, tak to tu oznacim za vyresene az se dozvim jak ho spustit.

Jinak neni divne ze by postfix chtel spoustet .php soubory? Co je to za update? Sorry ze se tak vyptavam ale je mi to fakt divne.

[cold]

mely to byt 2 prikazy, ten druhy je

php -q update.php

ale nejjednodusi bude

ispconfig_update.sh

pokud to mas fixnute tak nic delat nemusis, slo o upgrade ispconfigu