Project

General

Profile

Enhancement #770

redmine_dc: delete spam accounts

Added by Pierre-Louis Bonicoli about 1 month ago.

Status:
Resolved
Priority:
Normal
Category:
Service :: Web
Start date:
2022-04-20
Due date:
% Done:

100%

Estimated time:
1:00 h
Patch Available:
Confirmed:
Yes
Branch:
Entity:
DuckCorp
Security:
Help Needed:
No

Description

I deleted some redmine accounts (from the redmine DuckCorp instance only), for example those listed by this command:

wget https://www.stopforumspam.com/downloads/listed_email_365.gz
gunzip listed_email_365.gz
mysql redmine_dc -B -N -s -e "select user_id, address from email_addresses inner join users where email_addresses.user_id = users.id;" | gawk '$1 !~ /^[0-9]+$/{ a[$1] = ""} $2 in a { print $1 " " $2 }' listed_email_365 | wc -l

I also deleted some (3) locked accounts and almost all inactivated accounts.

Also available in: Atom PDF