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 ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users