OBIEE 11G - SMTP SSL Configuration

User_GT6FK

Hi everyone

I'm using obiee 11g (11.1.1.7) for dispatching daily mails with refresh dashboards.

Now Mail services asks to communicate with SMTP Server through secure channel.

BI architecture is not SSL enable.

SSL is used only to communicate with external LDAP.

I'm having troubles trying to configure Mail Server settings used by Oracle BI Agents.

Executing BI Agent I get the following error:

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

In OBIEE configuration is accomplished in EM --> Deployment --> Mail

Secure Socket Layer (SSL) Configuration:

SSL Configuration is with STARTTLS default port 25 .

'CA certificate source' : File.  Pointing to CA_ROOT.pem

SSL certificate verification depth: 3

SSL cipher list: empty

Certificates are  two: one Root and one Intermediate type .

Both are in .pem format.

Keep in mind that sending mail through openssl completes without problem,  first I run the following command:

openssl s_client -starttls smtp -connect smtpapplication.server:25 -CApath /home/oradba/MailCertificates_Pem -CAfile /home/oradba/MailCertificates_Pem/CA_ROOT.pem

After establishing the connection, it is required to execute 'ehlo test' or it's impossible to complete following steps.

Then I execute 'auth login' and finally is it possible to send mail.

Pls suggest possible solution to solve issue.

I guess should be related to correct management of 'ehlo test' step.

Thanks

Antonio

SteveF-Oracle

@3595316

Antonio,
Most modern mail servers (e.g. - office365, gmail, etc.) require STARTTLS and second ehlo.

The RFC in OBI 11g is not up-to-date to modern smtp and was never certified. OBI 12c 12.2.1.3 was the first version to support STARTTLS with the newer RFC
11.1.1.7 was released in 2013 and is out of Support.

I would recommend that you begin the process to migrate to Oracle Analytics Server 5.5 (the new rebranding of Oracle Business Intelligence), so that you have the latest features, certification, and support.

https://docs.oracle.com/en/middleware/bi/analytics-server/index.html