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:

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: 10552
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: Google [Bot] and 1 guest