• Question about integrate PostgreSQL with OpenKM

  • OpenKM has many interesting features, but requires some configuration process to show its full potential.
OpenKM has many interesting features, but requires some configuration process to show its full potential.
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.
 #950  by hbcomcn
 
I hade modify file \'repository.xml\' according with FAQ:

//code//
<?xml version=\"1.0\"?>
<Repository>
<FileSystem class=\"org.apache.jackrabbit.core.fs.local.LocalFileSystem\">
<param name=\"path\" value=\"${rep.home}/repository\"/>
</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.db.DbFileSystem\">
<param name=\"driver\" value=\"org.postgresql.Driver\"/>
<param name=\"url\" value=\"jdbc:postgresql://localhost/test\"/>
<param name=\"schema\" value=\"postgresql\"/>
<param name=\"user\" value=\"postgres\"/>
<param name=\"password\" value=\"111111\"/>
<param name=\"schemaObjectPrefix\" value=\"rep_\"/>
</FileSystem>
<PersistenceManager class=\"org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager\">
<param name=\"driver\" value=\"org.postgresql.Driver\"/>
<param name=\"url\" value=\"jdbc:postgresql://localhost/test\"/>
<param name=\"schema\" value=\"postgresql\"/>
<param name=\"user\" value=\"postgres\"/>
<param name=\"password\" value=\"111111\"/>
<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=\"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=\"org.postgresql.Driver\"/>
<param name=\"url\" value=\"jdbc:postgresql://localhost/test\"/>
<param name=\"schema\" value=\"postgresql\"/>
<param name=\"user\" value=\"postgres\"/>
<param name=\"password\" value=\"111111\"/>
<param name=\"schemaObjectPrefix\" value=\"rep_\"/>
</FileSystem>
<PersistenceManager class=\"org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager\">
<param name=\"driver\" value=\"org.postgresql.Driver\"/>
<param name=\"url\" value=\"jdbc:postgresql://localhost/test\"/>
<param name=\"schema\" value=\"postgresql\"/>
<param name=\"user\" value=\"postgres\"/>
<param name=\"password\" value=\"111111\"/>
<param name=\"schemaObjectPrefix\" value=\"${wsp.name}_\"/>
<param name=\"externalBLOBs\" value=\"false\"/>
</PersistenceManager>
</Versioning>
</Repository>
////////

I had created a database \'test\' in PostgreSQL, when I log in I got the error:\"Replacement not found for ${wsp.name}.\"
I am not about the meaning of some sessions which I had tabed red, hope somebody could help me, thanks!!!
(I had put the JDBC file of PostgreSQL \'postgresql-8.3-603.jdbc2.jar\', \'postgresql-8.3-603.jdbc2ee.jar\', \'postgresql-8.3-603.jdbc3.jar\' and \'postgresql-8.3-603.jdbc4.jar\' in folder \\OpenKM-2.0_JBoss-4.2.2.GA\\server\\default\\lib, do I need to change their name?)

the server log: [file name=server-edb0dc10a1693f0eb87b5ea4d62a36ee.zip size=70109]http://www.openkm.com/images/fbfiles/fi ... 2a36ee.zip[/file]
 #951  by jllort
 
You must only put one driver not two.

And restart jboss because the jar files on server/default/lib are not refreshing automatically by jboss, only when starting service.
 #952  by hbcomcn
 
the config file is correct yes?
jllort wrote:You must only put one driver not two.

And restart jboss because the jar files on server/default/lib are not refreshing automatically by jboss, only when starting service.
 #953  by hbcomcn
 
Hello jllort

I only put \'postgresql-8.3-603.jdbc3.jar\' in the \'lib\' folder
and restart the service but still the same problem,

I have such questionss:
1)is the config file correct?
what should be in the session "<param name="url" value="jdbc:postgresql://132.205.28.59/OpenKM"/>"?
2)I put jdbc in the \'lib\' folder and then start the service, anything else to be done?
3)nomally what kind of problem for this error:"Replacement not found for ${wsp.name}."

Thanks!!!
jllort wrote:You must only put one driver not two.

And restart jboss because the jar files on server/default/lib are not refreshing automatically by jboss, only when starting service.
 #954  by pavila
 
try
Code: Select all
<?xml version=\"1.0\"?>
<Repository>
  <FileSystem class=\"org.apache.jackrabbit.core.fs.local.LocalFileSystem\">
    <param name=\"path\" value=\"${rep.home}/repository\"/>
  </FileSystem>
  <Security appName=\"OpenKM\">
    <AccessManager class=\"es.git.openkm.core.OKMAccessManager\"/>
  </Security>
  <Workspaces rootPath=\"${rep.home}/workspaces\" defaultWorkspace=\"default\" />
  <Workspace name=\"${wsp.name}\">
    <FileSystem class=\"org.apache.jackrabbit.core.fs.db.DbFileSystem\">
      <param name=\"driver\" value=\"org.postgresql.Driver\"/>
      <param name=\"url\" value=\"jdbc:postgresql://localhost/test\"/>
      <param name=\"schema\" value=\"postgresql\"/>
      <param name=\"user\" value=\"postgres\"/>
      <param name=\"password\" value=\"*****\"/>
      <param name=\"schemaObjectPrefix\" value=\"${wsp.name}_\"/>
    </FileSystem>
    <PersistenceManager class=\"org.apache.jackrabbit.core.persistence.bundle.PostgreSQLPersistenceManager\">
      <param name=\"driver\" value=\"org.postgresql.Driver\"/>
      <param name=\"url\" value=\"jdbc:postgresql://localhost/test\"/>
      <param name=\"schema\" value=\"postgresql\"/>
      <param name=\"user\" value=\"postgres\"/>
      <param name=\"password\" value=\"*****\"/>
      <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=\"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.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/test\"/>
      <param name=\"schema\" value=\"postgresql\"/>
      <param name=\"user\" value=\"postgres\"/>
      <param name=\"password\" value=\"*****\"/>
      <param name=\"schemaObjectPrefix\" value=\"version_\"/>
      <param name=\"externalBLOBs\" value=\"false\"/>
    </PersistenceManager>
  </Versioning>
</Repository>
 #957  by hbcomcn
 
Hello thanks for your reply,
I got such error when I login:
repository appears to be in use since the file named .lock is locked by another process.
and even restart the same error.


Thanks!!!
the server log file:


pavila wrote:try
Code: Select all
<?xml version="1.0"?>
<Repository>
  <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
    <param name="path" value="${rep.home}/repository"/>
  </FileSystem>
  <Security appName="OpenKM">
    <AccessManager class="es.git.openkm.core.OKMAccessManager"/>
  </Security>
  <Workspaces rootPath="${rep.home}/workspaces" defaultWorkspace="default" />
  <Workspace name="${wsp.name}">
    <FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
      <param name="driver" value="org.postgresql.Driver"/>
      <param name="url" value="jdbc:postgresql://localhost/test"/>
      <param name="schema" value="postgresql"/>
      <param name="user" value="postgres"/>
      <param name="password" value="*****"/>
      <param name="schemaObjectPrefix" value="${wsp.name}_"/>
    </FileSystem>
    <PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.PostgreSQLPersistenceManager">
      <param name="driver" value="org.postgresql.Driver"/>
      <param name="url" value="jdbc:postgresql://localhost/test"/>
      <param name="schema" value="postgresql"/>
      <param name="user" value="postgres"/>
      <param name="password" value="*****"/>
      <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="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.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/test"/>
      <param name="schema" value="postgresql"/>
      <param name="user" value="postgres"/>
      <param name="password" value="*****"/>
      <param name="schemaObjectPrefix" value="version_"/>
      <param name="externalBLOBs" value="false"/>
    </PersistenceManager>
  </Versioning>
</Repository>
[file name=server-88608fcf050c43cb1b1d18acec31719f.zip size=69705]http://www.openkm.com/images/fbfiles/fi ... 31719f.zip[/file]
 #960  by jllort
 
Do you close jboss correctly ?

Stop jboss, and try removing .lock filename (under repository folder path)
 #967  by hbcomcn
 
acctually I modify \'repository.xml\' file before the first time I run OpenKM, and the above error turns out.
pavila wrote:The repository should be deleted and created again if you change the repository.xml file.

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.