OKM 4.1 & PostgreSQL 8.4

[amatykiewicz]

Trying to implement OpenKM on CentOS 5.5 with PostgreSQL 8.4. I "BELIEVE" I've followed all the instructions correctly: copied Postgres drivers (postgresql-8.4-701.jbdc3.jar & postgresql-8.4-701.jbdc4.jar) to $JBOSS_HOME/server/default/lib. Edited repository.xml to match configuration on PostgreSQL page. Created openkm and JbpmDB databases and confirmed connections. Modified the OpenKM.war file for the hibernation dialect. Edited openkm-ds.xml for datasources per PostgreSQL page, plus added postgres-ds.xml for DefaultDS and jbpm-ds.xml for JbpmDB.

Problem: when I try to log in, I get: "File system initialization failure.: root directory not set" and from server.log:

2010-08-16 22:53:31, 818 INFO [org.apache.jackrabbit.core.RepositoryImp] Initializing workspace 'default' ...
2010-08-16 22.53.31, 819 ERROR [org.apache.jackrabbit.core.RepositoryImp] Failed to initialize workspace 'default'
org.apache.jackrabbit.core.config.ConfigurationException: File System initialization failure: root directory not set: root directory not set

I'm kind of a newbie on this, but I've been through everything at least twice and I'm really stuck. All suggestions welcomed and thank you in advance.

[jllort]

have you started before OpenKM ? if you've got in jboss home repository folder, delete it, it's created first time and it's not recreated in future. If you've got some error in your configuration and you've started jboss, then must delete it and try again.

[amatykiewicz]

Yes, have deleted repository folder and insured JBoss is stopped each time change made in repository.xml file.

[pavila]

Please, post your repository.xml config file.

[amatykiewicz]

repository.xml

Code: Select all

<?xml version="1.0"?>
<!DOCTYPE Repository PUBLIC "-//The Apache Software Foundation//DTD Jackrabbit 1.4//EN"
                            "http://jackrabbit.apache.org/dtd/repository-1.4.dtd">
<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.local.LocalFileSystem">
            <param name="path" value="${wsp.home}"/>
        </FileSystem>
        <PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.DerbyPersistenceManager">
            <param name="url" value="jdbc:derby:${wsp.home}/db;create=true"/>
            <param name="schemaObjectPrefix" value="${wsp.name}_"/>
        </PersistenceManager>
        <SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
            <param name="path" value="${wsp.home}/index"/>
            <param name="resultFetchSize" value="100"/>
            <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="maxFieldLength" value="50000"/>
            <!-- Disable extractor pool -->
            <!-- <param name="extractorPoolSize" value="0"/> -->
            <param name="extractorTimeout" value="1000"/>
            <param name="bufferSize" value="10"/>
            <param name="cacheSize" value="1000"/>
            <param name="forceConsistencyCheck" value="false"/>
            <!-- <param name="consistencyCheck" value="true"/> -->
            <!-- <param name="consistencyFix" value="true"/> -->
            <param name="autoRepair" value="true"/>
            <!-- <param name="analyzer" value="es.git.openkm.analysis.SpanishAnalyzer"/> -->
            <param name="respectDocumentOrder" value="false"/>
            <param name="indexingConfiguration" value="${wsp.home}/../../../indexing_configuration.xml"/>
            <param name="textFilterClasses" value="
org.apache.jackrabbit.extractor.PlainTextExtractor,
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,
es.git.openkm.extractor.MsExcelTextExtractor,
es.git.openkm.extractor.MsPowerPointTextExtractor,
es.git.openkm.extractor.MsWordTextExtractor,
es.git.openkm.extractor.MsOffice2007TextExtractor,
es.git.openkm.extractor.ExifTextExtractor,
es.git.openkm.extractor.TiffTextExtractor,
es.git.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.DerbyPersistenceManager">
            <param name="url" value="jdbc:derby:${rep.home}/version/db;create=true"/>
            <param name="schemaObjectPrefix" value="version_"/>
        </PersistenceManager>
    </Versioning>
    <!-- Also see DatabaseDataStore-->
    <DataStore class="org.apache.jackrabbit.core.data.FileDataStore"/>
</Repository>

Sorry for the delay in responding; have been wrapped around the shaft with another project and just getting back to this. Again, ANY assistance or suggestions greatly appreciated.

[pavila]

Your repository.xml is configured for Derby, not PostgreSQL. Take a look at http://wiki.openkm.com/index.php/PostgreSQL see an example.