INSERT INTO user_roles(uuid, user_uuid, role)
VALUES (‘random-uuid’,
(select uuid from users where login=‘mylogin’),
‘admin’);
As well as
update users set crypted_password=‘100000$t2h8AtNs1AlCHuLobDjHQTn9XppwTIx88UjqUm4s8RsfTuXQHSd/fpFexAnewwPsO6jGFQUv/24DnO55hY6Xew==’, salt=‘k9x9eN127/3e/hf38iNiKwVfaVk=’, hash_method=‘PBKDF2’, reset_password=‘true’, user_local=‘true’ where login=‘admin’;
Still i am not able to reset the admin password, let me correct if iam doing anything not conventional to sonar doc.
You’re supposed to sub-in your login, where it says 'mylogin'. That grants your account admin permissions and from there you should be able to do what you need to do via the UI - including re-instating the admin account (just re-add it) and then resetting its password.
The second query resets the admin account’s password to admin, but that’s not going to do any good if the account has been deactivated and not re-established yet.
Just Wanted to clear understand on the issue. Exactly what is going here , is admin user locked or just failing or user is not recognized , user delete???.
SonarQube doesn’t delete user accounts, for referential integrity reasons. Users are deactivated instead. Among other things, that blanks out their passwords & drops their group associations.