Hi All,
We have migrated database from one DB server to another DB sever, using full export and import, now we are not able login to RSA via UI by AveksaAdmin.
Hi All,
We have migrated database from one DB server to another DB sever, using full export and import, now we are not able login to RSA via UI by AveksaAdmin.
You can check the password hash by running the following query, if you have another instance where you know the password you can also update it to see if that fixes it.
select value from avuser.t_system_settings where Parameter='SuperAdminPassword';
Can you try running these statements in the database:
UPDATE T_SYSTEM_SETTINGS SET VALUE='McMgxna6CptJbkUnw+r8vg==' WHERE PARAMETER='SuperAdminPassword';
UPDATE T_SYSTEM_SETTINGS SET VALUE='TRUE' WHERE PARAMETER='IsFirstLoginForSuperAdmin';
Commit;
This should reset the password to the original default value and require a password change on login.
Are other users able to login to the system?
Can you try running these statements in the database:
UPDATE T_SYSTEM_SETTINGS SET VALUE='McMgxna6CptJbkUnw+r8vg==' WHERE PARAMETER='SuperAdminPassword';
UPDATE T_SYSTEM_SETTINGS SET VALUE='TRUE' WHERE PARAMETER='IsFirstLoginForSuperAdmin';
Commit;
This should reset the password to the original default value and require a password change on login.
Are other users able to login to the system?