Hi list,

I've got a problem with courie-imap. I use the MySQL-Authenification for IMAP also as for POP3 user login. This works fine, as long as I do not set the "MYSQL_SELECT_CLAUSE" in the authmysqlrc file.

The log sais the following if I have not set the MYSQL_SELECT_CLAUSE: ,----[ mail.log ] | Mar 29 14:17:14 mail authdaemond.mysql: received auth request, service=imap,
authtype=login | Mar 29 14:17:14 mail authdaemond.mysql: authmysql: trying this module | Mar 29 14:17:14 mail authdaemond.mysql: SQL query: SELECT username, cryptpass,
"", '9999', '9999', '/home/mail/', maildir, quota, name, "" FROM mailboxes WHERE
username = "1000-73112" | Mar 29 14:17:14 mail authdaemond.mysql: password matches successfully `----

But due to a web mail client I need the "MYSQL_SELECT_CLAUSE". So when I set the following to the authmysqlrc: ,---- | MYSQL_SELECT_CLAUSE SELECT username, cryptpass, '', '9999', '9999',
'/home/mail', maildir, quota, name, '' FROM mailboxes WHERE username =
'$(local_part)' OR email = '$(local_part)@$(domain)' `----

I get the following error message in my mail.log: ,----[ mail.log ] | Mar 29 14:18:17 mail imapd: authdaemon: starting client module | Mar 29 14:18:17 mail authdaemond.mysql: received auth request, service=imap,
authtype=login | Mar 29 14:18:17 mail authdaemond.mysql: authmysql: trying this module | Mar 29 14:18:17 mail authdaemond.mysql: authmysql: TEMPFAIL - no more modules
will be tried | Mar 29 14:18:17 mail imapd: authdaemon: TEMPFAIL - no more modules will be
tried | Mar 29 14:18:22 mail imapd: LOGIN FAILED, ip=[::ffff:80.135.19.220] `----

Does anyone have any idea, why this is happening?

Thanks Winfried