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
Hello Heiko and Evgeniy,

thanks for your answers.

Heiko, i tried your suggestion

Am 16.04.2021 um 10:04 schrieb Heiko Schlittermann via Exim-users:
>            server_condition = ${if or{\
>                {bool{{${lookup mysql {MYSQL_AUTH_GWUSERPLAIN}}} {no}{yes}}}\
>                {bool{{${lookup mysql {MYSQL_AUTH_PLAIN}}} {no}{yes}}}\
>            }}


103670 SMTP<< AUTH PLAIN AHRvcnN0ZW5AZWxiZS1sYW5kLmRlAHF3ZXJ0eg==
103670 auth input decode: '' 'torsten@???' 'qwertz'
103670 auth_plain authenticator server_condition:
103670   $auth1 =
103670   $auth2 = torsten@???
103670   $auth3 = qwertzui
103670   $1 =
103670   $2 = torsten@???
103670   $3 = qwertzui
103670   search_open: mysql "NULL"
103670   search_find: file="NULL"
103670     key="SELECT COUNT(*) from mail where concat(username , '@', 
punycode) = 'torsten@???' AND password = 'qwertzui' AND 
password != ''" partial=-1 affix=NULL starflags=0 opts=NULL
103670   LRU list:
103670   internal_search_find: file="NULL"
103670     type=mysql key="SELECT COUNT(*) from mail where 
concat(username , '@', punycode) = 'torsten@???' AND password = 
'qwertzui' AND password != ''" opts=NULL
103670   database lookup required for SELECT COUNT(*) from mail where 
concat(username , '@', punycode) = 'torsten@???' AND password = 
'qwertzui' AND password != ''
103670   MySQL query: "SELECT COUNT(*) from mail where concat(username , 
'@', punycode) = 'torsten@???' AND password = 'qwertzui' AND 
password != ''" opts 'NULL'
103670   MYSQL new connection: host=localhost port=0 socket=NULL 
database=popaccounts user=mailadm
103670   lookup yielded: 1
103670 expansion failed: unrecognised boolean value "{1" inside 
"or{...}" condition
103670 SMTP>> 435 Unable to authenticate at present


Hmm, the lookup yielded: 1, but the expansion seems to check
"{1". From where comes this { ?

Thank you
Greetings Torsten