I'm having quoting issues and can't see what I'm doing wrong here.
Here's the rule (commented, but when uncommented I get the error below)
# deny message = ${extract{message} {\
# ${lookup pgsql{select deny_address,message
from \
# blacklist_address where \
# '${quote_pgsql:$h_From:}' ilike deny_address
\
# }}}}
# log_message = BLACKLIST_ADDR ${extract{message} {\
# ${lookup pgsql{select deny_address,message
from \
# blacklist_address where \
# '${quote_pgsql:$h_From:}' ilike deny_address
\
# }}}}
# condition = ${lookup pgsql{select 1 as truth from
blacklist_address where \
#
'${quote_pgsql:${sg{$h_From:}{.*(<.*>).*}{\$1}}}' ilike
deny_address}{$value}}
[1\66] 1rOjXw-00000000OOZ-0f3u H=malur.postgresql.org
[217.196.149.56]:36880 I=[192.147.25.65]:25 X=TLS1.3:TLS_
AES_256_GCM_SHA384:256 CV=yes DN="/CN=lists.postgresql.org"
F=<pgsql-committers-owner+m2386-532...@lists.postgresql.org> temporarily
rejected after DATA: PGSQL: query failed: ERROR: unterm
inated quoted string at or near "'<t...@sss.pgh.pa.us>'' ilike
deny_address{"
The From: line is:
[47\66] F From: Tom Lane <t...@sss.pgh.pa.us>
What am I missing here?
exim 4.97.1 (FreeBSD), PostgreSQL 15.5
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: l...@lerctr.org
US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106
--
## subscription configuration (requires account):
## https://lists.exim.org/mailman3/postorius/lists/exim-users.lists.exim.org/
## unsubscribe (doesn't require an account):
## exim-users-unsubscr...@lists.exim.org
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/
