2 Replies Latest reply on Jun 17, 2013 7:57 AM by waynediesel

    CSR: GetConnectionException: Access denied for user

      All -

       

      When attempting to run a query in ePO using the CSR log source, I have all of a sudden began receiving this error message:

       

      "com.mcafee.orion.core.template.db.exception.GetConnectionException: Access denied for user:'dba'@'XXXXXXX.domain.com' (using password: YES)"

       

      Has anyone ever seen this?

        • 1. Re: CSR: GetConnectionException: Access denied for user
          andyclements

          This looks like the user account used to access your database is being denied.  Has the password changed or expired?

          • 2. Re: CSR: GetConnectionException: Access denied for user

            Andy -

             

            You are corect, the account was being denied. How that account got to be that way, however, I have no idea.

             

            My instance of CSR is the default, locally installed version of MySQL with the standard account. There are no password complexities or expirations associated with the default setup. This just happened all of a sudden and then I could no longer run an report that pulled data from the CSR.

             

            I did manage to fix this issue, though:

             

            I manually stopped/started all of the McAfee services for ePO and CSR on the server and then this fixed the issue. I wish I knew a root cause, but have none, and there is very little documented on CSR and troubleshooting.