![]() It worked like a charm on my sonarqube instance version 8.9. (select uuid from users where login='mylogin'), If you've deleted admin and subsequently locked out the other users with global administrative permissions, you'll need to re-grant admin to a user with the following query: INSERT INTO user_roles(uuid, user_uuid, role) If you changed and then lost the admin password, you can reset it using the following query: 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' The official documentation when writing this answer currently states: Reinstating Admin Access How to generate sonarqube password hash ? private static final class Sha1Function implements HashFunction AuthenticationResult checkCredentials(UserDto user, String password) ") Do not forget to change password after successful login.Specifically, I instructed Retrospect to do a 'full restore' of the main disk partition. This time, I did not use the Retrospect 'disaster recovery CD.' Instead, I used Retrospect client and server software while Windows 7 was running. Go to SonarQube in your browser and try to login using credentials admin/admin I had been backing up with Retrospect on this computer, so I decided to use Retrospect to do the roll-back.Update users set crypted_password = '$2a$12$uCkkXmhW5ThVK8mpBvnXOOJRLd64LJeHTeCkSuB3lfaR2N0AYBaSi', salt=null, hash_method='BCRYPT' where login = 'admin' On documentation page in section Reinstating Admin Access you'll find query which allows you from database level reset admin user password to default password which is simply admin.Mysql -uSONARQUBE_USER -p -D bitnami_sonarqube In DATABASE section I found properties and which were in my case mysql credentials as plain text. ![]() In my case it was located at /opt/bitnami/apps/sonarqube/sonarqube/conf/ Here's list of steps that I took to reset admin password. In my case I do not have admin password and no database password. I would like to share the way how I recovered admin user password for Bitnami SonarQube hosted on AWS EC2 but I think it will be as well valid for any other cases.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |