Page 1 of 1

Migrating from 6.2.5 to 6.3

PostPosted:Thu Sep 04, 2014 1:46 pm
by vincentk222
Hi
I have 6.2.5 community edition running on Ubuntu 12.05LTS 64 bits
I tried to migrate this version to 6.3 community edition

I just found a procedure to migrate from 6.2.6 to 6.3: http://wiki.openkm.com/index.php/Migrat ... 2.6_to_6.3
Is this working for 6.2.5 too?

I follewed the instruction:

Make a backup!!!
Stop Tomcat OK
Edit OpenKM.cfg and set hibernate.hbm2ddl to update OK
Replace the OpenKM.war OK
Go to Administration > Crontab and delete "User Items Serialize" and "Refresh User Items" tasks. NOK because OpenKM is stopped (Tomcat stopped)

Run from your preferred SQL client these queries: OK
ALTER TABLE OKM_MIME_TYPE ADD COLUMN MT_SEARCH CHAR(1);
UPDATE OKM_MIME_TYPE SET MT_SEARCH='T';
ALTER TABLE OKM_MIME_TYPE MODIFY COLUMN MT_SEARCH CHAR(1) NOT NULL;

When I restart Tomcat, I still have OpenKM 6.2.5
I stop Tomcat again and remove
$TOMCAT_HOME/webapps/OpenKM
$TOMCAT_HOME/work/Catalina/localhost
and restart

At OpenKM login I get this error message : OKM-012024 (GetRootFolder):Database error

Last thing I forgot to mention is that openkm 6.2.5 is mapped to our AD

Re: Migrating from 6.2.5 to 6.3

PostPosted:Fri Sep 05, 2014 6:27 pm
by jllort
The error indicate "path not found" ?
Could you post stack trace error in catalina.log ?
My first impression is that you got security problem, quite strange, because from 6.2 to 6.3 I do not remember any change on LDAP integration. I suggest switch to database authetnication for a while, is a good way to check if this is the problem.

Re: Migrating from 6.2.5 to 6.3

PostPosted:Wed Sep 23, 2015 9:50 am
by sl0m0
I had exactly the same issue and solved it by doing the following:

1. Stop Tomcat
2. Edit OpenKM.cfg and set hibernate.hbm2ddl to update (again)
3. Restart MySQL database server
4. Start Tomcat

It should now be working.