Ubuntu move Repository

[silverspr]

Hello
Is the process to move the repository the same for Linux? The example I followed in the wiki looks like it pertained to windows.

I copied the repository folder $tomcat/repository to its new location /media/user/foldername
edited OpenKm.cfg file
repository.home=/media/user/foldername/repository

however on restart/reboot I get this error when logging into OpenKM (see attached)

error after repository move
moverepos.JPG (18.04 KiB) Viewed 6680 times

thanks for your help

[jllort]

seems a problem with database connection not with repository. Stop openkm, start again. See error on catalina.log file into log folder., Sure there must appears some error on start up process. I would like to see the stack trace error ( you can also remove catalina.log and upload here the start up log file )

[silverspr]

HI and thank you
All I did was move the repository as described earlier, copied to its new location and updated the OpenKM.cfg file to reflect the new location (raid drive mounted at startup). When starting the application, I can see a new repository folder being created in the $tomcat folder.

I've uploaded the log files...I hope this is what you need

[jllort]

You got problems with database

Code: Select all

2014-12-27 09:29:18,988 [localhost-startStop-1] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM]- Servlet /OpenKM threw load() exception
org.hsqldb.HsqlException: user lacks privilege or object not found: OKM_NODE_BASE
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.SchemaManager.getTable(Unknown Source)
	at org.hsqldb.ParserDQL.readTableName(Unknown Source)
	at org.hsqldb.ParserDQL.readTableOrSubquery(Unknown Source)
	at org.hsqldb.ParserDQL.XreadTableReference(Unknown Source)
	at org.hsqldb.ParserDQL.XreadFromClause(Unknown Source)
	at org.hsqldb.ParserDQL.XreadTableExpression(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQuerySpecification(Unknown Source)
	at org.hsqldb.ParserDQL.XreadSimpleTable(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryExpression(Unknown Source)
	at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
	at org.hsqldb.ParserCommand.compilePart(Unknown Source)
	at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
	at org.hsqldb.Session.compileStatement(Unknown Source)
	at org.hsqldb.StatementManager.compile(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
	at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)

Seems database is empty. The problem is not on repository folder the problem is on database.

[silverspr]

Hi and thanks jllort
I guess the repository and the database are not the same. I followed the instructions as per the wiki to move the repository. How do I fix this database error? When I move the repository back to the home location ($Tomcat) all is fine, it is a working application until the repository is moved. Is there another configuration change I've missed?

thanks

[jllort]

If you move repository folder into should also be the hsql database files ( take a look at your server.xml configuration and your new configuration ). What is sure is that you're trying to access some empty database.

[silverspr]

Thanks jllort, I think!
The instructions provided in the documentation make no mention of this? I would have to say the instructions are not clear. I've looked at the server.xml file but am not clear on your direction. Can you provide an example other than what is shown in the online manual?

Changing default repository home
OpenKM 6.2
By default, the OpenKM document repository is located at $TOMCAT_HOME/repository. To change the repository folder to another location, use the repository.home configuration property in the OpenKM.cfg file, e.g.
repository.home=C:/okmrepo

thanks

[jllort]

I can not image what you've done and if some step is wrong. Move repository is simply change destination into OpenKM.cfg file ( there's no other hidden things on it ).
What is clear is your database is not in place should be. You should have okmdb.* files investigate where do you got it in older installation.

Which are the folders into C:/okmrepo ?

Take a look also in server.xml there's the database connection and points to okmdb database.

[silverspr]

HI,
The text in red is the example from your online manual, I included it to show it doesn't mention having to configure the datastore...or database. These were the steps I followed as outlined in the online documentation. I am running OpenKM 6.2 on UBUNTU 14.04, not windows.

I copied the repository folder from $tomcat/repository to the new location AND changed the destination in the OpenKM.cfg file or do I ONLY change the destination in the OpenKm.cfg and NOT copy the repository to the new location??

In the working "older installation", all the okmdb files are in the respository folder....moving the repository folder should have captured all the files ( to my way of thinking!)

thanks again, I appreciate the challenges with trying to understand what one is doing without being able to see it...

[jllort]

Move repository means also copy the contents of it. If you got repositoryin location1 and what to move to location2 the folder must be moved otherwise you're not moving anything. When you change repository location into OpenKM.cfg is asumed you've moved all the contents to new location and inform openkm about new storage location.

[silverspr]

Hi jllort,
This is exactly what I've done, copied the repository folder to the new location in its entirety. I would then rename the original repository and update the openKM.cfg file pointing to the new location. All this was stated in the very first post. However I continue to get errors noted also in the first post. Which is why I then asked if there was something else needing to be done.

Perhaps I'll try a fresh new install...and move the repository prior to starting the application for the first time. Yes I will back up the data of the original install and import to the new install and repository location...hopefully.

[jllort]

If you got a backup, my suggestion is restore. Export to file system. Configure a fresh openkm with MySQL ( if I'm not wrong I've seen HSQL, not good idea on production ) and then import.

[silverspr]

I will takeyour advice into consideration, although I did try migrate to mysql once before and didn't have much success. As to moving the repository, I have tried on three different machines, windows (7/8.1) and Ubuntu, with no success on any of the three machines. It is obvious I must be doing something wrong for it to fail on three different machines, one a fresh install. If any of the other forum users has experience with this please advise me as to how you were able to manage this.

In the meantime I'll brush up on the MySQL section of the OpenKm manual.

thanks

[jllort]

Arrived this point, my suuggestion for you is ->
1- Go to administration -> Export -> ( if you got metadata check the metadata checkbox and check history checkbox) and export /okm:root to some server folder
2- collect all data exported and move to other computer
3- do a fresh installation with lastest 6.3 and MySQL
4- from new installation execute Administration -> Import with uuid and history checkbox selected ( also metadata if you checked when exported ).

Note: You can export /okm:root, /okm:categories etc... in case you export categories that node should be the first to be imported ( is the only thing you should consider while importing ).