Release announcements, helpful tips, and community discussion

Tip: Recover your administrator account

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 123.

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.