We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

Answered - Tons of spam registration, can I delete those emails from watchdog_email_list? | Forum

Topic location: Forum home » Support » General Questions
Aditya
Aditya Jan 4 '13

I got 700,000 spam registrations on my website. Obviously, a bot attack. The captcha has been defeated. "What plugin should I use to better deal with spam registrations" is a question for another day.


Right now, I have these 700k trash emails in ow_watchdog_email_list database table. Is this table anything like Drupal's watchdog table? I suppose these emails have not confirmed their email IDs, so they have not shifted over into the legit account tables. So can I just delete the rows in these tables? Is that safe or will it affect the site in any way (will it affect any legit accounts)?


Left like this, that table may slow down my site. Thanks for your time.

The Forum post is edited by Alia Jan 8 '13
Aditya
Aditya Jan 4 '13
If the team would like, I can email this table if you're interested in building a black list or something... not sure how that would make sense though.
Aditya
Aditya Jan 4 '13
Okay, wait a second... I may have even got this backwards... is that 'watchdog' some sort of security module? Just like ow_watchdog_black_list prevents registrations from known bad IPs, is this table something that comes builtin with oxwall?
Alia Team
Alia Jan 7 '13
Aditya, Wathdog is a simple anti-spam plugin developer by us.

>>ow_watchdog_email_list database table. Is this table anything like Drupal's watchdog table

This is Wathdog plugin's table.
 ow_watchdog_email_list - here emails of spammers are saved.
 ow_watchdog_black_list - here IP addresses of spammers are saved.

Aditya
Aditya Jan 7 '13
Thanks for clarifying, Aliia :) Good day!