In rare situations, it’s possible to become locked out of your administrator account in Cerb. For example, if you authenticate against an LDAP server that becomes unavailable then you won’t be able to log in.
In this situation, you can recover your administrator account by switching back to password authentication directly from the database.
Connect to your database from the console or a tool like phpMyAdmin.
Find your administrator’s worker ID:
SELECT id, CONCAT_WS_(' ',first_name,last_name) AS name, auth_extension_id FROM worker;
Let’s assume your ID is
Change back to password authentication for your account:
UPDATE worker SET auth_extension_id='login.password' WHERE id = 123;
You can also reset your password if needed (replace
s3cr3t below with your new password):
UPDATE worker_auth_hash SET pass_hash = SHA1(CONCAT(pass_salt,MD5('s3cr3t'))) WHERE worker_id = 123;
You then need to clear the server-side cache.
If you use Cerb Cloud, contact us to resolve this issue for you.