honeypot module - SQL issue resulting from underscores (?)

Created on 16 October 2022, almost 2 years ago
Updated 22 January 2023, over 1 year ago

Honeypot is a pretty simple module, that just pretends to submit contact submissions when a fake field is filled out by a bot. It also logs the 'blocked submission'. Autoban can and does work with honeypot since it's just pulling from the activity log, but I think there is a slight bug in the SQL query construction to pull from the message logs, particularly as it relates to underscores in the message.

For instance, the auto suggested 'log analyze' rule looks like this:
Type: honeypot
Message: Blocked submission of contact_message_feedback_form due to submission of a value in the honeypot field.

That suggested rule doesn't work, but I kept messing around with the wildcard option and variations of the message string and determined that the contact_message_feedback_form portion of the message is most likely what is failing the SQL query for the IP's to ban.

So, something like this works:
Type: honeypot
Message: Blocked submission of %

I think more precisely, it's caused by the underscores. I attempted to wrap them with brackets after googling SQL LIKE underscore syntax stuff, but I wasn't able to make any headway. Maybe I don't quite understand the syntax.

πŸ› Bug report
Status

Active

Version

1.7

Component

Code

Created by

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.71.5 2024