Online demo
Download
Contact

Because information matters

  • Help - javax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open connection

  • Problems with installing OpenKM? No problemo, the solution is closer than you think.
It is currently Fri Apr 19, 2024 8:19 am

Help - javax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open connection

Problems with installing OpenKM? No problemo, the solution is closer than you think.
Forum rules: Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
 Reply

Help - javax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open connection

 #47754  by andresclopezr
 
Hi Guys

My Name is Andres, i'm trying to setup my OpenKM but i got this message return (javax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open connection)

I´m using Windows 10 Pro, Google Chrome and Mozilla Fire Fox. OpenKM Version 6.3

Thanks for your help

This is my openkm log:
Code: Select all
2019-04-10 11:00:55,519 [localhost-startStop-1] [] INFO  com.openkm.core.Config - ** Application OpenKM has DTDs at C:\tomcat-8.5.24\webapps\OpenKM\WEB-INF\classes\dtd **
2019-04-10 11:00:55,525 [localhost-startStop-1] [] INFO  com.openkm.core.Config - ** Language profiles at C:\tomcat-8.5.24\webapps\OpenKM\WEB-INF\classes\lang-profiles **
2019-04-10 11:00:55,526 [localhost-startStop-1] [] INFO  com.openkm.core.Config - ** Reading config file C:\tomcat-8.5.24\OpenKM.cfg **
2019-04-10 11:00:55,528 [localhost-startStop-1] [] INFO  com.openkm.core.Config - LOAD - cloud.max.repository.size=0
2019-04-10 11:00:55,528 [localhost-startStop-1] [] INFO  com.openkm.core.Config - LOAD - cloud.max.users=0
2019-04-10 11:00:55,529 [localhost-startStop-1] [] INFO  com.openkm.core.Config - LOAD - cloud.mode=false
2019-04-10 11:00:55,529 [localhost-startStop-1] [] INFO  com.openkm.core.Config - LOAD - hibernate.create.autofix=true
2019-04-10 11:00:55,529 [localhost-startStop-1] [] INFO  com.openkm.core.Config - LOAD - hibernate.datasource=java:/comp/env/jdbc/OpenKMDS
2019-04-10 11:00:55,529 [localhost-startStop-1] [] INFO  com.openkm.core.Config - LOAD - hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
2019-04-10 11:00:55,529 [localhost-startStop-1] [] INFO  com.openkm.core.Config - LOAD - hibernate.hbm2ddl=none
2019-04-10 11:00:55,529 [localhost-startStop-1] [] INFO  com.openkm.core.Config - LOAD - hibernate.search.analyzer=org.apache.lucene.analysis.standard.StandardAnalyzer
2019-04-10 11:00:55,529 [localhost-startStop-1] [] INFO  com.openkm.core.Config - LOAD - hibernate.search.index.exclusive=true
2019-04-10 11:00:55,529 [localhost-startStop-1] [] INFO  com.openkm.core.Config - LOAD - hibernate.search.index.home=C:\tomcat-8.5.24\repository\index
2019-04-10 11:00:55,529 [localhost-startStop-1] [] INFO  com.openkm.core.Config - LOAD - hibernate.show_sql=false
2019-04-10 11:00:55,529 [localhost-startStop-1] [] INFO  com.openkm.core.Config - LOAD - hibernate.statistics=false
2019-04-10 11:00:55,529 [localhost-startStop-1] [] INFO  com.openkm.core.Config - LOAD - instance.chroot.path=
2019-04-10 11:00:55,529 [localhost-startStop-1] [] INFO  com.openkm.core.Config - LOAD - instance.home=C:\tomcat-8.5.24
2019-04-10 11:00:55,529 [localhost-startStop-1] [] INFO  com.openkm.core.Config - LOAD - jbpm.config=C:\tomcat-8.5.24\jbpm.xml
2019-04-10 11:00:55,529 [localhost-startStop-1] [] INFO  com.openkm.core.Config - LOAD - property.groups.cnd=C:\tomcat-8.5.24\PropertyGroups.cnd
2019-04-10 11:00:55,529 [localhost-startStop-1] [] INFO  com.openkm.core.Config - LOAD - property.groups.xml=C:\tomcat-8.5.24\PropertyGroups.xml
2019-04-10 11:00:55,529 [localhost-startStop-1] [] INFO  com.openkm.core.Config - LOAD - repository.cache.dxf=C:\tomcat-8.5.24\repository\cache\dxf
2019-04-10 11:00:55,529 [localhost-startStop-1] [] INFO  com.openkm.core.Config - LOAD - repository.cache.home=C:\tomcat-8.5.24\repository\cache
2019-04-10 11:00:55,529 [localhost-startStop-1] [] INFO  com.openkm.core.Config - LOAD - repository.cache.pdf=C:\tomcat-8.5.24\repository\cache\pdf
2019-04-10 11:00:55,529 [localhost-startStop-1] [] INFO  com.openkm.core.Config - LOAD - repository.cache.swf=C:\tomcat-8.5.24\repository\cache\swf
2019-04-10 11:00:55,529 [localhost-startStop-1] [] INFO  com.openkm.core.Config - LOAD - repository.config=NUL:
2019-04-10 11:00:55,529 [localhost-startStop-1] [] INFO  com.openkm.core.Config - LOAD - repository.datastore.backend=fs
2019-04-10 11:00:55,529 [localhost-startStop-1] [] INFO  com.openkm.core.Config - LOAD - repository.datastore.home=C:\tomcat-8.5.24\repository\datastore
2019-04-10 11:00:55,529 [localhost-startStop-1] [] INFO  com.openkm.core.Config - LOAD - repository.home=C:\tomcat-8.5.24\repository
2019-04-10 11:00:55,529 [localhost-startStop-1] [] INFO  com.openkm.core.Config - LOAD - repository.native=true
2019-04-10 11:00:55,530 [localhost-startStop-1] [] INFO  com.openkm.core.Config - LOAD - system.multiple.instances=false
2019-04-10 11:00:55,530 [localhost-startStop-1] [] INFO  com.openkm.util.WarUtils - okm.version: 6.3.7
2019-04-10 11:00:55,530 [localhost-startStop-1] [] INFO  com.openkm.util.WarUtils - okm.build: 3fc09ed
2019-04-10 11:00:55,532 [localhost-startStop-1] [] INFO  c.o.servlet.RepositoryStartupServlet - *** Application version: 6.3.7 (build: 3fc09ed) ***
2019-04-10 11:00:55,533 [localhost-startStop-1] [] INFO  c.o.servlet.RepositoryStartupServlet - *** Initialize cache manager... ***
2019-04-10 11:00:55,534 [localhost-startStop-1] [] WARN  com.openkm.cache.CacheProvider - Using Ehcache config from ClassPath: /ehcache.xml
2019-04-10 11:00:55,652 [localhost-startStop-1] [] INFO  com.openkm.cache.CacheProvider - Cache disk store path: C:\tomcat-8.5.24\temp/okm
2019-04-10 11:00:55,652 [localhost-startStop-1] [] INFO  c.o.servlet.RepositoryStartupServlet - *** Hibernate initialize ***
2019-04-10 11:00:56,353 [localhost-startStop-1] [] INFO  com.openkm.dao.HibernateUtil - Hibernate 'hibernate.dialect' = org.hibernate.dialect.MySQL5InnoDBDialect
2019-04-10 11:00:56,353 [localhost-startStop-1] [] INFO  com.openkm.dao.HibernateUtil - Hibernate 'hibernate.connection.datasource' = java:/comp/env/jdbc/OpenKMDS
2019-04-10 11:00:56,353 [localhost-startStop-1] [] INFO  com.openkm.dao.HibernateUtil - Hibernate 'hibernate.hbm2ddl.auto' = none
2019-04-10 11:00:56,353 [localhost-startStop-1] [] INFO  com.openkm.dao.HibernateUtil - Hibernate 'hibernate.show_sql' = false
2019-04-10 11:00:56,353 [localhost-startStop-1] [] INFO  com.openkm.dao.HibernateUtil - Hibernate 'hibernate.generate_statistics' = false
2019-04-10 11:00:56,353 [localhost-startStop-1] [] INFO  com.openkm.dao.HibernateUtil - Hibernate 'hibernate.search.default.directory_provider' = org.hibernate.search.store.FSDirectoryProvider
2019-04-10 11:00:56,354 [localhost-startStop-1] [] INFO  com.openkm.dao.HibernateUtil - Hibernate 'hibernate.search.default.indexBase' = C:\tomcat-8.5.24\repository\index
2019-04-10 11:01:01,086 [localhost-startStop-1] [] WARN  org.hibernate.cfg.SettingsFactory - Could not obtain connection to query metadata
java.sql.SQLException: Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.)
	at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2303) ~[tomcat-dbcp.jar:8.5.24]
	at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2043) ~[tomcat-dbcp.jar:8.5.24]
	at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1543) ~[tomcat-dbcp.jar:8.5.24]
	at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92) ~[hibernate-core-3.6.10.Final.jar:3.6.10.Final]
	at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:113) ~[hibernate-core-3.6.10.Final.jar:3.6.10.Final]
	at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863) [hibernate-core-3.6.10.Final.jar:3.6.10.Final]
	at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859) [hibernate-core-3.6.10.Final.jar:3.6.10.Final]
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870) [hibernate-core-3.6.10.Final.jar:3.6.10.Final]
	at com.openkm.dao.HibernateUtil.getSessionFactory(HibernateUtil.java:176) [classes/:6.3.7]
	at com.openkm.dao.HibernateUtil.getSessionFactory(HibernateUtil.java:82) [classes/:6.3.7]
	at com.openkm.servlet.RepositoryStartupServlet.init(RepositoryStartupServlet.java:89) [classes/:6.3.7]
	at javax.servlet.GenericServlet.init(GenericServlet.java:158) [servlet-api.jar:3.1.FR]
	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1183) [catalina.jar:8.5.24]
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1099) [catalina.jar:8.5.24]
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:989) [catalina.jar:8.5.24]
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4931) [catalina.jar:8.5.24]
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5241) [catalina.jar:8.5.24]
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:8.5.24]
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752) [catalina.jar:8.5.24]
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728) [catalina.jar:8.5.24]
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734) [catalina.jar:8.5.24]
	at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:986) [catalina.jar:8.5.24]
	at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857) [catalina.jar:8.5.24]
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [na:1.8.0_181]
	at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_181]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_181]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_181]
	at java.lang.Thread.run(Thread.java:748) [na:1.8.0_181]
Caused by: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) ~[mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) ~[mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:905) ~[mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:830) ~[mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455) ~[mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240) ~[mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199) ~[mysql-connector-java-8.0.15.jar:8.0.15]
	at org.apache.tomcat.dbcp.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) ~[tomcat-dbcp.jar:8.5.24]
	at org.apache.tomcat.dbcp.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:257) ~[tomcat-dbcp.jar:8.5.24]
	at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2313) ~[tomcat-dbcp.jar:8.5.24]
	at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2299) ~[tomcat-dbcp.jar:8.5.24]
	... 27 common frames omitted
Caused by: com.mysql.cj.exceptions.CJException: Access denied for user 'openkm'@'localhost' (using password: YES)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_181]
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_181]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_181]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_181]
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) ~[mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) ~[mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:129) ~[mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:816) ~[mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:741) ~[mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:709) ~[mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:132) ~[mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.protocol.a.NativeAuthenticationProvider.proceedHandshakeWithPluggableAuthentication(NativeAuthenticationProvider.java:540) ~[mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:202) ~[mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1449) ~[mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.NativeSession.connect(NativeSession.java:165) ~[mysql-connector-java-8.0.15.jar:8.0.15]
	at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:849) ~[mysql-connector-java-8.0.15.jar:8.0.15]
	... 35 common frames omitted
2019-04-10 11:01:01,417 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.DatabaseMetadataSequence]; using defaults.
2019-04-10 11:01:01,430 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.Action]; using defaults.
2019-04-10 11:01:01,438 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.Node]; using defaults.
2019-04-10 11:01:01,445 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.DatabaseMetadataType]; using defaults.
2019-04-10 11:01:01,456 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.ExceptionHandler]; using defaults.
2019-04-10 11:01:01,461 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.module.def.ModuleDefinition]; using defaults.
2019-04-10 11:01:01,468 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.ProcessDefinition]; using defaults.
2019-04-10 11:01:01,472 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.context.def.VariableAccess]; using defaults.
2019-04-10 11:01:01,482 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.instantiation.Delegation]; using defaults.
2019-04-10 11:01:01,489 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.Bookmark]; using defaults.
2019-04-10 11:01:01,494 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.Event]; using defaults.
2019-04-10 11:01:01,507 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.Css]; using defaults.
2019-04-10 11:01:01,516 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.Role]; using defaults.
2019-04-10 11:01:01,549 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.NodeProperty]; using defaults.
2019-04-10 11:01:01,553 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.NodeNote]; using defaults.
2019-04-10 11:01:01,566 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.Transition]; using defaults.
2019-04-10 11:01:01,575 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.User]; using defaults.
2019-04-10 11:01:01,580 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.Language]; using defaults.
2019-04-10 11:01:01,582 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.taskmgmt.def.TaskController]; using defaults.
2019-04-10 11:01:01,593 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.Translation]; using defaults.
2019-04-10 11:01:01,598 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.UserConfig]; using defaults.
2019-04-10 11:01:01,601 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.NodeDocumentVersion]; using defaults.
2019-04-10 11:01:01,614 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.taskmgmt.def.Task]; using defaults.
2019-04-10 11:01:01,617 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.DatabaseMetadataValue]; using defaults.
2019-04-10 11:01:01,621 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.MimeType]; using defaults.
2019-04-10 11:01:01,625 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.RegisteredPropertyGroup]; using defaults.
2019-04-10 11:01:01,633 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.node.Decision.decisionConditions]; using defaults.
2019-04-10 11:01:01,640 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.Transition.exceptionHandlers]; using defaults.
2019-04-10 11:01:01,642 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.ExceptionHandler.actions]; using defaults.
2019-04-10 11:01:01,642 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.node.TaskNode.tasks]; using defaults.
2019-04-10 11:01:01,673 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.taskmgmt.def.TaskMgmtDefinition.tasks]; using defaults.
2019-04-10 11:01:01,674 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.ProcessDefinition.definitions]; using defaults.
2019-04-10 11:01:01,675 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.Transition.events]; using defaults.
2019-04-10 11:01:01,676 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.taskmgmt.def.TaskMgmtDefinition.swimlanes]; using defaults.
2019-04-10 11:01:01,676 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.ProcessDefinition.actions]; using defaults.
2019-04-10 11:01:01,677 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.Node.arrivingTransitions]; using defaults.
2019-04-10 11:01:01,678 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.taskmgmt.def.Swimlane.tasks]; using defaults.
2019-04-10 11:01:01,678 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.taskmgmt.def.Task.exceptionHandlers]; using defaults.
2019-04-10 11:01:01,679 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.action.Script.variableAccesses]; using defaults.
2019-04-10 11:01:01,680 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.taskmgmt.def.Task.events]; using defaults.
2019-04-10 11:01:01,681 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.Language.translations]; using defaults.
2019-04-10 11:01:01,682 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.Node.exceptionHandlers]; using defaults.
2019-04-10 11:01:01,683 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.ProcessDefinition.nodes]; using defaults.
2019-04-10 11:01:01,684 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.Event.actions]; using defaults.
2019-04-10 11:01:01,685 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.ProcessDefinition.events]; using defaults.
2019-04-10 11:01:01,685 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.node.ProcessState.variableAccesses]; using defaults.
2019-04-10 11:01:01,686 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.Node.events]; using defaults.
2019-04-10 11:01:01,686 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.Node.leavingTransitions]; using defaults.
2019-04-10 11:01:01,688 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.taskmgmt.def.TaskController.variableAccesses]; using defaults.
2019-04-10 11:01:01,689 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.SuperState.nodes]; using defaults.
2019-04-10 11:01:01,690 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.ProcessDefinition.exceptionHandlers]; using defaults.
2019-04-10 11:01:01,691 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.jbpm.file.def.FileDefinition.processFiles]; using defaults.
2019-04-10 11:01:01,691 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.User.roles]; using defaults.
2019-04-10 11:01:01,788 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.hibernate.cache.UpdateTimestampsCache]; using defaults.
2019-04-10 11:01:01,790 [localhost-startStop-1] [] WARN  n.s.e.h.AbstractEhcacheRegionFactory - Couldn't find a specific ehcache configuration for cache named [org.hibernate.cache.StandardQueryCache]; using defaults.
2019-04-10 11:01:02,043 [localhost-startStop-1] [] INFO  c.o.servlet.RepositoryStartupServlet - *** Initialize property groups... ***
2019-04-10 11:01:02,046 [localhost-startStop-1] [] INFO  c.o.util.FormUtils$LocalResolver - new LocalResolver(C:\tomcat-8.5.24\webapps\OpenKM\WEB-INF\classes\dtd)
2019-04-10 11:01:02,047 [localhost-startStop-1] [] INFO  c.o.util.FormUtils$LocalResolver - registerDTD(-//OpenKM//DTD Property Groups 1.0//EN, C:\tomcat-8.5.24\webapps\OpenKM\WEB-INF\classes\dtd\property-groups-1.0.dtd)
2019-04-10 11:01:02,047 [localhost-startStop-1] [] INFO  c.o.util.FormUtils$LocalResolver - registerDTD(-//OpenKM//DTD Property Groups 1.1//EN, C:\tomcat-8.5.24\webapps\OpenKM\WEB-INF\classes\dtd\property-groups-1.1.dtd)
2019-04-10 11:01:02,047 [localhost-startStop-1] [] INFO  c.o.util.FormUtils$LocalResolver - registerDTD(-//OpenKM//DTD Property Groups 2.0//EN, C:\tomcat-8.5.24\webapps\OpenKM\WEB-INF\classes\dtd\property-groups-2.0.dtd)
2019-04-10 11:01:02,047 [localhost-startStop-1] [] INFO  c.o.util.FormUtils$LocalResolver - registerDTD(-//OpenKM//DTD Property Groups 2.1//EN, C:\tomcat-8.5.24\webapps\OpenKM\WEB-INF\classes\dtd\property-groups-2.1.dtd)
2019-04-10 11:01:02,047 [localhost-startStop-1] [] INFO  c.o.util.FormUtils$LocalResolver - registerDTD(-//OpenKM//DTD Property Groups 2.2//EN, C:\tomcat-8.5.24\webapps\OpenKM\WEB-INF\classes\dtd\property-groups-2.2.dtd)
2019-04-10 11:01:02,047 [localhost-startStop-1] [] INFO  c.o.util.FormUtils$LocalResolver - registerDTD(-//OpenKM//DTD Property Groups 2.3//EN, C:\tomcat-8.5.24\webapps\OpenKM\WEB-INF\classes\dtd\property-groups-2.3.dtd)
2019-04-10 11:01:02,047 [localhost-startStop-1] [] INFO  c.o.util.FormUtils$LocalResolver - registerDTD(-//OpenKM//DTD Report Parameters 2.0//EN, C:\tomcat-8.5.24\webapps\OpenKM\WEB-INF\classes\dtd\report-parameters-2.0.dtd)
2019-04-10 11:01:02,047 [localhost-startStop-1] [] INFO  c.o.util.FormUtils$LocalResolver - registerDTD(-//OpenKM//DTD Workflow Forms 1.0//EN, C:\tomcat-8.5.24\webapps\OpenKM\WEB-INF\classes\dtd\workflow-forms-1.0.dtd)
2019-04-10 11:01:02,048 [localhost-startStop-1] [] INFO  c.o.util.FormUtils$LocalResolver - registerDTD(-//OpenKM//DTD Workflow Forms 1.1//EN, C:\tomcat-8.5.24\webapps\OpenKM\WEB-INF\classes\dtd\workflow-forms-1.1.dtd)
2019-04-10 11:01:02,048 [localhost-startStop-1] [] INFO  c.o.util.FormUtils$LocalResolver - registerDTD(-//OpenKM//DTD Workflow Forms 2.0//EN, C:\tomcat-8.5.24\webapps\OpenKM\WEB-INF\classes\dtd\workflow-forms-2.0.dtd)
2019-04-10 11:01:02,048 [localhost-startStop-1] [] INFO  c.o.util.FormUtils$LocalResolver - registerDTD(-//OpenKM//DTD Workflow Forms 2.1//EN, C:\tomcat-8.5.24\webapps\OpenKM\WEB-INF\classes\dtd\workflow-forms-2.1.dtd)
2019-04-10 11:01:02,048 [localhost-startStop-1] [] INFO  c.o.util.FormUtils$LocalResolver - registerDTD(-//OpenKM//DTD Workflow Forms 2.2//EN, C:\tomcat-8.5.24\webapps\OpenKM\WEB-INF\classes\dtd\workflow-forms-2.2.dtd)
2019-04-10 11:01:02,048 [localhost-startStop-1] [] INFO  c.o.util.FormUtils$LocalResolver - registerDTD(-//OpenKM//DTD Workflow Forms 2.3//EN, C:\tomcat-8.5.24\webapps\OpenKM\WEB-INF\classes\dtd\workflow-forms-2.3.dtd)
2019-04-10 11:01:02,048 [localhost-startStop-1] [] INFO  c.o.util.FormUtils$LocalResolver - registerDTD(-//OpenKM//DTD Workflow Forms 2.4//EN, C:\tomcat-8.5.24\webapps\OpenKM\WEB-INF\classes\dtd\workflow-forms-2.4.dtd)
2019-04-10 11:01:02,051 [localhost-startStop-1] [] INFO  c.o.util.FormUtils$LocalResolver - resolveEntity(publicId=-//OpenKM//DTD Property Groups 2.0//EN, systemId=http://www.openkm.com/dtd/property-groups-2.0.dtd) => C:\tomcat-8.5.24\webapps\OpenKM\WEB-INF\classes\dtd\property-groups-2.0.dtd
2019-04-10 11:01:02,062 [localhost-startStop-1] [] INFO  c.o.servlet.RepositoryStartupServlet - *** Initialize language detection engine... ***
2019-04-10 11:01:06,346 [localhost-startStop-1] [] WARN  o.h.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null
2019-04-10 11:01:06,346 [localhost-startStop-1] [] ERROR o.h.util.JDBCExceptionReporter - Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.)
2019-04-10 11:01:06,347 [localhost-startStop-1] [] ERROR com.openkm.core.Config - ** Error reading configuration table **
2019-04-10 11:01:06,348 [localhost-startStop-1] [] INFO  c.o.servlet.RepositoryStartupServlet - *** Repository initializing... ***
2019-04-10 11:01:10,373 [localhost-startStop-1] [] WARN  o.h.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null
2019-04-10 11:01:10,373 [localhost-startStop-1] [] ERROR o.h.util.JDBCExceptionReporter - Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.)
2019-04-10 11:01:10,383 [localhost-startStop-1] [] WARN  o.a.c.o.s.i.a.CmisAtomPubServlet - CMIS version is not defined! Setting it to CMIS 1.0.
2019-04-10 11:01:15,196 [http-nio-0.0.0.0-8080-exec-9] [] WARN  o.h.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null
2019-04-10 11:01:15,197 [http-nio-0.0.0.0-8080-exec-9] [] ERROR o.h.util.JDBCExceptionReporter - Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.)
2019-04-10 11:01:19,203 [http-nio-0.0.0.0-8080-exec-8] [] WARN  o.h.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null
2019-04-10 11:01:19,203 [http-nio-0.0.0.0-8080-exec-8] [] ERROR o.h.util.JDBCExceptionReporter - Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.)

Re: Help - javax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open connection

 #47763  by jllort
 
The error is clear you can not connect with the user openkm to the database:
Code: Select all
.. 27 common frames omitted
Caused by: com.mysql.cj.exceptions.CJException: Access denied for user 'openkm'@'localhost' (using password: YES)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_181]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_181]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_181]
at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_181]
You should review your conf/server.xml configuration file section where is set the database connection. Check all values be right and also check you are able to connect to the database with these values.
https://docs.openkm.com/kcenter/view/ok ... secreation

I suppose you did installed MySQL database and created the okmdb database?
 Reply
 Return to “Installation”

Favorites

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.

Powered By phpBB -
 ©OpenKM 2021
 - All times are UTC -