Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Configure SSL SMTP Gmail for Scheduler Job in OBIEE 12c

Received Response
91
Views
11
Comments
quanvlm
quanvlm Rank 1 - Community Starter
edited Aug 13, 2024 6:17PM in Oracle Analytics Cloud and Server

Hi all,

     I had problems while configure google smtp mail service (SSL 465/ TLS 587) as smtp for scheduler job in my OBIEE 12c with error follows:

[nQSError: 75025] Handshake failed when connecting to SMTP server using SSL. AgentID: /users/weblogic/test agent

...Trying SMTP Delivery loop again... Sleeping for 3 seconds. AgentID: /users/weblogic/test agent

[nQSError: 75025] Handshake failed when connecting to SMTP server using SSL. AgentID: /users/weblogic/test agent

...Trying SMTP Delivery loop again... Sleeping for 5 seconds. AgentID: /users/weblogic/test agent

[nQSError: 75025] Handshake failed when connecting to SMTP server using SSL. AgentID: /users/weblogic/test agent

...Trying SMTP Delivery loop again... Sleeping for 8 seconds. AgentID: /users/weblogic/test agent

[nQSError: 75025] Handshake failed when connecting to SMTP server using SSL. AgentID: /users/weblogic/test agent

Exceeded number of SMTP delivery retries.


I have disabled firewall on my OBIEE server, but the problem still has occured. I tried gmx.com (port 25) as my smtp for scheduler job.

Are there any advice for me to resolve this problem?


Hope to see any feedback!


«1

Answers

  • handat
    handat Rank 5 - Community Champion

    You are getting a handshake error which means there is a problem with the SSL certificate validation or exchange. Add the following to your weblogic environment to get more detailed info about the problem for debug and diagnostic:

    -Dssl.debug=true -Dweblogic.StdoutDebugEnabled=true -Dweblogic.security.SSL.verbose=true

  • quanvlm
    quanvlm Rank 1 - Community Starter

    Thanks for you quick reply but still failed. My nqscheduler.log file as follow:

    2016-05-27_12-19-21.jpg

    There is any other suggestion for me? Thanks.

  • handat
    handat Rank 5 - Community Champion

    The gmail smtp will present back three certificates. Make sure the CA is trusted by your truststore. If not, import it into it as trusted.

    Here's a summary of that CA cert:

      Subject: CN=GeoTrust Global CA, O=GeoTrust Inc., C=US

      Signature Algorithm: SHA1withRSA, OID = 1.2.840.113549.1.1.5

      Key:  Sun RSA public key, 2048 bits

      modulus: 27620593608073140957439440929253438012688864718977347268272053725994928948867769687165112265058896553974818505070806430256424431940072485024407486246475597522063246121214348496326377341879755851197260401080498544606788760407243324127929930612201002157618691487713632251700065187865963692723720912135393438861302779432180613616167225206519123176430362410262429702404863434904116727055203524505580952824336979641923534005571504410997292144760317953739063178352809680844232935574095508445145910310675421726257114605895831426222686272114090063230017292595425393719031924942422176213538487957041730136782988405751614792953

      public exponent: 65537

      Validity: [From: Tue May 21 14:00:00 AEST 2002,

                   To: Tue Aug 21 14:00:00 AEST 2018]

      Issuer: OU=Equifax Secure Certificate Authority, O=Equifax, C=US

      SerialNumber: [    12bbe6]

  • quanvlm
    quanvlm Rank 1 - Community Starter

    Thanks @handat,

         Let me try with your advice.

  • quanvlm
    quanvlm Rank 1 - Community Starter

    I tried to add Gmail ca to OBIEE truststore, but still got error. I back to Oracle default mail server, port 25, it's OK. I gave up with Gmail configuration.  

  • LuisGodoy
    LuisGodoy Rank 1 - Community Starter

    i have the same error,  had looked for the solution in web forums but anyone know how to solve it,  i´m back to use a non secure port 25.

    AgentID:

    [nQSError: 75025] Handshake failed when connecting to SMTP server using SSL.    AgentID: /shared/....

    [nQSError: 75025] Handshake failed when connecting to SMTP server using SSL.    AgentID: /shared/....


    I created a folder where save cert files but just not work


  • JoazVieira
    JoazVieira Rank 1 - Community Starter

    Hi, i know how to resolve this problem.

    My domain use to google apps. My e-mails sent for obiee do not sent, the cause is because the error rejected by server.

    The Google page,  report aspmx.l.google.com do not sent e-mail for other domains, except google and gmail.

    https://support.google.com/a/answer/176600?hl=pt-BR

    Then, we have create entry SPF, type TXT in our registry DNS domain.

    https://support.google.com/a/answer/178723?hl=pt-BR&ref_topic=2759192

    My problem its resolved, its work now.

  • LuisGodoy
    LuisGodoy Rank 1 - Community Starter

    Thanks for this information, in addition I must say that in the account settings should not put anything in user and password.

    Currently it is working with gmail and has been solved perfectly

    I do not know why not work with ssl, fortunately already been solved using port 25

    Thank you again

    configemailobiee.jpg

  • JoazVieira
    JoazVieira Rank 1 - Community Starter

    Yes @LuisGodoy

    My obiee it is working with gmail perfectly. use port 25.

    But not send e-mails for other domains.

    The solution for the problem, i describe up topic.

    Joaz

  • LuisGodoy
    LuisGodoy Rank 1 - Community Starter

    I have done a test, trying to send to other servers and to run properly, the agent configuration I have placed 3 email accounts from different domains and has passed with no problem,  configagente.jpgconfigagente2.jpg