Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.For some unknown reasons, we experience a lot of fake registration in our newsletter:
http://www.reuniting.info/newsletter
Some crazy spammer robot keeps submitting fake emails for registration. Of course, those subscriptions are never confirmed, so no newsletter is ever sent to those fake emails.
I am happy to leave those useless emails in the table {sn_subscription} for now.
Our problem is that watching the watchdog logs, it's impossible to tell appart the fake subscriptions from the bona fide ones.
This patch removes the watchdog entry when an email is entered in the database, and adds one when the subscription is confirmed by the user.
This way, looking at the logs, we can know who confirmed their subscription to which newsletter (and we can welcome them with a complimentary newsletter).
| Comment | File | Size | Author |
|---|---|---|---|
| #1 | sn_spam_registration2.diff.txt | 2.38 KB | beginner |
| sn_spam_registration.diff.txt | 1.53 KB | beginner |
Comments
Comment #1
beginner commentedThis patch adds a similar watchdog entry when a user unsubscribes from a newsletter (but not necessarily removed for the DB altogether, yet).
Comment #2
beginner commentedSimplenews could also use the email_verify module, to cut down on spam registration:
http://drupal.org/project/email_verify
Comment #3
sutharsan commentedAdding a captcha is an other option.