[tor-bugs] #29420 [Internal Services/Service - trac]: Delete inactive users

[Tor Bug Tracker & Wiki]

#29420: Delete inactive users
----------------------------------------------+--------------------------
 Reporter:  ln5                               |          Owner:  qbi
     Type:  task                              |         Status:  assigned
 Priority:  Medium                            |      Milestone:
Component:  Internal Services/Service - trac  |        Version:
 Severity:  Normal                            |     Resolution:
 Keywords:                                    |  Actual Points:
Parent ID:                                    |         Points:
 Reviewer:                                    |        Sponsor:
----------------------------------------------+--------------------------

Comment (by arma):

 If we just delete all the users who haven't logged in in a year, we're
 going to have weird surprises, like somebody creating a new account under
 an old name and suddenly having control over "their" old tickets.

 So as a slight modification of the original idea: how about if the db
 query also checks if they have made a ticket and/or a comment, and skips
 over them if so? I bet that would still take care of most of the unused
 accounts.

 For extra credit, it might then be instructive to look at the accounts
 with only one ticket-or-comment to their credit -- I wonder how many of
 these are spammers that got through.

--
Ticket URL: <https://trac.torproject.org/projects/tor/ticket/29420#comment:2>
Tor Bug Tracker & Wiki <https://trac.torproject.org/>
The Tor Project: anonymity online