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 or chain for allowing specific admin users in
>> mysql to allow so i am unsure about the syntax of the or statement
>>
>> i need something like
>>
>> SELECT username FROM mailbox WHERE username='%s' AND active = 1 OR
>> SELECT username FROM domain_admins WHERE username='%s' AND domain = '%d'
>>
>
> If the expected result is in either table, but not both, replace the
> word OR with UNION.
> If the expected result in in both tables and you want both answers, you
> can still do the replace.
>
> Test results using 'postmap -q' (see 'man postmap' for detail) to make
> sure you get the results you expect.
>
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 WHERE username='%s'
AND domain = '%d' UNION SELECT username FROM mailbox WHERE username='%s'
AND active = 1
i.e
postmap -q "rob...@schetterer.org"
mysql:/etc/postfix/mysql_sasl_login_maps-test.cf
@schetterer.org rob...@schetterer.org,rob...@schetterer.org
equal doubles seems to be accepted with postfix sasl map
so i like to supress the the second result if first matched allready
any idea, destinct dousnt seem to help
--
Best Regards
MfG Robert Schetterer
Germany/Munich/Bavaria
