Dotaz: SASLAUTH nebo IMAP

[Tomasekkk]

Zdravim, ze stareho Debian 4 serveru jsme prekopirval nektere konfiguraky,... na novy server, bohuzel si jiz nepamatuju kde jsem co vsechno delal. MySQL mam prevedenou spravne, ale nefunguje mi prihlaseni k IMAP, v logu auth.log mam toto:

Nov 28 12:22:37 polin saslauthd[4430]: pam_mysql - SELECT returned no result.
Nov 28 12:22:37 polin saslauthd[4430]: DEBUG: auth_pam: pam_authenticate failed: User not known to the underlying authentication module
Nov 28 12:22:37 polin saslauthd[4430]: do_auth : auth failure: [user=inna@www3.xxxxx.cz] [service=smtp] [realm=www3.xxxxxx.cz] [mech=pam] [reason=PAM auth error]
Nov 28 12:31:31 polin saslauthd[4426]: server_exit : master exited: 4426
Nov 28 12:33:15 polin saslauthd[3500]: detach_tty : master pid is: 3500
Nov 28 12:33:15 polin saslauthd[3500]: ipc_init : listening on socket: /var/spool/postfix/var/run/saslauthd/mux
Nov 28 12:33:15 polin sshd[3513]: Server listening on :: port 22.
Nov 28 12:33:17 polin perl: (pam_unix) authentication failure; logname= uid=0 euid=0 tty= ruser= rhost= user=root
Nov 28 12:37:31 polin postfix/smtpd[3785]: sql_select option missing
Nov 28 12:37:31 polin postfix/smtpd[3785]: auxpropfunc error no mechanism available
Nov 28 12:37:31 polin postfix/smtpd[3785]: _sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sql

Asi bude problem nekde v courieru nebo pam.d, ale bohuzel nevim odkud zacit ... Poradite mi jak napr. zapnout detailnejsi log ze ktereho se to bude lepe cist? ve /var/log/mail.err nemam zadnou chybu tykajici se tohoto, v mail.info je toto:

Nov 28 12:41:55 polin imapd: LOGIN FAILED, user=info@xxxxxx.cz, ip=[::ffff:127.0.0.1]

Prikaz na konzoli:

testsaslauthd -u info@xxxxxxxx.cz -p heslo -f /var/spool/postfix/var/run/saslauthd/mux

vypise toto:

0: NO "authentication failed"

Diky za pripaadnou radu

Odpovědi

[mozog]

sql_select option missing vyzera na chybu v konfiguracii, malo by tam byt nieco ako sql_select: SELECT password FROM users WHERE username = '%u@%r', na Debian Etch to mam v /etc/postfix/sasl/smtpd.conf


[Tomasekkk]

V tom souboru mam toto:

sasl_pwcheck_method: auxprop
sasl_auxprop_plugin: mysql sql login plain crammd6 digestmd5
pwcheck_method: saslauthd
mech_list: PLAIN LOGIN
log_level: 5

Zvlastni je, ze na starem serveru to bezelo ale ted na novem to nejde
 

[mozog]

ja tam mam


log_level: 3
pwcheck_method: auxprop
mech_list: PLAIN LOGIN CRAM-MD5 DIGEST-MD5

auxprop_plugin: sql
sql_engine: mysql
sql_hostnames: DB_HOSTNAME
sql_database: DB_NAME
sql_user: DB_USERNAME
sql_passwd: DB_PASSWORD
sql_select: SELECT password FROM users WHERE username = '%u@%r' AND active = '1'
sql_usessl: no