Mysql Version

[alimalik]

Please tell me what version of Mysql will be use for OpenKM 5.0

[jllort]

Versions 5.0 and 5.1 are right ( you can try with older too without major problems )

[alimalik]

I got error like this :

Code: Select all

ERROR [JDBCExceptionReporter] Table not found in statement [/* insert com.openkm.dao.bean.Activity */ insert into OKM_ACTIVITY (ACT_DATE, ACT_USER, ACT_ACTION, ACT_ITEM, ACT_PARAMS) values (?, ?, ?, ?, ?)]
10:38:47,117 ERROR [UserActivity] could not insert: [com.openkm.dao.bean.Activity]

and when login i got error like on webpage

org.apache.jackrabbit.core.config.ConfigurationException cannot be cast to javax.jcr.LoginException

[jllort]

in your database has been created the tables ? the error "Table not found" seems indicating the table has not been created ?

[alimalik]

ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] schema export unsuccessful
org.hibernate.JDBCException: Error during import script execution

Please help

Some Tables created but login unsuccessful

[pavila]

I just installen an OpenKM 5.0 in MySQL 5.1 a few minutes ago without any problem. I need more information to triage the problem.

[alimalik]

Code: Select all

<?xml version="1.0"?>
<!DOCTYPE Repository PUBLIC "-//The Apache Software Foundation//DTD Jackrabbit 1.6//EN"
                            "http://jackrabbit.apache.org/dtd/repository-1.6.dtd">
<Repository>
    <FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
        <param name="driver" value="com.mysql.jdbc.Driver"/>
            <param name="url" value="jdbc:mysql://192.168.2.79:3306/OpenKMDS?autoReconnect=true"/>
            <param name="schemaObjectPrefix" value="rep_"/>
            <param name="schema" value="mysql"/>
            <param name="user" value="openkm"/>
         <param name="password" value="secret"/>
    </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.db.SimpleDbPersistenceManager">
           <param name="driver" value="com.mysql.jdbc.Driver"/>
            <param name="url" value="jdbc:mysql://192.168.2.79:3306/OpenKMDS?autoReconnect=true"/>
            <param name="schemaObjectPrefix" value="${wsp.name}_"/>
            <param name="schema" value="mysql"/>
            <param name="externalBLOBs" value="false"/>
            <param name="user" value="openkm"/>
         <param name="password" value="secret"/>
        </PersistenceManager>

        <!-- Search index and the file system it uses.
             class: FQN of class implementing the QueryHandler interface -->
        <SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
            <param name="path" value="${wsp.home}/index"/>
            <param name="textFilterClasses" value="
            org.apache.jackrabbit.extractor.PlainTextExtractor,
            org.apache.jackrabbit.extractor.MsWordTextExtractor,
            org.apache.jackrabbit.extractor.MsExcelTextExtractor,
            org.apache.jackrabbit.extractor.MsPowerPointTextExtractor,
            org.apache.jackrabbit.extractor.OpenOfficeTextExtractor,
            org.apache.jackrabbit.extractor.RTFTextExtractor,
            org.apache.jackrabbit.extractor.HTMLTextExtractor,
            org.apache.jackrabbit.extractor.XMLTextExtractor,
            org.apache.jackrabbit.extractor.PngTextExtractor,
            org.apache.jackrabbit.extractor.MsOutlookTextExtractor,
            com.openkm.extractor.PdfTextExtractor,
            com.openkm.extractor.AudioTextExtractor,
            com.openkm.extractor.ExifTextExtractor,
            com.openkm.extractor.TiffTextExtractor,
            com.openkm.extractor.SourceCodeTextExtractor,
            com.openkm.extractor.MsOffice2007TextExtractor"/>
            <param name="extractorPoolSize" value="2"/>
            <param name="supportHighlighting" value="false"/>
            <param name="indexingConfiguration" value="${wsp.home}/../../../indexing_configuration.xml"/>
        </SearchIndex>
    </Workspace>

    <!-- Configures the versioning -->
    <Versioning rootPath="${rep.home}/version">
        <FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
           <param name="driver" value="com.mysql.jdbc.Driver"/>
            <param name="url" value="jdbc:mysql://192.168.2.79:3306/OpenKMDS?autoReconnect=true"/>
            <param name="schemaObjectPrefix" value="ver_rep_"/>
            <param name="schema" value="mysql"/>
            <param name="user" value="openkm"/>
         <param name="password" value="secret"/>
       </FileSystem>
        <PersistenceManager class="org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager">
           <param name="driver" value="com.mysql.jdbc.Driver"/>
            <param name="url" value="jdbc:mysql://192.168.2.79:3306/OpenKMDS?autoReconnect=true"/>
            <param name="schemaObjectPrefix" value="ver_"/>
            <param name="schema" value="mysql"/>
            <param name="externalBLOBs" value="false"/>
            <param name="user" value="openkm"/>
         <param name="password" value="secret"/>
        </PersistenceManager>
    </Versioning>

  <DataStore class="org.apache.jackrabbit.core.data.db.DbDataStore"> 
     <param name="url" value="jdbc:mysql://192.168.2.79:3306/OpenKMDS?autoReconnect=true"/> 
         <param name="user" value="openkm"/> 
         <param name="password" value="secret"/> 
         <param name="driver" value="com.mysql.jdbc.Driver"/> 
        <param name="minRecordLength" value="100"/> 
        <param name="copyWhenReading" value="true"/> 
   </DataStore>

</Repository>

My repository.xml file code is like that now can be tell me where i am wrong

[jllort]

The problem seems is on openkm-ds.xml, not only repository.xml has database connection. The activity table uses database poll defined in openkm-ds.xml