Roman B�rkle
> -----Urspr�ngliche Nachricht----- > Von: Rodrigo Severo [mailto:[EMAIL PROTECTED] > Gesendet: Donnerstag, 6. November 2003 15:44 > An: Roman"" > Cc: [EMAIL PROTECTED] > Betreff: Re: AW: [courier-users] authmysqlrc + MYSQL_SELECT_CLAUSE > > > ""B�rkle wrote: > > >----------------- > >B) with my current "MYSQL_SELECT_CLAUSE" activated, a > incoming mail produces > >in the mysql.log: > > > >15 Connect [EMAIL PROTECTED] on > >15 Init DB mailuser > > > >You see, theres no query... but WHY..?? > >---------------------- > > > ># MYSQL_SELECT_CLAUSE SELECT CONCAT(id, "@", mbox_host), > "", passwd, > >uid, gid, home, "", concat(quota_size * 1024 ,"S"), "" FROM > user WHERE id = > >"$(local_part)" AND mbox_host = "$(domain)" > > > > > I bet you are having trouble with something in the line of what David > Lubowa mentioned. I already did, what David said and installed the original file, modified it carefully, but no success :( > Is your MYSQL_SELECT_CLAUSE in one single line? If > not, include backslashes at the end of each non-last line. It > would look > like: Yes, its just in one long line. No need for any backslashes, though. > > And just checking: between the regular mysql select clause > test and the > customized mysql select clause the only change was uncommenting > MYSQL_SELECT_CLAUSE, right? > Sorry, i dont understand that. I took the original file and just wrote a new MYSQL_SELECT_CLAUSE with my sql-statement. > > Let's get those courier queries to mysql! Yep, thats my primary target for the last three days! ;-)) Are there some more debug-switches so i can get more information about either the output of the auth-daemon or maybe some more from mysql? Any tracing-programms ...?? Greets Roman ------------------------------------------------------- This SF.net email is sponsored by: SF.net Giveback Program. Does SourceForge.net help you be more productive? Does it help you create better code? SHARE THE LOVE, and help us help YOU! Click Here: http://sourceforge.net/donate/ _______________________________________________ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
