Sonar Installation on Ubuntu and Windows

by idontknow   Last Updated June 13, 2019 08:26 AM

I am trying to install Sonar on ubuntu but there is always an error coming up. I couldnt find any installation guide explaining the installation step by step completely. Is there any?

Here is the latest log output.

INFO   | jvm 1    | 2013/03/30 10:30:31 | 2013-03-30 10:30:31.075:INFO::Stopped [email protected]:9000
INFO   | jvm 1    | 2013/03/30 10:30:31 | 2013-03-30 10:30:31.192:INFO::Shutdown hook complete
STATUS | wrapper  | 2013/03/30 10:30:32 | <-- Wrapper Stopped
STATUS | wrapper  | 2013/03/30 10:30:32 | --> Wrapper Started as Daemon
STATUS | wrapper  | 2013/03/30 10:30:32 | Launching a JVM...
INFO   | jvm 1    | 2013/03/30 10:30:32 | Wrapper (Version 3.2.3) http://wrapper.tanukisoftware.org
INFO   | jvm 1    | 2013/03/30 10:30:32 |   Copyright 1999-2006 Tanuki Software, Inc.  All Rights Reserved.
INFO   | jvm 1    | 2013/03/30 10:30:32 | 
INFO   | jvm 1    | 2013/03/30 10:30:32 | 2013-03-30 10:30:32.957:INFO::Logging to STDERR via org.mortbay.log.StdErrLog
INFO   | jvm 1    | 2013/03/30 10:30:33 | 2013-03-30 10:30:33.012:INFO::jetty-6.1.25
INFO   | jvm 1    | 2013/03/30 10:30:33 | 2013-03-30 10:30:33.204:INFO::NO JSP Support for /, did not find org.apache.jasper.servlet.JspServlet
2013.03.30 10:30:34 INFO  o.s.c.p.Database  Create JDBC datasource
2013.03.30 10:30:34 ERROR o.s.s.p.Platform  
### Error opening session.  Cause: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'sonar'@'localhost' (using password: YES))
### The error may exist in org/sonar/core/dashboard/WidgetPropertyMapper.java (best guess)
### The error occurred while processing mapper_resultMap[resourceResultMap]
### Cause: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'sonar'@'localhost' (using password: YES))
org.apache.ibatis.exceptions.PersistenceException: 
### Error opening session.  Cause: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'sonar'@'localhost' (using password: YES))
### The error may exist in org/sonar/core/dashboard/WidgetPropertyMapper.java (best guess)
### The error occurred while processing mapper_resultMap[resourceResultMap]
### Cause: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'sonar'@'localhost' (using password: YES))
    at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8) ~[mybatis-3.0.6.jar:3.0.6]
    at org.apache.ibatis.session.defaults.DefaultSqlSessionFactory.openSessionFromDataSource(DefaultSqlSessionFactory.java:83) ~[mybatis-3.0.6.jar:3.0.6]
    at org.apache.ibatis.session.defaults.DefaultSqlSessionFactory.openSession(DefaultSqlSessionFactory.java:40) ~[mybatis-3.0.6.jar:3.0.6]
    at org.sonar.core.persistence.MyBatis.openSession(MyBatis.java:142) ~[sonar-core-3.1.jar:na]
    at org.sonar.core.persistence.DatabaseVersion.getVersion(DatabaseVersion.java:51) ~[sonar-core-3.1.jar:na]
    at org.sonar.server.platform.DefaultServerUpgradeStatus.start(DefaultServerUpgradeStatus.java:40) ~[classes/:na]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.7.0_15]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.7.0_15]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_15]
    at java.lang.reflect.Method.invoke(Method.java:601) ~[na:1.7.0_15]
    at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.invokeMethod(ReflectionLifecycleStrategy.java:110) ~[picocontainer-2.14.1.jar:na]
    at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.start(ReflectionLifecycleStrategy.java:89) ~[picocontainer-2.14.1.jar:na]
    at org.picocontainer.injectors.AbstractInjectionFactory$LifecycleAdapter.start(AbstractInjectionFactory.java:84) ~[picocontainer-2.14.1.jar:na]
    at org.picocontainer.behaviors.AbstractBehavior.start(AbstractBehavior.java:169) ~[picocontainer-2.14.1.jar:na]
    at org.picocontainer.behaviors.Stored$RealComponentLifecycle.start(Stored.java:132) ~[picocontainer-2.14.1.jar:na]
    at org.picocontainer.behaviors.Stored.start(Stored.java:110) ~[picocontainer-2.14.1.jar:na]
    at org.picocontainer.DefaultPicoContainer.potentiallyStartAdapter(DefaultPicoContainer.java:1009) ~[picocontainer-2.14.1.jar:na]
    at org.picocontainer.DefaultPicoContainer.startAdapters(DefaultPicoContainer.java:1002) ~[picocontainer-2.14.1.jar:na]
    at org.picocontainer.DefaultPicoContainer.start(DefaultPicoContainer.java:760) ~[picocontainer-2.14.1.jar:na]
    at org.sonar.api.platform.ComponentContainer.startComponents(ComponentContainer.java:70) ~[sonar-plugin-api-3.1.jar:na]
    at org.sonar.server.platform.Platform.startDatabaseConnectors(Platform.java:153) ~[classes/:na]
    at org.sonar.server.platform.Platform.init(Platform.java:102) ~[classes/:na]
    at org.sonar.server.platform.PlatformLifecycleListener.contextInitialized(PlatformLifecycleListener.java:33) [classes/:na]
    at org.mortbay.jetty.handler.ContextHandler.startContext(ContextHandler.java:548) [jetty-6.1.25.jar:6.1.25]
    at org.mortbay.jetty.servlet.Context.startContext(Context.java:136) [jetty-6.1.25.jar:6.1.25]
    at org.mortbay.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1272) [jetty-6.1.25.jar:6.1.25]
    at org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:517) [jetty-6.1.25.jar:6.1.25]
    at org.mortbay.jetty.webapp.WebAppContext.doStart(WebAppContext.java:489) [jetty-6.1.25.jar:6.1.25]
    at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50) [jetty-util-6.1.25.jar:6.1.25]
    at org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:130) [jetty-6.1.25.jar:6.1.25]
    at org.mortbay.jetty.Server.doStart(Server.java:224) [jetty-6.1.25.jar:6.1.25]
    at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50) [jetty-util-6.1.25.jar:6.1.25]
    at org.sonar.application.JettyEmbedder.start(JettyEmbedder.java:72) [sonar-application-3.1.jar:na]
    at org.sonar.application.StartServer.main(StartServer.java:48) [sonar-application-3.1.jar:na]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.7.0_15]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.7.0_15]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_15]
    at java.lang.reflect.Method.invoke(Method.java:601) ~[na:1.7.0_15]
    at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:240) [wrapper-3.2.3.jar:3.2.3]
    at java.lang.Thread.run(Thread.java:722) [na:1.7.0_15]
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'sonar'@'localhost' (using password: YES))
    at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) ~[commons-dbcp-1.3.jar:1.3]
    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) ~[commons-dbcp-1.3.jar:1.3]
    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) ~[commons-dbcp-1.3.jar:1.3]
    at org.apache.ibatis.session.defaults.DefaultSqlSessionFactory.openSessionFromDataSource(DefaultSqlSessionFactory.java:73) ~[mybatis-3.0.6.jar:3.0.6]
    ... 38 common frames omitted
Caused by: java.sql.SQLException: Access denied for user 'sonar'@'localhost' (using password: YES)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:943) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4113) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1308) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2336) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2369) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.18.jar:na]
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_15]
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[na:1.7.0_15]
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_15]
    at java.lang.reflect.Constructor.newInstance(Constructor.java:525) ~[na:1.7.0_15]
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381) ~[mysql-connector-java-5.1.18.jar:na]
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) ~[mysql-connector-java-5.1.18.jar:na]
    at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) ~[commons-dbcp-1.3.jar:1.3]
    at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) ~[commons-dbcp-1.3.jar:1.3]
    at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) ~[commons-dbcp-1.3.jar:1.3]
    at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ~[commons-dbcp-1.3.jar:1.3]
    ... 41 common frames omitted
INFO   | jvm 1    | 2013/03/30 10:30:34 | 2013-03-30 10:30:34.963:WARN::Failed startup of context [email protected]{/,file:/usr/local/sonar-3.1/war/sonar-server}
INFO   | jvm 1    | 2013/03/30 10:30:34 | org.apache.ibatis.exceptions.PersistenceException: |### Error opening session.  Cause: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'sonar'@'localhost' (using password: YES))|### The error may exist in org/sonar/core/dashboard/WidgetPropertyMapper.java (best guess)|### The error occurred while processing mapper_resultMap[resourceResultMap]|### Cause: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'sonar'@'localhost' (using password: YES))
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.apache.ibatis.session.defaults.DefaultSqlSessionFactory.openSessionFromDataSource(DefaultSqlSessionFactory.java:83)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.apache.ibatis.session.defaults.DefaultSqlSessionFactory.openSession(DefaultSqlSessionFactory.java:40)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.sonar.core.persistence.MyBatis.openSession(MyBatis.java:142)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.sonar.core.persistence.DatabaseVersion.getVersion(DatabaseVersion.java:51)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.sonar.server.platform.DefaultServerUpgradeStatus.start(DefaultServerUpgradeStatus.java:40)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at java.lang.reflect.Method.invoke(Method.java:601)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.invokeMethod(ReflectionLifecycleStrategy.java:110)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.start(ReflectionLifecycleStrategy.java:89)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.picocontainer.injectors.AbstractInjectionFactory$LifecycleAdapter.start(AbstractInjectionFactory.java:84)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.picocontainer.behaviors.AbstractBehavior.start(AbstractBehavior.java:169)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.picocontainer.behaviors.Stored$RealComponentLifecycle.start(Stored.java:132)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.picocontainer.behaviors.Stored.start(Stored.java:110)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.picocontainer.DefaultPicoContainer.potentiallyStartAdapter(DefaultPicoContainer.java:1009)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.picocontainer.DefaultPicoContainer.startAdapters(DefaultPicoContainer.java:1002)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.picocontainer.DefaultPicoContainer.start(DefaultPicoContainer.java:760)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.sonar.api.platform.ComponentContainer.startComponents(ComponentContainer.java:70)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.sonar.server.platform.Platform.startDatabaseConnectors(Platform.java:153)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.sonar.server.platform.Platform.init(Platform.java:102)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.sonar.server.platform.PlatformLifecycleListener.contextInitialized(PlatformLifecycleListener.java:33)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.mortbay.jetty.handler.ContextHandler.startContext(ContextHandler.java:548)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.mortbay.jetty.servlet.Context.startContext(Context.java:136)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.mortbay.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1272)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:517)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.mortbay.jetty.webapp.WebAppContext.doStart(WebAppContext.java:489)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:130)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.mortbay.jetty.Server.doStart(Server.java:224)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.sonar.application.JettyEmbedder.start(JettyEmbedder.java:72)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.sonar.application.StartServer.main(StartServer.java:48)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at java.lang.reflect.Method.invoke(Method.java:601)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:240)
INFO   | jvm 1    | 2013/03/30 10:30:34 |   at java.lang.Thread.run(Thread.java:722)
INFO   | jvm 1    | 2013/03/30 10:30:34 | 2013-03-30 10:30:34.985:INFO::Started [email protected]:9000


Answers 1


Basically, here you are trying to get Sonar to connect to a MySQL database but sonar does not have the correct permissions to write to it. You need to log-in to mysql and type the command:

GRANT ALL PRIVILEGES ON sonar TO 'sonar'@'localhost' WITH GRANT OPTION;

This is providing your sonar database is called "sonar".

ecirp
ecirp
April 01, 2013 01:00 AM

Related Questions


Updated September 23, 2017 11:26 AM

Updated July 15, 2016 08:11 AM

Updated March 08, 2017 21:26 PM

Updated May 28, 2017 05:26 AM

Updated July 14, 2018 18:26 PM