Migrating from 4.1 to 5 on windows

[randomagenda]

Hi

I see you have released version 5.0

Can anyone tell me how to migrate my installation using windows? The documentation only describes how to do this in linux...

Many Thanks

[jllort]

I want to think that' you've read it: http://wiki.openkm.com/index.php/Migrat ... 4.1_to_5.0 . Java is multiplatform !

Remember first make a backup of your 4.1 version !

[randomagenda]

Hi

Yes I did read the Wiki but it wasn't clear how to use the utilities.jar file on a windows environment. I have now managed figure out how to get the utilities.jar migration utility to run correctly in Windows, using the correct options.

Although when I did I found that I got the following error if a user had bookmarks set. (After deleting the bookmarks the utlity ran fine.)

Code: Select all

Exception in thread "main" java.lang.ArithmeticException: / by zero
	at com.openkm.util.RepositoryUpgrade.main(RepositoryUpgrade.java:253)

However I am still having a problem, after running the utility.jar migration process, I am unable to login to OpenKM as any user, this includes the 'okmAdmin' user (I also tried using the default password.)

what could be the cause of users not being ported across to the new version?

[jllort]

The user table structure has changed from version 4.1 to 5.0 and can not be migrated the data by default. The default user created is okmAdmin/admin after migration.

On version 4.1 is still not yet hibernate configured and there's no automatic way for doing it you must connect to older database extract scripts and insert into new tables. From 5.X it'll not be necessary the updating database it'll be more automatic.

[randomagenda]

Thanks for this,

Can you tell me how to achieve this please

On version 4.1 is still not yet hibernate configured and there's no automatic way for doing it you must connect to older database extract scripts and insert into new tables.

After migrating I am unable to login using those details... do I need to create the users first before migrating?

[jllort]

you was using default OpenKM installation ? then older script database are on /default/server/data/hypersonic/ and here something called AUTH you must change this script to new database structure ( you can not copy directly older files ! )

You can make inserts using administration http://wiki.openkm.com/index.php/Database_query

[randomagenda]

Can you provide me with a basic script for migrating the users please.

I don't know any JDBC or Hibernate...

Is anybody else having issue's after upgrading?

[jllort]

Everybody will have this issue after migration, include us.

There's no magic migration script, but if you open the files I indicate, you'll see the insert scripts, must adapt these to new database structure in dbms files created in new database.

[haroldtheb]

Thanks for this,

Can you tell me how to achieve this please

On version 4.1 is still not yet hibernate configured and there's no automatic way for doing it you must connect to older database extract scripts and insert into new tables.

After migrating I am unable to login using those details... do I need to create the users first before migrating?

Did you ever get an answer or figure this out. I"m finding the upgrade from 4.1 to 5.0 to be frustrating.

[jllort]

Yes, it'll be the most complex migration we've done since now, but it's necessary. New migrations from 5.0 will be more easy to be done, because we've included hibernate and upgrading database it'll be more automatic than now ( with update parameter into cfg it'll be done automatically ). The problem from 4.x to 5.0 is that the hibernate inclusion needs some extra work.

For you it's a tedious work, imagine us, that we must migrate all of our customers that has several DBMS, we've included the hibernate change due making OpenKM more strong, and when we decide to include it, we've must assumed the migration problems. There's no magic script, simply we must dedicate some hours and working on each installation to restore manually dbms records with new structure.

[haroldtheb]

I can imagine that larger installations will be troublesome... I do not see any documentation on the structure of the 5.0 database. Is it only the user table that is has changed? If so, can you tell me the changes? I looked at the 4.1 OKMAuth.script, so I see that it can be adapted . I just need to know what the structure is. Thanks.

[pavila]

You have access to full source code, so is easy to see the table structure.