Open Source Document Management System | OpenKM

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]

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.

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.

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.

try

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]

Do you close jboss correctly ?

Stop jboss, and try removing .lock filename (under repository folder path)

The repository should be deleted and created again if you change the repository.xml file.

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.