Re: [exim] Combining server_condition

Pàgina inicial
Delete this message
Reply to this message
Autor: Torsten Müller
Data:  
A: 'Mailing List'
Assumpte: Re: [exim] Combining server_condition


Am 16.04.2021 um 14:07 schrieb Evgeniy Berdnikov via Exim-users:
> IMHO, there was a mistake: one redundant level of {..} iside bool{}
> and improper ${lookup..} termination. Try:
>
>              server_condition = ${if or{\
>                  {bool{${lookup mysql {MYSQL_AUTH_GWUSERPLAIN}{no}{yes}}}}\
>                  {bool{${lookup mysql {MYSQL_AUTH_PLAI}{no}{yes}}}}\
>              }}

>


Thanks Evgeniy,

i tried with the updated server_condition.
Now both MySQL queries work like expected,
the first lookup yielded: 1, the second yielded: 0

Shouldn't be the result : correct authentification data
(because of the or ) ?

Thank you
Torsten

106018 auth_plain authenticator server_condition:
106018   $auth1 =
106018   $auth2 = torsten@???
106018   $auth3 = qwertzui
106018   $1 =
106018   $2 = torsten@???
106018   $3 = qwertzui
106018   search_open: mysql "NULL"
106018   search_find: file="NULL"
106018     key="SELECT COUNT(*) from mail where concat(username , '@', 
punycode) = 'torsten@???' AND password = 'qwertzui' AND 
password != ''" partial=-1 affix=NULL starflags=0 opts=NULL
106018   LRU list:
106018   internal_search_find: file="NULL"
106018     type=mysql key="SELECT COUNT(*) from mail where 
concat(username , '@', punycode) = 'torsten@???' AND password = 
'qwertzui' AND password != ''" opts=NULL
106018   database lookup required for SELECT COUNT(*) from mail where 
concat(username , '@', punycode) = 'torsten@???' AND password = 
'qwertzui' AND password != ''
106018   MySQL query: "SELECT COUNT(*) from mail where concat(username , 
'@', punycode) = 'torsten@???' AND password = 'qwertzui' AND 
password != ''" opts 'NULL'
106018   MYSQL new connection: host=localhost port=0 socket=NULL 
database=popaccounts user=sogo
106018   lookup yielded: 1
106018   search_open: mysql "NULL"
106018     cached open
106018   search_find: file="NULL"
106018     key="SELECT COUNT(*) from mail where username = 
'torsten@???' AND password = 'qwertzui' AND password != ''" 
partial=-1 affix=NULL starflags=0 opts=NULL
106018   LRU list:
106018   internal_search_find: file="NULL"
106018     type=mysql key="SELECT COUNT(*) from mail where username = 
'torsten@???' AND password = 'qwertzui' AND password != ''" 
opts=NULL
106018   database lookup required for SELECT COUNT(*) from mail where 
username = 'torsten@???' AND password = 'qwertzui' AND password 
!= ''
106018   MySQL query: "SELECT COUNT(*) from mail where username = 
'torsten@???' AND password = 'qwertzui' AND password != ''" 
opts 'NULL'
106018   MYSQL using cached connection for localhost/popaccounts/mailadm
106018   lookup yielded: 0
106018 expanded string:
106018 SMTP>> 535 Incorrect authentication data