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.
Post Reply
andresclopezr
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: Wed Apr 10, 2019 4:06 pm

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

Post by andresclopezr » Wed Apr 10, 2019 4:11 pm

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.)

jllort
Moderator
Moderator
Posts: 10668
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

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

Post by jllort » Sat Apr 13, 2019 8:40 am

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?

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest