Login failed

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.
perdix
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: Thu Jun 21, 2012 8:08 pm

Login failed

Post by perdix » Mon Jun 25, 2012 2:22 pm

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

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

Re: Login failed

Post by jllort » Wed Jun 27, 2012 11:10 am

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

itiec
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: Mon Sep 24, 2012 9:33 am

Re: Login failed

Post by itiec » Mon Sep 24, 2012 12:53 pm

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

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

Re: Login failed

Post by jllort » Tue Sep 25, 2012 6:09 pm

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 ?

kumbulanit
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: Thu Feb 20, 2014 7:17 am

Re: Login failed

Post by kumbulanit » Tue Feb 25, 2014 10:00 am

i am on open km 6.0 and also experiencing this message when i try and access the application

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

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

Re: Login failed

Post by jllort » Thu Feb 27, 2014 9:29 pm

You got version 6 in production and then you get this error or is clean instalallation ?

kumbulanit
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: Thu Feb 20, 2014 7:17 am

Re: Login failed

Post by kumbulanit » Mon Mar 03, 2014 7:19 am

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

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

Re: Login failed

Post by jllort » Tue Mar 04, 2014 6:01 pm

stop tomcat
remove all log files
start tomcat and try login
stop tomcat and share here the log

jimac
Expert Boarder
Expert Boarder
Posts: 89
Joined: Thu Dec 01, 2016 4:01 am

Re: Login failed

Post by jimac » Thu Nov 09, 2017 6:19 am

I'm having the same problem here. Any solutions already?

jimac
Expert Boarder
Expert Boarder
Posts: 89
Joined: Thu Dec 01, 2016 4:01 am

Re: Login failed

Post by jimac » Thu Nov 09, 2017 6:21 am

I'm having the same problem. Any solutions in this topic already?

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

Re: Login failed

Post by jllort » Fri Nov 10, 2017 7:32 pm

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 ?

jimac
Expert Boarder
Expert Boarder
Posts: 89
Joined: Thu Dec 01, 2016 4:01 am

Re: Login failed

Post by jimac » Thu Nov 16, 2017 1:28 am

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.

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

Re: Login failed

Post by jllort » Fri Nov 17, 2017 8:45 am

What is the content of your OpenKM.cfg ( the file is into tomcat folder ). I suspect is not able to connect to the database.

jimac
Expert Boarder
Expert Boarder
Posts: 89
Joined: Thu Dec 01, 2016 4:01 am

Re: Login failed

Post by jimac » Mon Nov 20, 2017 9:03 am

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

jimac
Expert Boarder
Expert Boarder
Posts: 89
Joined: Thu Dec 01, 2016 4:01 am

Re: Login failed

Post by jimac » Mon Nov 20, 2017 9:11 am

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.

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest