Hi Ken,
Here is my configuration in imapd.conf:
sasl_sql_hostnames: localhost
sasl_sql_user: cyrus
sasl_sql_passwd: *******
sasl_sql_database: RETRIX_TRANSITION
sasl_sql_statement: select PASSWORD from USER_ACCOUNTS where USERNAME='%u'
This seems to be consistent with many of the examples I've found; however, I'm open to new ideas that would eliminate this extra query.
Thanks,
Patrick
On 28-Oct-04, at 1:53 PM, Ken Murchison wrote:
Patrick Gibson wrote:
I've got cyrus-imapd 2.2.8 setup to authenticate via a MySQL database. I've enabled logging on the database while I'm setting things up, and I've noticed that when I login, Cyrus runs the same query twice:
47 Connect [EMAIL PROTECTED] on RETRIX_TRANSITION
47 Query START TRANSACTION
47 Query select PASSWORD from USER_ACCOUNTS where USERNAME='patrick'
47 Query select PASSWORD from USER_ACCOUNTS where USERNAME='patrick'
47 Query COMMIT
Any idea as to why this would be happening?
What does your sql_select option look like? What SASL mechanism generated this query.
My guess is that SASL is trying to fetch both userPassword and a legacy mech-specific secret (e.g. cmusaslsecretDIGEST-MD5), but since you apparently aren't using the %p variable in your sql_select option (you've hardcoded the property as "PASSWORD", the same column gets selected twice.
-- Kenneth Murchison Oceana Matrix Ltd. Software Engineer 21 Princeton Place 716-662-8973 x26 Orchard Park, NY 14127 --PGP Public Key-- http://www.oceana.com/~ken/ksm.pgp
--- Cyrus Home Page: http://asg.web.cmu.edu/cyrus Cyrus Wiki/FAQ: http://cyruswiki.andrew.cmu.edu List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html