OBIEE 12C SMTP Server Configuration

BASSAM CHEHABEDDINE

Dears,

i am trying to configure smtp server in obiee and for test i am using gmail..

after creating agent and devices to account who i want to sent the analysis to the following error is showing:

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

any advice?

BR

Bassam

[Deleted User]

3660348 wrote:
and for test i am using gmail

Well what kind of settings are you using? EXACTLY?

BASSAM CHEHABEDDINE

Hi Christian,

smtp.gmail.com

465

my gmail address

my gmail address

password

SSL/TLS

where I enabled access to less secured apps from my gmail and disabled two way verification

[Deleted User]

SSL requires a certificate. Do you have that?

BASSAM CHEHABEDDINE

Hi,

i download the certificate from the below link  and followed as mentioned

https://blogs.oracle.com/oracleworkflow/configuring-notification-mailer-using-gmails-smtp-and-imap-servers-using-new-cer…

but not able to import the certificate, also when i am trying to use smtp port 25 without any security it is giving me :

[nQSError: 75027] Failed to open connection to SMTP Server (host smtp.gmail.com; port 25).    AgentID: /shared/agenttest..

also i managed to add certificate by  keytool -import  -file /home/oracle/app/cert/gmail_smtp.cer -keystore /home/oracle/app/cert/gmail_smtp -storepass changeit

and use the cert gmail_smtp in the em but still the same error

to note that port 465 is opened in my linux machine and i am able to telnet smtp,gmail.com

[Deleted User]

Google's non-SSL (TLS) post is 587. Not 25.

BASSAM CHEHABEDDINE

thank you a lot, it is working now, i used my domain email address on 587 and it is working now

[Deleted User]

Good!