Oracle Analytics Forum

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

0Auth2 E-Mail with Oracle Analytics Server 8.2?

Received Response
21
Views
2
Comments
Tim Ouimet
Tim Ouimet Rank 4 - Community Specialist

Hi Friends!

I've managed to get my head around the patch vs upgrade issue. I feel dumb.

That said - I have a new issue I'm troubleshooting.

I'm trying to get e-mail authentication working with our office365 server.

smtp.office365.com:587 using STARTTLS.

I've configured & tested the Tenant, Secret & Client ID's using independent powershell scripting and they work.

I keep getting a "[nQSError: 75025] Handshake failed when connecting to SMTP server using SSL." in nqscheduler.log. - Same in the Agent1-xx.log files.

Have you encountered this - what was your fix?

38852568

OAS STACK PATCH BUNDLE 8.2.0.0.260115 (Patch 38852511)

38807758

OWSM BUNDLE PATCH 12.2.1.4.251230

38792523

WLS PATCH SET UPDATE 12.2.1.4.251223

38783413

OAS BUNDLE PATCH 8.2.0.0.251219

38759265

FMW Thirdparty Bundle Patch 12.2.1.4.251212

38669934

JDBC19.29 BUNDLE PATCH 12.2.1.4.251117

38665131

OSS 19C BUNDLE PATCH 12.2.1.4.251117

38633461

FMWCONTROL BUNDLE PATCH 12.2.1.4.260120

38590502

PERL 5.40.2 patch for FMW 12.2.1.4.0

38582077

DATABASE RELEASE UPDATE 19.29.0.0.0 FOR FMW DBCLIENT

38447255

RDA release 26.1-2026120 for OFM 12.2.1.4 SPB

38400138

WebCenter Core Bundle Patch 12.2.1.4.250904

38348152

ADF BUNDLE PATCH 12.2.1.4.250822

37056593

One-off

36789759

FMW PLATFORM BUNDLE PATCH 12.2.1.4.240812

36649916

One-off

36316422

OPSS Bundle Patch 12.2.1.4.240220

35965629

ADR FOR WEBLOGIC SERVER 12.2.1.4.0 CPU JAN 2024

1221428

Coherence Cumulative Patch 12.2.1.4.28

35065206

One-off

31032676

One-off

Answers

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics & AI Strategist

    @Tim Ouimet - Please ensure the Office365 CA certificate file used is valid and the certificate details are also updated in mail settings configuration in EM or DV console > Mail settings.

    Certificate should be in .pem format.

    Refer - Agents Fail With ["NQSERROR:75025] Handshake failed" Error When Using Office365 SMTP For Delivery - KB409137

  • Tim Ouimet
    Tim Ouimet Rank 4 - Community Specialist

    Thanks!

    You may appreciate the irony.

    The cmckinnon in the path - is a an old co-worker of mine. I recall us having this issue once upon a time. I've followed the directions but to still no avail.

    I've added the RDA to my ticket with Support.

    Fingers crossed.