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 3


What about the documentation?

I consider that it's a nice guide, probably you'll have some troubles, it's normal, the real problem is that you need to be more specific with your question, what problem do you have? Why don't you tell us? What have you tried?

Castiblanco
Castiblanco
March 30, 2013 13:02 PM

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

I found this guide and I was able to install SQ simply and fastly.

Sir Montes
Sir Montes
June 13, 2019 08:24 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