代码之家 › 专栏 › 技术社区 › Surmeet

SonarQube启动然后停止

sonarqube

Surmeet · 技术社区 · 7 年前

我正试着用 ./sonar.sh start 命令它启动5秒,然后自行停止。

日志文件显示:

        at java.lang.Thread.run(Thread.java:811) [na:2.9 (11-22-2017)]
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.)
        at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) ~[commons-dbcp-1.4.jar:1.4]
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) ~[commons-dbcp-1.4.jar:1.4]
        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) ~[commons-dbcp-1.4.jar:1.4]
        at org.sonar.core.persistence.DefaultDatabase.checkConnection(DefaultDatabase.java:113) ~[sonar-core-4.5.4.jar:na]
        ... 27 common frames omitted
Caused by: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207) ~[postgresql-9.3-1101-jdbc4.jar:na]
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64) ~[postgresql-9.3-1101-jdbc4.jar:na]
        at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:138) ~[postgresql-9.3-1101-jdbc4.jar:na]
        at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29) ~[postgresql-9.3-1101-jdbc4.jar:na]
        at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21) ~[postgresql-9.3-1101-jdbc4.jar:na]
        at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31) ~[postgresql-9.3-1101-jdbc4.jar:na]
        at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) ~[postgresql-9.3-1101-jdbc4.jar:na]
        at org.postgresql.Driver.makeConnection(Driver.java:410) ~[postgresql-9.3-1101-jdbc4.jar:na]
        at org.postgresql.Driver.connect(Driver.java:280) ~[postgresql-9.3-1101-jdbc4.jar:na]
        at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) ~[commons-dbcp-1.4.jar:1.4]
        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) ~[commons-dbcp-1.4.jar:1.4]
        at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) ~[commons-dbcp-1.4.jar:1.4]
        at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ~[commons-dbcp-1.4.jar:1.4]
        ... 30 common frames omitted
Caused by: java.net.ConnectException: Connection refused (Connection refused)
        at java.net.PlainSocketImpl.socketConnect(Native Method) ~[na:1.8.0]
        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:380) ~[na:1.8.0]
        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:236) ~[na:1.8.0]
        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:218) ~[na:1.8.0]
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:403) ~[na:1.8.0]
        at java.net.Socket.connect(Socket.java:666) ~[na:1.8.0]
        at java.net.Socket.connect(Socket.java:606) ~[na:1.8.0]
        at org.postgresql.core.PGStream.<init>(PGStream.java:60) ~[postgresql-9.3-1101-jdbc4.jar:na]
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:101) ~[postgresql-9.3-1101-jdbc4.jar:na]
        ... 42 common frames omitted
2018.04.16 03:16:44 INFO  web[jruby.rack]  jruby 1.7.9 (ruby-1.8.7p370) 2013-12-06 87b108a on IBM J9 VM 8.0.5.6 - pxa6480sr5fp6-20171124_02(SR5 FP6) [linux-amd64]
2018.04.16 03:16:44 INFO  web[jruby.rack]  using a shared (threadsafe!) runtime
2018.04.16 03:16:51 ERROR web[jruby.rack]  initialization failed
org.jruby.rack.RackInitializationException: java.lang.NullPointerException
        at org.jruby.rack.RackInitializationException.wrap(RackInitializationException.java:31) ~[jruby-rack-1.1.13.2.jar:na]
        at org.jruby.rack.DefaultRackApplicationFactory.getApplication(DefaultRackApplicationFactory.java:111) ~[jruby-rack-1.1.13.2.jar:na]
        at org.jruby.rack.SharedRackApplicationFactory.doInit(SharedRackApplicationFactory.java:31) ~[jruby-rack-1.1.13.2.jar:na]
        at org.jruby.rack.RackApplicationFactoryDecorator.init(RackApplicationFactoryDecorator.java:94) ~[jruby-rack-1.1.13.2.jar:na]
        ... 10 common frames omitted
2018.04.16 03:16:51 ERROR web[o.a.c.c.StandardContext]  Error listenerStart
2018.04.16 03:16:51 ERROR web[o.a.c.c.StandardContext]  Context [] startup failed due to previous errors
2018.04.16 03:16:51 ERROR web[o.a.c.l.WebappClassLoader]  The web application [] appears to have started a thread named [JRubyJIT-2] but has failed to stop it. This is very likely to create a memory leak.
2018.04.16 03:16:51 ERROR web[o.a.c.l.WebappClassLoader]  The web application [] appears to have started a thread named [JRubyJIT-1] but has failed to stop it. This is very likely to create a memory leak.
2018.04.16 03:16:51 ERROR web[o.a.c.l.WebappClassLoader]  The web application [] appears to have started a thread named [Timer-0] but has failed to stop it. This is very likely to create a memory leak.
2018.04.16 03:16:51 INFO  web[o.a.c.h.Http11Protocol]  Starting ProtocolHandler ["http-bio-0.0.0.0-9000"]
2018.04.16 03:16:51 INFO  web[o.s.s.app.Logging]  Web server is started
2018.04.16 03:16:51 INFO  web[o.s.s.a.EmbeddedTomcat]  HTTP connector enabled on port 9000
2018.04.16 03:16:51 WARN  web[o.s.p.ProcessEntryPoint]  Fail to start web
java.lang.IllegalStateException: Webapp did not start
        at org.sonar.server.app.EmbeddedTomcat.isReady(EmbeddedTomcat.java:83) ~[sonar-server-4.5.4.jar:na]
        at org.sonar.server.app.WebServer.isReady(WebServer.java:45) [sonar-server-4.5.4.jar:na]
        at org.sonar.process.ProcessEntryPoint.launch(ProcessEntryPoint.java:80) ~[sonar-process-4.5.4.jar:na]
        at org.sonar.server.app.WebServer.main(WebServer.java:65) [sonar-server-4.5.4.jar:na]
2018.04.16 03:16:51 INFO  web[o.a.c.h.Http11Protocol]  Pausing ProtocolHandler ["http-bio-0.0.0.0-9000"]
2018.04.16 03:16:52 INFO  web[o.a.c.h.Http11Protocol]  Stopping ProtocolHandler ["http-bio-0.0.0.0-9000"]
2018.04.16 03:16:52 INFO  web[o.a.c.h.Http11Protocol]  Destroying ProtocolHandler ["http-bio-0.0.0.0-9000"]
2018.04.16 03:16:52 INFO  web[o.s.s.app.Logging]  Web server is stopped
2018.04.16 03:16:52 INFO  app[o.s.p.m.TerminatorThread] Process[search] is stopping
2018.04.16 03:16:52 INFO  sea[o.s.p.StopWatcher]  Stopping process
2018.04.16 03:16:52 INFO  sea[o.elasticsearch.node]  [sonar-1523828793595] stopping ...
2018.04.16 03:16:52 INFO  sea[o.elasticsearch.node]  [sonar-1523828793595] stopped
2018.04.16 03:16:52 INFO  sea[o.elasticsearch.node]  [sonar-1523828793595] closing ...
2018.04.16 03:16:52 INFO  sea[o.elasticsearch.node]  [sonar-1523828793595] closed
2018.04.16 03:16:52 INFO  app[o.s.p.m.TerminatorThread] Process[search] is stopped
<-- Wrapper Stopped

你能帮帮我吗?

声纳。属性

sonar.jdbc.maxActive=20
sonar.jdbc.maxIdle=5
sonar.jdbc.minIdle=2
sonar.jdbc.maxWait=5000
sonar.jdbc.minEvictableIdleTimeMillis=600000
sonar.jdbc.timeBetweenEvictionRunsMillis=30000

包装器。属性

wrapper.java.command=java
wrapper.java.additional.1=-Djava.awt.headless=true
wrapper.java.mainclass=org.tanukisoftware.wrapper.WrapperSimpleApp
wrapper.java.classpath.1=../../lib/jsw/*.jar
wrapper.java.classpath.2=../../lib/*.jar
wrapper.java.library.path.1=./lib
wrapper.app.parameter.1=org.sonar.application.App
wrapper.java.initmemory=3
# Xmx can't be set to a lower value because of compatibility with Java 6
wrapper.java.maxmemory=32

此外,正在给sonarqube的端口9000上没有运行其他进程

2 回复 | 直到 7 年前

Eric Hartmann 7 年前

您的SonarQube配置为使用Postgresql数据库,但根据以下错误,您的服务器无法连接到此数据库:

Caused by: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

您应该检查 sonar.jdbc.url 所有物

George312 7 年前

你是否在声纳中取消了这些行的注释。属性?(sonarqube\u文件夹/conf/sonar.properties)

 sonar.jdbc.username= 
 sonar.jdbc.password=
 sonar.jdbc.url=jdbc:postgresql://localhost/sonar

并将用户名和密码设置为您为角色设置的用户名和密码? 例如:

 sonar.jdbc.username=sonar 
 sonar.jdbc.password=sonar

在创建角色时未设置角色权限之前,我遇到了另一个问题,重新启动电脑后,我无法连接到数据库。创建新角色后,我必须右键单击新角色并在pgAdmin中添加权限。有时我还必须手动连接到服务器。

打开pgAdmin
右键单击服务器并连接