Dealing with unwanted signups

Added by Shane Pearlman almost 10 years ago

Wanted to bring up this topic here instead of help and get the advice of the rest of the redmine dev crew. In short, spammers are setting up accounts and we have no simple way to purge them (beyond a direct call to the db). My vote is to have a reject feature that is just a delete on any user account that has no other table association (issues ...).

Thoughts?

http://www.redmine.org/boards/2/topics/5649

Replies (3)

RE: Dealing with unwanted signups - Added by Brad Beattie almost 10 years ago

Alternatively, take a look at #1354 for Akismet support. I've put in an intial skeleton code-wise, but it needs some work. It's not a priority for me, but if it is for anyone else, that'd be a good place to start.

RE: Dealing with unwanted signups - Added by Eric Davis almost 10 years ago

This is also related to #3433.

Eric

RE: Dealing with unwanted signups - Added by Chris Miller almost 10 years ago

If you're not afraid of the command line...

First go and lock all spammer accounts. Next...

root@myserver.com# mysql -p
> SELECT login,mail,state FROM redmine.users WHERE state = 3;

This should return a list of all users you want to get rid of. READ THROUGH IT CAREFULLY! There is no way to un-do the next step:

> DELETE FROM redmine.users WHERE state = 3;
> quit;

Done, they're gone - for good.

(1-3/3)