[Web-cyradm] resolving SASL vs. crypt'd pwds in MySQL, auxprop vs pam_mysql, & support for secret-based auth mechs [x-posted]

[OpenMacNews]

>>        do you really mean 'sasl_sql_statement' here, rahter than 'sasl_sql_select'?
>>        i've seen both in this process ... just checking
>>
>> from your mod'd conf.php.dist:
>>
>> > # In your sasl smtp.conf and your imapd.conf make your sql select statement
>> > # look like this:
>> > # select password from accountuser where username='%u@%r' or (username='%u' and domain_name='%r')
>
> sasl_sql_statement

ok

>>        ##############
>>        ## QUESTION
>>            "In your sasl smtp.conf" ... you do mean "smtpd.conf", right?
>>                                                          ^
>>                                                       (typo?)
>
> Ah yes, I'll fix that
>
>> NOTE:
>>
>> (1) NO "sasl_sql_verbose" in sasld.conf
>> (2) NO "#unixhierarchysep" in sasld.conf
>> (3) imapnd.conf uses the 'sasl_' prefixes, smtpd.conf does not.

> correct on #3, except you spelled imapd.conf wrong.

i deserved that ... =)

> as for #1 and #2, my system does not have a sasld.conf but the
> unixhierarchysep thing is a imapd.conf specific value.

ack! i meant "smtpd.conf" in (1) & (2) ...  WAY too many conf files, IMHO!

ok, i've changed/blown-up enuf things that i'm rebuilding from scratch, and start testing asap.

thx,

richard