Versioning Problem

[ibrahim]

Hi

I have So far configured the Openkm with MySQL 5.0 and set up repository as for Document Management with Database which is Working Fine as per the requirement. But there still am facing the following problems,

1. The version of the document is showing as "jcr:rootVersion" once I have uploaded the document.
2. Since XPath is case sensitive, I was not able to search the files with different case. So can you give me a XPath query for case insensitive?

[jllort]

That's something really new ...

Which version of OpenKM are you using ?

[ibrahim]

Hi jllort... thanks for your reply.

I am using OpenKM 4.0 version.

[jllort]

Have you changed source code or it's default OpenKM ?
Which mysql version are you using ?

Have you tried upgrading to 4.1 ? there's only need to change war file and copy two files in jboss_home ( the new PropertyGroups.cnd and .xml ), before doing anything first make backups

[ibrahim]

Hi Jllort,

I haven't changed the source code till now. I have taken the source code from SVN and planning to do some customization.

Am using mysql 5.1 vesion. And I haven't tried for upgrading to the newer version of OpenKM4.1.

[jllort]

If you planning some developement ... I suggest OpenKM 5.0. Next week we'll release in demo ... and actual code starting to be stable, althought it until one - two months will not consider stable ( we're making tests now ). In OpenKM 5.0 we've done architecture to make plugins compatible between OpenKM versions and more configurable UI ( hide / show major OpenKM UI elements, the idea is hide actual OpenKM and put yours or extends with yours, take a look here : http://wiki.openkm.com/index.php/Widget_library ). The idea is that partners and thirdparty could create plugins and sell them if they want.

I recommend you use 4.1 head, it's more stable than 4.0
for mysql 4.1 needs some OpenKM:cfg tag

This bug is really strange because I've got some OpenKM with mysql and I've never seen it ... is there any server.log error or similar ? it's too strange I can not understand it

[ibrahim]

Hi Jllot,

I didn’t find any error in the server.log file. Moreover am not getting any error message at the time of uploading the document.

For your reference, please check the repository.xml and server.log file that you can find as an attachment.

Do you have any solution for this?

Which file/files I need to modify to solve the issue?

Thanks for the help.


repository.xml

Code: Select all

<?xml version="1.0" ?>
<Repository>

<FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
       <param name="driver" value="com.mysql.jdbc.Driver"/>
       <param name="url" value="jdbc:mysql://localhost:3306/openkm?autoReconnect=true"/>
       <param name="user" value="root" />
	   <param name="password" value="root" />
       <param name="schema" value="mysql"/>
       <param name="schemaObjectPrefix" value="J_R_FS_"/>
   </FileSystem>

 <DataStore class="org.apache.jackrabbit.core.data.db.DbDataStore">
        <param name="driver" value="com.mysql.jdbc.Driver"/>
       	<param name="url" value="jdbc:mysql://localhost:3306/openkm?autoReconnect=true"/>
       	<param name="user" value="root" />
	    <param name="password" value="root" />
        <param name="databaseType" value="mysql"/>        
        <param name="minRecordLength" value="1024"/>
        <param name="maxConnections" value="3"/>
        <param name="copyWhenReading" value="true"/>
        <param name="tablePrefix" value=""/>
        <param name="schemaObjectPrefix" value=""/>
    </DataStore>

  
  <Security appName="OpenKM">
    <AccessManager class="es.git.openkm.core.OKMAccessManager"/>
  </Security>


<Workspaces rootPath="${rep.home}/workspaces" defaultWorkspace="default"/>
 
    <Workspace name="${wsp.name}">
       
		<PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager">
			<param name="driver" value="com.mysql.jdbc.Driver"/>
			<param name="url" value="jdbc:mysql://localhost:3306/openkm?autoReconnect=true"/>
			<param name="user" value="root" />
			<param name="password" value="root" />
			<param name="schema" value="mysql"/>
			<param name="schemaObjectPrefix" value="J_PM_${wsp.name}_" />
			<param name="externalBLOBs" value="false" />
		</PersistenceManager>
		
		<FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
			<param name="driver" value="com.mysql.jdbc.Driver"/>
			<param name="url" value="jdbc:mysql://localhost:3306/openkm"/>
			<param name="user" value="root" />
			<param name="password" value="root" />
			<param name="schema" value="mysql"/>
			<param name="schemaObjectPrefix" value="J_FS_${wsp.name}_"/>
		</FileSystem>
    
        <SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
            <param name="path" value="${wsp.home}/index"/>
            <param name="supportHighlighting" value="true"/>
        </SearchIndex>
    
    </Workspace>

 <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://localhost:3306/openkm?autoReconnect=true"/>
			<param name="user" value="root" />
			<param name="password" value="root" />
			<param name="schema" value="mysql"/>
			<param name="schemaObjectPrefix" value="J_V_FS_"/>
		</FileSystem>
		
		<PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager">
			<param name="driver" value="com.mysql.jdbc.Driver"/>
			<param name="url" value="jdbc:mysql://localhost:3306/openkm?autoReconnect=true"/>
			<param name="user" value="root" />
			<param name="password" value="root" />
			<param name="schema" value="mysql"/>
			<param name="schemaObjectPrefix" value="J_V_PM_" />
			<param name="externalBLOBs" value="false" />
		</PersistenceManager>

    </Versioning>
   
    <SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
        <param name="path" value="${rep.home}/repository/index"/>
        <param name="supportHighlighting" value="true"/>
    </SearchIndex> 
</Repository>

[pavila]

Can you reproduce this issue with a fresh OpenKM 4.1 installation?