Duplicated users and paging not working in user list with LDAP connectivity

[mtellerd (Miguel Telleria)]

In an “accidental” (see below) upgrade of sonarqube LTS from 8.9.6 to 8.9.8…

… we see duplicated users displayed twice and paging (clicking in More) not working. We use LDAP integration which works ok recognizing credentials.

The symptoms are similar to the ones reported in Duplicated users in list.

STEPS TO REPRODUCE

1. After a not desired non-LTS upgrade (to version 9.x) the sonarqube-8.9.8.54436 was installed in the filesystem.

2. An LDAP link was introduced in the configuration of sonar.properties

   ldap.url=ldap://:389
   ldap.authentication=simple
   ldap.user.baseDn=dc=people,dc=contacts,dc=ldap,dc=department,dc=company,dc=com
   ldap.user.request=(&(objectClass=inetOrgPerson)(uid={login}))
   ldap.group.baseDn=dc=sso,dc=apps,dc=ldap,dc=department,dc=company,dc=com
   ldap.group.request=(&(objectClass=groupOfUniqueNames)(uniqueMember={dn}))

3. The (Oracle) database schema was wiped out hoping that a restart will recreate the tables.

4. systemctl restart sonarqube8

5. Go to web UI. Enter default admin password, etc

6. Log in the web UI with an LDAP user that belongs to the LDAP grooup sonar_administrators

7. The database schema was wiped out hoping that a restart will recreate the tables.

8. Got to Administration → Security → Users

EXPECTED RESULT:

The whole list of 14 users should appear and using “More” should display the different list of users

ACTUAL RESULT:

• Users are shown twice (with same data including last login time).
• Paging “More” is shown but clicking there has no effect

EXTRA INFO

Attached:

• Ajax call for list of users
• System info

sonarqube_ajax_user_request.json (3.6 KB)
sonarqube_system_info_pp.json (25.1 KB)

[Colin]

Hey there.

Try deleting the data/es7 folder of your SonarQube instance and restarting the service (entirely).

[mtellerd (Miguel Telleria)]

thanks a lot Colin, the problem is solved with your tip.

So all that was needed was removing the ElasticSearch index and have it recreated automatically on restart.

thanks again,
Miguel