Open Source Document Management System | OpenKM

PostPosted:**Mon Dec 12, 2011 5:43 am**

Hi jllort,

I split the post about Mysql based URL location problem to this loop. Then I will describe my detailed installation steps using Mysql.

1. Download OpenKM-5.1.8_JBoss-4.2.3.GA.zip from official link.
2. Unpack souce, change OpenKM.cfg

Code: Select all

#hibernate.dialect=org.hibernate.dialect.HSQLDialect
hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
hibernate.hbm2ddl=create

3. edit openkm-ds.xml

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>
<!-- <datasources>
  <local-tx-datasource>
    <jndi-name>OpenKMDS</jndi-name>
    <connection-url>jdbc:hsqldb:${jboss.server.data.dir}${/}hypersonic${/}OKM_APP</connection-url>
    <driver-class>org.hsqldb.jdbcDriver</driver-class>
    <user-name>sa</user-name>
    <password></password>
    <min-pool-size>5</min-pool-size>
    <max-pool-size>20</max-pool-size>
    <idle-timeout-minutes>0</idle-timeout-minutes>
    <prepared-statement-cache-size>32</prepared-statement-cache-size>
    <metadata>
      <type-mapping>Hypersonic SQL</type-mapping>
    </metadata>
    <depends>jboss:service=Hypersonic,database=OKM_APP</depends>
  </local-tx-datasource>
  <mbean code="org.jboss.jdbc.HypersonicDatabase" 
         name="jboss:service=Hypersonic,database=OKM_APP">
    <attribute name="Database">OKM_APP</attribute>
    <attribute name="InProcessMode">true</attribute>
  </mbean>
</datasources> -->
<datasources>
<local-tx-datasource>
<jndi-name>OpenKMDS</jndi-name>
<connection-url>jdbc:mysql://127.0.0.1:3306/openkm?autoReconnect=true</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>openkm</user-name>
<password>XXXX</password>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<idle-timeout-minutes>0</idle-timeout-minutes>
<prepared-statement-cache-size>32</prepared-statement-cache-size>
<metadata>
<type-mapping>MySQL</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>

4. (Optional) change repository.xml, since whether change this file does not make any changes, this config will not be listed.
5. In Admin Page, change application.url to http://myIpAddress/OpenKM/index.jsp
6. Now, refresh the browser, then, click "URL" in property tab, paste the URL like http://10.3.0.57/OpenKM/index.jsp?fldPa ... oot/DEV_AG into browser, it will only redirect me to http://10.3.0.57/OpenKM/frontend/index.jsp, "?fldPath=/okm:root/DEV_AG" disappeared, as a result, Folder DEV_AG cannot be located.

PostPosted:**Tue Dec 13, 2011 5:24 pm**

Seems it's a bug with UI, I've been done some changes in actual trunk what will be version 5.1.9
Could you test in our online demo is error happens there ?

PostPosted:**Wed Dec 14, 2011 8:01 am**

Hi jllort,

Demo site works well, I guess it use default HSQL installation, isn't it ？

PostPosted:**Wed Dec 14, 2011 9:19 am**

Hi jllort,

I also tested "Templates" , browser will hang if I use a document's URL like:
http://demo.openkm.com/OpenKM/frontend/ ... -09-27.pdf
This phenomenon is quite similar with folder URL location.

PostPosted:**Wed Dec 14, 2011 7:12 pm**

I forgot update community version too, I'll try to solve it there too. Not easy because I made a lot of changes, that needs to make changes on startup sequence. I'll try to solve at least disable the hang problem.

PostPosted:**Thu Dec 15, 2011 2:31 am**

hi jllort,

Thank you very much for your devotion! OpenKM will be even more perfect !

PostPosted:**Thu Dec 22, 2011 7:14 am**

Hi jllort,

The newest nightly build 7367 still exist the hung problem for categories and templates. Maybe it was not disabled in this build?

PostPosted:**Fri Dec 23, 2011 3:06 pm**

I'm on holidays and until 28 then I'll take a look on it, I still not found time to move the changes I made on trunk to 5.1.9

PostPosted:**Tue Dec 27, 2011 2:53 am**

Oh, I see, wish you a good holiday, though it's late for Christmas wishes! I will also wait for the new fix then.

PostPosted:**Tue Jan 10, 2012 5:18 am**

Hi jllort,

This problem still exist for Mysql installation. After redirection from OpenKM/index.jsp to OpenKM/frontend/index.jsp, all parameters lost.
I'm using Version: 5.1.9-SNAPSHOT (build: 7407)

Yesterday, I wrongly post this problem in "Categories" post, which bothered pavila, I will paste that post here:

URL link to locate Categories works well for default installation now.
However, we are using mysql as database, and we still cannot locate a Category via the URL link.
The phenomenon is that if I type a URL like : http://doc.xxx.com.cn/OpenKM/index.jsp? ... roduct_9_0 into browser and press enter, the URL will be redirect to http://doc.XXX.com.cn/OpenKM/frontend/index.jsp.
Problems happened here: all parameters following index.jsp were lost.

Temporary workaround is set the following value in Admin Panel.
application.url String http://doc.XXX.com.cn/OpenKM/frontend/index.jsp
But this will affect WebDAV access.

PostPosted:**Tue Jan 10, 2012 9:14 am**

Now I understand the problem. I have created this issue http://issues.openkm.com/view.php?id=2002 and fixed the problem. Please, if you still have the issue add a note to the bug tracking system.

Open Source Document Management System | OpenKM

Cannot use "URL" as a link to folder path in Taxonomy

Cannot use "URL" as a link to folder path in Taxonomy

Re: Cannot use "URL" as a link to folder path in Taxonomy

Re: Cannot use "URL" as a link to folder path in Taxonomy

Re: Cannot use "URL" as a link to folder path in Taxonomy

Re: Cannot use "URL" as a link to folder path in Taxonomy

Re: Cannot use "URL" as a link to folder path in Taxonomy

Re: Cannot use "URL" as a link to folder path in Taxonomy

Re: Cannot use "URL" as a link to folder path in Taxonomy

Re: Cannot use "URL" as a link to folder path in Taxonomy

Re: Cannot use "URL" as a link to folder path in Taxonomy

Re: Cannot use "URL" as a link to folder path in Taxonomy