FYI : How to reset the administrator password for the LC server

Avatar

Avatar

Mrsunilg-3z0lTX

Avatar

Mrsunilg-3z0lTX

Mrsunilg-3z0lTX

20-02-2012

Issue

If you wish to change the administrator’s password for the LiveCycle server you must do it manually in the database.

Reason

The administrator’s password is the only password stored in the database table EDCPrincipalLocalAccountEntity.

Solution

To select the correct record run this query:

SELECT uidstring, password, salt
FROM adobe.edcprincipallocalaccountentity A, adobe.edcprincipaluserentity B
WHERE A.refuserprincipalid = b.id AND b.uidstring = ‘administrator’;

The values in the salt and password field together constitute the password for the administrator account. On a sample installation where the password for the administrator account was “password” the password field was set to:

TXScDjEEQCzWccUMUdf8wijx/hE=

and the salt field was set to:

JNIBnmos3d0WE9W8oquFIQ==

To reset your password to “password” run this update command to update the two fields in the EDCPrincipalLocalAccountEntity table with the above values and you should be able to login.

UPDATE adobe.edcprincipallocalaccountentity, adobe.edcprincipaluserentity
SET password = ‘TXScDjEEQCzWccUMUdf8wijx/hE=’, salt = ‘JNIBnmos3d0WE9W8oquFIQ==’
WHERE adobe.edcprincipallocalaccountentity.refuserprincipalid = adobe.edcprincipaluserentity.id
AND adobe.edcprincipaluserentity.uidstring = ‘administrator’;

You may have to restart the application server for these changes to take affect.

Additional Information

This solution has been verified on a MySQL database with LiveCycle ES 8.0.  The database schema for later versions of LiveCycle ES (8.2.1, 9, 10 etc…), and for other Database types (Oracle, SQL Server) may differ, and may require modifications to the above SQL statements.

In some databases the “edcprincipallocalaccountentity” table does not exist, but is represented by the “edcprincipallocalaccount” table. The information in this technote is provided as-is and should be tested before applying it to a production database.  Performing a full backup of the database before applying any changes is recommended.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Mrsunilg-3z0lTX

Avatar

Mrsunilg-3z0lTX

Mrsunilg-3z0lTX

23-03-2012

i could reset.

but when  account is locked then wait for some time. it will unlock automatically. above solution is if you have forgotten password. then use above method to reset password to "password"

Regards

Sunil

Answers (0)