How to use OpenKm with postgres

[nyali]

Dear Forum

I am trying to connect my OpenKm with postgres here is my repository.xml

<?xml version=\"1.0\"?>
<Repository>
<FileSystem class=\"org.apache.jackrabbit.core.fs.local.LocalFileSystem\">
<param name=\"path\" value=\"${rep.home}/repository\"/>
</FileSystem>
<Security appName=\"Jackrabbit\">
<AccessManager class=\"es.git.openkm.core.OKMAccessManager\"/>
</Security>
<Workspaces rootPath=\"${wsp.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/openkm\"/>
<param name=\"schema\" value=\"postgresql\"/>
<param name=\"user\" value=\"postgres\"/>
<param name=\"password\" value=\"postgres\"/>
<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/openkm\"/>
<param name=\"schema\" value=\"postgresql\"/>
<param name=\"user\" value=\"postgres\"/>
<param name=\"password\" value=\"postgres\"/>
<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=\"textFilterClasses\" value=\"
org.apache.jackrabbit.core.query.lucene.TextPlainTextFilter,
org.apache.jackrabbit.core.query.MsExcelTextFilter,
org.apache.jackrabbit.core.query.MsPowerPointTextFilter,
org.apache.jackrabbit.core.query.MsWordTextFilter,
org.apache.jackrabbit.core.query.PdfTextFilter,
org.apache.jackrabbit.core.query.HTMLTextFilter,
org.apache.jackrabbit.core.query.XMLTextFilter,
org.apache.jackrabbit.core.query.RTFTextFilter,
org.apache.jackrabbit.core.query.OpenOfficeTextFilter\" />

<!-- These are all default values. You can change them if you want -->
<!--
<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=\"queryClass\" value=\"org.apache.jackrabbit.core.query.QueryImpl\"/>
<param name=\"idleTime\" value=\"-1\"/>
-->
<!-- end of default values -->
</SearchIndex>
</Workspace>
<Versioning rootPath=\"${rep.home}/versions\">
<FileSystem class=\"org.apache.jackrabbit.core.fs.db.DbFileSystem\">
<param name=\"driver\" value=\"org.postgresql.Driver\"/>
<param name=\"url\" value=\"jdbc:postgresql://localhost/openkm\"/>
<param name=\"schema\" value=\"postgresql\"/>
<param name=\"user\" value=\"postgres\"/>
<param name=\"password\" value=\"postgres\"/>
<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/openkm\"/>
<param name=\"schema\" value=\"postgresql\"/>
<param name=\"user\" value=\"postgres\"/>
<param name=\"password\" value=\"postgres\"/>
<param name=\"schemaObjectPrefix\" value=\"${wsp.name}_\"/>
<param name=\"externalBLOBs\" value=\"false\"/>
</PersistenceManager>

</Versioning>
</Repository>


whats wrong in it.

[jllort]

Remember repository is only created on first time running openkm, if you started before openkm you need to stop, delete repository directory and try to run other time with this configuration.

If you have do it and problems persists tell us more, some error on startup ?