Enhancement #770
redmine_dc: delete spam accounts
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.