#1195 Time for a password reset
Closed: Fixed None Opened 15 years ago by mmcgrath.

We need to do a password reset. We don't have this documented yet and if the code exists to automate it, i'm not aware of it. So here's what I propose:

select username from people where password_changed < '2008-11-09';

Email all of those people.

Wait a week. Re run that command and email again.

Wait a week. Re-run that command and email again.

Set anyone who has not changed their password to inactive. Toshio, Ricky, any thoughts?


Changing the query to run:

select count(username) from people where password_changed < '2008-11-09' and status='active';

I ran:

update people set status='inactive' where password_changed < '2008-11-09' and status='active';

delete from person_roles where role_status='unapproved' and person_id in(select id from people where status='inactive');

The new version of fas should also start taking in to account the inactive users.

Login to comment on this ticket.

Metadata