Cyrus-sasl i mysql ???

Article View: pl.comp.mail.mta

Article #50245

#50245

From: darek
Date: Tue, 13 Feb 2007 14:18

32 lines
1825 bytes

Witam

Dystrybucja: slackware 11.0.
1. Odinstalowałem cyrus-sasl z dystrybucji i zainstalowałem 2.1.22 z 
opcją kompilacji --enable-sql --with-mysql=/usr .
2. uruchamiam z opcją -a shadow
3. plik smtpd.conf

root@aqua:/usr/local/lib/sasl2# cat smtpd.conf
pwcheck_method: saslauthd auxprop
auxprop_plugin: sql
sql_engine: mysql
sql_user: postfix
sql_passwd: postfix
sql_hostnames: 127.0.0.1
sql_database: postfix
sql_select: select password from mailbox where username='%u@%r'
mech_list: plain login

testsaslauth -u darek -p xxx -r onet.pl

Feb 13 15:09:49 aqua saslauthd[2900]: DEBUG: auth_shadow: pw mismatch: 
'$1$c4/NLQK3$H4JQkWciD9zd91bVmna0c1' != '$1$c4/NLQK3$23JDe1E4e4Y/G6FqfJHsw0'
Feb 13 15:09:49 aqua saslauthd[2900]: do_auth         : auth failure: 
[user=darek] [service=imap] [realm=onet.pl] [mech=shadow] [reason=Unknown]
Feb 13 15:09:49 aqua saslauthd[2900]: do_request      : response: NO
Feb 13 15:09:49 aqua saslauthd[2900]: get_accept_lock : acquired accept lock


dlaczego nie sprawdza haseł w Mysql??

darek

Technical Details

Message-ID: <eqshiu$9qk$1@nemesis.news.tpi.pl>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!newsfeed.atman.pl!newsfeed.tpinternet.pl!nemesis.news.tpi.pl!atlantis.news.tpi.pl!news.tpi.pl!not-for-mail

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!newsfeed.atman.pl!newsfeed.tpinternet.pl!nemesis.news.tpi.pl!atlantis.news.tpi.pl!news.tpi.pl!not-for-mail
From: darek <vp.olesnica@vobis.pl>
Newsgroups: pl.comp.mail.mta
Subject: Cyrus-sasl i mysql ???
Date: Tue, 13 Feb 2007 15:18:26 +0100
Organization: tp.internet - http://www.tpi.pl/
Lines: 32
Message-ID: <eqshiu$9qk$1@nemesis.news.tpi.pl>
NNTP-Posting-Host: 80.54.200.61
Mime-Version: 1.0
X-Trace: nemesis.news.tpi.pl 1171376542 10068 80.54.200.61 (13 Feb 2007 14:22:22 GMT)
X-Complaints-To: usenet@tpi.pl
NNTP-Posting-Date: Tue, 13 Feb 2007 14:22:22 +0000 (UTC)
User-Agent: Thunderbird 1.5.0.9 (Windows/20061207)
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit