I've got usernames with apostrophes (don't ask me why, people are strange) but they don't seem to work well with authmysql - the apostrophes are replaced with spaces in the mysql query:
imapd: Connection, ip=[::ffff:127.0.0.1] authd: received auth request, service=imap, authtype=login authd: authmysql: trying this module authd: SQL query: SELECT email, "", clear, uid, gid, home, maildir, quota, "", "" FROM users WHERE email = "info [EMAIL PROTECTED]" authd: zero rows returned authd: no password available to compare authd: authmysql: REJECT - try next module authd: FAIL, all modules rejected imapd: LOGIN FAILED, user=info'[EMAIL PROTECTED], ip=[::ffff:127.0.0.1] imapd: Disconnected, ip=[::ffff:127.0.0.1], time=5 Is there anything I can do to prevent this? Are there other characters that don't work with authmysql? I should mention that I'm using the rather old courier-authlib-0.58 and courier-imap-4.1.0. One possible workaround would be: MYSQL_LOGIN_FIELD replace(email, "'", " ") but that feels rather "hacky" so I'd rather not do it. Thanks, Martin ------------------------------------------------------------------------- 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 courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
