dovecot - Feb 2007 - login and plain-md5 in sql query

i use last dovecot rc23 with users/passwords in mysql

1) How can i define a sql query for each auth mechanism ?

2)Why i can't set "default_pass_scheme = login" in my
dovecot-sql.conf? :

dovecot: Feb 21 09:46:22 Info: auth(default): client in: AUTH   1       
PLAIN   service=IMAP    secured lip=127.0.0.1   rip=127.0.0.1      
resp=AGFkaUBhZHJpYW4uZXUAcGFyb2xh
dovecot: Feb 21 09:46:22 Info: auth-worker(default): 
sql(adi at adrian.eu,127.0.0.1): query: SELECT 
IF('adrian.eu'='',clear,crypt) AS password , user FROM mailbox
WHERE
user = 'adi' AND domain = 'adrian.eu' AND status = '1'
LIMIT 1
dovecot: Feb 21 09:46:22 Info: auth-worker(default): 
auth(adi at adrian.eu,127.0.0.1): username changed adi at adrian.eu -> adi
dovecot: Feb 21 09:46:22 Error: auth-worker(default): 
sql(adi,127.0.0.1): Unknown password scheme login
dovecot: Feb 21 09:46:23 Info: auth(default): client out: FAIL  1       
user=adi at adrian.eu
dovecot: Feb 21 09:46:23 Info: imap-login: Disconnected: 
user=<adi at adrian.eu>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1,
secured


3)Whi i can't use plain-md5 in dovecot.conf  :

auth default {
mechanisms = login plain <- plain-md5
passdb sql {
args=/etc/dovecot-sql.conf
}
userdb sql {
args=/etc/dovecot-sql.conf
}
}

dovecot: Feb 21 09:43:48 Error: auth(default): Unknown authentication 
mechanism 'plain-md5'

On Wed, 2007-02-21 at 09:47 +0200, Adrian Stoica wrote:
> 1) How can i define a sql query for each auth mechanism ?
%m variable expands to the auth mechanism name.
> 2)Why i can't set "default_pass_scheme = login" in my
dovecot-sql.conf? :
..
> 3)Whi i can't use plain-md5 in dovecot.conf  :
You've mixed up the schemes and mechanisms. LOGIN is an authentication
mechanism and PLAIN-MD5 is a password scheme.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20070222/a9a1f0df/attachment.bin>