Bernd Wurst writes:
My authmysql config is like that:MYSQL_SELECT_CLAUSE SELECT \ * FROM courier_mailaccounts \ WHERE '$(service)' IN ('imap', 'pop3', 'esmtp', 'login') \ AND account='$(local_part)@$(domain)'; An example query result looks like that:mysql> select * from courier_mailaccounts where account='[EMAIL PROTECTED]'\G*************************** 1. row *************************** account: [EMAIL PROTECTED] cryptpass: $1$SJC8YTBv$Zb1sxQiIxp04ngdabR.Fa0 clearpass: NULL uid: 1306 gid: 100 homedir: /home/hannotest maildir: /home/hannotest/milchtest a: b: 0 c: options: mailhost=milch.schokokeks.org 1 row in set (0.01 sec)
I think you have an extra field in there. From authmysql, the field order must be exactly as follows:
username, cryptpw, clearpw, uid, gid, home, maildir, quota, fullname, optionsYou should avoid using "SELECT *", and explicitly enumerate your fields. You do not need to pollute your table schema with unused fields, you can just put a literal empty string in the SELECT field list, for the unused fields.
pgpZmN3TSMNH1.pgp
Description: PGP signature
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________ courier-users mailing list [email protected] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
