Page 1 of 2

Login failed

Posted: Mon Jun 25, 2012 2:22 pm
by perdix
Hi Guys

I just did a fresh install of OpenKM 6.0 Professional Trail on Ubuntu 12.04 server. The installation went well and I could start using the system immediated. I created some profiles, users and uploaded all my documents all without problems.

I then decided to reboot the server to ensure that everything is working correctly. I'm now simply greated with with following message (I'm not even asked for a username and password):

Code: Select all

  Application error
  Class:	javax.servlet.ServletException
  Message:	com.openkm.core.DatabaseException: could not execute query
  Date:	Mon Jun 25 15:58:15 SAST 2012
  [Return]
I looked in the logs, specifically this file: /opt/openkm-6.0/tomcat/logs/localhost.log
I found the following interesting entry:

Code: Select all

2012-06-25 15:58:15,652 [http-bio-8080-exec-7] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM].[jsp] - Servlet.service() for servlet [jsp] in context with path [/OpenKM] threw exception [javax.servlet.ServletException: com.openkm.core.DatabaseException: could not execute query] with root cause
org.hsqldb.HsqlException: user lacks privilege or object not found: OKM_LANGUAGE
Any advice?

Regards
Charl

Re: Login failed

Posted: Wed Jun 27, 2012 11:10 am
by jllort
seems grants privileges I see this kind of error when you execute as root and then try as normal user.

Try sudo chown -Rf user:user openkm-6.0.0

Tell us if it solves the problem

Re: Login failed

Posted: Mon Sep 24, 2012 12:53 pm
by itiec
Got the same error.
Fresh install of OS, it works fine. i shut it down and when i start it, got this error.
using OpenKM Pro 6.0.1. Linux x64 platform
some okmdb files are created: .log, .script and .properties

any idea ?
thks

Re: Login failed

Posted: Tue Sep 25, 2012 6:09 pm
by jllort
It think is a security problem of the user who's creating the database or which you're starting the application. Always are you starting the application on the same way ?

Re: Login failed

Posted: Tue Feb 25, 2014 10:00 am
by kumbulanit
i am on openkm 6.0 and also experiencing this message when i try and access the application

Code: Select all

Application error

Class:	org.apache.jasper.JasperException
Message:	javax.servlet.ServletException: com.openkm.core.DatabaseException: could not execute query
Date:	Tue Feb 25 09:36:15 SAST 2014
i checked the log file and it gave me an error with OKM_LANGUAGE

how can i solve this

Re: Login failed

Posted: Thu Feb 27, 2014 9:29 pm
by jllort
You got version 6 in production and then you get this error or is clean instalallation ?

Re: Login failed

Posted: Mon Mar 03, 2014 7:19 am
by kumbulanit
jllort wrote:You got version 6 in production and then you get this error or is clean instalallation ?
i have it production and i am getting that error

Re: Login failed

Posted: Tue Mar 04, 2014 6:01 pm
by jllort
stop tomcat
remove all log files
start tomcat and try login
stop tomcat and share here the log

Re: Login failed

Posted: Thu Nov 09, 2017 6:19 am
by jimac
I'm having the same problem here. Any solutions already?

Re: Login failed

Posted: Thu Nov 09, 2017 6:21 am
by jimac
I'm having the same problem. Any solutions in this topic already?

Re: Login failed

Posted: Fri Nov 10, 2017 7:32 pm
by jllort
What OpenKM version did you have installed ?
How did you installed ? with the wizard as is shown in our video https://www.youtube.com/watch?v=7C40UMajJ0k ?

Re: Login failed

Posted: Thu Nov 16, 2017 1:28 am
by jimac
Hi!

It was installed last January, it's a OpenKM 6.3.2 It was a task that is assigned to me to repair this kind of error.

Re: Login failed

Posted: Fri Nov 17, 2017 8:45 am
by jllort
What is the content of your OpenKM.cfg ( the file is into tomcat folder ). I suspect is not able to connect to the database.

Re: Login failed

Posted: Mon Nov 20, 2017 9:03 am
by jimac
Good Day!

Here's my OpenKM.cfg

Code: Select all

# OpenKM Hibernate configuration values
hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
hibernate.hbm2ddl=none

# Initial configuration - Linux
system.imagemagick.convert=/usr/bin/convert
system.openoffice.path=/usr/lib/libreoffice
system.swftools.pdf2swf=/opt/openkm/bin/pdf2swf -f -T 9 -t -s storeallcharacters ${fileIn} -o ${fileOut}

# Initial configuration - Windows
#system.imagemagick.convert=C:/openkm/bin/convert.exe
#system.openoffice.path=C:/Program Files (x86)/OpenOffice 4
#system.swftools.pdf2swf=C:/openkm/bin/pdf2swf.exe -f -T 9 -t -s storeallcharacters ${fileIn} -o ${fileOut}
Thank You in Advance

Re: Login failed

Posted: Mon Nov 20, 2017 9:11 am
by jimac
On the last part of my Catalina.log is this:

Code: Select all

2017-11-20 17:05:24,273 [localhost-startStop-1] INFO  com.openkm.util.FormUtils$LocalResolver- registerDTD(-//OpenKM//DTD Workflow Forms 2.3//EN, /home/dmsserver/openkm-6.3.2-community/tomcat/webapps/OpenKM/WEB-INF/classes/dtd/workflow-forms-2.3.dtd)
2017-11-20 17:05:24,274 [localhost-startStop-1] INFO  com.openkm.util.FormUtils$LocalResolver- resolveEntity(publicId=-//OpenKM//DTD Property Groups 2.1//EN, systemId=http://www.openkm.com/dtd/property-groups-2.1.dtd) => /home/dmsserver/openkm-6.3.2-community/tomcat/webapps/OpenKM/WEB-INF/classes/dtd/property-groups-2.1.dtd
2017-11-20 17:05:24,378 [localhost-startStop-1] WARN  org.hibernate.util.JDBCExceptionReporter- SQL Error: -5501, SQLState: 42501
2017-11-20 17:05:24,379 [localhost-startStop-1] ERROR org.hibernate.util.JDBCExceptionReporter- user lacks privilege or object not found: OKM_DB_METADATA_TYPE
2017-11-20 17:05:24,385 [localhost-startStop-1] ERROR com.openkm.bean.form.Select- Unable to get key values for Select
com.openkm.core.DatabaseException: could not execute query
	at com.openkm.dao.DatabaseMetadataDAO.findAllTypes(DatabaseMetadataDAO.java:377)
	at com.openkm.util.DatabaseMetadataUtils.replaceVirtual(DatabaseMetadataUtils.java:250)
	at com.openkm.util.DatabaseMetadataUtils.replaceVirtual(DatabaseMetadataUtils.java:236)
	at com.openkm.dao.KeyValueDAO.getKeyValues(KeyValueDAO.java:78)
	at com.openkm.dao.KeyValueDAO.getKeyValues(KeyValueDAO.java:91)
	at com.openkm.bean.form.Select.getOptionsFromDb(Select.java:197)
	at com.openkm.bean.form.Select.handleDbOptions(Select.java:160)
	at com.openkm.bean.form.Select.setOptions(Select.java:61)
	at com.openkm.util.FormUtils.parseField(FormUtils.java:553)
	at com.openkm.util.FormUtils.parsePropertyGroupsForms(FormUtils.java:198)
	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.deployWAR(HostConfig.java:1073)
	at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
	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: org.hibernate.exception.SQLGrammarException: could not execute query
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.loader.Loader.doList(Loader.java:2545)
	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.DatabaseMetadataDAO.findAllTypes(DatabaseMetadataDAO.java:371)
	... 27 more
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: OKM_DB_METADATA_TYPE
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
	at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
	at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
	at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
	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)
	... 35 more
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: OKM_DB_METADATA_TYPE
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.SchemaManager.getTable(Unknown Source)
	at org.hsqldb.ParserDQL.readTableName(Unknown Source)
	at org.hsqldb.ParserDQL.readTableOrSubquery(Unknown Source)
	at org.hsqldb.ParserDQL.XreadTableReference(Unknown Source)
	at org.hsqldb.ParserDQL.XreadFromClause(Unknown Source)
	at org.hsqldb.ParserDQL.XreadTableExpression(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQuerySpecification(Unknown Source)
	at org.hsqldb.ParserDQL.XreadSimpleTable(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryExpression(Unknown Source)
	at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
	at org.hsqldb.ParserCommand.compilePart(Unknown Source)
	at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
	at org.hsqldb.Session.compileStatement(Unknown Source)
	at org.hsqldb.StatementManager.compile(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 46 more
2017-11-20 17:05:24,398 [localhost-startStop-1] WARN  org.hibernate.util.JDBCExceptionReporter- SQL Error: -5501, SQLState: 42501
2017-11-20 17:05:24,398 [localhost-startStop-1] ERROR org.hibernate.util.JDBCExceptionReporter- user lacks privilege or object not found: OKM_DB_METADATA_TYPE
2017-11-20 17:05:24,398 [localhost-startStop-1] ERROR com.openkm.bean.form.Select- Unable to get key values for Select
com.openkm.core.DatabaseException: could not execute query
	at com.openkm.dao.DatabaseMetadataDAO.findAllTypes(DatabaseMetadataDAO.java:377)
	at com.openkm.util.DatabaseMetadataUtils.replaceVirtual(DatabaseMetadataUtils.java:250)
	at com.openkm.util.DatabaseMetadataUtils.replaceVirtual(DatabaseMetadataUtils.java:236)
	at com.openkm.dao.KeyValueDAO.getKeyValues(KeyValueDAO.java:78)
	at com.openkm.dao.KeyValueDAO.getKeyValues(KeyValueDAO.java:91)
	at com.openkm.bean.form.Select.getOptionsFromDb(Select.java:197)
	at com.openkm.bean.form.Select.handleDbOptions(Select.java:160)
	at com.openkm.bean.form.Select.setOptions(Select.java:61)
	at com.openkm.util.FormUtils.parseField(FormUtils.java:553)
	at com.openkm.util.FormUtils.parsePropertyGroupsForms(FormUtils.java:198)
	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.deployWAR(HostConfig.java:1073)
	at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
	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: org.hibernate.exception.SQLGrammarException: could not execute query
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.loader.Loader.doList(Loader.java:2545)
	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.DatabaseMetadataDAO.findAllTypes(DatabaseMetadataDAO.java:371)
	... 27 more
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: OKM_DB_METADATA_TYPE
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
	at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
	at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
	at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
	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)
	... 35 more
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: OKM_DB_METADATA_TYPE
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.SchemaManager.getTable(Unknown Source)
	at org.hsqldb.ParserDQL.readTableName(Unknown Source)
	at org.hsqldb.ParserDQL.readTableOrSubquery(Unknown Source)
	at org.hsqldb.ParserDQL.XreadTableReference(Unknown Source)
	at org.hsqldb.ParserDQL.XreadFromClause(Unknown Source)
	at org.hsqldb.ParserDQL.XreadTableExpression(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQuerySpecification(Unknown Source)
	at org.hsqldb.ParserDQL.XreadSimpleTable(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryExpression(Unknown Source)
	at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
	at org.hsqldb.ParserCommand.compilePart(Unknown Source)
	at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
	at org.hsqldb.Session.compileStatement(Unknown Source)
	at org.hsqldb.StatementManager.compile(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 46 more
2017-11-20 17:05:24,402 [localhost-startStop-1] WARN  org.hibernate.util.JDBCExceptionReporter- SQL Error: -5501, SQLState: 42501
2017-11-20 17:05:24,402 [localhost-startStop-1] ERROR org.hibernate.util.JDBCExceptionReporter- user lacks privilege or object not found: OKM_DB_METADATA_TYPE
2017-11-20 17:05:24,402 [localhost-startStop-1] ERROR com.openkm.bean.form.Select- Unable to get key values for Select
com.openkm.core.DatabaseException: could not execute query
	at com.openkm.dao.DatabaseMetadataDAO.findAllTypes(DatabaseMetadataDAO.java:377)
	at com.openkm.util.DatabaseMetadataUtils.replaceVirtual(DatabaseMetadataUtils.java:250)
	at com.openkm.util.DatabaseMetadataUtils.replaceVirtual(DatabaseMetadataUtils.java:236)
	at com.openkm.dao.KeyValueDAO.getKeyValues(KeyValueDAO.java:78)
	at com.openkm.dao.KeyValueDAO.getKeyValues(KeyValueDAO.java:91)
	at com.openkm.bean.form.Select.getOptionsFromDb(Select.java:197)
	at com.openkm.bean.form.Select.handleDbOptions(Select.java:160)
	at com.openkm.bean.form.Select.setOptions(Select.java:61)
	at com.openkm.util.FormUtils.parseField(FormUtils.java:553)
	at com.openkm.util.FormUtils.parsePropertyGroupsForms(FormUtils.java:198)
	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.deployWAR(HostConfig.java:1073)
	at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
	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: org.hibernate.exception.SQLGrammarException: could not execute query
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.loader.Loader.doList(Loader.java:2545)
	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.DatabaseMetadataDAO.findAllTypes(DatabaseMetadataDAO.java:371)
	... 27 more
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: OKM_DB_METADATA_TYPE
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
	at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
	at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
	at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
	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)
	... 35 more
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: OKM_DB_METADATA_TYPE
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.SchemaManager.getTable(Unknown Source)
	at org.hsqldb.ParserDQL.readTableName(Unknown Source)
	at org.hsqldb.ParserDQL.readTableOrSubquery(Unknown Source)
	at org.hsqldb.ParserDQL.XreadTableReference(Unknown Source)
	at org.hsqldb.ParserDQL.XreadFromClause(Unknown Source)
	at org.hsqldb.ParserDQL.XreadTableExpression(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQuerySpecification(Unknown Source)
	at org.hsqldb.ParserDQL.XreadSimpleTable(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryExpression(Unknown Source)
	at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
	at org.hsqldb.ParserCommand.compilePart(Unknown Source)
	at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
	at org.hsqldb.Session.compileStatement(Unknown Source)
	at org.hsqldb.StatementManager.compile(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 46 more
2017-11-20 17:05:24,442 [localhost-startStop-1] INFO  com.openkm.servlet.RepositoryStartupServlet- *** Initialize language detection engine... ***
2017-11-20 17:05:24,812 [localhost-startStop-1] WARN  org.hibernate.util.JDBCExceptionReporter- SQL Error: -5501, SQLState: 42501
2017-11-20 17:05:24,812 [localhost-startStop-1] ERROR org.hibernate.util.JDBCExceptionReporter- user lacks privilege or object not found: OKM_CONFIG
2017-11-20 17:05:24,812 [localhost-startStop-1] ERROR com.openkm.core.Config- ** Error reading configuration table **
2017-11-20 17:05:24,813 [localhost-startStop-1] INFO  com.openkm.servlet.RepositoryStartupServlet- *** Repository initializing... ***
2017-11-20 17:05:24,825 [localhost-startStop-1] WARN  org.hibernate.util.JDBCExceptionReporter- SQL Error: -5501, SQLState: 42501
2017-11-20 17:05:24,825 [localhost-startStop-1] ERROR org.hibernate.util.JDBCExceptionReporter- user lacks privilege or object not found: OKM_NODE_BASE
2017-11-20 17:05:24,825 [localhost-startStop-1] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM]- Servlet /OpenKM threw load() exception
org.hsqldb.HsqlException: user lacks privilege or object not found: OKM_NODE_BASE
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.SchemaManager.getTable(Unknown Source)
	at org.hsqldb.ParserDQL.readTableName(Unknown Source)
	at org.hsqldb.ParserDQL.readTableOrSubquery(Unknown Source)
	at org.hsqldb.ParserDQL.XreadTableReference(Unknown Source)
	at org.hsqldb.ParserDQL.XreadFromClause(Unknown Source)
	at org.hsqldb.ParserDQL.XreadTableExpression(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQuerySpecification(Unknown Source)
	at org.hsqldb.ParserDQL.XreadSimpleTable(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryExpression(Unknown Source)
	at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
	at org.hsqldb.ParserCommand.compilePart(Unknown Source)
	at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
	at org.hsqldb.Session.compileStatement(Unknown Source)
	at org.hsqldb.StatementManager.compile(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
	at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
	at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
	at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
	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:261)
	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.deployWAR(HostConfig.java:1073)
	at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
	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)
2017-11-20 17:05:24,919 [localhost-startStop-1] WARN  org.apache.chemistry.opencmis.server.impl.atompub.CmisAtomPubServlet- CMIS version is not defined! Setting it to CMIS 1.0.
2017-11-20 17:05:24,956 [localhost-startStop-1] INFO  org.apache.catalina.startup.HostConfig- Deploying web application directory /home/dmsserver/openkm-6.3.2-community/tomcat/webapps/ROOT
2017-11-20 17:05:25,803 [main] INFO  org.apache.coyote.http11.Http11Protocol- Starting ProtocolHandler ["http-bio-0.0.0.0-8080"]
2017-11-20 17:05:25,825 [main] INFO  org.apache.coyote.ajp.AjpProtocol- Starting ProtocolHandler ["ajp-bio-127.0.0.1-8109"]
2017-11-20 17:05:25,847 [main] INFO  org.apache.catalina.startup.Catalina- Server startup in 42418 ms
2017-11-20 17:05:26,353 [http-bio-0.0.0.0-8080-exec-1] INFO  org.springframework.beans.factory.xml.XmlBeanDefinitionReader- Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
2017-11-20 17:05:26,436 [http-bio-0.0.0.0-8080-exec-1] INFO  org.springframework.jdbc.support.SQLErrorCodesFactory- SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
2017-11-20 17:05:26,443 [http-bio-0.0.0.0-8080-exec-1] INFO  org.apache.cxf.phase.PhaseInterceptorChain- Application {http://ws.openkm.com}OKMAuth#{http://ws.openkm.com}login has thrown exception, unwinding now: com.openkm.core.AccessDeniedException: PreparedStatementCallback; bad SQL grammar [select usr_id, usr_password, 1 from OKM_USER where usr_id=? and usr_active=T]; nested exception is java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: OKM_USER
2017-11-20 17:05:47,148 [http-bio-0.0.0.0-8080-exec-2] INFO  org.apache.cxf.phase.PhaseInterceptorChain- Application {http://ws.openkm.com}OKMAuth#{http://ws.openkm.com}login has thrown exception, unwinding now: com.openkm.core.AccessDeniedException: PreparedStatementCallback; bad SQL grammar [select usr_id, usr_password, 1 from OKM_USER where usr_id=? and usr_active=T]; nested exception is java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: OKM_USER
2017-11-20 17:06:47,332 [http-bio-0.0.0.0-8080-exec-3] INFO  org.apache.cxf.phase.PhaseInterceptorChain- Application {http://ws.openkm.com}OKMAuth#{http://ws.openkm.com}login has thrown exception, unwinding now: com.openkm.core.AccessDeniedException: PreparedStatementCallback; bad SQL grammar [select usr_id, usr_password, 1 from OKM_USER where usr_id=? and usr_active=T]; nested exception is java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: OKM_USER
2017-11-20 17:07:47,537 [http-bio-0.0.0.0-8080-exec-4] INFO  org.apache.cxf.phase.PhaseInterceptorChain- Application {http://ws.openkm.com}OKMAuth#{http://ws.openkm.com}login has thrown exception, unwinding now: com.openkm.core.AccessDeniedException: PreparedStatementCallback; bad SQL grammar [select usr_id, usr_password, 1 from OKM_USER where usr_id=? and usr_active=T]; nested exception is java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: OKM_USER
Thank You.