Hi Gordon et al,

Here is the solution:

warn ��condition = ${if eq {$acl_m_greyexpiry}{} {1}}
�� set acl_m_dontcare = ${lookup sqlite {INSERT INTO greylist \
�� VALUES ( '${quote_sqlite:$acl_m_greyident)', \
�� '${eval10:$tod_epoch+300}', \
�� '${quote_sqlite:$sender_host_address}', \
�� '${quote_sqlite:$sender_helo_name}' );}}

On Fri, Mar 3, 2023 at 8:02��PM Gordon Dickens <gordon@dickens.com> wrote:

Hi Odhiambo,

That looks good, however, to be honest, I'm not sure if that will solve the entire problem or not.�� I have not yet installed exim 4.96 and so I haven't had any reason to test/try this issue.�� When I get around to installing 4.96 then I will be most interested in what you ended up doing!

I suggest that you pose this question on the Exim users mailing list and you will probably get assistance quickly.�� Hopefully, Jeremy will chime in.

FYI,

Gordon

On 3/2/23 05:25, Odhiambo Washington wrote:
Hi Gordon,

Thanks for the response.

So is it the sender_host_address that needs to be quoted?

��warn ��condition = ${if eq {$acl_m_greyexpiry}{} {1}}
�� set acl_m_dontcare = ${lookup sqlite {INSERT INTO greylist \
�� VALUES ( '$acl_m_greyident', \
�� '${eval10:$tod_epoch+300}', \
�� '${quote_sqlite:sender_host_address}', \
�� '${quote_sqlite:$sender_helo_name}' );}}
On Thu, Mar 2, 2023 at 1:55��AM Gordon Dickens <gecko@exim4u.org> wrote:
Hi Odhiambo,

Sorry for taking so long to reply but I have been away on holiday for the past two weeks.��

I have not yet installed Exim 4.96, however, I found a solution in the following thread:

https://lists.exim.org/lurker/message/20220501.095853.5f017b3c.en.html

FYI,

Gordon

On 2/17/23 06:37, Odhiambo Washington wrote:
Hello everyone,

Happy 2023!

I have encountered��this on my mainlog today and wondering if anyone else has seen it with Exim 4.96 and has a solution.

2023-02-17 00:37:20 1pSlw1-0001PT-02 tainted search query is not properly quoted (ACL warn, /etc/exim/exim-greylist.conf.inc 124): INSERT INTO greylist VALUES ( 'adxz8uCZUAwum6TLfg4b', '1676583740', '40.107.237.54', 'NAM12-BN8-obe.outbound.protection.outlook.com' );

--

Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.",��egrep -v '^$|^.*#'��\_(��)_/��:-)
_______________________________________________
users mailing list -- users@exim4u.org
To unsubscribe send an email to users-leave@exim4u.org
_______________________________________________
users mailing list -- users@exim4u.org
To unsubscribe send an email to users-leave@exim4u.org
--

Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.",��egrep -v '^$|^.*#'��\_(��)_/��:-)
_______________________________________________
users mailing list -- users@exim4u.org
To unsubscribe send an email to users-leave@exim4u.org

Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.",��egrep -v '^$|^.*#'��\_(��)_/��:-)