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.