sonarqube - Sonar qube is not getting started -
while running startsonar.bat command line getting following error contineously.sonarqube log file showing below messages.
any appreciated!
--> wrapper started console launching jvm... wrapper (version 3.2.3) http://wrapper.tanukisoftware.org copyright 1999-2006 tanuki software, inc. rights reserved. 2015.06.13 15:04:41 info app[o.s.p.m.javaprocesslauncher] launch process[search]: c:\program files\java\jdk1.8.0_45\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=d:\sonarqube-5.1\sonarqube-5.1\temp -cp ./lib/common/*;./lib/search/* org.sonar.search.searchserver c:\users\rkutchar\appdata\local\temp\sq-process3411693551115002418properties 2015.06.13 15:04:42 info es[o.s.p.processentrypoint] starting search 2015.06.13 15:04:42 info es[o.s.s.searchserver] starting elasticsearch[sonarqube] on port 9001 2015.06.13 15:04:42 info es[o.elasticsearch.node] [sonar-1434188081817] version[1.4.4], pid[7068], build[c88f77f/2015-02-19t13:05:36z] 2015.06.13 15:04:42 info es[o.elasticsearch.node] [sonar-1434188081817] initializing ... 2015.06.13 15:04:42 info es[o.e.plugins] [sonar-1434188081817] loaded [], sites [] 2015.06.13 15:04:43 info es[o.elasticsearch.node] [sonar-1434188081817] initialized 2015.06.13 15:04:43 info es[o.elasticsearch.node] [sonar-1434188081817] starting ... 2015.06.13 15:04:44 info es[o.e.transport] [sonar-1434188081817] bound_address {inet[/0.0.0.0:9001]}, publish_address {inet[/10.76.17.174:9001]} 2015.06.13 15:04:44 info es[o.e.discovery] [sonar-1434188081817] sonarqube/y7poplbzq8gqvlg6o70c3g 2015.06.13 15:04:47 info es[o.e.cluster.service] [sonar-1434188081817] new_master [sonar-1434188081817][y7poplbzq8gqvlg6o70c3g][din35003079][inet[/10.76.17.174:9001]]{rack_id=sonar-1434188081817}, reason: zen-disco-join (elected_as_master) 2015.06.13 15:04:47 info es[o.elasticsearch.node] [sonar-1434188081817] started 2015.06.13 15:04:47 info es[o.e.gateway] [sonar-1434188081817] recovered [6] indices cluster_state 2015.06.13 15:04:48 info app[o.s.p.m.monitor] process[search] 2015.06.13 15:04:48 info app[o.s.p.m.javaprocesslauncher] launch process[web]: c:\program files\java\jdk1.8.0_45\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=d:\sonarqube-5.1\sonarqube-5.1\temp -cp ./lib/common/*;./lib/server/*;d:\sonarqube-5.1\sonarqube-5.1\lib\jdbc\mysql\mysql-connector-java-5.1.34.jar org.sonar.server.app.webserver c:\users\rkutchar\appdata\local\temp\sq-process4890757865030388998properties 2015.06.13 15:04:49 info web[o.s.p.processentrypoint] starting web 2015.06.13 15:04:49 info web[o.s.s.app.webapp] webapp directory: d:\sonarqube-5.1\sonarqube-5.1\web 2015.06.13 15:04:49 info web[o.a.c.h.http11nioprotocol] initializing protocolhandler ["http-nio-0.0.0.0-9000"] 2015.06.13 15:04:49 info web[o.a.t.u.n.nioselectorpool] using shared selector servlet write/read 2015.06.13 15:04:50 info web[o.e.plugins] [sonar-1434188081817] loaded [], sites [] 2015.06.13 15:04:50 info web[o.s.s.p.serverimpl] sonarqube server / 5.1 / 4aa9af3a6a4362b61db365fba32eb0a55d411e7a 2015.06.13 15:04:50 info web[o.s.c.p.database] create jdbc datasource jdbc:mysql://localhost:3306/sonar?useunicode=true&characterencoding=utf8&rewritebatchedstatements=true&useconfigs=maxperformance 2015.06.13 15:04:50 error web[o.a.c.c.c.[.[.[/]] exception sending context initialized event listener instance of class org.sonar.server.platform.platformservletcontextlistener java.lang.illegalstateexception: can not connect database. please check connectivity , settings (see properties prefixed 'sonar.jdbc.'). @ org.sonar.core.persistence.defaultdatabase.checkconnection(defaultdatabase.java:117) ~[sonar-core-5.1.jar:na] @ org.sonar.core.persistence.defaultdatabase.start(defaultdatabase.java:73) ~[sonar-core-5.1.jar:na] @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) ~[na:1.8.0_45] @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:62) ~[na:1.8.0_45] @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43) ~[na:1.8.0_45] @ java.lang.reflect.method.invoke(method.java:497) ~[na:1.8.0_45] @ org.picocontainer.lifecycle.reflectionlifecyclestrategy.invokemethod(reflectionlifecyclestrategy.java:110) ~[picocontainer-2.14.3.jar:na] @ org.picocontainer.lifecycle.reflectionlifecyclestrategy.start(reflectionlifecyclestrategy.java:89) ~[picocontainer-2.14.3.jar:na] @ org.picocontainer.injectors.abstractinjectionfactory$lifecycleadapter.start(abstractinjectionfactory.java:84) ~[picocontainer-2.14.3.jar:na] @ org.picocontainer.behaviors.abstractbehavior.start(abstractbehavior.java:169) ~[picocontainer-2.14.3.jar:na] @ org.picocontainer.behaviors.stored$realcomponentlifecycle.start(stored.java:132) ~[picocontainer-2.14.3.jar:na] @ org.picocontainer.behaviors.stored.start(stored.java:110) ~[picocontainer-2.14.3.jar:na] @ org.picocontainer.defaultpicocontainer.potentiallystartadapter(defaultpicocontainer.java:1015) ~[picocontainer-2.14.3.jar:na] @ org.picocontainer.defaultpicocontainer.startadapters(defaultpicocontainer.java:1008) ~[picocontainer-2.14.3.jar:na] @ org.picocontainer.defaultpicocontainer.start(defaultpicocontainer.java:766) ~[picocontainer-2.14.3.jar:na] @ org.sonar.api.platform.componentcontainer.startcomponents(componentcontainer.java:91) ~[sonar-plugin-api-5.1.jar:na] @ org.sonar.server.platform.platform.startlevel1container(platform.java:96) ~[sonar-server-5.1.jar:na] @ org.sonar.server.platform.platform.init(platform.java:72) ~[sonar-server-5.1.jar:na] @ org.sonar.server.platform.platformservletcontextlistener.contextinitialized(platformservletcontextlistener.java:43) ~[sonar-server-5.1.jar:na] @ org.apache.catalina.core.standardcontext.listenerstart(standardcontext.java:4720) [tomcat-embed-core-8.0.18.jar:8.0.18] @ org.apache.catalina.core.standardcontext.startinternal(standardcontext.java:5154) [tomcat-embed-core-8.0.18.jar:8.0.18] @ org.apache.catalina.util.lifecyclebase.start(lifecyclebase.java:150) [tomcat-embed-core-8.0.18.jar:8.0.18] @ org.apache.catalina.core.containerbase$startchild.call(containerbase.java:1409) [tomcat-embed-core-8.0.18.jar:8.0.18] @ org.apache.catalina.core.containerbase$startchild.call(containerbase.java:1399) [tomcat-embed-core-8.0.18.jar:8.0.18] @ java.util.concurrent.futuretask.run(futuretask.java:266) [na:1.8.0_45] @ java.util.concurrent.threadpoolexecutor.runworker(threadpoolexecutor.java:1142) [na:1.8.0_45] @ java.util.concurrent.threadpoolexecutor$worker.run(threadpoolexecutor.java:617) [na:1.8.0_45] @ java.lang.thread.run(thread.java:745) [na:1.8.0_45] caused by: org.apache.commons.dbcp.sqlnestedexception: cannot create poolableconnectionfactory (access denied user 'sonar'@'localhost' (using password: yes)) @ org.apache.commons.dbcp.basicdatasource.createpoolableconnectionfactory(basicdatasource.java:1549) ~[commons-dbcp-1.4.jar:1.4] @ org.apache.commons.dbcp.basicdatasource.createdatasource(basicdatasource.java:1388) ~[commons-dbcp-1.4.jar:1.4] @ org.apache.commons.dbcp.basicdatasource.getconnection(basicdatasource.java:1044) ~[commons-dbcp-1.4.jar:1.4] @ org.sonar.core.persistence.defaultdatabase.checkconnection(defaultdatabase.java:115) ~[sonar-core-5.1.jar:na] ... 27 common frames omitted caused by: java.sql.sqlexception: access denied user 'sonar'@'localhost' (using password: yes) @ com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:996) ~[mysql-connector-java-5.1.34.jar:5.1.34] @ com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:3887) ~[mysql-connector-java-5.1.34.jar:5.1.34] @ com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:3823) ~[mysql-connector-java-5.1.34.jar:5.1.34] @ com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:870) ~[mysql-connector-java-5.1.34.jar:5.1.34] @ com.mysql.jdbc.mysqlio.proceedhandshakewithpluggableauthentication(mysqlio.java:1659) ~[mysql-connector-java-5.1.34.jar:5.1.34] @ com.mysql.jdbc.mysqlio.dohandshake(mysqlio.java:1206) ~[mysql-connector-java-5.1.34.jar:5.1.34] @ com.mysql.jdbc.connectionimpl.coreconnect(connectionimpl.java:2234) ~[mysql-connector-java-5.1.34.jar:5.1.34] @ com.mysql.jdbc.connectionimpl.connectonetryonly(connectionimpl.java:2265) ~[mysql-connector-java-5.1.34.jar:5.1.34] @ com.mysql.jdbc.connectionimpl.createnewio(connectionimpl.java:2064) ~[mysql-connector-java-5.1.34.jar:5.1.34] @ com.mysql.jdbc.connectionimpl.<init>(connectionimpl.java:790) ~[mysql-connector-java-5.1.34.jar:5.1.34] @ com.mysql.jdbc.jdbc4connection.<init>(jdbc4connection.java:44) ~[mysql-connector-java-5.1.34.jar:5.1.34] @ sun.reflect.nativeconstructoraccessorimpl.newinstance0(native method) ~[na:1.8.0_45] @ sun.reflect.nativeconstructoraccessorimpl.newinstance(nativeconstructoraccessorimpl.java:62) ~[na:1.8.0_45] @ sun.reflect.delegatingconstructoraccessorimpl.newinstance(delegatingconstructoraccessorimpl.java:45) ~[na:1.8.0_45] @ java.lang.reflect.constructor.newinstance(constructor.java:422) ~[na:1.8.0_45] @ com.mysql.jdbc.util.handlenewinstance(util.java:377) ~[mysql-connector-java-5.1.34.jar:5.1.34] @ com.mysql.jdbc.connectionimpl.getinstance(connectionimpl.java:395) ~[mysql-connector-java-5.1.34.jar:5.1.34] @ com.mysql.jdbc.nonregisteringdriver.connect(nonregisteringdriver.java:325) ~[mysql-connector-java-5.1.34.jar:5.1.34] @ org.apache.commons.dbcp.driverconnectionfactory.createconnection(driverconnectionfactory.java:38) ~[commons-dbcp-1.4.jar:1.4] @ org.apache.commons.dbcp.poolableconnectionfactory.makeobject(poolableconnectionfactory.java:582) ~[commons-dbcp-1.4.jar:1.4] @ org.apache.commons.dbcp.basicdatasource.validateconnectionfactory(basicdatasource.java:1556) ~[commons-dbcp-1.4.jar:1.4] @ org.apache.commons.dbcp.basicdatasource.createpoolableconnectionfactory(basicdatasource.java:1545) ~[commons-dbcp-1.4.jar:1.4] ... 30 common frames omitted 2015.06.13 15:04:51 info web[jruby.rack] jruby 1.7.9 (ruby-1.8.7p370) 2013-12-06 87b108a on java hotspot(tm) 64-bit server vm 1.8.0_45-b15 [windows 7-amd64] 2015.06.13 15:04:51 info web[jruby.rack] using shared (threadsafe!) runtime
edit:
apply plugin: "sonar-runner" sonarrunner { sonarproperties { // can set on command line - dsonar.analysis.mode=incremental property "sonar.host.url","http://localhost:9000" property "sonar.jdbc.url","jdbc:mysql://sonar.someserver.int:3306/sonar" property "sonar.jdbc.driverclassname","com.mysql.jdbc.driver" property "sonar.jdbc.username", "****" property "sonar.jdbc.password", "****" //i added these properties gradle.build property "sonar.projectkey","com.example.rkutchar.myapplication" property "sonar.projectname","myapplication" property "sonar.projectversion","v1.0" property "sonar.language","java" property "sonar.sources","src/main/java" property "sonar.binaries","build" } } subprojects { sonarrunner { sonarproperties { properties["sonar.sources"] += "src/main/java" } } } sonarrunner { toolversion = '2.4' }
project.properties file
# required metadata sonar.projectkey=myapplication sonar.projectname=my application sonar.projectversion=1.0 # comma-separated paths directories sources (required) sonar.sources=src/main/java # language sonar.language=java # encoding of source files sonar.sourceencoding=utf-8
conf/sonar-properties
#configure here general information environment, such sonarqube db details example #no information specific project should appear here #----- default sonarqube server #sonar.host.url=http://localhost:9000 #----- postgresql #sonar.jdbc.url=jdbc:postgresql://localhost/sonar #----- mysql sonar.jdbc.url=jdbc:mysql://localhost:3306/sonar? useunicode=true&characterencoding=utf8 #----- oracle #sonar.jdbc.url=jdbc:oracle:thin:@localhost/xe #----- microsoft sqlserver #sonar.jdbc.url=jdbc:jtds:sqlserver://localhost/sonar;selectmethod=cursor #----- global database settings #sonar.jdbc.username=sonar #sonar.jdbc.password=sonar #----- default source code encoding #sonar.sourceencoding=utf-8 #----- security (when 'sonar.forceauthentication' set 'true') #sonar.login=admin #sonar.password=admin
it seems permissions not correct on database. have execute following statement on mysql database:
grant privileges on `sonar`.* 'sonar'@'localhost';
Comments
Post a Comment