7 Replies Latest reply: May 16, 2013 12:05 PM by alexn RSS

    EPO 5.0 console is unavailable .

    alexn

      I changed my authentication mode on ePOP 5.0 to MIXD created a new user.

      And today I saw my event parser service was down and i am not having epo console even the config page ia not comming up although Aplication and apache services are up.

       

      Anyone could tell how can I have http://server :8443:/core/config page ant change user or password here so my Event parser could be started.(I also create a DB snapshot from ePO 5.0 Console and I blve it doesnt cause this issue)

       

      This is Event parser log.

      ePOData_Connection.cpp(568): COM Error 0x80040E4D, source=Microsoft OLE DB Provider for SQL Server, desc=Login failed for user 'alexstewart'., msg=IDispatch error #3149

      20130515142732 E #04948 EPODAL   ePOData_Connection.cpp(583): COM Error 0x80040E4D, source=Microsoft OLE DB Provider for SQL Server, desc=Login failed for user 'alexstewart'., msg=IDispatch error #3149

      20130515142732 E #04948 EPODAL   ePOData_Connection.cpp(327): COM Error 0x80040E4D, source=Microsoft OLE DB Provider for SQL Server, desc=Login failed for user 'alexstewart'., msg=IDispatch error #3149

      20130515142732 E #04948 EPODAL   ePOData_Connection.cpp(352): Error 0x80040E4D returned from credentials callback. Database NOT available

      20130515142732 E #04948 EVNTPRSR D:\EPO3\BUILD\epo\dev\src\server\include\ePOData.inl(319): Database initialization: Failed (hr=0x80040E4D).

      20130515142732 E #04948 EVNTPRSR Failed to initialize database layer. Cannot continue.

      20130515142732 I #04948 EVNTPRSR EventParser Stopped.

      20130515142732 I #04948 EVNTPRSR Cleaning up Server...

        • 1. Re: EPO 5.0 console is unavailable .
          ajha1

          Hi alexn,

           

          If you could share the Orion.log then it would be easy for us to give you any suggestion, However what you can do is -

          Stop all the McAfee EPO Services.

           

          Go to <EPO Installation Path>\server\conf\orion\

          Copy db.properties to another location (If something goes bad then you can copy it back )

           

          Then go to <EPO Installation Path>\server\conf\orion\, open db.properties using a text editior (notepad), remove the DB Instance name and Encypted password.

           

          Save the File.

           

          Start Only McAFee EPO Application Service and try to access https://localhost:8443/core/config page and if you are able to access it then enter the required credentials and click on Test Connection.

           

          Assuming that you have entered the correct credentials,If test connection is successfulll, Click on Apply.

           

          Restart the Application Service and Start Other two McAfee EPO Service and try to login and update the post there is any issues.

           

          Message was edited by: ajha1 on 16/5/13 6:59:19 AM IST
          • 2. Re: EPO 5.0 console is unavailable .
            alexn

            No luck with this workaround. I think ePO 5.0 should behave like 4.6.It doesnt understand Windows or Mixd mode and keep on trying with same user even if changed the authentication mode.

             

            Please see orion.log

            • 3. Re: EPO 5.0 console is unavailable .
              ajha1

              The Error is "FATAL [main] core.OrionCore   - killing server. reason = Failed to read the server's multi-tenant mode property (is there a multi.tenant.mode record in the OrionServerProperties table?)"

               

              I am aware of the issue, let me check my notes and revert to you

              • 4. Re: EPO 5.0 console is unavailable .
                alexn

                Ajay, Where I can find Orion Server property table in ePO folders?

                • 5. Re: EPO 5.0 console is unavailable .
                  alexn

                  Hi anyone can let me know this location, this is the fresh event parser log

                   

                  0130516080848 I #06832 EVNTPRSR Initializing Server...

                  20130516080848 I #06832 EVNTPRSR Database initialization: Starting.

                  20130516080848 I #06832 MFEFIPS  Loading: "C:\PROGRA~2\McAfee\EPOLIC~1", Role = Officer, Mode = Normal

                  20130516080848 I #06832 MFEFIPS  Module Initialized.

                  20130516080848 E #06832 EVNTPRSR D:\EPO3\BUILD\epo\dev\src\server\include\ePOData.inl(290): Missing DB connection info in C:\PROGRA~2\McAfee\EPOLIC~1\Server\conf\orion\DBFAC3~1.PRO

                  20130516080848 E #06832 EPODAL   ePOData_Connection.cpp(352): Error 0x80000008 returned from credentials callback. Database NOT available

                  20130516080848 E #06832 EVNTPRSR D:\EPO3\BUILD\epo\dev\src\server\include\ePOData.inl(319): Database initialization: Failed (hr=0x80000008).

                  20130516080848 E #06832 EVNTPRSR Failed to initialize database layer. Cannot continue.

                  20130516080848 I #06832 EVNTPRSR EventParser Stopped.

                  20130516080848 I #06832 EVNTPRSR Cleaning up Server...

                  • 6. Re: EPO 5.0 console is unavailable .
                    JoeBidgood

                    This error is slightly misleading - it's a result of the main issue, which is a failure to authenticate to SQL. The way that ePO 5.0 responds when it can't access the DB is different compared to previous versions, which has the side-effect of making the config-auth page unavailable. (This will be fixed in the next patch.)

                     

                    The way round this is to manually edit the db.properties file (which is what the config-auth page does.) Take a backup copy of the file and then open it in a text editor.

                     

                    • db.user.name  is the name of the account ePO will use to connect to SQL.
                    • db.user.domain indicates if ePO is using Windows or SQL authentication: if blank, it's using SQL: otherwise this is the name of the domain that will be used for Windows authentication.
                    • db.user.passwd.encrypted.ex is the password hash for the account.

                     

                    Change db.user.passwd.encrypted.ex to db.user.passwd and enter the password in plain text. So for example if the password was "foobar", the entry might look like this:

                    db.user.passwd.encrypted.ex=WiZy6IX3X4iLqq6AljJWHA\=\=

                     

                    You would change it to:

                    db.user.passwd=foobar

                     

                    Save and close the file, and start the application server service. (Don't start the other ePO services yet.) Once started, go to the config-auth page and re-enter the password, and test the connection. Assuming the test passes, click Save, which will save the hash back to the db.properties file. You can then start the other services.

                     

                    HTH -

                     

                    Joe

                    • 7. Re: EPO 5.0 console is unavailable .
                      alexn

                      Thank you Joe It resolved the issue.

                       

                      Thank you Ajay.You were realy helpful.

                       

                      Joe, You are right I noticed this thing in ePO 5.0, So advice would be if we change ourSQL user then Manaually change db.propereties file and then we can get config page else not.

                       

                      on 5/16/13 12:05:03 PM CDT