VMware Cloud Community
mattm_hyperic
Contributor
Contributor

Exporting 3.2.1 inter DB for 3.2.3 build?

I had some difficulty upgrading from 3.2.1 to 3.2.3. I did a new install of 3.2.3 on the same server, is there a way to migrate the built in DB of 3.2.1 into 3.2.3?

Thanks in advance.
Reply
0 Kudos
5 Replies
mattm_hyperic
Contributor
Contributor

any thoughts on this? Boils down to being a pain to have to reinstall all my clients again..
Reply
0 Kudos
mattm_hyperic
Contributor
Contributor

Here is my stack trace error I get after starting m old 3.2.1 server:
javax.servlet.jsp.JspException: Cannot open connection; CausedByException is: Cannot open connection; nested exception is: org.hibernate.exception.GenericJDBCException: Cannot open connection; - nested throwable: (org.hibernate.exception.GenericJDBCException: Cannot open connection) at org.hyperic.hq.ui.taglib.HelpTag.doStartTag(HelpTag.java:69) at org.apache.jsp.common.Login_jsp._jspx_meth_hq_help_0(Unknown Source) at org.apache.jsp.common.Login_jsp._jspService(Unknown Source) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301) at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1085) at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:263) at org.apache.struts.action.RequestProcessor.internalModuleRelativeForward(RequestProcessor.java:1023) at org.apache.struts.tiles.TilesRequestProcessor.internalModuleRelativeForward(TilesRequestProcessor.java:345) at org.apache.struts.action.RequestProcessor.processForward(RequestProcessor.java:572) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:221) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.hyperic.hq.ui.AuthenticationFilter.doFilter(AuthenticationFilter.java:120) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.hyperic.hibernate.filter.SessionFilter$1.run(SessionFilter.java:59) at org.hyperic.hq.hibernate.SessionManager.runInSessionInternal(SessionManager.java:79) at org.hyperic.hq.hibernate.SessionManager.runInSession(SessionManager.java:68) at org.hyperic.hibernate.filter.SessionFilter.doFilter(SessionFilter.java:57) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.hyperic.hq.product.servlet.filter.JMXFilter.doFilter(JMXFilter.java:324) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) at java.lang.Thread.run(Unknown Source)
Reply
0 Kudos
admin
Immortal
Immortal

What were the problems you encountered? The migration will be
performed automatically during a normal upgrade procedure. If the
problems that you ran into have to do with the existing database
schema, exporting and re-importing would just cause the same problem.

Charles


Reply
0 Kudos
mattm_hyperic
Contributor
Contributor

I installed the upgrade via RPM - it installed but it wouldn't launch the new version. When i tried starting the new server there were some errors that were reported (forgot to record them) I removed the RPM then installed by source, however it never said anything about upgrading. Now I have 2 versions of the server - 3.2.1 and 3.2.3, only the 3.2.3 starts. When i try to launch 3.2.1, i receive the error above.

So, I'm wondering how I can export the DB from the 3.2.1 into 3.2.3 - thanks for any help.
Reply
0 Kudos
admin
Immortal
Immortal

If you are upgrading, you'll need to pass the -upgrade flag. See: http://support.hyperic.com/confluence/display/DOC/Upgrade+Guide. It should ask you the location of your existing HQ server.

Charles
Reply
0 Kudos