Admin password in default authentication - Alfresco Content Services - 23.4 - 23.4 - Ready - Alfresco - external

SELECT anp1.node_id,
        anp1.qname_id,
        anp1.string_value
 FROM alf_node_properties anp1
    INNERJOIN alf_qname aq1 ON aq1.id = anp1.qname_id
    INNERJOIN alf_node_properties anp2 ON anp2.node_id = anp1.node_id
    INNERJOIN alf_qname aq2 ON aq2.id = anp2.qname_id
 WHERE aq1.local_name = '**hashIndicator**'
 AND aq2.local_name = 'username'
 AND anp2.string_value = 'admin';

The output shows the current password encoding being used.

 +---------+----------+--------------+
 | node_id | qname_id | string_value |
 +---------+----------+--------------+
 |       4 |       94 | **bcrypt10**   |
 +---------+----------+--------------+
 1 row in set (0.01 sec)

If no rows are returned, set the password using the instructions shown above (md4 encoding).

If a row is returned, encode the password using the result of the query, which can either be md4 or sha256 or bcrypt10 encoding.

Run the following query to find the identifying parameters for how the Admin password is stored.

SELECT anp1.node_id,
        anp1.qname_id,
        anp1.string_value
 FROM alf_node_properties anp1
    INNERJOIN alf_qname aq1 ON aq1.id = anp1.qname_id
    INNERJOIN alf_node_properties anp2 ON anp2.node_id = anp1.node_id
    INNERJOIN alf_qname aq2 ON aq2.id = anp2.qname_id
 WHERE aq1.local_name = '**passwordHash**'
 AND aq2.local_name = 'username'
 AND anp2.string_value = 'admin';

The output shows the current hashed password for the Admin user. Here’s an example output:

 +---------+----------+--------------------------------------------------------------+
 | node_id | qname_id | string_value                                                 |
 +---------+----------+--------------------------------------------------------------+
 |       4 |       93 |**$2a$10$dq/2zNUA.MmECYipl1WMoOyGHYbaygh23PUa3Ox5xDHH7Z0guqF42**|
 +---------+----------+--------------------------------------------------------------+
 1 row in set (0.00 sec)

UPDATE alf_node_properties
  SET string_value='209c6174da490caeb422f3fa5a7ae634'
  WHERE
  node_id=THENODEIDABOVE
  and
  qname_id=THEQNAMEVALUEABOVE

Replace THENODEIDABOVE and THEQNAMEVALUEABOVE with the result values of node_id and qname_id, obtained in the previous step. In this example, it is 4 and 93, respectively.