当前位置: 动力学知识库 > 问答 > 编程问答 >

sonarqube - Sonar 3.2 with SQL Server 2008

问题描述:

We've installed and configured Sonar 3.2. With the internal database there is no problem, but when connecting to SQL Server database we get an error:

We're sorry, but something went wrong.

Please try back in a few minutes and contact support if the problem persists.

<%= link_to "Go back to the homepage", home_path %>

When I look at the sonar.log this code is shown:

 2013.10.22 15:07:13 INFO o.s.s.p.ServerImpl Sonar Server / 3.2 / d9303b2d9d4c1e75f8536e4144028f1999f727f4

2013.10.22 15:07:13 INFO o.s.c.p.Database Create JDBC datasource to url jdbc:jtds:sqlserver://172.30.71.139;databaseName=sonar32ta;instanceName=SE;SelectMethod=Cursor

2013.10.22 15:07:14 INFO o.s.s.p.DefaultServerFileSystem Sonar home: /opt/sonar-3.2

2013.10.22 15:07:14 INFO o.s.s.p.DefaultServerFileSystem Deploy dir: /opt/sonar-3.2/war/sonar-server/deploy

2013.10.22 15:07:14 INFO org.sonar.INFO Install plugins...

2013.10.22 15:07:14 INFO o.s.s.p.PluginDeployer Deploy plugin Findbugs / 3.2 / d9303b2d9d4c1e75f8536e4144028f1999f727f4

2013.10.22 15:07:15 INFO o.s.s.p.PluginDeployer Deploy plugin JaCoCo / 3.2 / d9303b2d9d4c1e75f8536e4144028f1999f727f4

2013.10.22 15:07:15 INFO o.s.s.p.PluginDeployer Deploy plugin English Pack / 3.2 / d9303b2d9d4c1e75f8536e4144028f1999f727f4

2013.10.22 15:07:15 INFO o.s.s.p.PluginDeployer Deploy plugin Surefire / 3.2 / d9303b2d9d4c1e75f8536e4144028f1999f727f4

2013.10.22 15:07:15 INFO o.s.s.p.PluginDeployer Deploy plugin Duplications / 3.2 / d9303b2d9d4c1e75f8536e4144028f1999f727f4

2013.10.22 15:07:15 INFO o.s.s.p.PluginDeployer Deploy plugin Checkstyle / 3.2 / d9303b2d9d4c1e75f8536e4144028f1999f727f4

2013.10.22 15:07:15 INFO o.s.s.p.PluginDeployer Deploy plugin PMD / 3.2 / d9303b2d9d4c1e75f8536e4144028f1999f727f4

2013.10.22 15:07:15 INFO o.s.s.p.PluginDeployer Deploy plugin Java / 3.2 / d9303b2d9d4c1e75f8536e4144028f1999f727f4

2013.10.22 15:07:15 INFO o.s.s.p.PluginDeployer Deploy plugin Core / 3.2 / d9303b2d9d4c1e75f8536e4144028f1999f727f4

2013.10.22 15:07:15 INFO o.s.s.p.PluginDeployer Deploy plugin Database Cleaner / 3.2 / d9303b2d9d4c1e75f8536e4144028f1999f727f4

2013.10.22 15:07:15 INFO o.s.s.p.PluginDeployer Deploy plugin Cobertura / 3.2 / d9303b2d9d4c1e75f8536e4144028f1999f727f4

2013.10.22 15:07:15 INFO o.s.s.p.PluginDeployer Deploy plugin Squid for Java / 3.2 / d9303b2d9d4c1e75f8536e4144028f1999f727f4

2013.10.22 15:07:15 INFO o.s.s.p.PluginDeployer Deploy plugin Email notifications / 3.2 / d9303b2d9d4c1e75f8536e4144028f1999f727f4

2013.10.22 15:07:15 INFO o.s.s.p.PluginDeployer Deploy plugin Design / 3.2 / d9303b2d9d4c1e75f8536e4144028f1999f727f4

2013.10.22 15:07:15 INFO org.sonar.INFO Install plugins done: 274 ms

2013.10.22 15:07:15 INFO o.s.s.p.ApplicationDeployer Deploy Ruby on Rails applications

INFO | jvm 1 | 2013/10/22 15:07:27 | JRuby limited openssl loaded. http://jruby.org/openssl

INFO | jvm 1 | 2013/10/22 15:07:27 | gem install jruby-openssl for full support.

INFO | jvm 1 | 2013/10/22 15:07:38 | 2013-10-22 15:07:38.957:WARN:/:unable to create shared application instance

INFO | jvm 1 | 2013/10/22 15:07:38 | org.jruby.rack.RackInitializationException: no connection available|?from /opt/sonar-3.2/war/sonar-server/WEB-INF/vendor/gems/activerecord-jdbc-adapter-1.1.3/lib/arjdbc/jdbc/connection.rb:61:in `initialize'|?from /opt/sonar-3.2/war/sonar-server/WEB-INF/vendor/gems/activerecord-jdbc-adapter-1.1.3/lib/arjdbc/jdbc/adapter.rb:31:in `initialize'|?from /opt/sonar-3.2/war/sonar-server/WEB-INF/vendor/gems/activerecord-jdbc-adapter-1.1.3/lib/arjdbc/jdbc/connection_methods.rb:6:in `jdbc_connection'|?from org/jruby/RubyKernel.java:2056:in `send'|?from /opt/sonar-3.2/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in `new_connection'|?from /opt/sonar-3.2/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:245:in `checkout_new_connection'|?from /opt/sonar-3.2/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:188:in `checkout'|?from org/jruby/RubyKernel.java:1418:in `loop'|?from /opt/sonar-3.2/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in `checkout'|?from file:/opt/sonar-3.2/war/sonar-server/WEB-INF/lib/jruby-complete-1.6.1.jar!/META-INF/jruby.home/lib/ruby/1.8/monitor.rb:191:in `mon_synchronize'|?from /opt/sonar-3.2/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:183:in `checkout'|?from /opt/sonar-3.2/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:98:in `connection'|?from /opt/sonar-3.2/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:326:in `retrieve_connection'|?from /opt/sonar-3.2/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:123:in `retrieve_connection'|?from /opt/sonar-3.2/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:115:in `connection'|?from /opt/sonar-3.2/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/migration.rb:435:in `initialize'|?from /opt/sonar-3.2/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/migration.rb:400:in `up'|?from /opt/sonar-3.2/war/sonar-server/WEB-INF/vendor/rails/activerecord/lib/active_record/migration.rb:383:in `migrate'|?from /opt/sonar-3.2/war/sonar-server/WEB-INF/lib/database_version.rb:63:in `upgrade_and_start'|?from /opt/sonar-3.2/war/sonar-server/WEB-INF/lib/database_version.rb:75:in `automatic_setup'|?from /opt/sonar-3.2/war/sonar-server/WEB-INF/config/environment.rb:131:in `(root)'|?from org/jruby/RubyKernel.java:1063:in `load'|?from /opt/sonar-3.2/war/sonar-server/WEB-INF/config/environment.rb:53:in `load_environment'|?from file:/opt/sonar-3.2/war/sonar-server/WEB-INF/lib/jruby-rack-1.0.0.1.jar!/jruby/rack/rails.rb:46:in `to_app'|?from file:/opt/sonar-3.2/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:/opt/sonar-3.2/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)'|

this is a part of sonar.properties:

 sonar.web.port: 9000

sonar.web.context: /

#----- Credentials

# Permissions to create tables and indexes must be granted to JDBC user.

# The schema must be created first.

sonar.jdbc.username: sonar

sonar.jdbc.password: sonar

sonar.jdbc.maxActive: 10

sonar.jdbc.maxIdle: 5

sonar.jdbc.minIdle: 2

sonar.jdbc.maxWait: 5000

sonar.jdbc.minEvictableIdleTimeMillis: 600000

sonar.jdbc.timeBetweenEvictionRunsMillis: 30000

sonar.jdbc.url: jdbc:jtds:sqlserver://172.30.71.139;databaseName=sonar32ta;instanceName=SE;SelectMethod=Cursor

sonar.jdbc.driverClassName: net.sourceforge.jtds.jdbc.Driver

sonar.jdbc.validationQuery: select 1

sonar.jdbc.dialect: mssql

I created a new scheme called 'sonar' and a user called 'sonar'. The permissions are ok, but still I get that error I mentioned.

Can someone please help me with this issue?

With kind regards

分享给朋友:
您可能感兴趣的文章:
随机阅读: