Need

An administrator may need to reset the semadmin user password in case the original password is lost or needs to be updated for security reasons outside of the Semarchy UI.


Summarized Solution

The password for the semadmin user can be reset using an SQL query to set it back to the default. Once logged in with this default password, it can be changed through the application interface.


/!\ Updating the semadmin user password via the database should be a a very last resort thing.


Detailed Solution


Prerequisites:

  • Database access required: this solution requires access to the Semarchy xDM database to execute SQL commands. Ensure you have the necessary permissions and work with a database administrator if needed.
  • Security precaution: resetting the password to a default value should be a temporary measure. Change it immediately after logging in to prevent unauthorized access.


Follow the steps below to reset the password for the semadmin user:

  1. Run the password update query: use the following SQL query to reset the semadmin user password to the default value (semadmin). This query updates the password directly in the database.

update IDM_USER set INTERNAL_IDP_PASSWORD = '{BCRYPT}$2a$10$74UDuViXPez5S3mNri7KbOWrb6tfHVbKAlQvlAfQQ.CRZTEyS8GDO' 
where USERNAME = 'semadmin';

  • Log in with the default password: after executing the query, log in to Semarchy xDM using the following credentials:

    • Username: semadmin
    • Password: semadmin

  • Update the password through the interface: once logged in, navigate to Configuration > User Management and select semadmin to update the password to a new, secure value.


Troubleshooting:

If the default password reset does not work, verify that the IDM_USER table structure is as expected and ensure there are no additional restrictions on the user account.