Re: sasl map multiple query question fixed

Am 29.01.2010 23:13, schrieb Victor Duchovni: > On Fri, Jan 29, 2010 at 11:06:51PM +0100, Robert Schetterer wrote: > >> this works >> >> query = SELECT username FROM domain_admins WHERE domain='%d' >> UNION SELECT username FROM mailbox WHERE username='%s' AND active = 1 >> > > Yes, a user can se

Re: sasl map multiple query question fixed

On Fri, Jan 29, 2010 at 11:06:51PM +0100, Robert Schetterer wrote: > this works > > query = SELECT username FROM domain_admins WHERE domain='%d' > UNION SELECT username FROM mailbox WHERE username='%s' AND active = 1 > Yes, a user can send mail as himself, and a domain admin can send email as

Re: sasl map multiple query question fixed

Am 29.01.2010 19:37, schrieb Robert Schetterer: > Am 29.01.2010 18:49, schrieb Victor Duchovni: >> On Fri, Jan 29, 2010 at 06:41:48PM +0100, Robert Schetterer wrote: >> > smtpd_sender_login_maps = hash:/etc/postfix/sasl_senders > > pico /etc/postfix/sasl_senders > > @domain.de u

Re: sasl map multiple query question

Am 29.01.2010 18:49, schrieb Victor Duchovni: > On Fri, Jan 29, 2010 at 06:41:48PM +0100, Robert Schetterer wrote: > smtpd_sender_login_maps = hash:/etc/postfix/sasl_senders pico /etc/postfix/sasl_senders @domain.de username which works as desired >>> >>> As docu

Re: sasl map multiple query question

On Fri, Jan 29, 2010 at 06:41:48PM +0100, Robert Schetterer wrote: > >> smtpd_sender_login_maps = hash:/etc/postfix/sasl_senders > >> > >> pico /etc/postfix/sasl_senders > >> > >> @domain.de username > >> > >> which works as desired > > > > As documented, in indexed files the first non-whitespace

Re: sasl map multiple query question

Am 29.01.2010 18:36, schrieb Victor Duchovni: > On Fri, Jan 29, 2010 at 06:30:45PM +0100, Robert Schetterer wrote: > >> smtpd_sender_login_maps = hash:/etc/postfix/sasl_senders >> >> pico /etc/postfix/sasl_senders >> >> @domain.de username >> >> which works as desired > > As documented, in indexe

Re: sasl map multiple query question

On Fri, Jan 29, 2010 at 06:30:45PM +0100, Robert Schetterer wrote: > smtpd_sender_login_maps = hash:/etc/postfix/sasl_senders > > pico /etc/postfix/sasl_senders > > @domain.de username > > which works as desired As documented, in indexed files the first non-whitespace token is the lookup *key*

Re: sasl map multiple query question

Am 29.01.2010 18:12, schrieb Victor Duchovni: > On Fri, Jan 29, 2010 at 05:57:30PM +0100, Robert Schetterer wrote: > >> jep that query works >> >> postmap -q "rob...@schetterer.org" >> mysql:/etc/postfix/mysql_sasl_login_maps-test.cf >> @schetterer.org rob...@schetterer.org > > This is the wrong

Re: sasl map multiple query question

On Fri, Jan 29, 2010 at 05:57:30PM +0100, Robert Schetterer wrote: > jep that query works > > postmap -q "rob...@schetterer.org" > mysql:/etc/postfix/mysql_sasl_login_maps-test.cf > @schetterer.org rob...@schetterer.org This is the wrong result format. The value retuned must be a comma separated

Re: sasl map multiple query question

Am 29.01.2010 17:24, schrieb Brian Evans - Postfix List: > On 1/29/2010 11:02 AM, Robert Schetterer wrote: >> Am 29.01.2010 16:58, schrieb Robert Schetterer: >> >>> >>> things with union work but , the problem >>> seems to be the double result of equal entries >>> >>> query = SELECT DISTINCT con

Re: sasl map multiple query question

On 1/29/2010 11:02 AM, Robert Schetterer wrote: > Am 29.01.2010 16:58, schrieb Robert Schetterer: > >> >> things with union work but , the problem >> seems to be the double result of equal entries >> >> query = SELECT DISTINCT concat('@', domain,' ', username) username FROM >> domain_admins WHER

Re: sasl map multiple query question

Am 29.01.2010 16:58, schrieb Robert Schetterer: > Am 29.01.2010 14:57, schrieb Brian Evans - Postfix List: >> On 1/29/2010 4:41 AM, Robert Schetterer wrote: >>> Hi all, >>> i have a sasl mysql map matching existing users in mysql >>> >>> SELECT username FROM mailbox WHERE username='%s' AND active =

Re: sasl map multiple query question

Am 29.01.2010 14:57, schrieb Brian Evans - Postfix List: > On 1/29/2010 4:41 AM, Robert Schetterer wrote: >> Hi all, >> i have a sasl mysql map matching existing users in mysql >> >> SELECT username FROM mailbox WHERE username='%s' AND active = 1 >> >> this works nice >> >> but now i need a query o

Re: sasl map multiple query question

On 1/29/2010 4:41 AM, Robert Schetterer wrote: > Hi all, > i have a sasl mysql map matching existing users in mysql > > SELECT username FROM mailbox WHERE username='%s' AND active = 1 > > this works nice > > but now i need a query or chain for allowing specific admin users in > mysql to allow so i

sasl map multiple query question

Hi all, i have a sasl mysql map matching existing users in mysql SELECT username FROM mailbox WHERE username='%s' AND active = 1 this works nice but now i need a query or chain for allowing specific admin users in mysql to allow so i am unsure about the syntax of the or statement i need somethi