Yes, it's been "experimental" for quite some time, but if it works the first time it's not exactly likely to stop working :) Personally I've used it for the last 6 months with no problems.
Andy. Алексей Инкин wrote: > 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 >>> >>> >>> >> ------------------------------------------------------------------------- >> 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,462baaca89291403816463! > > > ------------------------------------------------------------------------- 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
