|
|
| (24 intermediate revisions by 3 users not shown) |
| Line 1: |
Line 1: |
| | {{TOCright}} __TOC__ | | {{TOCright}} __TOC__ |
| | | | |
| − | Download PostgreSQL JDBC driver from [http://jdbc.postgresql.org/ PostgreSQL Driver Page] and move it to ''$JBOSS_HOME/server/default/lib''. | + | Download PostgreSQL JDBC driver from [http://jdbc.postgresql.org/ PostgreSQL Driver Page] and move it to ''$JBOSS_HOME/server/default/lib'' if you have OpenKM-5.X and ''$TOMCAT_HOME/lib'' for OpenKM-6.X. |
| | | | |
| − | == Repository configuration ==
| + | {{Note|'''OpenKM 5.1.8''' has been verified to run with '''PostgreSQL 9.1''' using the JDBC driver '''postgresql-9.1-901.jdbc4.jar''' under JBoss 4.2.3.}} |
| − | <source lang="xml">
| + | |
| − | <?xml version="1.0" encoding="UTF-8"?>
| + | * [[PostgreSQL-OpenKM 6.0 | OpenKM 6.0]] (also valid for OpenKM 6.X+) |
| − | <Repository>
| + | * [[PostgreSQL-OpenKM 5.0 | OpenKM 5.0]] (also valid for OpenKM 5.X+) |
| − | <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
| + | * [[PostgreSQL-OpenKM 4.1 | OpenKM 4.1]] |
| − | <param name="path" value="${rep.home}/repository"/>
| + | |
| − | </FileSystem>
| + | If you want to obtain the maximun performance from PostgreSQL, [http://pgfouine.projects.postgresql.org/index.html pgFouine] will help in your task. |
| − | <Security appName="OpenKM">
| + | |
| − | <AccessManager class="com.openkm.core.OKMAccessManager"/>
| + | [[Category: Installation Guide]] |
| − | </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.bundle.PostgreSQLPersistenceManager">
| |
| − | <param name="driver" value="org.postgresql.Driver"/>
| |
| − | <param name="url" value="jdbc:postgresql://localhost:3306/openkm?autoReconnect=true"/>
| |
| − | <param name="schema" value="postgresql"/>
| |
| − | <param name="user" value="root"/>
| |
| − | <param name="password" value="xxx"/>
| |
| − | <param name="schemaObjectPrefix" value="${wsp.name}_"/>
| |
| − | <param name="externalBLOBs" value="false"/>
| |
| − | </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="indexingConfiguration" value="$ {wsp.home}/../../../indexing_configuration.xml"/>
| |
| − | <param name="textFilterClasses" value="
| |
| − | org.apache.jackrabbit.core.query.lucene.TextPlainTextFilter,
| |
| − | 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,
| |
| − | com.openkm.extractor.MsExcelTextExtractor,
| |
| − | com.openkm.extractor.MsPowerPointTextExtractor,
| |
| − | com.openkm.extractor.MsWordTextExtractor,
| |
| − | com.openkm.extractor.MsOffice2007TextExtractor,
| |
| − | com.openkm.extractor.ExifTextExtractor,
| |
| − | com.openkm.extractor.TiffTextExtractor,
| |
| − | com.openkm.extractor.AudioTextExtractor" />
| |
| − | </SearchIndex>
| |
| − | </Workspace>
| |
| − | <Versioning rootPath="${rep.home}/version">
| |
| − | <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
| |
| − | <param name="path" value="${rep.home}/version"/>
| |
| − | </FileSystem>
| |
| − | <PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.PostgreSQLPersistenceManager">
| |
| − | <param name="driver" value="org.postgresql.Driver"/>
| |
| − | <param name="url" value="jdbc:postgresql://localhost:3306/openkm?autoReconnect=true"/>
| |
| − | <param name="schema" value="postgresql"/>
| |
| − | <param name="user" value="root"/>
| |
| − | <param name="password" value="xxx"/>
| |
| − | <param name="schemaObjectPrefix" value="version_"/>
| |
| − | <param name="externalBLOBs" value="false"/>
| |
| − | </PersistenceManager>
| |
| − | </Versioning>
| |
| − | </Repository>
| |
| − | </source>
| |
