Sonarqube unable to connect with cockroachdb

SonarQube
1

Must-share information (formatted with Markdown):

  • which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension)
    sonarqube: sonarqube:7.1

  • what are you trying to achieve
    I am trying to deploy sonarqube on kubernetes GCP with cockroach db database.

  • what have you tried so far to achieve this
    I have tried sonarqube with postgress db and it’s working fine. But i am not able to connect it with cockroach db.
    I am using below JDBC for cockroach db.

          env:
          - name: "SONARQUBE_JDBC_USERNAME"
            value: "sonarqube" 
          - name: "SONARQUBE_JDBC_URL"
            value: "jdbc:postgresql://cockroach-ip:26257/sonarqube?sslmode=require"
          - name: "SONARQUBE_JDBC_PASSWORD"
            value: "mypassword"

Error i am getting :

java.lang.IllegalStateException: Can not connect to database. Please check connectivity and settings (see the properties prefixed by 'sonar.jdbc.'). at org.sonar.db.DefaultDatabase.checkConnection(DefaultDatabase.java:108)
2

Hi,

We don’t support that DB, so among other things, we don’t include the driver in the distribution…

Also, 7.1 has some age on it at this point. The current LTS is 7.9.2 and the current version is 8.2. And with 8.2 we add official Docker images, so you probably want to go ahead & upgrade.

 
HTH,
Ann