При дебаге вот это интересно на мой взгляд.
Почему "query was not one that returns data"?
На 4.89 все устраивает.

14:55:46 66397 type=mysql key="UPDATE whitelist set date=now() where sender_ip='185.128.235.25' limit 1;" 14:55:46 66397 database lookup required for UPDATE whitelist set date=now() where sender_ip='185.128.235.25' limit 1; 14:55:46 66397 MySQL query: UPDATE whitelist set date=now() where sender_ip='185.128.235.25' limit 1;
14:55:46 66397 MYSQL using cached connection for (/tmp/mysql.sock)/exim/exim
14:55:46 66397 MYSQL: query was not one that returns data
14:55:46 66397 lookup forced cache cleanup
14:55:46 66397 lookup yielded: 1
14:55:46 66397 ├──expanding: ${lookup mysql{UPDATE whitelist set date=now() where sender_ip='${quote_mysql:$sender_host_address}' limit 1;}}
14:55:46 66397  └─────result: 1
14:55:46 66397 check condition = ${lookup mysql{UPDATE whitelist set date=now() where sender_ip='${quote_mysql:$sender_host_address}' limit 1;}}
14:55:46 66397                 = 1
14:55:46 66397 check set acl_m_white = 1



12.01.2018 9:51, Mikhail Golub пишет:
Спасибо.

Добавил. Долго ждать не пришлось.

WHITELIST = UPDATE whitelist set date=now() where sender_ip='${quote_mysql:$sender_host_address}' limit 1;

warn set acl_m_sq = ${lookup mysql{WHITELIST}}
      logwrite = sq:<$acl_m_sq>
      condition = ${if eq{${substr_0_1:$acl_m_sq}}{1}}
      set acl_m_white = 1

2018-01-12 09:47:20 sq:<1▒)\004\b>
2018-01-12 09:48:43 sq:<0rator.ua)(|(&(!(userAccountControl:1.2.840.113556.1.4.803:=2))(msExchRecipientTypeDetails=1))(msExchRecipientTypeDetails=4))(objectclass=user))>
2018-01-12 09:48:44 sq:<0WHERE relay_ip = '185.128.235.25'>

Баг?
Баг.


11.01.2018 21:16, l...@lena.kiev.ua пишет:
warn condition = ${lookup mysql{GOOD_SENDER}}
      set acl_m_white = 1

И как отловить эти глюки в 4.90 даже мыслей пока нет.

Заменить на:

  warn set acl_m_sq = ${lookup mysql{GOOD_SENDER}}
       logwrite = sq:<$acl_m_sq>
       condition = ${if eq{${substr_0_1:$acl_m_sq}}{1}}
       set acl_m_white = 1

Потом

grep 'sq:' /var/log/exim/mainlog

и если найдется какой-то мусор, то оформить новый баг на
http://bugs.exim.org
привести этот кусок ACL и вывод этого grep.

_______________________________________________
Exim-users mailing list
Exim-users@mailground.net
http://mailground.net/mailman/listinfo/exim-users



_______________________________________________
Exim-users mailing list
Exim-users@mailground.net
http://mailground.net/mailman/listinfo/exim-users



_______________________________________________
Exim-users mailing list
Exim-users@mailground.net
http://mailground.net/mailman/listinfo/exim-users

Ответить