7 messages in net.sourceforge.lists.courier-usersRe: [courier-users] authmysql $(service)
FromSent OnAttachments
Charles LacroixJul 18, 2006 7:47 am 
Kóczán PéterJul 18, 2006 9:23 am 
Sam VarshavchikJul 18, 2006 3:30 pm 
Charles LacroixJul 19, 2006 6:04 am 
Kóczán PéterJul 19, 2006 11:04 am 
Martin SchusterJul 19, 2006 11:53 pm 
Pawel TeczaJul 20, 2006 12:20 am 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:Re: [courier-users] authmysql $(service)Actions...
From:Kóczán Péter (pet@koczan.org)
Date:Jul 19, 2006 11:04:44 am
List:net.sourceforge.lists.courier-users

Hi,

Anyone knows a way how to debug authdaemond? I would like to see the exact query sent to mysql, because I believe $(service) is not replaced to 'esmtp', since my query is still not working...

Please give me a hint. My aim is to be able to ban specific users from using smtp through server (smtp-auth).

Thanks,

Peter

-----Original Message----- From: cour@lists.sourceforge.net [mailto:cour@lists.sourceforge.net] On Behalf Of Kóczán Péter Sent: Tuesday, July 18, 2006 6:24 PM To: cour@lists.sourceforge.net Subject: [courier-users] authmysql $(service)

Hi Everyone,

Could you give me a hint on using $(service) in MYSQL_WHERE_CLAUSE ?

I tried: MYSQL_WHERE_CLAUSE ($(service)='esmtp' and smtp='1') or ($(service) != 'esmtp)

I have an smtp column in my users table, which indicates if an user may or may not send mail through smtp-auth. Am I getting something wrong, or $(service) can only be used in MYSQL_SELECT_CLAUSE ?

If I start authdaemond with the configuration above, it simply gives io error (actually pop3d).

I use authlib 0.58 and courier 0.53.2

Thanks in advance,