how to move data repository to nas

[gwaitsi]

I have OpenKM v6.3 running on a local Ubuntu 14.04 desktop because some dependencies were not meet on my OpenMediaVault 0.50 box.
I have however, been using the MySQL server on the nas box successfully with this installation,
however, i notice from the mysql backups, that there are not docs and therefore i have to backup two separate machines to get a full backup.

I now want to install OpenKM directly onto my nas box and move the repository from the workstation.

Can you please advise how to go about this?

thanks

[jllort]

Must take in consideration OpenKM is an application, does your nas allow to run java applications ? you must install Oracle Java JDK 1.7. Can you do it ?
OpenKM has a folder into tomcat-7.0.27 called repository you get application in one path and repository in other, simply moving repository folder to other location and setting the new path into OpenKM.cfg ( take a look here http://wiki.openkm.com/index.php/Applic ... itory_home )

About moving all application ( also repository ) simply move your tomcat-7.0.27 to new server ( that includes by default the repository ) and also install MySQL ( with MySQL imported dump ) and Oracle Java to get OpenKM running. Moving application has same steps than restore backup, into the new server. There's no much mistery on it.

[gwaitsi]

Hi jllort,

Not having too much luck getting everything moved. Output of the version.sh file below. are you able to help please?

Code: Select all

Using CATALINA_BASE:   /usr/local/openkm
Using CATALINA_HOME:   /usr/local/openkm
Using CATALINA_TMPDIR: /usr/local/openkm/temp
Using JRE_HOME:        /usr/lib/jvm/java-7-oracle
Using CLASSPATH:       /usr/local/openkm/bin/bootstrap.jar:/usr/local/openkm/bin/tomcat-juli.jar
Using CATALINA_PID:    /usr/local/openkm/catalina.pid
Server version: Apache Tomcat/7.0.53
Server built:   Mar 25 2014 06:20:16
Server number:  7.0.53.0
OS Name:        Linux
OS Version:     3.2.0-4-amd64
Architecture:   amd64
JVM Version:    1.7.0_72-b14
JVM Vendor:     Oracle Corporation

mysql server is connectable from both workstation and localhost. the Ubuntu desktop install is working, connected to nas mysql.ke

key output in the log

Code: Select all

2014-10-28 08:05:12,216 [main] INFO  org.apache.catalina.core.AprLifecycleListener- Loaded APR based Apache Tomcat Native library 1.1.31 using APR version 1.4.6.
2014-10-28 08:05:12,218 [main] INFO  org.apache.catalina.core.AprLifecycleListener- APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
2014-10-28 08:05:13,490 [main] INFO  org.apache.catalina.core.AprLifecycleListener- OpenSSL successfully initialized (OpenSSL 1.0.1e 11 Feb 2013)
2014-10-28 08:05:15,739 [main] INFO  org.apache.coyote.http11.Http11AprProtocol- Initializing ProtocolHandler ["http-apr-0.0.0.0-8080"]
2014-10-28 08:05:15,901 [main] INFO  org.apache.coyote.ajp.AjpAprProtocol- Initializing ProtocolHandler ["ajp-apr-127.0.0.1-8009"]
2014-10-28 08:05:15,953 [main] INFO  org.apache.catalina.startup.Catalina- Initialization processed in 7447 ms
Oct 28, 2014 8:05:15 AM com.openkm.util.LoggerWatchdog doOnChange
INFO: *** Log4j configuration file changed ***
DEBUG: JavaMail version 1.4.7
DEBUG: successfully loaded resource: /META-INF/javamail.default.providers
DEBUG: Tables of loaded providers
DEBUG: Providers Listed By Class Name: {com.sun.mail.smtp.SMTPSSLTransport=javax.mail.Provider[TRANSPORT,smtps,com.sun.mail.smtp.SMTPSSLTransport,Oracle], com.sun.mail.smtp.SMTPTransport=javax.mail.Provider[TRANSPORT,smtp,com.sun.mail.smtp.SMTPTransport,Oracle], com.sun.mail.imap.IMAPSSLStore=javax.mail.Provider[STORE,imaps,com.sun.mail.imap.IMAPSSLStore,Oracle], com.sun.mail.pop3.POP3SSLStore=javax.mail.Provider[STORE,pop3s,com.sun.mail.pop3.POP3SSLStore,Oracle], com.sun.mail.imap.IMAPStore=javax.mail.Provider[STORE,imap,com.sun.mail.imap.IMAPStore,Oracle], com.sun.mail.pop3.POP3Store=javax.mail.Provider[STORE,pop3,com.sun.mail.pop3.POP3Store,Oracle]}
DEBUG: Providers Listed By Protocol: {imaps=javax.mail.Provider[STORE,imaps,com.sun.mail.imap.IMAPSSLStore,Oracle], imap=javax.mail.Provider[STORE,imap,com.sun.mail.imap.IMAPStore,Oracle], smtps=javax.mail.Provider[TRANSPORT,smtps,com.sun.mail.smtp.SMTPSSLTransport,Oracle], pop3=javax.mail.Provider[STORE,pop3,com.sun.mail.pop3.POP3Store,Oracle], pop3s=javax.mail.Provider[STORE,pop3s,com.sun.mail.pop3.POP3SSLStore,Oracle], smtp=javax.mail.Provider[TRANSPORT,smtp,com.sun.mail.smtp.SMTPTransport,Oracle]}
DEBUG: successfully loaded resource: /META-INF/javamail.default.address.map
2014-10-28 08:05:16,417 [main] INFO  org.apache.catalina.core.StandardService- Starting service Catalina
2014-10-28 08:05:16,419 [main] INFO  org.apache.catalina.core.StandardEngine- Starting Servlet Engine: Apache Tomcat/7.0.53
2014-10-28 08:05:16,673 [localhost-startStop-1] INFO  org.apache.catalina.startup.HostConfig- Deploying web application archive /usr/local/openkm/webapps/OpenKM.war
2014-10-28 08:06:15,367 [localhost-startStop-1] INFO  org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM]- No Spring WebApplicationInitializer types detected on classpath
2014-10-28 08:06:15,555 [localhost-startStop-1] INFO  org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM]- Initializing Spring root WebApplicationContext
2014-10-28 08:06:15,556 [localhost-startStop-1] INFO  org.springframework.web.context.ContextLoader- Root WebApplicationContext: initialization started
2014-10-28 08:06:15,829 [localhost-startStop-1] INFO  org.springframework.web.context.support.XmlWebApplicationContext- Refreshing Root WebApplicationContext: startup date [Tue Oct 28 08:06:15 CET 2014]; root of context hierarchy
2014-10-28 08:06:16,166 [localhost-startStop-1] INFO  org.springframework.beans.factory.xml.XmlBeanDefinitionReader- Loading XML bean definitions from ServletContext resource [/WEB-INF/applicationContext.xml]
2014-10-28 08:06:18,628 [localhost-startStop-1] INFO  org.springframework.context.annotation.ClassPathBeanDefinitionScanner- JSR-250 'javax.annotation.ManagedBean' found and supported for component scanning
2014-10-28 08:06:24,474 [localhost-startStop-1] INFO  org.springframework.beans.factory.xml.XmlBeanDefinitionReader- Loading XML bean definitions from class path resource [META-INF/cxf/cxf.xml]
2014-10-28 08:06:24,537 [localhost-startStop-1] INFO  org.springframework.beans.factory.xml.XmlBeanDefinitionReader- Loading XML bean definitions from class path resource [META-INF/cxf/cxf-servlet.xml]
2014-10-28 08:06:25,163 [localhost-startStop-1] INFO  org.springframework.security.core.SpringSecurityCoreVersion- You are running with Spring Security Core 3.1.0.RELEASE
2014-10-28 08:06:25,163 [localhost-startStop-1] INFO  org.springframework.security.config.SecurityNamespaceHandler- Spring Security 'config' module version is 3.1.0.RELEASE
---------------------
2014-10-28 08:06:58,039 [localhost-startStop-1] INFO  org.springframework.security.config.http.DefaultFilterChainValidator- Checking whether login URL '/login.jsp' is accessible with your configuration
2014-10-28 08:06:58,204 [localhost-startStop-1] INFO  org.springframework.web.context.ContextLoader- Root WebApplicationContext: initialization completed in 42648 ms
2014-10-28 08:06:58,340 [localhost-startStop-1] INFO  com.openkm.core.Config- ** Application OpenKM has DTDs at /usr/local/openkm/webapps/OpenKM/WEB-INF/classes/dtd **
2014-10-28 08:06:58,352 [localhost-startStop-1] INFO  com.openkm.core.Config- ** Language profiles at /usr/local/openkm/webapps/OpenKM/WEB-INF/classes/lang-profiles **
2014-10-28 08:06:58,353 [localhost-startStop-1] INFO  com.openkm.core.Config- ** Reading config file /usr/local/openkm/OpenKM.cfg **
2014-10-28 08:06:58,361 [localhost-startStop-1] INFO  com.openkm.core.Config- LOAD - hibernate.create.autofix=true
2014-10-28 08:06:58,361 [localhost-startStop-1] INFO  com.openkm.core.Config- LOAD - hibernate.datasource=java:/comp/env/jdbc/OpenKMDS
2014-10-28 08:06:58,362 [localhost-startStop-1] INFO  com.openkm.core.Config- LOAD - hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
2014-10-28 08:06:58,362 [localhost-startStop-1] INFO  com.openkm.core.Config- LOAD - hibernate.hbm2ddl=none
2014-10-28 08:06:58,362 [localhost-startStop-1] INFO  com.openkm.core.Config- LOAD - hibernate.search.analyzer=org.apache.lucene.analysis.standard.StandardAnalyzer
2014-10-28 08:06:58,362 [localhost-startStop-1] INFO  com.openkm.core.Config- LOAD - hibernate.search.index.exclusive=true
2014-10-28 08:06:58,362 [localhost-startStop-1] INFO  com.openkm.core.Config- LOAD - hibernate.search.index.home=/media/a7e96974-7965-4103-9743-281802f3d956/eapenas_openkm/repository/index
2014-10-28 08:06:58,363 [localhost-startStop-1] INFO  com.openkm.core.Config- LOAD - hibernate.show_sql=false
2014-10-28 08:06:58,363 [localhost-startStop-1] INFO  com.openkm.core.Config- LOAD - hibernate.statistics=false
2014-10-28 08:06:58,363 [localhost-startStop-1] INFO  com.openkm.core.Config- LOAD - instance.chroot.path=
2014-10-28 08:06:58,363 [localhost-startStop-1] INFO  com.openkm.core.Config- LOAD - instance.home=/usr/local/openkm
2014-10-28 08:06:58,363 [localhost-startStop-1] INFO  com.openkm.core.Config- LOAD - jbpm.config=/usr/local/openkm/jbpm.xml
2014-10-28 08:06:58,364 [localhost-startStop-1] INFO  com.openkm.core.Config- LOAD - property.groups.cnd=/usr/local/openkm/PropertyGroups.cnd
2014-10-28 08:06:58,364 [localhost-startStop-1] INFO  com.openkm.core.Config- LOAD - property.groups.xml=/usr/local/openkm/PropertyGroups.xml
2014-10-28 08:06:58,364 [localhost-startStop-1] INFO  com.openkm.core.Config- LOAD - repository.cache.dxf=/media/a7e96974-7965-4103-9743-281802f3d956/eapenas_openkm/repository/cache/dxf
2014-10-28 08:06:58,364 [localhost-startStop-1] INFO  com.openkm.core.Config- LOAD - repository.cache.home=/media/a7e96974-7965-4103-9743-281802f3d956/eapenas_openkm/repository/cache
2014-10-28 08:06:58,364 [localhost-startStop-1] INFO  com.openkm.core.Config- LOAD - repository.cache.pdf=/media/a7e96974-7965-4103-9743-281802f3d956/eapenas_openkm/repository/cache/pdf
2014-10-28 08:06:58,365 [localhost-startStop-1] INFO  com.openkm.core.Config- LOAD - repository.cache.swf=/media/a7e96974-7965-4103-9743-281802f3d956/eapenas_openkm/repository/cache/swf
2014-10-28 08:06:58,365 [localhost-startStop-1] INFO  com.openkm.core.Config- LOAD - repository.config=/dev/null
2014-10-28 08:06:58,365 [localhost-startStop-1] INFO  com.openkm.core.Config- LOAD - repository.datastore.backend=fs
2014-10-28 08:06:58,365 [localhost-startStop-1] INFO  com.openkm.core.Config- LOAD - repository.datastore.home=/media/a7e96974-7965-4103-9743-281802f3d956/eapenas_openkm/repository/datastore
2014-10-28 08:06:58,365 [localhost-startStop-1] INFO  com.openkm.core.Config- LOAD - repository.home=/usr/local/openkm/repository
2014-10-28 08:06:58,365 [localhost-startStop-1] INFO  com.openkm.core.Config- LOAD - repository.native=true
2014-10-28 08:06:58,366 [localhost-startStop-1] INFO  com.openkm.core.Config- LOAD - system.multiple.instances=false
2014-10-28 08:06:58,378 [localhost-startStop-1] INFO  com.openkm.util.WarUtils- Implementation-Version: 6.3.0
2014-10-28 08:06:58,379 [localhost-startStop-1] INFO  com.openkm.util.WarUtils- Implementation-Build: 8156
2014-10-28 08:06:58,385 [localhost-startStop-1] INFO  com.openkm.servlet.RepositoryStartupServlet- *** Application version: 6.3.0 (build: 8156) ***
2014-10-28 08:06:58,385 [localhost-startStop-1] INFO  com.openkm.servlet.RepositoryStartupServlet- *** Hibernate initialize ***
2014-10-28 08:07:14,010 [localhost-startStop-1] INFO  com.openkm.dao.HibernateUtil- Hibernate 'hibernate.dialect' = org.hibernate.dialect.MySQL5InnoDBDialect
2014-10-28 08:07:14,010 [localhost-startStop-1] INFO  com.openkm.dao.HibernateUtil- Hibernate 'hibernate.connection.datasource' = java:/comp/env/jdbc/OpenKMDS
2014-10-28 08:07:14,010 [localhost-startStop-1] INFO  com.openkm.dao.HibernateUtil- Hibernate 'hibernate.hbm2ddl.auto' = none
2014-10-28 08:07:14,011 [localhost-startStop-1] INFO  com.openkm.dao.HibernateUtil- Hibernate 'hibernate.show_sql' = false
2014-10-28 08:07:14,011 [localhost-startStop-1] INFO  com.openkm.dao.HibernateUtil- Hibernate 'hibernate.generate_statistics' = false
2014-10-28 08:07:14,011 [localhost-startStop-1] INFO  com.openkm.dao.HibernateUtil- Hibernate 'hibernate.search.default.directory_provider' = org.hibernate.search.store.FSDirectoryProvider
2014-10-28 08:07:14,011 [localhost-startStop-1] INFO  com.openkm.dao.HibernateUtil- Hibernate 'hibernate.search.default.indexBase' = /media/a7e96974-7965-4103-9743-281802f3d956/eapenas_openkm/repository/index
-------------------------------------------
2014-10-28 08:07:28,298 [localhost-startStop-1] INFO  com.openkm.util.DocConverter- *** Build Office Manager ***
2014-10-28 08:07:28,299 [localhost-startStop-1] INFO  com.openkm.util.DocConverter- system.openoffice.path=/usr/lib/libreoffice
2014-10-28 08:07:28,299 [localhost-startStop-1] INFO  com.openkm.util.DocConverter- system.openoffice.tasks=200
2014-10-28 08:07:28,299 [localhost-startStop-1] INFO  com.openkm.util.DocConverter- system.openoffice.port=2002
2014-10-28 08:07:28,442 [localhost-startStop-1] INFO  org.artofsolving.jodconverter.office.ProcessPoolOfficeManager- ProcessManager implementation is SigarProcessManager
Oct 28, 2014 8:07:28 AM org.artofsolving.jodconverter.office.ProcessPoolOfficeManager <init>
INFO: ProcessManager implementation is SigarProcessManager
2014-10-28 08:07:28,527 [OfficeProcessThread-0] WARN  org.artofsolving.jodconverter.office.OfficeProcess- profile dir '/usr/local/openkm/temp/.jodconverter_socket_host-127.0.0.1_port-2002' already exists; deleting
Oct 28, 2014 8:07:28 AM org.artofsolving.jodconverter.office.OfficeProcess prepareInstanceProfileDir
WARNING: profile dir '/usr/local/openkm/temp/.jodconverter_socket_host-127.0.0.1_port-2002' already exists; deleting
2014-10-28 08:07:28,547 [OfficeProcessThread-0] WARN  org.artofsolving.jodconverter.office.OfficeProcess- could not delete profileDir: Failed to list contents of /usr/local/openkm/temp/.jodconverter_socket_host-127.0.0.1_port-2002; renamed it to /usr/local/openkm/temp/.jodconverter_socket_host-127.0.0.1_port-2002.old.1414480048542
Oct 28, 2014 8:07:28 AM org.artofsolving.jodconverter.office.OfficeProcess deleteProfileDir
WARNING: could not delete profileDir: Failed to list contents of /usr/local/openkm/temp/.jodconverter_socket_host-127.0.0.1_port-2002; renamed it to /usr/local/openkm/temp/.jodconverter_socket_host-127.0.0.1_port-2002.old.1414480048542
2014-10-28 08:07:28,551 [OfficeProcessThread-0] INFO  org.artofsolving.jodconverter.office.OfficeProcess- starting process with acceptString 'socket,host=127.0.0.1,port=2002,tcpNoDelay=1' and profileDir '/usr/local/openkm/temp/.jodconverter_socket_host-127.0.0.1_port-2002'
Oct 28, 2014 8:07:28 AM org.artofsolving.jodconverter.office.OfficeProcess start
INFO: starting process with acceptString 'socket,host=127.0.0.1,port=2002,tcpNoDelay=1' and profileDir '/usr/local/openkm/temp/.jodconverter_socket_host-127.0.0.1_port-2002'
2014-10-28 08:07:28,615 [OfficeProcessThread-0] INFO  org.artofsolving.jodconverter.office.OfficeProcess- started process; pid = 5508
Oct 28, 2014 8:07:28 AM org.artofsolving.jodconverter.office.OfficeProcess start
INFO: started process; pid = 5508
2014-10-28 08:07:34,759 [OfficeProcessThread-0] INFO  org.artofsolving.jodconverter.office.OfficeConnection- connected: 'socket,host=127.0.0.1,port=2002,tcpNoDelay=1'
Oct 28, 2014 8:07:34 AM org.artofsolving.jodconverter.office.OfficeConnection connect
INFO: connected: 'socket,host=127.0.0.1,port=2002,tcpNoDelay=1'
2014-10-28 08:07:34,768 [localhost-startStop-1] INFO  com.openkm.extension.core.ExtensionManager- Initialize and load plugins...
2014-10-28 08:07:34,941 [localhost-startStop-1] WARN  net.xeoh.plugins.base.impl.classpath.loader.FileLoader- Supplied path does not exist. Unable to add plugins from there.
Oct 28, 2014 8:07:34 AM net.xeoh.plugins.base.impl.classpath.loader.FileLoader loadFrom
WARNING: Supplied path does not exist. Unable to add plugins from there.
2014-10-28 08:07:34,945 [localhost-startStop-1] INFO  com.openkm.servlet.RepositoryStartupServlet- *** Execute start script ***
2014-10-28 08:07:34,949 [localhost-startStop-1] WARN  com.openkm.util.ExecutionUtils- Unable to read script: /usr/local/openkm/start.bsh
2014-10-28 08:07:34,950 [localhost-startStop-1] WARN  com.openkm.util.ExecutionUtils- Unable to read jar: /usr/local/openkm/start.jar
2014-10-28 08:07:34,950 [localhost-startStop-1] INFO  com.openkm.servlet.RepositoryStartupServlet- *** Execute start SQL ***
2014-10-28 08:07:34,950 [localhost-startStop-1] WARN  com.openkm.servlet.RepositoryStartupServlet- Unable to read sql: /usr/local/openkm/start.sql
2014-10-28 08:07:35,153 [localhost-startStop-1] WARN  org.apache.chemistry.opencmis.server.impl.atompub.CmisAtomPubServlet- CMIS version is not defined! Setting it to CMIS 1.0.
2014-10-28 08:07:35,291 [localhost-startStop-1] INFO  org.apache.catalina.startup.HostConfig- Deploying web application directory /usr/local/openkm/webapps/ROOT
2014-10-28 08:07:38,887 [main] INFO  org.apache.coyote.http11.Http11AprProtocol- Starting ProtocolHandler ["http-apr-0.0.0.0-8080"]
2014-10-28 08:07:38,945 [main] INFO  org.apache.coyote.ajp.AjpAprProtocol- Starting ProtocolHandler ["ajp-apr-127.0.0.1-8009"]
2014-10-28 08:07:38,961 [main] INFO  org.apache.catalina.startup.Catalina- Server startup in 143008 ms
2014-10-28 08:07:39,498 [http-apr-0.0.0.0-8080-exec-2] INFO  org.apache.coyote.http11.Http11AprProcessor- Error parsing HTTP request header
 Note: further occurrences of HTTP header parsing errors will be logged at DEBUG level.
2014-10-28 08:07:39,501 [http-apr-0.0.0.0-8080-exec-1] INFO  org.apache.coyote.http11.Http11AprProcessor- Error parsing HTTP request header
 Note: further occurrences of HTTP header parsing errors will be logged at DEBUG level.

It seems to start everything including office, but dies in the end and the screen just comes up black.

gracias

[gwaitsi]

this is rather strange......

It works under Chrome v38, but obviously it says "browser has no java support" for scanner and uploader
but it does not work unders firefox, where java is supported.

does that help narrow the possibilities

[gwaitsi]

Further update:

Windows Client
IE11 - Working with Java Applet for Uploading / Scanning
Chrome v38 - Working with Java Applet for Uploading / Scanning
Firefox 33 - Reports Java Deployment Toolkit has known security vulnerabilities and has therefore been blocked.

Ubuntu Client
Chrome v38 - Working without Java support i.e. no Uploading / Scanning due to removal of NPAPI support
Firefox 33 - Just get a blank screen. No warnings, etc

But interestingly, when i use Ubuntu clients to access the application on the Ubuntu Desktop which connects to the nas db, it works fine

[jllort]

for what I undertanding you has succesfuly moved to nas no ? I saw 2014-10-28 08:07:38,961 [main] INFO org.apache.catalina.startup.Catalina- Server startup in 143008 ms in your log and seems right ?
About the question of java applets, please add other post about it, is not good idea merge several questions on same post, that cause a lot of confusion to the users, thanks.

[gwaitsi]

hi jllort,

in principle i think yes, you can say the move is completed and now there are some minor issues that don't appear on the desktop install.

I will try to break the issues down to separate topics per your proposal.

cheers