LiveCycle ES: how to reset the administrator password for the LC server

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.

VN:F [1.9.22_1171]
Was this helpful? Please rate the content.
Rating: 10.0/10 (2 votes cast)
LiveCycle ES: how to reset the administrator password for the LC server, 10.0 out of 10 based on 2 ratings

Comments are closed.