1 2 Previous Next 10 Replies Latest reply on Mar 7, 2008 11:03 PM by TimoG

    Moving MSDE to SQL Server 2005

      Hey

      Currently my ePO 3.6.1 is running against a local MSDE db. I want to move my MSDE to a SQL Server 2005 server.

      So I shutdown the ePO and MSDE services on the ePO server.

      I copied ePO's mdf and the ldf to the SQL 2005 server. Then I "Attached Database".

      In SQL Server Mgmt Studio the database is listed and is running. Compat Mode is 80.

      Back on the ePO server I
      - ran CfgNAIMs and changed the SQL server name to the SQL servers name and the database name to the correct db name
      - edited the reg and deleted the key DependOnService for both EVENTPARSER and RSDSERVER.
      - edited SQL-Jobs.sql and changed SERVERNAM_ePO to both ePO DB NAME and also ePO_LAB-EPO_SQLDB (name of the DB on SQL 2005)

      All this goes just fine but when I try and logon to the ePO Console I get an error Server Not Responding. Please Verify: 1 Logon Info is correct 2 The network is running correctly. 3 ePO server is running etc...

      When I use CfgNAIMs to change the DB location back to the MSDE I can login fine , only when the DB is on the SQL server I can not login.

      Thanks very much for any ideas !

      TimoG
        • 1. RE: Moving MSDE to SQL Server 2005
          metalhead
          Please post your epoapsvr.log (epo installdir\db\logs) and epo.log (epo installdir\tomcat\logs) after trying to logon to your MS SQL Server. Be sure to restart the epo services after changing the cfgnaims.exe information.
          • 2. epo.log
            Thanks for the tip , I have been restarting the services after I make any changes in CfgNaiMs. Here is the most recent from epo.log . These SQL Server errors do not look good.. any ideas?

            2008-02-28 08:58:50,963 WARN base.Database - Unable to dynamically obtain MS SQL Server password. Using 9999; change property epo.default.db.port if this is not correct.
            2008-02-28 08:58:59,656 WARN base.Database - Unable to dynamically obtain MS SQL Server password. Using 1433; change property epo.default.db.port if this is not correct.
            2008-02-28 08:59:05,874 WARN base.Database - Unable to dynamically obtain MS SQL Server password. Using 1433; change property epo.default.db.port if this is not correct.
            2008-02-28 08:59:13,315 WARN base.Database - Unable to dynamically obtain MS SQL Server password. Using 1433; change property epo.default.db.port if this is not correct.
            2008-02-28 08:59:19,404 WARN base.Database - Unable to dynamically obtain MS SQL Server password. Using 1433; change property epo.default.db.port if this is not correct.
            2008-02-28 08:59:20,125 ERROR server.Server - java.lang.NullPointerException
            2008-02-28 08:59:20,125 ERROR servlet.ControllerServlet - Error initializing WebUi null
            java.lang.NullPointerException
            at com.mcafee.epo.webui.server.Server.reloadConfiguration(Server.java:193)
            at com.mcafee.epo.webui.server.Server.init(Server.java:75)
            at com.mcafee.epo.webui.servlet.ControllerServlet.init(ControllerServlet.java:57)
            at javax.servlet.GenericServlet.init(GenericServlet.java:256)
            at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:935)
            at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:823)
            at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:342 7)
            at org.apache.catalina.core.StandardContext.start(StandardContext.java:3628)
            at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:821)
            at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807)
            at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595)
            at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java :307)
            at org.apache.catalina.core.StandardHost.install(StandardHost.java:788)
            at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:559)
            at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:401)
            at org.apache.catalina.startup.HostConfig.start(HostConfig.java:718)
            at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:358)
            at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.j ava:166)
            at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1196)
            at org.apache.catalina.core.StandardHost.start(StandardHost.java:754)
            at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188)
            at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:363)
            at org.apache.catalina.core.StandardService.start(StandardService.java:497)
            at org.apache.catalina.core.StandardServer.start(StandardServer.java:2190)
            at org.apache.catalina.startup.CatalinaService.start(CatalinaService.java:273)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.apache.catalina.startup.BootstrapService.start(BootstrapService.java:245)
            at org.apache.catalina.startup.BootstrapService.main(BootstrapService.java:307)
            2008-02-28 08:59:42,778 WARN base.Database - Unable to dynamically obtain MS SQL Server password. Using 9999; change property epo.default.db.port if this is not correct.
            2008-02-28 08:59:51,490 WARN base.Database - Unable to dynamically obtain MS SQL Server password. Using 1433; change property epo.default.db.port if this is not correct.
            2008-02-28 09:00:11,889 ERROR server.Server - java.lang.NullPointerException
            2008-02-28 09:00:11,889 ERROR servlet.ControllerServlet - Error initializing WebUi null
            java.lang.NullPointerException
            at com.mcafee.epo.webui.server.Server.reloadConfiguration(Server.java:193)
            at com.mcafee.epo.webui.server.Server.init(Server.java:75)
            at com.mcafee.epo.webui.servlet.ControllerServlet.init(ControllerServlet.java:57)
            at javax.servlet.GenericServlet.init(GenericServlet.java:256)
            at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:935)
            at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:823)
            at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:342 7)
            at org.apache.catalina.core.StandardContext.start(StandardContext.java:3628)
            at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:821)
            at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807)
            at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595)
            at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java :307)
            at org.apache.catalina.core.StandardHost.install(StandardHost.java:788)
            at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:559)
            at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:401)
            at org.apache.catalina.startup.HostConfig.start(HostConfig.java:718)
            at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:358)
            at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.j ava:166)
            at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1196)
            at org.apache.catalina.core.StandardHost.start(StandardHost.java:754)
            at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188)
            at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:363)
            at org.apache.catalina.core.StandardService.start(StandardService.java:497)
            at org.apache.catalina.core.StandardServer.start(StandardServer.java:2190)
            at org.apache.catalina.startup.CatalinaService.start(CatalinaService.java:273)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.apache.catalina.startup.BootstrapService.start(BootstrapService.java:245)
            at org.apache.catalina.startup.BootstrapService.main(BootstrapService.java:307)
            2008-02-28 09:00:12,580 ERROR server.Server - java.lang.NullPointerException
            2008-02-28 09:00:12,580 ERROR servlet.ControllerServlet - Error initializing WebUi null
            java.lang.NullPointerException
            at com.mcafee.epo.webui.server.Server.reloadConfiguration(Server.java:193)
            at com.mcafee.epo.webui.server.Server.init(Server.java:75)
            at com.mcafee.epo.webui.servlet.ControllerServlet.init(ControllerServlet.java:57)
            at javax.servlet.GenericServlet.init(GenericServlet.java:256)
            at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:935)
            at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:668)
            at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 210)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNe xt(StandardPipeline.java:643)
            at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
            at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 191)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNe xt(StandardPipeline.java:643)
            at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.ja va:551)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNe xt(StandardPipeline.java:641)
            at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNe xt(StandardPipeline.java:641)
            at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
            at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
            at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422)
            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNe xt(StandardPipeline.java:643)
            at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.jav a:171)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNe xt(StandardPipeline.java:641)
            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:163)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNe xt(StandardPipeline.java:641)
            at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
            at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:17 4)
            at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNe xt(StandardPipeline.java:643)
            at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
            at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
            at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199)
            at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828)
            at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnecti on(Http11Protocol.java:700)
            at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584)
            at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:6 83)
            at java.lang.Thread.run(Thread.java:534)
            • 3. EpoApSvr.log
              and here is the most recent from EpoApSvr.log , thanks very much for any assistance!!



              20080227134702 I #680 RManJNI Starting RManJNI
              20080227134703 I #680 RManJNI SPipe site appended to sitelist
              20080227134703 I #680 RManJNI Updating sitelist file C:\Program Files\McAfee\ePO\3.6.1\DB\SiteMgr.xml...
              20080227134703 I #680 RManJNI SPipe site appended to sitelist
              20080227134703 I #680 RManJNI Updating sitelist file C:\Program Files\McAfee\ePO\3.6.1\DB\SiteList.xml...
              20080227134703 I #680 RManJNI SiteList updated, copy sitelist...
              20080227134704 I #680 RManJNI Checking agent package: CURRENT\EPOAGENT2000LYNX\INSTALL\0409
              20080227134704 I #680 RManJNI Checking agent zip package integrity...
              20080227134704 I #680 RManJNI Create Agent Zip Package...
              20080227134704 I #680 RManJNI compressing file Uninst.sh...
              20080227134704 I #680 RManJNI compressing file Install.sh...
              20080227134704 I #680 RManJNI compressing file ale-2.0.2-116.i386.rpm...
              20080227134704 I #680 RManJNI compressing file siteinfo.ini...
              20080227134704 I #680 RManJNI Check agent sfx file integrity...
              20080227134704 I #680 RManJNI Create Agent Sfx Package C:\Program Files\McAfee\ePO\3.6.1\DB\Software\CURRENT\EPOAGENT2000LYNX\INSTALL\0409\aleins t...
              20080227134704 I #680 RManJNI Checking agent package: CURRENT\EPOAGENT3000\INSTALL\0409
              20080227134704 I #680 RManJNI Checking agent zip package integrity...
              20080227134704 I #680 RManJNI Checked agent zip package failed!
              20080227134704 I #680 RManJNI Checked agent sfx file failed!
              20080227134704 I #680 RManJNI Signaling Repository Manager open for business()
              20080227134731 I #3904 EPOJNI Initialize server event log file C:\Program Files\McAfee\ePO\3.6.1\DB\naimserv.log
              20080227134731 I #3904 EPOJNI Getting license data...
              20080227134731 I #3904 EPOJNI Got license data, buffer size = 153
              20080227134734 I #3904 EPOJNI Getting license data...
              20080227134734 I #3904 EPOJNI Got license data, buffer size = 153
              20080227134734 I #3904 EPOJNI Getting license data...
              20080227134734 I #3904 EPOJNI Got license data, buffer size = 153
              20080227134734 I #1920 EPOJNI Getting license data...
              20080227134734 I #1920 EPOJNI Got license data, buffer size = 153
              20080227134734 I #3904 EPOJNI Getting license data...
              20080227134734 I #3904 EPOJNI Got license data, buffer size = 153
              20080227134734 I #1920 EPOJNI Getting license data...
              20080227134734 I #1920 EPOJNI Got license data, buffer size = 153
              20080227134734 I #3904 EPOJNI Getting license data...
              20080227134734 I #3904 EPOJNI Got license data, buffer size = 153
              20080227134735 I #1920 EPOJNI Getting license data...
              20080227134735 I #1920 EPOJNI Got license data, buffer size = 153
              20080227134746 I #2660 EPOJNI Getting license data...
              20080227134746 I #2660 EPOJNI Got license data, buffer size = 153
              20080227134746 I #1920 EPOJNI Getting license data...
              20080227134746 I #1920 EPOJNI Got license data, buffer size = 153
              20080227134746 I #2660 EPOJNI Getting license data...
              20080227134746 I #2660 EPOJNI Got license data, buffer size = 153
              20080227134749 I #1920 EPOJNI Getting license data...
              20080227134749 I #1920 EPOJNI Got license data, buffer size = 153
              20080227134837 I #2996 DAL ePO 3.6 DAL exit
              20080227135405 I #1860 RManJNI Starting RManJNI
              20080227135406 I #1860 RManJNI Checking agent package: CURRENT\EPOAGENT2000LYNX\INSTALL\0409
              20080227135406 I #1860 RManJNI Checking agent zip package integrity...
              20080227135406 I #1860 RManJNI Checked agent zip package OK!
              20080227135406 I #1860 RManJNI Check agent sfx file integrity...
              20080227135406 I #1860 RManJNI Checked agent sfx file OK!
              20080227135406 I #1860 RManJNI Checking agent package: CURRENT\EPOAGENT3000\INSTALL\0409
              20080227135406 I #1860 RManJNI Checking agent zip package integrity...
              20080227135406 I #1860 RManJNI Checked agent zip package failed!
              20080227135406 I #1860 RManJNI Checked agent sfx file failed!
              20080227135406 I #1860 RManJNI Signaling Repository Manager open for business()
              20080227135409 I #3724 EPOJNI Initialize server event log file C:\Program Files\McAfee\ePO\3.6.1\DB\naimserv.log
              20080227135409 I #3724 EPOJNI Getting license data...
              20080227135409 I #3724 EPOJNI Got license data, buffer size = 153
              20080227135411 I #3724 EPOJNI Getting license data...
              20080227135411 I #3724 EPOJNI Got license data, buffer size = 153
              20080227135411 I #1508 EPOJNI Getting license data...
              20080227135411 I #1508 EPOJNI Got license data, buffer size = 153
              20080227135411 I #3724 EPOJNI Getting license data...
              20080227135411 I #3724 EPOJNI Got license data, buffer size = 153
              20080227135411 I #1508 EPOJNI Getting license data...
              20080227135411 I #1508 EPOJNI Got license data, buffer size = 153
              20080227135411 I #3724 EPOJNI Getting license data...
              20080227135411 I #3724 EPOJNI Got license data, buffer size = 153
              20080227135411 I #1508 EPOJNI Getting license data...
              20080227135411 I #1508 EPOJNI Got license data, buffer size = 153
              20080227135411 I #3724 EPOJNI Getting license data...
              20080227135411 I #3724 EPOJNI Got license data, buffer size = 153
              20080227135447 I #1552 EPOJNI Getting license data...
              20080227135447 I #1552 EPOJNI Got license data, buffer size = 153
              20080227135501 I #3724 EPOJNI Getting license data...
              20080227135501 I #3724 EPOJNI Got license data, buffer size = 153
              20080227135503 I #3532 EPOJNI Getting license data...
              20080227135503 I #3532 EPOJNI Got license data, buffer size = 153
              20080227135503 I #1552 EPOJNI Getting license data...
              20080227135503 I #1552 EPOJNI Got license data, buffer size = 153
              20080227135503 I #3532 EPOJNI Getting license data...
              20080227135503 I #3532 EPOJNI Got license data, buffer size = 153
              20080227135503 I #1552 EPOJNI Getting license data...
              20080227135503 I #1552 EPOJNI Got license data, buffer size = 153
              20080227135503 I #3532 EPOJNI Getting license data...
              20080227135503 I #3532 EPOJNI Got license data, buffer size = 153
              20080227135503 I #1552 EPOJNI Getting license data...
              20080227135503 I #1552 EPOJNI Got license data, buffer size = 153
              20080227135503 I #3532 EPOJNI Getting license data...
              20080227135503 I #3532 EPOJNI Got license data, buffer size = 153
              20080227135510 I #3532 EPOJNI Getting license data...
              20080227135510 I #3532 EPOJNI Got license data, buffer size = 153
              20080227135521 I #1760 DAL ePO 3.6 DAL exit
              • 4. RE: EpoApSvr.log
                metalhead
                2008-02-28 09:00:12,580 ERROR servlet.ControllerServlet - Error initializing WebUi null
                java.lang.NullPointerException

                Edit the atlas.properties file in c:\Program Files\Common Files\McAfee\Tomcat\conf\epo:

                Change
                epo.default.db.port = 9999
                to
                epo.default.db.port = 1433

                Restart the ePO services and try again.
                • 5. Working now!
                  Right on, I just did that and its working! Thanks very much!
                  • 6. RE: EpoApSvr.log


                    This just solved my problem too. Moved EPO 3.6.1 from MSDE on one server to our MS SQL 2005 server. Followed the kb article from NAI, but couldn't log on to the server anymore. This just solved the issue. Perhaps NAI should put it in their kb article.

                    Thanks metalhead!

                    Eric
                    • 7. RE: EpoApSvr.log
                      tonyb99
                      epo.default.db.port = 1433

                      This the default port for 4.0 and is in the documentation already
                      • 8. RE: EpoApSvr.log


                        As metalhead wrote, the entry said 9999 and I had to manually change it to 1433. This is not in the documentation for moving EPO 3.6.x to another SQL server.
                        Besides, I am not using 4.0, as I wrote before. Please be so kind to actually read my message before replying.
                        • 9. RE: EpoApSvr.log
                          tonyb99
                          Apols you are correct epo.default.db.port = 1433 is just the default SQL port that is in use by SQL if it hasnt been changed, I assumed you were moving to 4.0 but this is equally valid for 3.6.x

                          Docs:

                          Verify and change the SQL port to the port that the new SQL server is using, if necessary.

                          1. Verify the SQL port that the new server is using against what the ePO server is currently configured to use.

                            NOTE: If moving an MSDE database to a remote SQL server, the SQL ports will most likely be different and must be changed.[LIST=1]
                          2. Click Start, Run, type: SVRNETCN, and click OK.
                          3. Ensure that the name displayed next to Instance(s) on this server is the name of the SQL server.
                          4. Ensure that Named Pipes and TCP/IP display under Enabled protocols.
                          5. Under Enabled protocols, click TCP/IP and select Properties.

                            NOTE: TCP port 1433 displays in the Default port: field by default.

                          [*]If the ports are different, change the SQL port on the new SQL server to the port that the new SQL server is using, per the methods listed in article [COLOR=#0000ff]KB45788[/COLOR].[/LIST]quoted above:

                          Recommended steps for migrating or moving the ePO database to a new SQL server
                          https://knowledge.mcafee.com/SupportSite/search.do?cmd=displayKC&docType=kc&exte rnalId=KB47986&sliceId=SAL_Public&dialogID=24788803&stateId=1 0 24790859
                          1 2 Previous Next