How to connect Mysql 5.6 to sonar 6.1

soma srikanth

unread,

Oct 24, 2016, 12:16:38 PM10/24/16

to SonarQube

Hello,

I installed sonar 6.1 on aws ec2 after installing it i made following changes in my sonar.properties file uncommented

sonar.jdbc.url= endpoint of rds mysql

sonar.jdbc.username=user of mysql which i created launching db instance

sonar.jdbc.pwd=pwd which i created launching db instance

sonar.web.port=8080

and when i ran service sonar status it says sonarqube is running but when i try open the sonar using the ip address it is not running how do i make rds db instance connect to my sonar server which is on ec2 instance ?

thanks,

Srikanth

soma srikanth

unread,

Oct 24, 2016, 5:09:36 PM10/24/16

to SonarQube

Sonar logs

at org.sonar.server.app.WebServer.start(WebServer.java:41) [sonar-server-6.1.jar:na]

at org.sonar.process.ProcessEntryPoint.launch(ProcessEntryPoint.java:102) [sonar-process-6.1.jar:na]

at org.sonar.server.app.WebServer.main(WebServer.java:67) [sonar-server-6.1.jar:na]

Caused by: org.apache.catalina.LifecycleException: Protocol handler initialization failed

at org.apache.catalina.connector.Connector.initInternal(Connector.java:962) ~[tomcat-embed-core-8.0.32.jar:8.0.32]

at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:102) [tomcat-embed-core-8.0.32.jar:8.0.32]

... 10 common frames omitted

Caused by: java.net.SocketException: Permission denied

at sun.nio.ch.Net.bind0(Native Method) ~[na:1.8.0_74]

at sun.nio.ch.Net.bind(Net.java:433) ~[na:1.8.0_74]

at sun.nio.ch.Net.bind(Net.java:425) ~[na:1.8.0_74]

at sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:223) ~[na:1.8.0_74]

at sun.nio.ch.ServerSocketAdaptor.bind(ServerSocketAdaptor.java:74) ~[na:1.8.0_74]

at org.apache.tomcat.util.net.NioEndpoint.bind(NioEndpoint.java:340) ~[tomcat-embed-core-8.0.32.jar:8.0.32]

at org.apache.tomcat.util.net.AbstractEndpoint.init(AbstractEndpoint.java:742) ~[tomcat-embed-core-8.0.32.jar:8.0.32]

at org.apache.coyote.AbstractProtocol.init(AbstractProtocol.java:458) ~[tomcat-embed-core-8.0.32.jar:8.0.32]

at org.apache.coyote.http11.AbstractHttp11JsseProtocol.init(AbstractHttp11JsseProtocol.java:120) ~[tomcat-embed-core-8.0.32.jar:8.0.32]

at org.apache.catalina.connector.Connector.initInternal(Connector.java:960) ~[tomcat-embed-core-8.0.32.jar:8.0.32]

... 11 common frames omitted

2016.10.24 21:04:51 WARN web[][o.s.p.ProcessEntryPoint] Fail to start web

java.lang.RuntimeException: org.apache.catalina.LifecycleException: Failed to initialize component [StandardServer[-1]]

at com.google.common.base.Throwables.propagate(Throwables.java:160) ~[guava-18.0.jar:na]

at org.sonar.server.app.EmbeddedTomcat.start(EmbeddedTomcat.java:65) ~[sonar-server-6.1.jar:na]

at org.sonar.server.app.WebServer.start(WebServer.java:41) [sonar-server-6.1.jar:na]

at org.sonar.process.ProcessEntryPoint.launch(ProcessEntryPoint.java:102) ~[sonar-process-6.1.jar:na]

at org.sonar.server.app.WebServer.main(WebServer.java:67) [sonar-server-6.1.jar:na]

Caused by: org.apache.catalina.LifecycleException: Failed to initialize component [StandardServer[-1]]

at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:106) ~[tomcat-embed-core-8.0.32.jar:8.0.32]

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:136) ~[tomcat-embed-core-8.0.32.jar:8.0.32]

at org.apache.catalina.startup.Tomcat.start(Tomcat.java:345) ~[tomcat-embed-core-8.0.32.jar:8.0.32]

at org.sonar.server.app.EmbeddedTomcat.start(EmbeddedTomcat.java:62) ~[sonar-server-6.1.jar:na]

... 3 common frames omitted

Caused by: org.apache.catalina.LifecycleException: Failed to initialize component [StandardService[Tomcat]]

at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:106) ~[tomcat-embed-core-8.0.32.jar:8.0.32]

at org.apache.catalina.core.StandardServer.initInternal(StandardServer.java:851) ~[tomcat-embed-core-8.0.32.jar:8.0.32]

at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:102) ~[tomcat-embed-core-8.0.32.jar:8.0.32]

... 6 common frames omitted

Caused by: org.apache.catalina.LifecycleException: Failed to initialize connector [Connector[HTTP/1.1-80]]

at org.apache.catalina.core.StandardService.initInternal(StandardService.java:575) ~[tomcat-embed-core-8.0.32.jar:8.0.32]

at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:102) ~[tomcat-embed-core-8.0.32.jar:8.0.32]

... 8 common frames omitted

2016.10.24 21:04:52 INFO app[][o.s.p.m.Monitor] Process[es] is stopping

2016.10.24 21:04:52 INFO es[][o.s.p.StopWatcher] Stopping process

2016.10.24 21:04:52 INFO es[][o.elasticsearch.node] [sonarqube] stopping ...

2016.10.24 21:04:52 INFO es[][o.elasticsearch.node] [sonarqube] stopped

2016.10.24 21:04:52 INFO es[][o.elasticsearch.node] [sonarqube] closing ...

2016.10.24 21:04:52 INFO es[][o.elasticsearch.node] [sonarqube] closed

2016.10.24 21:04:53 INFO app[][o.s.p.m.Monitor] Process[es] is stopped

soma srikanth

unread,

Oct 24, 2016, 5:11:26 PM10/24/16

to SonarQube, G. Ann Campbell, Freddy Mallet

Julien Lancelot

unread,

Oct 25, 2016, 3:10:20 AM10/25/16

to soma srikanth, SonarQube, G. Ann Campbell, Freddy Mallet

Hi Soma,

You're using a wrong parameter for the password, you should use sonar.jdbc.password

Regards,

--
You received this message because you are subscribed to the Google Groups "SonarQube" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sonarqube+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sonarqube/8581a6b5-a0ee-4e0c-a9b3-0fe7086e4cb8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Julien LANCELOT | SonarSource

http://sonarsource.com

soma srikanth

unread,

Oct 25, 2016, 10:54:26 AM10/25/16

to SonarQube, soma.sr...@gmail.com, ann.ca...@sonarsource.com, freddy...@sonarsource.com

Finally i got a reply ! thanks for that but i'm using sonar.jdbc.password not sonar.jdbc.pwd i just used pwd as a shortcut for that here are my sonarlogs can you please look in to this

--> Wrapper Started as Daemon

Launching a JVM...

Startup failed: Timed out waiting for a signal from the JVM.

JVM did not exit on request, terminated

JVM exited on its own while waiting to kill the application.

JVM exited in response to signal SIGKILL (9).

JVM Restarts disabled. Shutting down.

<-- Wrapper Stopped

--> Wrapper Started as Daemon

Launching a JVM...

Wrapper (Version 3.2.3) http://wrapper.tanukisoftware.org

2016.10.25 14:17:10 INFO app[o.s.p.m.JavaProcessLauncher] Launch process[search]: /usr/java/jdk1.8.0_74/jre/bin/java -Djava.awt.headless=true -Xmx1G -Xms256m -Xss256k -Djava.net.preferIPv4Stack=true -XX:+UseParNewGC -XX:+UseConcMarkSweepGC -XX:CMSInitiatingOccupancyFraction=75 -XX:+UseCMSInitiatingOccupancyOnly -XX:+HeapDumpOnOutOfMemoryError -Djava.io.tmpdir=/opt/sonar/temp -cp ./lib/common/*:./lib/search/* org.sonar.search.SearchServer /tmp/sq-process5610422735978764351properties

2016.10.25 14:17:14 INFO es[o.s.p.ProcessEntryPoint] Starting search

2016.10.25 14:17:14 INFO es[o.s.s.SearchServer] Starting Elasticsearch[sonarqube] on port 9001

2016.10.25 14:17:17 INFO es[o.elasticsearch.node] [sonar-1477405025097] version[1.4.4], pid[3453], build[c88f77f/2015-02-19T13:05:36Z]

2016.10.25 14:17:17 INFO es[o.elasticsearch.node] [sonar-1477405025097] initializing ...

2016.10.25 14:17:17 INFO es[o.e.plugins] [sonar-1477405025097] loaded [], sites []

2016.10.25 14:17:22 INFO es[o.elasticsearch.node] [sonar-1477405025097] initialized

2016.10.25 14:17:22 INFO es[o.elasticsearch.node] [sonar-1477405025097] starting ...

2016.10.25 14:17:23 WARN es[o.e.common.network] failed to resolve local host, fallback to loopback

java.net.UnknownHostException: ip-10-212-142-227: ip-10-212-142-227: unknown error

at java.net.InetAddress.getLocalHost(InetAddress.java:1505) ~[na:1.8.0_74]

at org.elasticsearch.common.network.NetworkUtils.<clinit>(NetworkUtils.java:55) ~[elasticsearch-1.4.4.jar:na]

at org.elasticsearch.transport.netty.NettyTransport.createClientBootstrap(NettyTransport.java:350) [elasticsearch-1.4.4.jar:na]

at org.elasticsearch.transport.netty.NettyTransport.doStart(NettyTransport.java:250) [elasticsearch-1.4.4.jar:na]

at org.elasticsearch.common.component.AbstractLifecycleComponent.start(AbstractLifecycleComponent.java:85) [elasticsearch-1.4.4.jar:na]

at org.elasticsearch.transport.TransportService.doStart(TransportService.java:91) [elasticsearch-1.4.4.jar:na]

at org.elasticsearch.common.component.AbstractLifecycleComponent.start(AbstractLifecycleComponent.java:85) [elasticsearch-1.4.4.jar:na]

at org.elasticsearch.node.internal.InternalNode.start(InternalNode.java:242) [elasticsearch-1.4.4.jar:na]

at org.sonar.search.SearchServer.start(SearchServer.java:46) [sonar-search-5.1.2.jar:na]

at org.sonar.process.ProcessEntryPoint.launch(ProcessEntryPoint.java:77) [sonar-process-5.1.2.jar:na]

at org.sonar.search.SearchServer.main(SearchServer.java:80) [sonar-search-5.1.2.jar:na]

Caused by: java.net.UnknownHostException: ip-10-212-142-227: unknown error

at java.net.Inet4AddressImpl.lookupAllHostAddr(Native Method) ~[na:1.8.0_74]

at java.net.InetAddress$2.lookupAllHostAddr(InetAddress.java:928) ~[na:1.8.0_74]

at java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1323) ~[na:1.8.0_74]

at java.net.InetAddress.getLocalHost(InetAddress.java:1500) ~[na:1.8.0_74]

... 10 common frames omitted

2016.10.25 14:17:23 INFO es[o.e.transport] [sonar-1477405025097] bound_address {inet[/0.0.0.0:9001]}, publish_address {inet[/10.212.142.227:9001]}

2016.10.25 14:17:23 INFO es[o.e.discovery] [sonar-1477405025097] sonarqube/Ojjt8GY8TBmnqexaYFX9dg

2016.10.25 14:17:26 INFO es[o.e.cluster.service] [sonar-1477405025097] new_master [sonar-1477405025097][Ojjt8GY8TBmnqexaYFX9dg][localhost][inet[/10.212.142.227:9001]]{rack_id=sonar-1477405025097}, reason: zen-disco-join (elected_as_master)

2016.10.25 14:17:26 INFO es[o.elasticsearch.node] [sonar-1477405025097] started

2016.10.25 14:17:26 INFO es[o.e.gateway] [sonar-1477405025097] recovered [0] indices into cluster_state

Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=160m; support was removed in 8.0

2016.10.25 14:17:27 INFO app[o.s.p.m.Monitor] Process[search] is up

2016.10.25 14:17:27 INFO app[o.s.p.m.JavaProcessLauncher] Launch process[web]: /usr/java/jdk1.8.0_74/jre/bin/java -Djava.awt.headless=true -Dfile.encoding=UTF-8 -Djruby.management.enabled=false -Djruby.compile.invokedynamic=false -Xmx768m -XX:MaxPermSize=160m -XX:+HeapDumpOnOutOfMemoryError -Djava.net.preferIPv4Stack=true -Djava.io.tmpdir=/opt/sonar/temp -cp ./lib/common/*:./lib/server/*:/opt/sonar/lib/jdbc/mysql/mysql-connector-java-5.1.34.jar org.sonar.server.app.WebServer /tmp/sq-process6004628083317301158properties

2016.10.25 14:17:32 INFO web[o.s.p.ProcessEntryPoint] Starting web

2016.10.25 14:17:33 INFO web[o.s.s.app.Webapp] Webapp directory: /opt/sonar/web

2016.10.25 14:17:34 INFO web[o.a.c.h.Http11NioProtocol] Initializing ProtocolHandler ["http-nio-0.0.0.0-80"]

2016.10.25 14:17:34 ERROR web[o.a.c.h.Http11NioProtocol] Failed to initialize end point associated with ProtocolHandler ["http-nio-0.0.0.0-80"]

java.net.SocketException: Permission denied

at sun.nio.ch.Net.bind0(Native Method) ~[na:1.8.0_74]

at sun.nio.ch.Net.bind(Net.java:433) ~[na:1.8.0_74]

at sun.nio.ch.Net.bind(Net.java:425) ~[na:1.8.0_74]

at sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:223) ~[na:1.8.0_74]

at sun.nio.ch.ServerSocketAdaptor.bind(ServerSocketAdaptor.java:74) ~[na:1.8.0_74]

at org.apache.tomcat.util.net.NioEndpoint.bind(NioEndpoint.java:343) ~[tomcat-embed-core-8.0.18.jar:8.0.18]

at org.apache.tomcat.util.net.AbstractEndpoint.init(AbstractEndpoint.java:730) ~[tomcat-embed-core-8.0.18.jar:8.0.18]

at org.apache.coyote.AbstractProtocol.init(AbstractProtocol.java:457) ~[tomcat-embed-core-8.0.18.jar:8.0.18]

at org.apache.coyote.http11.AbstractHttp11JsseProtocol.init(AbstractHttp11JsseProtocol.java:120) [tomcat-embed-core-8.0.18.jar:8.0.18]

at org.apache.catalina.connector.Connector.initInternal(Connector.java:960) [tomcat-embed-core-8.0.18.jar:8.0.18]

at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:102) [tomcat-embed-core-8.0.18.jar:8.0.18]

at org.apache.catalina.core.StandardService.initInternal(StandardService.java:567) [tomcat-embed-core-8.0.18.jar:8.0.18]

at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:102) [tomcat-embed-core-8.0.18.jar:8.0.18]

at org.apache.catalina.core.StandardServer.initInternal(StandardServer.java:851) [tomcat-embed-core-8.0.18.jar:8.0.18]

at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:102) [tomcat-embed-core-8.0.18.jar:8.0.18]

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:139) [tomcat-embed-core-8.0.18.jar:8.0.18]

at org.apache.catalina.startup.Tomcat.start(Tomcat.java:340) [tomcat-embed-core-8.0.18.jar:8.0.18]

at org.sonar.server.app.EmbeddedTomcat.start(EmbeddedTomcat.java:62) [sonar-server-5.1.2.jar:na]

at org.sonar.server.app.WebServer.start(WebServer.java:40) [sonar-server-5.1.2.jar:na]

at org.sonar.process.ProcessEntryPoint.launch(ProcessEntryPoint.java:77) [sonar-process-5.1.2.jar:na]

at org.sonar.server.app.WebServer.main(WebServer.java:66) [sonar-server-5.1.2.jar:na]

2016.10.25 14:17:34 ERROR web[o.a.c.c.StandardService] Failed to initialize connector [Connector[HTTP/1.1-80]]

org.apache.catalina.LifecycleException: Failed to initialize component [Connector[HTTP/1.1-80]]

at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:106) [tomcat-embed-core-8.0.18.jar:8.0.18]

at org.apache.catalina.core.StandardService.initInternal(StandardService.java:567) ~[tomcat-embed-core-8.0.18.jar:8.0.18]