AdminUI administrator locked out

[plummer6699]

Hi.  I created a new AEM server.  I changed the password, and changed it in OSGi.  However something has locked it and I cannot get it unlocked no matter what i do.  Without getting my server scrapped, is there another way to reset that administrator password?  Thx

[Pranay_M]

Hi @plummer6699,

The issue related to the "Administrator" account being locked is that there were multiple attempts to access the server which caused the account to lock itself.

To unlock the account, you will need to execute the below steps and execute a few queries in the database.

1. Login into the database as an admin user.

2. Now locate the Super Admin account using the following SQL: SELECT * FROM adobe.edcprincipalentity where canonicalname = ‘SuperAdmin’;

3. You should see the column countauthfailure has a number > 20 and islocked is set to 1 (locked)

4. Now you can either use the GUI to change the value or run the following SQL: UPDATE adobe.edcprincipalentity SET islocked = 0 WHERE canonicalname = ‘SuperAdmin’;

5. You should be able to log in to your Super Administrator account now.

It’s probably a good idea to create a second Super Administrator account just in case this happens again.

Thanks
Pranay

[plummer6699]

Excellent thanks.  Now....since we are just using the built-in database...... what is the db name that I am connecting to?  

[Pranay_M · Accepted solution]

Hi @plummer6699,

I assume that you have a Windows setup and a turnkey installation. If you are using the default DB(MYSQL) then the best way to fix the issue is to install the MySQL workbench and connect to a schema. The default username and password should be "adobe" and "adobe".

Once you login to the schema you can search for the table and execute the query. Incase you have some confusion, please feel free to raise a support case with us and I can help you fix the issue quickly.

Thanks

Pranay

[Pranay_M]

Hi @plummer6699,

Please let me know if you were able to resolve the issue or still facing the same problem.

Thanks
Pranay

[Pranay_M]

Hi @Khushwant_Singh,

Can you please help in marking this thread resolved.

Thanks
Pranay

[plummer6699]

it is resolved....but how do i mark it 'resolved'?  thx