Error - while encrypting the jdbc password in sonarqube 4.3.3

Question

I followed the below link (http://docs.sonarqube.org/display/SONAR/Settings+Encryption ) and try to encrypt the sonar jdbc password and I set the password and key path in maven project as below

<sonar.jdbc.url>jdbc:h2:tcp://localhost:9093/sonar</sonar.jdbc.url><sonar.jdbc.username>sonar</sonar.jdbc.username>
<sonar.jdbc.password>{aes}LUc8lslPKL7YBxBSobm3XA==</sonar.jdbc.password>
<sonar.secretKeyPath>/apps1/Sonar/Sonar secret.txt</sonar.secretKeyPath>

But while building the project i'm getting the below issues.

" Fail to decrypt the property sonar.jdbc.password. Please check your secret key. The property sonar.secretKeyPath does not link to a valid file"

I'm using Linux in which SonarQube 4.3.3 has been installed and I'm running the maven project in windows.

Please help me to solve the issues.

`/apps1/Sonar/Sonar secret.txt` : is this a path on the SonarQube server or on the client where you run the Scanner for Maven ? — Nicolas B., Mar 17 '16 at 12:08
/apps1/Sonar/Sonar secret.txt is the path of the sonarqube server — sangeetha kannan, Mar 17 '16 at 12:22

score 1 · Accepted Answer · edited Jun 20 '20 at 09:12

1

The secret key must be copied wherever you use encrypted properties. Here you're using encryption on the scanner side, so you must first copy the key on that machine and set sonar.secretKeyPath accordingly. As per Settings Encryption documentation:

To use an encrypted value on the scanner side,

Copy the secret key file to the machine running the analysis

Use the encrypted values where needed

Configure the scanner with the location of the secret key file.

edited Jun 20 '20 at 09:12

Community

1
1

answered Mar 17 '16 at 13:36

Nicolas B.

7,245
17
29

Thank you for your reply. Now it's working for me - Sangeetha – sangeetha kannan Mar 21 '16 at 07:28

Error - while encrypting the jdbc password in sonarqube 4.3.3

1 Answers1