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 = tors...@elbe-land.de
106018 $auth3 = qwertzui
106018 $1 =
106018 $2 = tors...@elbe-land.de
106018 $3 = qwertzui
106018 search_open: mysql "NULL"
106018 search_find: file="NULL"
106018 key="SELECT COUNT(*) from mail where concat(username , '@',
punycode) = 'tors...@elbe-land.de' 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) = 'tors...@elbe-land.de' AND password =
'qwertzui' AND password != ''" opts=NULL
106018 database lookup required for SELECT COUNT(*) from mail where
concat(username , '@', punycode) = 'tors...@elbe-land.de' AND password =
'qwertzui' AND password != ''
106018 MySQL query: "SELECT COUNT(*) from mail where concat(username ,
'@', punycode) = 'tors...@elbe-land.de' 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 =
'tors...@elbe-land.de' 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 =
'tors...@elbe-land.de' AND password = 'qwertzui' AND password != ''"
opts=NULL
106018 database lookup required for SELECT COUNT(*) from mail where
username = 'tors...@elbe-land.de' AND password = 'qwertzui' AND password
!= ''
106018 MySQL query: "SELECT COUNT(*) from mail where username =
'tors...@elbe-land.de' 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
--
## 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/
