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