Unlocking all the users

Sometimes, you can see the need of unlock all the users at once, or some of them at once.

An example of a use case would be User management error after activation of SAML or Immediate Logout After Login Issue.

If it's the case, you can sort it with a single command in the database:

update users set account_expired = false, password_expired = false, account_locked = false, auth_failed_count = 0 where username <> 'system';

You can launch it with:

sudo su postgres
psql
\c iriusprod
update users set account_expired = false, password_expired = false, account_locked = false, auth_failed_count = 0 where username <> 'system';

Or with:

sudo -u postgres psql -d iriusprod --command "update users set account_expired = false, password_expired = false, account_locked = false, auth_failed_count = 0 where username <> 'system';" 2> /dev/null