• SOLVED:Can't Get Portable Edition Started

  • Problems with installing OpenKM? No problemo, the solution is closer than you think.
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.
 #40254  by alexwgordon
 
Hi Guys,

I'd say I'm still fairly new to all this, but I'm struggling to get the Portable Edition of OpenKM started and running. I've followed the readme.txt that comes with it, but haven't successfully been able to start the openkm server to login via localhost:8080/OpenKM. Here are the steps I've taken, please let me know if I'm missing something!
  • 1. Create fresh VM with Parallels of W7 without any shared folders
    2. Copy openkm-dev to C:
    3. Start MySQL
    4. Open MySQL workbench and setup openkm w/ openkm password and root without a password
    5. Run install.bat as admin
    6. Open Eclipse (I get a message to update workspace - I click OK)
    7. Change/add 64-bit JRE in Eclipse
    8. Change JAVA_HOME for 64-bit
    9. In Eclipse, run Build OpenKM 6.3
    10. Create hard-link via junction.exe
    11. Right-click and start openkm server
From here I open Firefox portable and go to localhost:8080/OpenKM and I get:

HTTP Status 404 - /OpenKM/
type Status report
message /OpenKM/
description the request resource is not available.

In the server console, this is all I get:
Code: Select all
log4j:WARN No appenders could be found for logger (org.apache.catalina.startup.Catalina).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
Aug 06, 2015 10:16:36 AM com.openkm.util.LoggerWatchdog doOnChange
INFO: *** Log4j configuration file changed ***
2015-08-06 10:16:36,595 [main] INFO  org.apache.catalina.core.StandardService- Starting service Catalina
2015-08-06 10:16:36,595 [main] INFO  org.apache.catalina.core.StandardEngine- Starting Servlet Engine: Apache Tomcat/7.0.53
2015-08-06 10:16:36,610 [localhost-startStop-1] INFO  org.apache.catalina.startup.HostConfig- Deploying web application directory C:\openkm-dev\tomcat-7.0.27\webapps\ROOT
2015-08-06 10:16:38,421 [main] INFO  org.apache.coyote.http11.Http11Protocol- Starting ProtocolHandler ["http-bio-127.0.0.1-8080"]
2015-08-06 10:16:38,421 [main] INFO  org.apache.coyote.ajp.AjpProtocol- Starting ProtocolHandler ["ajp-bio-127.0.0.1-8009"]
2015-08-06 10:16:38,421 [main] INFO  org.apache.catalina.startup.Catalina- Server startup in 1894 ms
Am I missing anything important? Thanks guys, really appreciate your help!
Last edited by alexwgordon on Wed Aug 19, 2015 4:49 pm, edited 1 time in total.
 #40261  by jllort
 
I think the problem is with the hard link with junction. The link but be the forder target/OpenKM, ensure the content of this folder is shown into $TOMCAT/webapps/OpenKM

I'm seeing tomcat starting correctly but seems the OpenKM ( war or exploded ( target / OpenKM ) ) is not there.
 #40316  by alexwgordon
 
Hi jllort! You were correct, the hardlink junction was not okay for some reason. After repairing that link when trying to start the server I get this now:
Code: Select all
Could not load the Tomcat server configuration at \Servers\openkm-config. The configuration may be corrupt or incomplete.
Resource is out of sync with the file system: '/Servers/openkm-config/server.xml'.
or
Code: Select all
Could not load the Tomcat server configuration at \Servers\openkm-config. The configuration may be corrupt or incomplete.
Resource is out of sync with the file system: '/Servers/openkm-config/context.xml'.
It seems to vary on which file it says is out of sync in the openkm-config.

Any suggestions for correcting this? Thanks in advance!
 #40317  by alexwgordon
 
Ah okay, so I got the server sort of started up.

Basically I just did a quick right-click > Refresh of the Servers in the Navigator, rebuilt OpenKM one more time and ran the Server. The server started up like I thought it should.

Upon trying to login via PortableFirefox, I got this message in the browser
Code: Select all
Class: 	org.apache.jasper.JasperException
Message: 	javax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open connection
Date: 	Tue Aug 18 11:31:28 PDT 2015
I looked in the Console and saw grabbed this:
Code: Select all
2015-08-18 11:38:07,957 [localhost-startStop-1] WARN  org.hibernate.cfg.SettingsFactory- Could not obtain connection to query metadata
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.)
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
	at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)
	at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:113)
	at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863)
	at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870)
	at com.openkm.dao.HibernateUtil.getSessionFactory(HibernateUtil.java:180)
	at com.openkm.dao.HibernateUtil.getSessionFactory(HibernateUtil.java:91)
	at com.openkm.servlet.RepositoryStartupServlet.init(RepositoryStartupServlet.java:100)
	at javax.servlet.GenericServlet.init(GenericServlet.java:158)
	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1284)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1197)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1087)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5210)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5493)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1229)
	at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1875)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:745)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
	at com.mysql.jdbc.Util.getInstance(Util.java:384)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2412)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:787)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:357)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
	at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
	at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
	... 27 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1122)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2334)
	... 40 more
Caused by: java.net.ConnectException: Connection refused: connect
	at java.net.DualStackPlainSocketImpl.connect0(Native Method)
	at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
	at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
	at java.net.Socket.connect(Socket.java:579)
	at java.net.Socket.connect(Socket.java:528)
	at java.net.Socket.<init>(Socket.java:425)
	at java.net.Socket.<init>(Socket.java:241)
	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:293)
	... 41 more
2015-08-18 11:38:08,489 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.Node]; using defaults.
2015-08-18 11:38:08,520 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.Bookmark]; using defaults.
2015-08-18 11:38:08,535 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.instantiation.Delegation]; using defaults.
2015-08-18 11:38:08,535 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.User]; using defaults.
2015-08-18 11:38:08,551 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.ProcessDefinition]; using defaults.
2015-08-18 11:38:08,551 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.Action]; using defaults.
2015-08-18 11:38:08,567 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.Transition]; using defaults.
2015-08-18 11:38:08,863 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.NodeProperty]; using defaults.
2015-08-18 11:38:08,879 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.Language]; using defaults.
2015-08-18 11:38:08,894 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.Translation]; using defaults.
2015-08-18 11:38:08,894 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.DatabaseMetadataValue]; using defaults.
2015-08-18 11:38:08,910 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.NodeDocumentVersion]; using defaults.
2015-08-18 11:38:08,925 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.RegisteredPropertyGroup]; using defaults.
2015-08-18 11:38:08,925 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.module.def.ModuleDefinition]; using defaults.
2015-08-18 11:38:08,941 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.ExceptionHandler]; using defaults.
2015-08-18 11:38:08,957 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.Css]; using defaults.
2015-08-18 11:38:08,972 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.DatabaseMetadataType]; using defaults.
2015-08-18 11:38:08,988 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.MimeType]; using defaults.
2015-08-18 11:38:08,988 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.DatabaseMetadataSequence]; using defaults.
2015-08-18 11:38:08,988 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.Role]; using defaults.
2015-08-18 11:38:09,004 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.taskmgmt.def.Task]; using defaults.
2015-08-18 11:38:09,020 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.Event]; using defaults.
2015-08-18 11:38:09,036 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.context.def.VariableAccess]; using defaults.
2015-08-18 11:38:09,051 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.taskmgmt.def.TaskController]; using defaults.
2015-08-18 11:38:09,051 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.NodeNote]; using defaults.
2015-08-18 11:38:09,067 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.UserConfig]; using defaults.
2015-08-18 11:38:09,098 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.Language.translations]; using defaults.
2015-08-18 11:38:09,145 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.ProcessDefinition.nodes]; using defaults.
2015-08-18 11:38:09,145 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.ProcessDefinition.actions]; using defaults.
2015-08-18 11:38:09,145 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.taskmgmt.def.TaskMgmtDefinition.tasks]; using defaults.
2015-08-18 11:38:09,145 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.Node.events]; using defaults.
2015-08-18 11:38:09,145 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.ProcessDefinition.definitions]; using defaults.
2015-08-18 11:38:09,145 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.Node.leavingTransitions]; using defaults.
2015-08-18 11:38:09,160 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.taskmgmt.def.Task.events]; using defaults.
2015-08-18 11:38:09,160 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.node.TaskNode.tasks]; using defaults.
2015-08-18 11:38:09,160 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.ExceptionHandler.actions]; using defaults.
2015-08-18 11:38:09,160 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.Event.actions]; using defaults.
2015-08-18 11:38:09,160 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.SuperState.nodes]; using defaults.
2015-08-18 11:38:09,160 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.Transition.exceptionHandlers]; using defaults.
2015-08-18 11:38:09,160 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.taskmgmt.def.Task.exceptionHandlers]; using defaults.
2015-08-18 11:38:09,160 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.Node.arrivingTransitions]; using defaults.
2015-08-18 11:38:09,160 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.Node.exceptionHandlers]; using defaults.
2015-08-18 11:38:09,160 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.ProcessDefinition.exceptionHandlers]; using defaults.
2015-08-18 11:38:09,160 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.action.Script.variableAccesses]; using defaults.
2015-08-18 11:38:09,160 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [com.openkm.dao.bean.User.roles]; using defaults.
2015-08-18 11:38:09,176 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.file.def.FileDefinition.processFiles]; using defaults.
2015-08-18 11:38:09,176 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.node.ProcessState.variableAccesses]; using defaults.
2015-08-18 11:38:09,176 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.ProcessDefinition.events]; using defaults.
2015-08-18 11:38:09,176 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.taskmgmt.def.TaskMgmtDefinition.swimlanes]; using defaults.
2015-08-18 11:38:09,176 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.node.Decision.decisionConditions]; using defaults.
2015-08-18 11:38:09,176 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.graph.def.Transition.events]; using defaults.
2015-08-18 11:38:09,176 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.taskmgmt.def.Swimlane.tasks]; using defaults.
2015-08-18 11:38:09,176 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.jbpm.taskmgmt.def.TaskController.variableAccesses]; using defaults.
2015-08-18 11:38:09,348 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.hibernate.cache.UpdateTimestampsCache]; using defaults.
2015-08-18 11:38:09,348 [localhost-startStop-1] WARN  net.sf.ehcache.hibernate.AbstractEhcacheRegionFactory- Couldn't find a specific ehcache configuration for cache named [org.hibernate.cache.StandardQueryCache]; using defaults.
2015-08-18 11:38:09,613 [localhost-startStop-1] INFO  com.openkm.servlet.RepositoryStartupServlet- *** Initialize property groups... ***
2015-08-18 11:38:09,613 [localhost-startStop-1] INFO  com.openkm.util.FormUtils$LocalResolver- new LocalResolver(C:\openkm-dev\tomcat-7.0.27\webapps\OpenKM\WEB-INF\classes\dtd)
2015-08-18 11:38:09,613 [localhost-startStop-1] INFO  com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Property Groups 1.0//EN, C:\openkm-dev\tomcat-7.0.27\webapps\OpenKM\WEB-INF\classes\dtd\property-groups-1.0.dtd)
2015-08-18 11:38:09,613 [localhost-startStop-1] INFO  com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Property Groups 1.1//EN, C:\openkm-dev\tomcat-7.0.27\webapps\OpenKM\WEB-INF\classes\dtd\property-groups-1.1.dtd)
2015-08-18 11:38:09,613 [localhost-startStop-1] INFO  com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Property Groups 2.0//EN, C:\openkm-dev\tomcat-7.0.27\webapps\OpenKM\WEB-INF\classes\dtd\property-groups-2.0.dtd)
2015-08-18 11:38:09,613 [localhost-startStop-1] INFO  com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Property Groups 2.1//EN, C:\openkm-dev\tomcat-7.0.27\webapps\OpenKM\WEB-INF\classes\dtd\property-groups-2.1.dtd)
2015-08-18 11:38:09,613 [localhost-startStop-1] INFO  com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Property Groups 2.2//EN, C:\openkm-dev\tomcat-7.0.27\webapps\OpenKM\WEB-INF\classes\dtd\property-groups-2.2.dtd)
2015-08-18 11:38:09,613 [localhost-startStop-1] INFO  com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Property Groups 2.3//EN, C:\openkm-dev\tomcat-7.0.27\webapps\OpenKM\WEB-INF\classes\dtd\property-groups-2.3.dtd)
2015-08-18 11:38:09,613 [localhost-startStop-1] INFO  com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Report Parameters 2.0//EN, C:\openkm-dev\tomcat-7.0.27\webapps\OpenKM\WEB-INF\classes\dtd\report-parameters-2.0.dtd)
2015-08-18 11:38:09,613 [localhost-startStop-1] INFO  com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Workflow Forms 1.0//EN, C:\openkm-dev\tomcat-7.0.27\webapps\OpenKM\WEB-INF\classes\dtd\workflow-forms-1.0.dtd)
2015-08-18 11:38:09,613 [localhost-startStop-1] INFO  com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Workflow Forms 1.1//EN, C:\openkm-dev\tomcat-7.0.27\webapps\OpenKM\WEB-INF\classes\dtd\workflow-forms-1.1.dtd)
2015-08-18 11:38:09,613 [localhost-startStop-1] INFO  com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Workflow Forms 2.0//EN, C:\openkm-dev\tomcat-7.0.27\webapps\OpenKM\WEB-INF\classes\dtd\workflow-forms-2.0.dtd)
2015-08-18 11:38:09,613 [localhost-startStop-1] INFO  com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Workflow Forms 2.1//EN, C:\openkm-dev\tomcat-7.0.27\webapps\OpenKM\WEB-INF\classes\dtd\workflow-forms-2.1.dtd)
2015-08-18 11:38:09,613 [localhost-startStop-1] INFO  com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Workflow Forms 2.2//EN, C:\openkm-dev\tomcat-7.0.27\webapps\OpenKM\WEB-INF\classes\dtd\workflow-forms-2.2.dtd)
2015-08-18 11:38:09,613 [localhost-startStop-1] INFO  com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Workflow Forms 2.3//EN, C:\openkm-dev\tomcat-7.0.27\webapps\OpenKM\WEB-INF\classes\dtd\workflow-forms-2.3.dtd)
2015-08-18 11:38:09,613 [localhost-startStop-1] INFO  com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Workflow Forms 2.4//EN, C:\openkm-dev\tomcat-7.0.27\webapps\OpenKM\WEB-INF\classes\dtd\workflow-forms-2.4.dtd)
2015-08-18 11:38:09,613 [localhost-startStop-1] INFO  com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Workflow Forms 2.5//EN, C:\openkm-dev\tomcat-7.0.27\webapps\OpenKM\WEB-INF\classes\dtd\workflow-forms-2.5.dtd)
2015-08-18 11:38:09,613 [localhost-startStop-1] INFO  com.openkm.util.FormUtils$LocalResolver- resolveEntity(publicId=-//OpenKM//DTD Property Groups 2.4//EN, systemId=http://www.openkm.com/dtd/property-groups-2.4.dtd) => NULL
2015-08-18 11:38:10,268 [localhost-startStop-1] INFO  com.openkm.module.common.CommonAuthModule- PrincipalAdapter: com.openkm.principal.DatabasePrincipalAdapter
2015-08-18 11:38:10,675 [net.sf.ehcache.CacheManager@341ed4] INFO  net.sf.ehcache.util.UpdateChecker- New update(s) found: 2.4.7 [http://www.terracotta.org/confluence/display/release/Release+Notes+Ehcache+Core+2.4]. Please check http://ehcache.org for the latest version.
2015-08-18 11:38:20,457 [localhost-startStop-1] WARN  org.hibernate.util.JDBCExceptionReporter- SQL Error: 0, SQLState: null
2015-08-18 11:38:20,457 [localhost-startStop-1] ERROR org.hibernate.util.JDBCExceptionReporter- Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.)
2015-08-18 11:38:20,457 [localhost-startStop-1] ERROR com.openkm.module.common.CommonAuthModule- Cannot open connection
com.openkm.principal.PrincipalAdapterException: Cannot open connection
	at com.openkm.principal.DatabasePrincipalAdapter.getUsers(DatabasePrincipalAdapter.java:54)
	at com.openkm.module.common.CommonAuthModule.getUsers(CommonAuthModule.java:46)
	at com.openkm.module.db.DbAuthModule.getUsers(DbAuthModule.java:479)
	at com.openkm.api.OKMAuth.getUsers(OKMAuth.java:134)
	at com.openkm.select.values.ListClass.getOptions(ListClass.java:37)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at com.openkm.util.cl.ClassLoaderUtils.invokeMethodFromClass(ClassLoaderUtils.java:115)
	at com.openkm.util.cl.ClassLoaderUtils.invokeMethodFromClass(ClassLoaderUtils.java:51)
	at com.openkm.bean.form.Select.getOptionsFromClass(Select.java:270)
	at com.openkm.bean.form.Select.handleClassOptions(Select.java:231)
	at com.openkm.bean.form.Select.setOptions(Select.java:62)
	at com.openkm.util.FormUtils.parseField(FormUtils.java:573)
	at com.openkm.util.FormUtils.parsePropertyGroupsForms(FormUtils.java:218)
	at com.openkm.servlet.RepositoryStartupServlet.init(RepositoryStartupServlet.java:110)
	at javax.servlet.GenericServlet.init(GenericServlet.java:158)
	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1284)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1197)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1087)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5210)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5493)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1229)
	at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1875)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:745)
Caused by: com.openkm.core.DatabaseException: Cannot open connection
	at com.openkm.dao.AuthDAO.findAllUsers(AuthDAO.java:267)
	at com.openkm.principal.DatabasePrincipalAdapter.getUsers(DatabasePrincipalAdapter.java:47)
	... 33 more
Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection
	at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)
	at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
	at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
	at org.hibernate.loader.Loader.doQuery(Loader.java:801)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
	at org.hibernate.loader.Loader.doList(Loader.java:2542)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
	at org.hibernate.loader.Loader.list(Loader.java:2271)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
	at com.openkm.dao.AuthDAO.findAllUsers(AuthDAO.java:263)
	... 34 more
Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.)
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
	at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)
	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
	... 48 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
	at com.mysql.jdbc.Util.getInstance(Util.java:384)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2412)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:787)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:357)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
	at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
	at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
	... 52 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1122)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2334)
	... 65 more
Caused by: java.net.ConnectException: Connection refused: connect
	at java.net.DualStackPlainSocketImpl.connect0(Native Method)
	at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
	at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
	at java.net.Socket.connect(Socket.java:579)
	at java.net.Socket.connect(Socket.java:528)
	at java.net.Socket.<init>(Socket.java:425)
	at java.net.Socket.<init>(Socket.java:241)
	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:293)
	... 66 more
Exception occured: Cannot open connection
2015-08-18 11:38:20,472 [localhost-startStop-1] INFO  com.openkm.servlet.RepositoryStartupServlet- *** Initialize language detection engine... ***
2015-08-18 11:38:30,957 [localhost-startStop-1] WARN  org.hibernate.util.JDBCExceptionReporter- SQL Error: 0, SQLState: null
2015-08-18 11:38:30,957 [localhost-startStop-1] ERROR org.hibernate.util.JDBCExceptionReporter- Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.)
2015-08-18 11:38:30,957 [localhost-startStop-1] ERROR com.openkm.core.Config- ** Error reading configuration table **
2015-08-18 11:38:30,957 [localhost-startStop-1] INFO  com.openkm.servlet.RepositoryStartupServlet- *** Repository initializing... ***
2015-08-18 11:38:41,113 [localhost-startStop-1] WARN  org.hibernate.util.JDBCExceptionReporter- SQL Error: 0, SQLState: null
2015-08-18 11:38:41,113 [localhost-startStop-1] ERROR org.hibernate.util.JDBCExceptionReporter- Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.)
2015-08-18 11:38:41,113 [localhost-startStop-1] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM]- Servlet /OpenKM threw load() exception
java.net.ConnectException: Connection refused: connect
	at java.net.DualStackPlainSocketImpl.connect0(Native Method)
	at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
	at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
	at java.net.Socket.connect(Socket.java:579)
	at java.net.Socket.connect(Socket.java:528)
	at java.net.Socket.<init>(Socket.java:425)
	at java.net.Socket.<init>(Socket.java:241)
	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:293)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2334)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:787)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:357)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
	at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
	at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
	at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92)
	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
	at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
	at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
	at org.hibernate.loader.Loader.doQuery(Loader.java:801)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
	at org.hibernate.loader.Loader.doList(Loader.java:2542)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
	at org.hibernate.loader.Loader.list(Loader.java:2271)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
	at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890)
	at com.openkm.dao.NodeBaseDAO.calculateUuidFromPath(NodeBaseDAO.java:259)
	at com.openkm.dao.NodeBaseDAO.calculateUuidFromPath(NodeBaseDAO.java:232)
	at com.openkm.dao.NodeBaseDAO.getUuidFromPath(NodeBaseDAO.java:122)
	at com.openkm.module.db.DbRepositoryModule.create(DbRepositoryModule.java:112)
	at com.openkm.module.db.DbRepositoryModule.initialize(DbRepositoryModule.java:85)
	at com.openkm.servlet.RepositoryStartupServlet.start(RepositoryStartupServlet.java:175)
	at com.openkm.servlet.RepositoryStartupServlet.init(RepositoryStartupServlet.java:127)
	at javax.servlet.GenericServlet.init(GenericServlet.java:158)
	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1284)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1197)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1087)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5210)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5493)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1229)
	at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1875)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:745)
2015-08-18 11:38:41,161 [localhost-startStop-1] WARN  org.apache.chemistry.opencmis.server.impl.atompub.CmisAtomPubServlet- CMIS version is not defined! Setting it to CMIS 1.0.
2015-08-18 11:38:41,192 [localhost-startStop-1] INFO  org.apache.catalina.startup.HostConfig- Deploying web application directory C:\openkm-dev\tomcat-7.0.27\webapps\ROOT
2015-08-18 11:38:41,925 [main] INFO  org.apache.coyote.http11.Http11Protocol- Starting ProtocolHandler ["http-bio-127.0.0.1-8080"]
2015-08-18 11:38:41,925 [main] INFO  org.apache.coyote.ajp.AjpProtocol- Starting ProtocolHandler ["ajp-bio-127.0.0.1-8009"]
2015-08-18 11:38:41,925 [main] INFO  org.apache.catalina.startup.Catalina- Server startup in 66339 ms
2015-08-18 11:38:52,658 [http-bio-127.0.0.1-8080-exec-9] WARN  org.hibernate.util.JDBCExceptionReporter- SQL Error: 0, SQLState: null
2015-08-18 11:38:52,658 [http-bio-127.0.0.1-8080-exec-9] ERROR org.hibernate.util.JDBCExceptionReporter- Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.)
2015-08-18 11:38:52,658 [http-bio-127.0.0.1-8080-exec-9] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM].[jsp]- Servlet.service() for servlet jsp threw exception
java.net.ConnectException: Connection refused: connect
	 ...
2015-08-18 11:38:52,674 [http-bio-127.0.0.1-8080-exec-9] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM].[jsp]- Servlet.service() for servlet [jsp] in context with path [/OpenKM] threw exception [org.apache.jasper.JasperException: javax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open connection] with root cause
java.net.ConnectException: Connection refused: connect
Any help would be greatly appreciated! Thank you so much :D
 #40322  by jllort
 
If you read the README.txt file is described there that you must "start" the database before. Database is also a portable MySQL. I suppose you have forgotten this step ?
 #40324  by alexwgordon
 
Ah! Problem solved! With all my starting and stopping while I was working with the portable edition, (you were correct) that I forgot to restart MySQL :oops:

Portable edition fully working now! :) Thanks, jllort!
 #40731  by hichamo
 
​Hi,
please help me to resolve this problem,
I get this message when I run the build of OpenKM:
Code: Select all
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR] 
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException​
​thanks a lot​
 #40732  by jllort
 
I suspect the maven libraries have not been downloaded ( can take several minutes to complete downloading all project dependences ), try with :
Right click on project > Maven > Update project

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.