Open Source Document Management System | OpenKM

Because information matters
https://forum.openkm.com/

Problems with 5.1.3

https://forum.openkm.com/viewtopic.php?t=5144

Page 1 of 2

Problems with 5.1.3

PostPosted:Mon May 09, 2011 3:39 pm
by gvillaran
hi, i erased 5.0.4 and installed OpenKm 5.1.3 and i have some problems that i didnt have with 5.0.4 :

1. You cant login to the system if i dont have admin role.
2. You cant Preview files anymore, it always show "Preview unavailable"
3. You cant assign permissions by group only by user (Groups dont show in the security window)

i tried to post the entire config but i couldnt cause something saying that my post looked as spam, so i tried attaching the config as a txt
or doc and wont let me either, what kind of file i can attach?

i run OpenKm with Ubuntu 10.02 64bits.

* BTW everything was fine in 5.0.4, the only thing i found in this version is that the preview sometimes cant show certain files, but thats it.

Re: Problems with 5.1.3

PostPosted:Tue May 10, 2011 7:50 pm
by pavila
The OpenKM 5.0.4 to 5.1.3 transition can't be performed only replacing the WAR. Have you downloaded the JBoss + OpenKM bundle? Note also that OpenKM.cfg only is user for basic database configuration. The configuration now is manager from the administration tab.

Note: Try to attach a zip archive.

Re: Problems with 5.1.3

PostPosted:Mon May 16, 2011 5:48 am
by joako
I had a similar issue, like the pdf2swf path was hardcoded.

So I saw the error, and created a symlink of where OpenKM thinks pdf2swf is to where it actually is.

But another issue I have is the scrolling in the PDF previews doesn't work. If you scroll the preview goes blank.

Re: Problems with 5.1.3

PostPosted:Mon May 16, 2011 2:08 pm
by jllort
about scroll preview ... which browser version are you using ?

Re: Problems with 5.1.3

PostPosted:Tue May 17, 2011 4:28 am
by joako
Firefox 4.

Also for the preview, it seems the first used value from OpenKM.cfg is imported into the database? Because under administration I see this configurable.

Re: Problems with 5.1.3

PostPosted:Thu May 19, 2011 1:43 pm
by pavila
Some configuration values get the default values from OpenKM.cfg but once the database is created, the only can be modified from administration.

Re: Problems with 5.1.3

PostPosted:Thu May 19, 2011 2:48 pm
by kizs
I did a fresh install of 5.1.3 on Oracle 11g and i can't login because got this error message: "java.lang.ClassCastException: javax.jcr.RepositoryException cannot be cast to javax.jcr.LoginException".

Got this error when I try okmAdmin/admin, with wrong username or password I got normally "Authentication error".

log file:
Code: Select all
org.apache.jackrabbit.core.state.ItemStateException: failed to write bundle: deadbeef-face-babe-cafe-babecafebabe
        at org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.store(BundleDbPersistenceManager.java:588)
        at org.apache.jackrabbit.core.version.VersionManagerImpl.<init>(VersionManagerImpl.java:153)
        at org.apache.jackrabbit.core.RepositoryImpl.createVersionManager(RepositoryImpl.java:469)
        at org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:319)
        at org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:627)
        at com.openkm.module.direct.DirectRepositoryModule.getRepository(DirectRepositoryModule.java:112)
        at com.openkm.util.JCRUtils$1.run(JCRUtils.java:342)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAs(Subject.java:337)
        at com.openkm.util.JCRUtils.getSession(JCRUtils.java:337)
        at com.openkm.module.direct.DirectAuthModule.login(DirectAuthModule.java:65)
        at com.openkm.api.OKMAuth.login(OKMAuth.java:52)
        at org.apache.jsp.frontend.index_jsp._jspService(index_jsp.java:59)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:336)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
        at java.lang.Thread.run(Thread.java:662)
Caused by: org.apache.jackrabbit.core.state.ItemStateException: failed to write bundle: deadbeef-face-babe-cafe-babecafebabe
        at org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.storeBundle(BundleDbPersistenceManager.java:1251)
        at org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.putBundle(AbstractBundlePersistenceManager.java:711)
        at org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.storeInternal(AbstractBundlePersistenceManager.java:651)
        at org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.store(AbstractBundlePersistenceManager.java:515)
        at org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.store(BundleDbPersistenceManager.java:568)
        ... 37 more
Caused by: java.lang.IllegalStateException: Unable to insert index for string: versionStorage
        at org.apache.jackrabbit.core.persistence.bundle.util.NGKDbNameIndex.insertString(NGKDbNameIndex.java:63)
        at org.apache.jackrabbit.core.persistence.bundle.util.DbNameIndex.stringToIndex(DbNameIndex.java:98)
        at org.apache.jackrabbit.core.persistence.bundle.util.BundleBinding.writeBundle(BundleBinding.java:270)
        at org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.storeBundle(BundleDbPersistenceManager.java:1242)
        ... 41 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: Az üres (NULL) ide nem szúrható be: ("OPENKM"."VERSION_NAMES"."ID")

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1008)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
        at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
        at org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmtInternal(ConnectionRecoveryManager.java:371)
        at org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmtInternal(ConnectionRecoveryManager.java:298)
        at org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmt(ConnectionRecoveryManager.java:261)
        at org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmt(ConnectionRecoveryManager.java:239)
        at org.apache.jackrabbit.core.persistence.bundle.util.NGKDbNameIndex.insertString(NGKDbNameIndex.java:61)
        ... 44 more

Re: Problems with 5.1.3

PostPosted:Fri May 20, 2011 7:25 am
by pavila
There was an error in initial repository creation. Stop JBoss, clean database, delete $JBOSS_HOME/repository folder and start JBoss again.

Re: Problems with 5.1.3

PostPosted:Fri May 20, 2011 8:50 am
by kizs
pavila wrote:There was an error in initial repository creation. Stop JBoss, clean database, delete $JBOSS_HOME/repository folder and start JBoss again.
Ok, working, but found these errors in server.log:
Code: Select all
2011-05-20 10:52:28,223 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] schema export unsuccessful
org.hibernate.JDBCException: Error during import script execution at line 1823
	at org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:332)
	at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:264)
	at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:211)
	at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:353)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1341)
	at com.openkm.dao.HibernateUtil.getSessionFactory(HibernateUtil.java:77)
	at com.openkm.dao.HibernateUtil.getSessionFactory(HibernateUtil.java:62)
	at com.openkm.dao.ConfigDAO.getProperty(ConfigDAO.java:150)
	at com.openkm.dao.ConfigDAO.getBoolean(ConfigDAO.java:193)
	at com.openkm.core.Config.reload(Config.java:567)
	at com.openkm.core.Config.load(Config.java:553)
	at com.openkm.servlet.RepositoryStartupServlet.init(RepositoryStartupServlet.java:86)
        ...
Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "NOW": érvénytelen azonosító

	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
Code: Select all
2011-05-20 11:01:33,676 WARN  [org.apache.jackrabbit.core.query.lucene.JackrabbitTextExtractor] Extractor class not found: com.openkm.extractor.TiffTextExtractor
java.lang.ClassNotFoundException: com.openkm.extractor.TiffTextExtractor
	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1358)
	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1204)
	at java.lang.Class.forName0(Native Method)
        ...
Code: Select all
2011-05-20 11:01:33,686 WARN  [org.apache.jackrabbit.core.query.lucene.SearchIndex] Exception initializing indexing configuration from: /opt/OpenKM/repository/workspaces/default/../../../indexing_configuration.xml
org.apache.jackrabbit.spi.commons.conversion.IllegalNameException: Internal error.: Unknown namespace URI: http://www.openkm.org/1.0: Namespace not registered: http://www.openkm.org/1.0: Unknown namespace URI: http://www.openkm.org/1.0: Namespace not registered: http://www.openkm.org/1.0: Namespace not registered: http://www.openkm.org/1.0
	at org.apache.jackrabbit.core.query.lucene.AbstractNamespaceMappings.translateName(AbstractNamespaceMappings.java:55)
	at org.apache.jackrabbit.core.query.lucene.IndexingConfigurationImpl.init(IndexingConfigurationImpl.java:165)
	at org.apache.jackrabbit.core.query.lucene.SearchIndex.createIndexingConfiguration(SearchIndex.java:1067)
	at org.apache.jackrabbit.core.query.lucene.SearchIndex.doInit(SearchIndex.java:499)
	at org.apache.jackrabbit.core.query.AbstractQueryHandler.init(AbstractQueryHandler.java:66)
        ...

Re: Problems with 5.1.3

PostPosted:Fri May 20, 2011 9:04 pm
by joako
pavila wrote:Some configuration values get the default values from OpenKM.cfg but once the database is created, the only can be modified from administration.

This I never know. It explains some issues. Maybe in the next release in OpenKM.cfg you can put a comment that notes that?

Re: Problems with 5.1.3

PostPosted:Sun May 22, 2011 6:42 am
by jllort
The relevant error is, don't worry for others.
Code: Select all
2011-05-20 10:52:28,223 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] schema export unsuccessful
org.hibernate.JDBCException: Error during import script execution at line 1823
   at org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:332)
   at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:264)
Here indicates de import.sql has not been executed totally. You might take a look where has been stopped. Into OpenKM.war /WEB-INF/import.sql

Re: Problems with 5.1.3

PostPosted:Mon May 23, 2011 11:22 pm
by gvillaran
Ok i confifured the preview thing in the web admin page and is working now, now how can i check this other two:

1. You cant login to the system if i dont have admin role.
2. You cant assign permissions by group only by user (Groups dont show in the security window)

i have no errors starting the program i saw some warnings but no errors.

the file i downloaded is the one that downloads with the link that is in the first page, is called OpenKM-5.1.3_JBoss-4.2.3.GA

im dowloading the 5.1.4 and will do a fresh install to see if the same happens

Thanks for the help

Re: Problems with 5.1.3

PostPosted:Tue May 24, 2011 1:25 am
by mossimo32001
There's also some discrepancy in preview, watch out for my post.

Re: Problems with 5.1.3

PostPosted:Tue May 24, 2011 7:46 pm
by gvillaran
5.1.4 is working pretty good, no problems even with groups, 5.1.3 have some issues it seems.

Re: Problems with 5.1.3

PostPosted:Sat May 28, 2011 10:05 am
by jllort
hi gvillaran all users need have AdminRole or UserRole ( that are used as connection grants ). UserRole must not be propagated to repository because all users have it, the idea is that a user haver UserRole and other roles, these are really propagated but not UserRole
All times are UTC
Page 1 of 2
Powered by phpBB® Forum Software © phpBB Limited