9 Replies Latest reply on Sep 28, 2011 9:01 PM by 874079

    Mail configuration OBIEE 11g

    user8007837
      Hi,

      I am getting the following error when I run the agent, which I have created for testing. My OS is MS Windows Server 2008 R2.
      Eventually succeeded, but encountered and resolved errors...
          Number of skipped recipients: 2 of 3
      
          AgentID: /users/jorge/UsageTrackingAgent
      [nQSError: 75005] Failed to send AUTH command. 5.7.8 Error: authentication failed: UGFzc3dvcmQ6    AgentID: /users/jorge/UsageTrackingAgent
          ...Trying SMTP Delivery loop again... Sleeping for 3 seconds.    AgentID: /users/jorge/UsageTrackingAgent
      [nQSError: 75005] Failed to send AUTH command. 5.7.8 Error: authentication failed: UGFzc3dvcmQ6    AgentID: /users/jorge/UsageTrackingAgent
          ...Trying SMTP Delivery loop again... Sleeping for 5 seconds.    AgentID: /users/jorge/UsageTrackingAgent
      [nQSError: 75005] Failed to send AUTH command. 5.7.8 Error: authentication failed: UGFzc3dvcmQ6    AgentID: /users/jorge/UsageTrackingAgent
          ...Trying SMTP Delivery loop again... Sleeping for 8 seconds.    AgentID: /users/jorge/UsageTrackingAgent
      [nQSError: 75005] Failed to send AUTH command. 5.7.8 Error: authentication failed: UGFzc3dvcmQ6    AgentID: /users/jorge/UsageTrackingAgent
          Exceeded number of SMTP delivery retries.
      This is how I have configured Mail setting at Enterprise Manager.
      *SMTP server:*smtp.gmail.com (I tried smtp.emailsrvr.com, port 25)
      *Port:* 587     
      *Display name of sender:* jorge     
      *Email address of sender:* jorge.xyz@gmail.com     
      *Username:*jorge.xyz@gmail.com     
      *Password:* Password of my email
      *Confirm password:* Password of my email     
      *Number of retries upon failure:* 1     
      *Maximum recipients (enter zero for no maximum):* 0
      *Addressing method:* Blind Copy Recipient (Bcc) ( I tried To also)     
      
      Please help to fix this issue. 
      then Activated cnages and Restarted services with no errors.

      Please help to fix this issue.
        • 1. Re: Mail configuration OBIEE 11g
          Amith Y
          In the configuration page where you provide SMTP server and port number details, you will need to use the mail server of your organization instead of using gmail and yahoo.com. You will need to setup your own mail server if you dont have one.
          • 2. Re: Mail configuration OBIEE 11g
            user8007837
            Hi Amit,

            Thanks for your response. I have tried my organization SMTP server as well and getting the same error. But in theory it should work with any valid SAMP sever.

            See the example below,which worked with gmail.

            http://krishnasalapati.blogspot.com/2011/02/ibot-mail-configuration-for-obiee-11g.html

            Cheers,
            Jorge

            Edited by: user8007837 on 26-Apr-2011 10:13
            • 3. Re: Mail configuration OBIEE 11g
              Amith Y
              Did you try to use the port # 25 with gmail server?

              Regards,
              -Amith.
              • 4. Re: Mail configuration OBIEE 11g
                user8007837
                Yes I did.

                Thanks

                Updated:

                I remember I was getting different error, so I tested with port # 25 again. this is the error I am getting
                Eventually succeeded, but encountered and resolved errors...
                    Number of skipped recipients: 2 of 3
                
                    AgentID: /users/jorge/UsageTrackingAgent
                [nQSError: 75005] Failed to send AUTH command. SMTP server does not support any authentication mechanisms.  Remove email credentials, or use a server which supports authentication.    AgentID: /users/jorge/UsageTrackingAgent
                    ...Trying SMTP Delivery loop again... Sleeping for 3 seconds.    AgentID: /users/jorge/UsageTrackingAgent
                [nQSError: 75005] Failed to send AUTH command. SMTP server does not support any authentication mechanisms.  Remove email credentials, or use a server which supports authentication.    AgentID: /users/jorge/UsageTrackingAgent
                    ...Trying SMTP Delivery loop again... Sleeping for 5 seconds.    AgentID: /users/jorge/UsageTrackingAgent
                [nQSError: 75005] Failed to send AUTH command. SMTP server does not support any authentication mechanisms.  Remove email credentials, or use a server which supports authentication.    AgentID: /users/jorge/UsageTrackingAgent
                    ...Trying SMTP Delivery loop again... Sleeping for 8 seconds.    AgentID: /users/jorge/UsageTrackingAgent
                [nQSError: 75005] Failed to send AUTH command. SMTP server does not support any authentication mechanisms.  Remove email credentials, or use a server which supports authentication.    AgentID: /users/jorge/UsageTrackingAgent
                    Exceeded number of SMTP delivery retries.
                Edited by: user8007837 on 26-Apr-2011 10:33
                • 5. Re: Mail configuration OBIEE 11g
                  Amith Y
                  Jorge,

                  Please refer to this link below and perform all the steps in it.

                  http://gerardnico.com/wiki/smtp_telnet

                  Thanks,
                  -Amith.
                  1 person found this helpful
                  • 6. Re: Mail configuration OBIEE 11g
                    user8007837
                    Hi Amilt,

                    Thanks again. I executed Google STARTTLS from the above link, and then run the agent. I am still getting the same error.
                    C:\Users\Administrator>telnet smtp.gmail.com 587
                    
                    
                    220 mx.google.com ESMTP d59sm3142380wed.45
                    EHLO OBIEE
                    250-mx.google.com at your service, [62.97.99.232]
                    250-SIZE 35882577
                    250-8BITMIME
                    250-STARTTLS
                    250 ENHANCEDSTATUSCODES
                    AUTH LOGIN
                    530 5.7.0 Must issue a STARTTLS command first. d59sm3142380wed.45
                    STARTTLS
                    220 2.0.0 Ready to start TLS
                    EHLO OBIEE
                    
                    
                    Connection to host lost.
                    
                    C:\Users\Administrator>
                    Thanks.
                    • 7. Re: Mail configuration OBIEE 11g
                      user8007837
                      Hi,

                      I have at least found where the error is. I think error is in SMTP server, need to find out what. I have created a mail at Gmx.com (as Nico suggested) and used it in the mail config. Its working fine.

                      Amit, I have awarded you points as Helpful answer.

                      Thanks.
                      • 8. Re: Mail configuration OBIEE 11g
                        Amith Y
                        Jorge,

                        I was about to suggest you to do the same. Thanks for the points.

                        Cheers,
                        Amith.
                        • 9. Re: Mail configuration OBIEE 11g
                          874079
                          This happens because the SMTP server does not accept authentication.

                          You need to remove the user and password from credentials.

                          This link shows how to remove the credentials, because there is a bug that does not permit you erase user and password:
                          http://shivabizint.wordpress.com/2011/04/17/to-delete-smtp-settings-in-obiee11g-enterprise-manager/