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 '^$|^.*#' ¯\_(ツ)_/¯ :-)
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 <http://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(a)exim4u.org To unsubscribe send an email tousers-leave(a)exim4u.org
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(a)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(a)exim4u.org To unsubscribe send an email to users-leave(a)exim4u.org
_______________________________________________ users mailing list -- users(a)exim4u.org To unsubscribe send an email to users-leave(a)exim4u.org
-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
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(a)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 <http://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(a)exim4u.org To unsubscribe send an email tousers-leave(a)exim4u.org
_______________________________________________ users mailing list -- users(a)exim4u.org To unsubscribe send an email to users-leave(a)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(a)exim4u.org To unsubscribe send an email tousers-leave(a)exim4u.org
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(a)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(a)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(a)exim4u.org To unsubscribe send an email to users-leave(a)exim4u.org
_______________________________________________ users mailing list -- users(a)exim4u.org To unsubscribe send an email to users-leave(a)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(a)exim4u.org To unsubscribe send an email to users-leave(a)exim4u.org
-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Thanks very much Odhiambo!... Gordon On 3/20/23 12:59, Odhiambo Washington wrote:
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(a)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(a)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 <http://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(a)exim4u.org To unsubscribe send an email tousers-leave(a)exim4u.org
_______________________________________________ users mailing list -- users(a)exim4u.org To unsubscribe send an email to users-leave(a)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(a)exim4u.org To unsubscribe send an email tousers-leave(a)exim4u.org
-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
On Mon, Mar 20, 2023 at 7:59 PM Odhiambo Washington <odhiambo(a)gmail.com> wrote:
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}' );}}
CORRECTED: The old solution was wrong as I mistakenly used ) instead of } at the end of acl_m_greyident. 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}' );}} -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
Hi Odhiambo, Thanks for the update and letting us know! Gordon On 3/24/23 05:43, Odhiambo Washington wrote:
On Mon, Mar 20, 2023 at 7:59 PM Odhiambo Washington <odhiambo(a)gmail.com> wrote:
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}' );}}
CORRECTED: The old solution was wrong as I mistakenly used ) instead of } at the end of acl_m_greyident.
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}' );}}
-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
_______________________________________________ users mailing list --users(a)exim4u.org To unsubscribe send an email tousers-leave(a)exim4u.org
participants (3)
-
Gordon Dickens -
Gordon Dickens -
Odhiambo Washington