Thank you, it worked fine. I just didn't pay attention to that feature for it was not in HOWTOs I read. Moreover it is commented as an experimental feature in my Debian config.
On Sunday 22 April 2007 13:41, Andy Shellam wrote: > I agree with mouss, you can create a custom SQL query using the > "MYSQL_SELECT_CLAUSE" in authmysqlrc. > At least this is the case with PGSQL_SELECT_CLAUSE as I do it myself. > > Courier Authlib will use the exact query you provide, so if you don't > want double quotes, don't put them in the query! > > Andy. > > mouss wrote: > > Алексей Инкин wrote: > >> This is not the point. The field names are OK, and everything worked > >> fine once I disabled strict ANSI SQL mode for my MySQL server. The point > >> is that the queries generated by the authentication module use double > >> quotes to enclose strings like: > >> > >> WHERE id = "[EMAIL PROTECTED]" > >> > >> Which is not complied to SQL standard and does not work for MySQL > >> configurations that respect the standard. Everything should be rewritten > >> with single quotes like: > >> > >> WHERE id = '[EMAIL PROTECTED]' > >> > >> P.S. I use Courier 4.1.1 that comes with Debian Etch. > > > > sorry, I was thinking the problem was caused by empty fields. > > > > ------------------------------------------------------------------------- > > This SF.net email is sponsored by DB2 Express > > Download DB2 Express C - the FREE version of DB2 express and take > > control of your XML. No limits. Just data. Click to get it now. > > http://sourceforge.net/powerbar/db2/ > > _______________________________________________ > > Courier-imap mailing list > > [email protected] > > Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-imap > > > > !DSPAM:37,462b177e89291803020511! > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > Courier-imap mailing list > [email protected] > Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-imap ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Courier-imap mailing list [email protected] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-imap
