Log in issue after sonarqube:9.9-developer image upgrade

SonarQube 9.9 LTS Upgrade
1

Make sure to tell us:

  • What version are you upgrading from?
    9.6.1-developer image
  • System information (Operating system, Java version, Database provider/version)
    OS: Linux, Java version: 16, DB version: Azure SQL
  • What’s the issue you’re facing?
    Log in issue(intermittent) after sonarqube:9.9-developer image upgrade. Log in page just redirects back to the log in page after providing the correct credentials.
2

Hi,

There’s not a lot to go on here.

Have you checked your server logs to see if there are any errors when these looping redirects happen?

What’s your auth system?

What shows up in the user’s browser console when this happens? Anything?

 
Ann

3

Hi Ann,

Thanks for the reply.
Have you checked your [server logs] to see if there are any errors when these looping redirects happen?
We did not see anything on the logs.

What’s your auth system?
Its a default basic auth type.

What shows up in the user’s browser console when this happens? Anything?
After providing credentials and hitting enter, it again redirects back to the login page. Sometimes, it redirects to …/sonarqube/projects page but still not logged in.

4

Hi,

Does that mean you’re using SonarQube’s built-in authentication?

With redirects, it sounds like there’s SAML involved…?

 
Ann

5

Yes, Sonarqube built-in authentication.
Attaching few screenshots here:

image
image1218×470 14.4 KB

After I enter the credentials and hit enter, this is how it looks:

image
image1876×468 44.6 KB

As you can see on the right top corner(red mark), it is still not logged in.

6

Hi,

You should increase your server logging level to DEBUG and try logging in again. More than likely this is just a bad password. It’s possible that case is playing a role here.

Note that a global admin can reset a locally-maintained user’s password.

 
HTH,
Ann

7

Hi,

I have a global admin access and I’m sure that the password is right. If its wrong, it’ll be shown like this:
image

I’ll set the logging level to DEBUG and update you soon.

8

Hi,

I’ve set the below config in the SonarQube deployment yaml and tried:
image

Still not able to log in. Any other suggestions, please.

9

Hi,

With the system logging at debug, I’m interested in what shows up in your server logs when you try to log in.

 
Ann

10

Attaching sonar.log
sonar.log (3.1 KB)

11

Hi,

Did you read the log? If so, what did you make of this?

2023.05.03 14:18:44 WARN  app[][startup] ####################################################################################################################
2023.05.03 14:18:44 WARN  app[][startup] Default Administrator credentials are still being used. Make sure to change the password or deactivate the account.
2023.05.03 14:18:44 WARN  app[][startup] ####################################################################################################################

 
Ann

12

Hi Ann,

Yes, as per the log default credentials are in use. I’m using the default credentials to login but not able to login. To change the password I need to login to that dashboard first.
Is there any other way to do that?

13

Hi,

Okay, so the default credentials (admin/admin) were in use when the instance started up. If you weren’t able to log in with them, then there’s likely something between you & SonarQube (e.g. a proxy) interfering with the traffic.

 
HTH,
Ann

14

Hi Ann,

There is no proxy because we are able to see all the project information on the Sonar dashboard but not able to login with default credentials.

Thanks,
Sharanya K

15

Hi Sharanya,

That’s unrelated. There may still be a proxy in between.

Nonetheless, I suggest you try reinstating the default credentials and go from there.

 
HTH,
Ann

16

We tried resetting the password in the database, seeing the same result. After login page, we able to see the dashboard like before but still not logged in.

17

Hi,

You should make sure you’re accepting cookies. After that, I’m out of ideas.

 
Ann

18

Hi Ann,

We created another Sonarqube instance and tried logging in, it worked. I was able to login and reset the password. But it is intermediate, now I’m not able to login.

Is it okay if we rollback to the older version(9.6.1-developer image)?
Is there a way for you to create a ticket internally and assign an engineer on this please?

19

Hi,

You would need a DB backup from 9.6.1 (or any earlier version) to downgrade.

This cause is going to be external to SonarQube. You should talk to your network folks, look at your cookies and maybe even use something like Wireshark to trace the network traffic. But as I said earlier, I’m out of guesses.

 
Ann

20

Hi,

Sure, thanks for the help.

Can you please help us with the database downgrade steps?