Open Source Document Management System | OpenKM

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

openkm error

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

Page 1 of 1

openkm error

PostPosted:Sat Dec 18, 2010 3:51 am
by dwm123
i download OpenKM-5.0_JBoss-4.2.3.GA.zip ,
-------install openkm --------------------------------
#unzip OpenKM-5.0_JBoss-4.2.3.GA.zip
#mv jboss-4.2.3.GA /opt
[root@openkm opt]# ll
总计 4
drwxr-xr-x 9 root root 4096 12-18 11:29 jboss-4.2.3.GA
#cd jboss-4.2.3.GA/bin
#./run.sh -b 0.0.0.0
open url http://192.168.1.178:8080/OpenKM/com.op ... /index.jsp

login okAdmin password admin ,it work .i create a user terry , and create document 123, upload file install.txt (locked)
----------------------------------------------------------------------------
quesitones:
when i restart openkm, login okAdmin by web
******the user terry lost . and i can't unlock install.txt

so i want to install mysql-5 for storage user information .

1) install mysql5 (ip 192.168.1.178)
＃yum install mysql

mysql> GRANT ALL PRIVILEGES ON *.* TO 'openkm'@'localhost'

-> IDENTIFIED BY '123456' WITH GRANT OPTION;

mysql> GRANT ALL PRIVILEGES ON *.* TO 'openkm'@'%'

-> IDENTIFIED BY '123456' WITH GRANT OPTION;

2 ) configurtion repository.xml
ip 192.168.1.178 (connect internet is ok )
Code: Select all
[root@openkm jboss-4.2.3.GA]# cat repository.xml
<?xml version="1.0"?>
<Repository>
    <FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
        <param name="driver" value="com.mysql.jdbc.Driver"/>
            <param name="url" value="jdbc:mysql://192.168.1.178/openkm?autoReconnect=true"/>
            <param name="schemaObjectPrefix" value="rep_"/>
            <param name="schema" value="mysql"/>
            <param name="user" value="openkm"/>
         <param name="password" value="123456"/>
    </FileSystem>
    <Security appName="OpenKM">
      <AccessManager class="es.git.openkm.core.OKMAccessManager"/>
      <!-- <AccessManager class="org.apache.jackrabbit.core.security.SimpleAccessManager"/> -->
    </Security>
    <Workspaces rootPath="${rep.home}/workspaces" defaultWorkspace="default" />
    <Workspace name="${wsp.name}">
        <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
            <param name="path" value="${wsp.home}"/>
        </FileSystem>
        <PersistenceManager class="org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager">
           <param name="driver" value="com.mysql.jdbc.Driver"/>
            <param name="url" value="jdbc:mysql://192.168.1.178/openkm?autoReconnect=true"/>
            <param name="schemaObjectPrefix" value="${wsp.name}_"/>
            <param name="schema" value="mysql"/>
            <param name="externalBLOBs" value="false"/>
            <param name="user" value="openkm"/>
         <param name="password" value="123456"/>
        </PersistenceManager>
        <SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
            <param name="path" value="${wsp.home}/index"/>
            <param name="useCompoundFile" value="true"/>
            <param name="minMergeDocs" value="100"/>
            <param name="volatileIdleTime" value="3"/>
            <param name="maxMergeDocs" value="100000"/>
            <param name="mergeFactor" value="10"/>
            <param name="bufferSize" value="10"/>
            <param name="cacheSize" value="1000"/>
            <param name="forceConsistencyCheck" value="false"/>
            <param name="autoRepair" value="true"/>
            <param name="analyzer" value="org.apache.lucene.analysis.standard.StandardAnalyzer"/>
            <param name="respectDocumentOrder" value="false"/>
            <param name="textFilterClasses" value="
org.apache.jackrabbit.core.query.lucene.TextPlainTextFilter,
org.apache.jackrabbit.extractor.MsExcelTextExtractor,
org.apache.jackrabbit.extractor.MsPowerPointTextExtractor,
org.apache.jackrabbit.extractor.MsWordTextExtractor,
org.apache.jackrabbit.extractor.PdfTextExtractor,
org.apache.jackrabbit.extractor.HTMLTextExtractor,
org.apache.jackrabbit.extractor.XMLTextExtractor,
org.apache.jackrabbit.extractor.RTFTextExtractor,
org.apache.jackrabbit.extractor.OpenOfficeTextExtractor" />
        </SearchIndex>
    </Workspace>
    <Versioning rootPath="${rep.home}/version">
        <FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
           <param name="driver" value="com.mysql.jdbc.Driver"/>
            <param name="url" value="jdbc:mysql://192.168.1.178/openkm?autoReconnect=true"/>
            <param name="schemaObjectPrefix" value="ver_rep_"/>
            <param name="schema" value="mysql"/>
            <param name="user" value="openkm"/>
         <param name="password" value="123456"/>
       </FileSystem>
        <PersistenceManager class="org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager">
           <param name="driver" value="com.mysql.jdbc.Driver"/>
            <param name="url" value="jdbc:mysql://192.168.1.178/openkm?autoReconnect=true"/>
            <param name="schemaObjectPrefix" value="ver_"/>
            <param name="schema" value="mysql"/>
            <param name="externalBLOBs" value="false"/>
            <param name="user" value="openkm"/>
         <param name="password" value="123456"/>
        </PersistenceManager>
    </Versioning>
</Repository>
3)
[root@openkm lib]# pwd
/opt/jboss-4.2.3.GA/server/default/lib

[root@openkm lib]# ls mysql-connector-java-5.1.12-bin.jar
mysql-connector-java-5.1.12-bin.jar

4))restart openkm error
Code: Select all
org.apache.jackrabbit.core.state.ItemStateException: failed to write bundle: cafebabe-cafe-babe-cafe-babecafebabe
        at org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.store(BundleDbPersistenceManager.java:588)
        at org.apache.jackrabbit.core.state.SharedItemStateManager.createRootNodeState(SharedItemStateManager.java:1710)
        at org.apache.jackrabbit.core.state.SharedItemStateManager.<init>(SharedItemStateManager.java:204)
        at org.apache.jackrabbit.core.RepositoryImpl.createItemStateManager(RepositoryImpl.java:1353)
        at org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.doInitialize(RepositoryImpl.java:1948)
        at org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.initialize(RepositoryImpl.java:1919)
        at org.apache.jackrabbit.core.RepositoryImpl.initStartupWorkspaces(RepositoryImpl.java:489)
        at org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:330)
        at org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:627)
        at com.openkm.module.direct.DirectRepositoryModule.getRepository(DirectRepositoryModule.java:114)
        at com.openkm.util.JCRUtils$1.run(JCRUtils.java:309)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAs(Subject.java:357)
        at com.openkm.util.JCRUtils.getSession(JCRUtils.java:304)
        at com.openkm.module.direct.DirectAuthModule.login(DirectAuthModule.java:65)
        at com.openkm.api.OKMAuth.login(OKMAuth.java:52)
        at org.apache.jsp.com_openkm_frontend_Main.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:636)
Caused by: org.apache.jackrabbit.core.state.ItemStateException: failed to write bundle: cafebabe-cafe-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)
        ... 41 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL101218095250540' defined on 'DEFAULT_BUNDLE'.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source)
        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.BundleDbPersistenceManager.storeBundle(BundleDbPersistenceManager.java:1247)
        ... 45 more
Caused by: java.sql.SQLException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL101218095250540' defined on 'DEFAULT_BUNDLE'.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
        ... 59 more
Caused by: ERROR 23505: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL101218095250540' defined on 'DEFAULT_BUNDLE'.
        at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
        at org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(Unknown Source)
        at org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown Source)
        at org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown Source)
        at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown Source)
        at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown Source)
        at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source)
        at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
        at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
        at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
        ... 53 more
now i don't login with okAdmin by web , reports some information for below

"javax.jcr.RepositoryException cannot be cast to javax.jcr.LoginException"

i don't know why ?

by the way , where i can download OpenKM-4.0-JBoss-4.2.3.GA.zip or OpenKM-5-RC

thanks

Re: openkm error

PostPosted:Sun Dec 19, 2010 6:48 pm
by jllort
You can download any version from http://sourceforge.net/projects/openkm/

About your problem, consider make a fresh installation for change configuration to MySQL, because repository is only configured on first time start up ( if you want to clean an installation simply delete the repository folder that OpenKM creates the first time jboss i started at jboss_home

Re: openkm error

PostPosted:Thu Jan 20, 2011 12:35 pm
by alimalik
Help me i got an error message like this:

javax.jcr.RepositoryException cannot be cast to javax.jcr.LoginException

Re: openkm error

PostPosted:Thu Jan 20, 2011 8:57 pm
by pavila
This error:
Code: Select all
failed to write bundle: cafebabe-cafe-babe-cafe-babecafebabe
means that the repository creation process failed. Check directory permissions, repository.xml configuration, etc. Is not easy to guess with little information.
All times are UTC
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited