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.
