not able to open OpenKM software
PostPosted:Mon Apr 21, 2014 11:05 am
javax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open connection
Open Source Document Management System | OpenKM
Because information matters
https://forum.openkm.com/
not able to open OpenKM software
Page 1 of 1
Re: not able to open OpenKM software
PostPosted:Tue Apr 22, 2014 6:06 am
The more verbose and more details you provide, the better would be the community support.
Re: not able to open OpenKM software
PostPosted:Mon Jun 22, 2015 11:58 am
Hey Moderators/Developers,
I'm also suffering from the "javax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open connection" error.
Full message from Firefox 38.0.5:
Please let me know if you need any other info to assist in resolving this issue [and I can get into OpenKM again!
]
OpenKM Version: Community v6.3.0
OS: Windows 7 SP1 64bit
I'm also suffering from the "javax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open connection" error.
Full message from Firefox 38.0.5:
Code: Select all
I've attached a copy of the catalina.log file fyi.Application error
Class: org.apache.jasper.JasperException
Message: javax.servlet.ServletException: com.openkm.core.DatabaseException: Cannot open connection
Date: Mon Jun 22 19:51:32 AWST 2015Please let me know if you need any other info to assist in resolving this issue [and I can get into OpenKM again!
]OpenKM Version: Community v6.3.0
OS: Windows 7 SP1 64bit
Re: not able to open OpenKM software
PostPosted:Tue Jun 23, 2015 11:09 am
I think you've forgot to attach the catalina.log file ( please with openkm stopped, remove catalina.log file, start and when error will happening again, zip the catalina.log file an attach here ).
Re: not able to open OpenKM software
PostPosted:Wed Jun 24, 2015 9:12 am
I tried to upload the attachment and I get a yellow triangle "error" informing me that
"Sorry, the board attachment quota has been reached."
Compressed log file has been uploaded to: http://1drv.ms/1LD8H9y
Let me know once you've got the file and I will remove from OneDrive.
"Sorry, the board attachment quota has been reached."
Compressed log file has been uploaded to: http://1drv.ms/1LD8H9y
Let me know once you've got the file and I will remove from OneDrive.
Re: not able to open OpenKM software
PostPosted:Fri Jun 26, 2015 7:05 am
I suspect the cause of the problem, application can not get connection to the database, you have several error into the log file:
Code: Select all
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.deployWAR(HostConfig.java:1073)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
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(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)Code: Select all
Check your server.xml configuration, your mysql is up and you can get connection from the server.java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)Re: not able to open OpenKM software
PostPosted:Fri Jun 26, 2015 7:11 am
Can you share some screenshot of the error you get when trying to upload a file ( zip file ). Try with it http://snag.gy/
Re: not able to open OpenKM software
PostPosted:Sat Jun 27, 2015 10:16 pm
Hi jllort,
You were correct about checking server.xml. My server's IP address changed and wasn't aware of it. I've been able to get OpenKM working again Thanks!
I have uploaded a screenshot to http://snag.gy/qzyGl.jpg
You were correct about checking server.xml. My server's IP address changed and wasn't aware of it. I've been able to get OpenKM working again
Thanks!I have uploaded a screenshot to http://snag.gy/qzyGl.jpg
Re: not able to open OpenKM software
PostPosted:Sun Jun 28, 2015 2:39 pm
We will investigate the problem you have to upload files in the forum.
Re: not able to open OpenKM software
PostPosted:Mon Jun 29, 2015 10:41 am
I've raised the quota limit. Please, try again.
Re: not able to open OpenKM software
PostPosted:Thu Aug 13, 2015 2:37 am
Hi pavila,
Apologies for the delay in noticing & responding your response/request.
I've reattempted to upload the Catalina.ZIP file; this time with success! Should be attached
The key issue has been resolved and I'm presuming the file is being uploaded just as a test
Regards
Apologies for the delay in noticing & responding your response/request.
I've reattempted to upload the Catalina.ZIP file; this time with success! Should be attached
The key issue has been resolved and I'm presuming the file is being uploaded just as a test
Regards
Re: not able to open OpenKM software
PostPosted:Thu Aug 13, 2015 10:31 am
Seems you're getting problems connecting with database, see:
- try to connect from the same openkm server using the credential at server.xml
- ensure you have not firewalled the connection or similar.
Code: Select all
- check is mysql is upCaused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.- try to connect from the same openkm server using the credential at server.xml
- ensure you have not firewalled the connection or similar.