SQ Server - admin login stopped working -

SonarQube
1

A while back, I set up a SonarQube instance from AWS marketplace by Bitnami - Debian 5-10, SQ 9.9, Postgres 15.2
It was working for months, a couple weeks ago, it started stating that the admin password no longer worked.
According to these docs

the following query should fix

update users set crypted_password=‘100000$t2h8AtNs1AlCHuLobDjHQTn9XppwTIx88UjqUm4s8RsfTuXQHSd/fpFexAnewwPsO6jGFQUv/24DnO55hY6Xew==’, salt=‘k9x9eN127/3e/hf38iNiKwVfaVk=’, hash_method=‘PBKDF2’, reset_password=‘true’, user_local=‘true’, active=‘true’ where login=‘admin’;

When I run this, I get the following error - what am I doing wrong?

Password for user postgres:
psql (15.2)
Type “help” for help.

postgres=# update users set crypted_password=‘100000$t2h8AtNs1AlCHuLobDjHQTn9XppwTIx88UjqUm4s8RsfTuXQHSd/fpFexAnewwPsO6jGFQUv/24DnO55hY6Xew==’, salt=‘k9x9eN127/3e/hf38iNiKwVfaVk=’, hash_method=‘PBKDF2’, reset_password=‘true’, user_local=‘true’, active=‘true’ where login=‘admin’;
ERROR: relation “users” does not exist
LINE 1: update users set crypted_password='100000$t2h8AtNs1AlCHuLobD…
^

2

Hi,

Would you mind sharing why you’re using a Bitnami instance, instead of getting it straight from the source?

Regarding your question, it looks like you’re in the wrong schema…?

 
HTH,
Ann

3

BITNAMI has a preconfigured instance that includes all DB’s etc.
I thought about the schema thing, but I not great at DB, I did the following to look for schemas, but this is all it showed.
Do you know name of schema I should be looking for?

postgres=# \dn+
                                       List of schemas
  Name  |       Owner       |           Access privileges            |      Description       
--------+-------------------+----------------------------------------+------------------------
 public | pg_database_owner | pg_database_owner=UC/pg_database_owner+| standard public schema
        |                   | =U/pg_database_owner

               |
4

Hi,

Typically the schema is named something like sonar, but you’re using Bitnami because all the DB stuff is preconfigured, so you’ll probably need to ask Bitnami.

(And you can probably find the schema name in the JDBC URL in the SonarQube config file. Normally that’s located in $SONARQUBE-HOME/conf.

 
HTH,
Ann