Sonar

Sonar fails to start if the sonar.jdbc.* properties are encrypted

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: 3.0
  • Fix Version/s: 3.0.1, 3.1
  • Component/s: Encryption
  • Labels:
    None
  • Environment:
    WinXP SP2
  • Number of attachments :
    0

Description

To reproduce the issue on Windows XP:

  1. Start a standalone version of Sonar 3.0+
  2. Generate a secret key and place the "sonar-secret.txt" file in "~/.sonar"
  3. Restart Sonar and encrypt the string "sonar"
  4. Put the encrypted string in the "sonar.properties" file, for the "sonar.jdbc.password" key
  5. Restart Sonar => it fails with the following stacktrace:
INFO   | jvm 1    | 2012/04/27 17:10:23 | org.jruby.rack.RackInitializationException: syntax error on line 4, col -1: `'
|?from file:/D:/sonar/sonar-3.0/war/sonar-server/WEB-INF/lib/jruby-complete-1.6.1.jar!/META-INF/jruby.home/lib/ruby/1.8/yaml.rb:134:in `load'
|?from D:/sonar/sonar-3.0/war/sonar-server/WEB-INF/config/../vendor/rails/railties/lib/initializer.rb:902:in `database_configuration'
|?from D:/sonar/sonar-3.0/war/sonar-server/WEB-INF/config/../vendor/rails/railties/lib/initializer.rb:437:in `initialize_database'
|?from D:/sonar/sonar-3.0/war/sonar-server/WEB-INF/config/../vendor/rails/railties/lib/initializer.rb:141:in `process'
|?from org/jruby/RubyKernel.java:2052:in `send'
|?from D:/sonar/sonar-3.0/war/sonar-server/WEB-INF/config/../vendor/rails/railties/lib/initializer.rb:113:in `run'
|?from D:/sonar/sonar-3.0/war/sonar-server/WEB-INF/config/environment.rb:23:in `(root)'
|?from org/jruby/RubyKernel.java:1063:in `load'
|?from D:/sonar/sonar-3.0/war/sonar-server/WEB-INF/config/environment.rb:53:in `load_environment'
|?from file:/D:/sonar/sonar-3.0/war/sonar-server/WEB-INF/lib/jruby-rack-1.0.0.1.jar!/jruby/rack/rails.rb:46:in `to_app'
|?from file:/D:/sonar/sonar-3.0/war/sonar-server/WEB-INF/lib/jruby-rack-1.0.0.1.jar!/jruby/rack/rails.rb:191:in `new'
|?from <script>:2:in `(root)'|?from org/jruby/RubyKernel.java:2021:in `instance_eval'
|?from file:/D:/sonar/sonar-3.0/war/sonar-server/WEB-INF/lib/jruby-rack-1.0.0.1.jar!/vendor/rack-1.2.1/rack/builder.rb:46:in `initialize'
|?from <script>:2:in `(root)'|.

Issue Links

is related to

Improvement - An improvement or enhancement to an existing feature or task. SONAR-3495 Initial exception is lost when settings can't be decrypted

  • Major - Major loss of function.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are not closed can be reopened.
relates to

New Feature - A new feature of the product, which has yet to be developed. SONAR-2084 Support for encrypted configuration

  • Major - Major loss of function.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are not closed can be reopened.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Simon Brandhof added a comment -

The issue occurs on all OS. It occurs when the properties sonar.jdbc.username, sonar.jdbc.password or sonar.jdbc.url are encrypted on server side.

Show
Simon Brandhof added a comment - The issue occurs on all OS. It occurs when the properties sonar.jdbc.username, sonar.jdbc.password or sonar.jdbc.url are encrypted on server side.
Hide
Permalink
Freddy Mallet added a comment -

Manually tested !

Show
Freddy Mallet added a comment - Manually tested !
Hide
Permalink
Simon Brandhof added a comment -

Our framework for integration tests prevents from implementing this test.

Show
Simon Brandhof added a comment - Our framework for integration tests prevents from implementing this test.
Hide
Permalink
onur bacak added a comment -

I still have the same problem with sonar version 3.0.1

did a console start: (it's a linux-x86-64 and jdk1.6.0_24_64bit)

Running sonar...
wrapper | --> Wrapper Started as Console
wrapper | Launching a JVM...
jvm 1 | Please use CMSClassUnloadingEnabled in place of CMSPermGenSweepingEnabled in the future
jvm 1 | Wrapper (Version 3.2.3) http://wrapper.tanukisoftware.org
jvm 1 | Copyright 1999-2006 Tanuki Software, Inc. All Rights Reserved.
jvm 1 |
jvm 1 | 2012-05-18 11:34:30.906:INFO::Logging to STDERR via org.mortbay.log.StdErrLog
jvm 1 | 2012-05-18 11:34:30.962:INFO::jetty-6.1.25
jvm 1 | 2012-05-18 11:34:31.261:INFO::NO JSP Support for /sonar, did not find org.apache.jasper.servlet.JspServlet
jvm 1 | 2012-05-18 11:34:33.029:WARN::Failed startup of context org.mortbay.jetty.webapp.WebAppContext@3cc70b0d

{/sonar,file:/work/sonar-3.0.1/war/sonar-server}

jvm 1 | java.lang.IllegalStateException: Fail to decrypt the property sonar.jdbc.password. Please check your secret key.
jvm 1 | at org.sonar.api.config.Settings.getString(Settings.java:83)

sonar.properties
############################################################################################
sonar.secretKeyPath=/work/sonar-3.0.1/conf/sonar-jdbc-secret.txt

            • Connection pool settings
              sonar.jdbc.username: sonar_p
              sonar.jdbc.password: {aes}

              U2FsdGVkX1+KdUDr05FSzHuSuuLhnVotSUfOC4iwyXY=
              sonar.jdbc.maxActive: 20
              sonar.jdbc.maxIdle: 5
              sonar.jdbc.minIdle: 2
              sonar.jdbc.maxWait: 5000
              sonar.jdbc.minEvictableIdleTimeMillis: 600000
              sonar.jdbc.timeBetweenEvictionRunsMillis: 30000
              ############################################################################################

ls on the dir:
/work/sonar-3.0.1/conf> ll
total 18
rw-rr- 1 root root 3050 2012-05-18 11:12 logback.xml
rw-rr- 1 root root 616 2012-05-18 11:12 Sonargraph.license
rw-rr- 1 root root 25 2012-05-18 11:25 sonar-jdbc-secret.txt
rw-rr- 1 root root 6400 2012-05-18 11:40 sonar.properties
rw-rr- 1 root root 5580 2012-05-18 11:12 wrapper.conf

or am I doing something wrong?

Show
onur bacak added a comment - I still have the same problem with sonar version 3.0.1 did a console start: (it's a linux-x86-64 and jdk1.6.0_24_64bit) Running sonar... wrapper | --> Wrapper Started as Console wrapper | Launching a JVM... jvm 1 | Please use CMSClassUnloadingEnabled in place of CMSPermGenSweepingEnabled in the future jvm 1 | Wrapper (Version 3.2.3) http://wrapper.tanukisoftware.org jvm 1 | Copyright 1999-2006 Tanuki Software, Inc. All Rights Reserved. jvm 1 | jvm 1 | 2012-05-18 11:34:30.906:INFO::Logging to STDERR via org.mortbay.log.StdErrLog jvm 1 | 2012-05-18 11:34:30.962:INFO::jetty-6.1.25 jvm 1 | 2012-05-18 11:34:31.261:INFO::NO JSP Support for /sonar, did not find org.apache.jasper.servlet.JspServlet jvm 1 | 2012-05-18 11:34:33.029:WARN::Failed startup of context org.mortbay.jetty.webapp.WebAppContext@3cc70b0d {/sonar,file:/work/sonar-3.0.1/war/sonar-server} jvm 1 | java.lang.IllegalStateException: Fail to decrypt the property sonar.jdbc.password. Please check your secret key. jvm 1 | at org.sonar.api.config.Settings.getString(Settings.java:83) sonar.properties ############################################################################################ sonar.secretKeyPath=/work/sonar-3.0.1/conf/sonar-jdbc-secret.txt Connection pool settings sonar.jdbc.username: sonar_p sonar.jdbc.password: {aes} U2FsdGVkX1+KdUDr05FSzHuSuuLhnVotSUfOC4iwyXY= sonar.jdbc.maxActive: 20 sonar.jdbc.maxIdle: 5 sonar.jdbc.minIdle: 2 sonar.jdbc.maxWait: 5000 sonar.jdbc.minEvictableIdleTimeMillis: 600000 sonar.jdbc.timeBetweenEvictionRunsMillis: 30000 ############################################################################################ ls on the dir: /work/sonar-3.0.1/conf> ll total 18 rw-r r - 1 root root 3050 2012-05-18 11:12 logback.xml rw-r r - 1 root root 616 2012-05-18 11:12 Sonargraph.license rw-r r - 1 root root 25 2012-05-18 11:25 sonar-jdbc-secret.txt rw-r r - 1 root root 6400 2012-05-18 11:40 sonar.properties rw-r r - 1 root root 5580 2012-05-18 11:12 wrapper.conf or am I doing something wrong?
Hide
Permalink
Simon Brandhof added a comment -

Unfortunately the initial error is lost (see SONAR-3495), but it seems that the location of your secret key is badly set. Please check that the property sonar.secretKeyPath is correctly defined. More details in http://docs.codehaus.org/display/SONAR/Settings+Encryption.

Show
Simon Brandhof added a comment - Unfortunately the initial error is lost (see SONAR-3495 ), but it seems that the location of your secret key is badly set. Please check that the property sonar.secretKeyPath is correctly defined. More details in http://docs.codehaus.org/display/SONAR/Settings+Encryption .

People

  • Assignee:
    Simon Brandhof
    Reporter:
    Fabrice Bellingard
Vote (0)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved: