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: '' '[email protected]' 'qwertz'
103670 auth_plain authenticator server_condition:
103670 $auth1 =
103670 $auth2 = [email protected]
103670 $auth3 = qwertzui
103670 $1 =
103670 $2 = [email protected]
103670 $3 = qwertzui
103670 search_open: mysql "NULL"
103670 search_find: file="NULL"
103670 key="SELECT COUNT(*) from mail where concat(username , '@',
punycode) = '[email protected]' 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) = '[email protected]' AND password =
'qwertzui' AND password != ''" opts=NULL
103670 database lookup required for SELECT COUNT(*) from mail where
concat(username , '@', punycode) = '[email protected]' AND password =
'qwertzui' AND password != ''
103670 MySQL query: "SELECT COUNT(*) from mail where concat(username ,
'@', punycode) = '[email protected]' 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
--
## List details at https://lists.exim.org/mailman/listinfo/exim-users
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/
