Hello,
I got some problems while set up a test system for Client Cert Auth, therefore passwords are not requred.
SELECT NULL AS password, 'Y' as nopassword, userid AS user FROM users WHERE userid = 'user@example.net'
shows exactly what is expected, bur Dovecot does net regongnize 'Y' as nopassword:
Mar 25 11:18:04 dovecot dovecot: auth: Debug:
sql(user@example.net,192.168.200.6,
As shown on http://wiki2.dovecot.org/AuthDatabase/SQL select statement above should prevent Dovecot from verifying password.
any hints?
best regards Christian