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 )
[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
"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
-------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
3)[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>
[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
now i don't login with okAdmin by web , reports some information for below 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
"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