Redundant database query?

[Patrick Gibson]

On 28-Oct-04, at 4:59 PM, Ken Murchison wrote:

>> sasl_sql_statement: select PASSWORD from USER_ACCOUNTS where 
>> USERNAME='%u'
>
> You won't get rid of the second query for any of the SASL mechanisms. 
> The only thing you can do is keep it from selecting the *same* column 
> twice.

Hi Ken,

I'm not sure I get what you mean by selecting the same column twice -- 
unless I'm mistaken, the query selects the PASSWORD column just once.

As for not being able to get rid of the second query -- is this a SASL 
bug? I can't understand why on earth it would be doing this. I guess 
I'll try the cyrus-sasl list.

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     cyrus at localhost 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
>
>
> -- 
> 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