I am getting the that error: Cannot create PoolableConnectionFactory (Access denied for user 'root '@'localhost' (using password: NO) Exception.
I know the password for root on the MariaDB , I have also checked the context.xml and server.xml files but I see no reference to the root user.
Excerpt from my knowage log file :
[localhost-startStop-1] 06 Jun 2018 17:46:53,636 ERROR org.hibernate.util.JDBCExceptionReporter.logExceptions:234 - Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: NO))
[localhost-startStop-1] 06 Jun 2018 17:46:53,636 ERROR org.hibernate.util.JDBCExceptionReporter.logExceptions:234 - Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: NO))
[localhost-startStop-1] 06 Jun 2018 17:46:53,650 ERROR it.eng.spagobi.commons.dao.ConfigDAOHibImpl.loadAllConfigParameters:79 - HibernateException during query
org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:160)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:81)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1473)
at it.eng.spagobi.commons.dao.ConfigDAOHibImpl.loadAllConfigParameters(ConfigDAOHibImpl.java:63)
at it.eng.spagobi.commons.SingletonConfigCache.<init>(SingletonConfigCache.java:40)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at java.lang.Class.newInstance(Class.java:442)
at it.eng.spagobi.commons.SingletonConfig.<init>(SingletonConfig.java:53)
at it.eng.spagobi.commons.SingletonConfig.getInstance(SingletonConfig.java:43)
at it.eng.spago.dbaccess.Configurator.<init>(Configurator.java:104)
at it.eng.spago.dbaccess.Configurator.getInstance(Configurator.java:117)
at it.eng.spago.dbaccess.DataConnectionManager.<init>(DataConnectionManager.java:74)
at it.eng.spago.dbaccess.DataConnectionManager.getInstance(DataConnectionManager.java:192)
at it.eng.spago.dbaccess.DataAccessInitializer.init(DataAccessInitializer.java:42)
at it.eng.spago.init.InitializerManager.init(InitializerManager.java:79)
at it.eng.spago.configuration.ConfigServlet.init(ConfigServlet.java:115)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1280)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1193)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1088)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5198)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5481)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:634)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1230)
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1876)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: NO))
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
