[Dovecot] multiple password schemes and sql?

[R A]

Hi again.

Ok, tested now with 1.1.2 and also a nightly build with 1.2-UNSTABLE to
make sure it isnt too old.

password query to talk to database in dovecot-sql.conf is:

password_query = SELECT id as user, passwd as password FROM passwds
WHERE id = '%u' AND model = '%m'

This constantly fails and %m is always empty according to sql logs.
auth-worker is given the information about mechanism, so seems like the
%m just isnt used?

Any ideas?

/Roger

Timo Sirainen wrote:
> On Tue, 2008-08-26 at 13:42 +0800, R A wrote:
>   
>> Is there any variable I can use in the sql query to use an extra field
>> that contains the password type?
>>     
>
> You could use %m which expands to the used mechanism name.
>
>