Some Users not able to login to Sonarqube URL after upgrade from 8.9 to 9.9.1

SonarQube
,
1

Must-share information (formatted with Markdown):

  • which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension)
    Remarks : SonarQube 9.9
  • how is SonarQube deployed: zip, Docker, Helm
    Remarks : Helm
  • what are you trying to achieve
    Remarks : After upgrade from 8.9 to 9.9,some users are only allowed to login into Sonarqube.And,same issue for non-prod.Not sure what changed during migration for these users.Users marked with LDAP are able to login.
  • what have you tried so far to achieve this

Do not share screenshots of logs – share the text itself (bonus points for being well-formatted)!

2

Please find below database artifacts.

First user is able to login but second user is not able to login.

sonar=> select * from users where name like '%Rajiv%';
  login   |     name     |          email          | crypted_password | salt | active |  created_at   |  updated_at   | scm_accounts | external_login | external_identit
y_provider | user_local | homepage_type | homepage_parameter | hash_method |         uuid         | external_id | last_connection_date | reset_password | last_sonarlint
_connection

------------
 radhawan | Rajiv Dhawan | Rajiv.Dhawan@davita.com |                  |      | t      | 1674582678009 | 1687413898147 |              | radhawan       | LDAP_default
           | f          |               |                    |             | AYXk59n5hBJzhn6Cx3Ut | radhawan    |        1687413898147 | f              |

(1 row)

sonar=> select * from users where name like '%John%';
    login    |    name     |          email          | crypted_password | salt | active |  created_at   |  updated_at   | scm_accounts | external_login | external_ident
ity_provider | user_local | homepage_type | homepage_parameter | hash_method |         uuid         | external_id | last_connection_date | reset_password | last_sonarli
nt_connection

 JOHNTHOMAS4 | John Thomas | John.Thomas4@davita.com |                  |      | t      | 1675327294493 | 1675749354488 |              | JOHNTHOMAS4    | sonarqube
             | f          |               |                    |             | AYYRScwdH2d19ShFTmVZ | JOHNTHOMAS4 |        1675749354488 | f              |

(1 row)
3

Hi,

Welcome to the community!

It looks like the user who can’t log in is a ‘native’ SonarQube user. I.e. his credentials are stored only in the SonarQube DB, rather than his auth being delegated to another system.

how is John Thomas attempting to log in? Is he clicking ‘More Options’ on the login page to get to the native login page?

 
Ann