SonarQube login doesn't work after password reset

sumukha.prasanna 2020-12-30 15:53:47 UTC #1

Keywords: SonarQube - AWS - Technical issue - Credentials
Description:
Hello,

I followed https://community.bitnami.com/t/sonarqube-app-user-admin-not-work/49652/2 to reset my password for the admin. After executing the sudo ./bnconfig command with the new password, I am unable to login to the SonarQube dashboard which is hosted on an EC2 instance from bitnami's AMI. The error is "Authentication Failed" for the right password.

Can you please suggest how to debug this issue?

Thanks,
SKP

sumukha.prasanna 2020-12-30 21:00:15 UTC #2

@jcarmona, here is the new ticket.

Ibone 2020-12-31 09:12:55 UTC #3

Hi @sumukha.prasanna,

thanks for using Bitnami, Could you check this guide to change the password?
https://docs.bitnami.com/aws/apps/sonarqube/administration/change-admin-password/

Happy new year,
Ibone.

sumukha.prasanna 2020-12-31 15:41:22 UTC #4

Hello @Ibone,

I did try the command line way from the psql database to change the password but resulting in 'id' column not found when I execute the UPDATE users command.

The UI way of changing password is not possible as the main problem is I am unable to login to the sonar UI. I am trying to route traffic to another instance but would still like to know if there is a method to resolve this issue for future problems.

Thank you and happy new year to you too,
SKP.

jota 2021-01-04 15:07:02 UTC #5

Hi @sumukha.prasanna,

We are going to work on reproducing the issue and will update this ticket as soon as we have more information.

jota 2021-01-05 12:28:27 UTC #6

Hi @sumukha.prasanna,

I reproduced the problem and will notify our documentation team to update the guide. In the meantime, you can update the password by following these steps:

Get the salt value of your user (I'm going to use "admin")

psql --username=postgres bitnami_sonarqube -c "select * from users where login='admin';"

Once you get the salt, go to this site

http://www.sha1-online.com/

and hash your password using the salt. The format is the following one

--SALT_VALUE_YOU_GOT--NEW_PASSWORD--

Get the value the website returns and run this command to update the database

psql --username=postgres bitnami_sonarqube -c "UPDATE users SET crypted_password='HASHED_PASSWORD_HERE', hash_method='SHA1' WHERE login='admin';"

Try to log in to the app again

Happy to help!

Was my answer helpful? Click on

jota 2021-01-05 12:34:41 UTC #7

UPDATE: Run these commands to update the password using the command line only

user="admin"
new_salt=$(tr -dc A-Za-z0-9 </dev/urandom | head -c 40 ; echo '')
new_password="bitnami1234"
salted_password=$(echo -n "--${new_salt}--${new_password}--" | sha1sum | awk '{print $1}')
psql --username=postgres bitnami_sonarqube -c "UPDATE users SET crypted_password='$salted_password', salt='$new_salt', hash_method='SHA1' WHERE login='$user';"

sumukha.prasanna 2021-01-05 16:32:37 UTC #8

Hello @jota,

I am logged into the EC2 instance using the session manager where the bitnami sonarqube application is running. When I execute the first command, the salt column turns out to be returning empty value. There are other columns which return the value as expected. Is this normal? and is there any other way to get the salt value of the user?

I am unable to SSH into the instance as of now to try the second method here.

Regards,
SKP

jota 2021-01-07 09:18:33 UTC #9

Hi @sumukha.prasanna,

If you are logged to the instance and can execute the command to obtain the salt from the database, you should be able to execute the commands of the last message I posted. Are you sure you SSH the instance properly?

sumukha.prasanna 2021-01-07 22:44:24 UTC #10

Hi @jota,

I am connected to the instance from AWS Session Manager. I meant the 1st command does execute but does not return the salt value of the admin. The output has other values but not the salt.

Anyways, I have created another instance and routed traffic there as this approach was taking longer.

Regards,
SKP

jota 2021-01-08 10:28:18 UTC #11

Hi @sumukha.prasanna,

Please ensure you are SSHing the instance following our guides.

https://docs.bitnami.com/aws/faq/get-started/connect-ssh/

sumukha.prasanna 2021-01-08 15:46:36 UTC #12

Hi @jota,

I am following this guide. The steps to SSH are not a problem, the Sonar instance is backed by a bastion and I have some trouble getting around that.

Thank you for the instructions, let's close this thread.

Regards,
SKP

jota 2021-01-11 10:45:49 UTC #13

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!