AdminUI administrator locked out | Community
Skip to main content
P
plummer6699
Level 2
April 3, 2025
Solved

AdminUI administrator locked out

  • April 3, 2025
  • 1 reply
  • 689 views

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

Best answer by Pranay_M

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

1 reply

P
Adobe Employee
Pranay_MAdobe Employee
Adobe Employee
April 4, 2025

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

    P
    plummer6699Author
    Level 2
    April 7, 2025

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

    P
    Adobe Employee
    Pranay_MAdobe Employee
    Adobe Employee
    April 16, 2025

    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


    Hi @plummer6699,

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

    Thanks
    Pranay

    Terms & ConditionsAccessibility statement

    Loading footer...