Smtp server - backup scripts

[satish]

Dear erman,

We have recieved an smtp server and port 465,along with cert1.pem file from vendor.

We are using below mailx command to test sending email from our backup shell scripts(L0,L1,ARCHIVELOG)

We have recieved an smtp server and port 465,along with cert1.pem file.

We are using below mailx command to test sending email from our backup scripts(L0,L1,ARCHIVELOG)

mailx -v -r 'ARC Backup<[e-mail]>' -s 'ATTENTION!: Archive log backups of PRODDB has failed' -S smtp=smtpser:465
 -S smtp-use-starttls -S smtp-auth=login -S smtp-auth-user=[e-mail] -S smtp-auth-password=Satish@8844 -S ssl-verify=ignore -S
nss-config-dir=/etc/pki/nssdb/ [e-mail]

We are able to send the email without using the cert1.pem file which the vendor has provided..
Do we need to copy the pem file to some location,can you please advice.


Resolving host smtpser:465 . . . done.
Connecting to 111.111.11.111:465 . . . connected.
220 smtpser:465 ESMTP
>>> EHLO erpsupport
250-smtpser:465
250-8BITMIME
250-SIZE 36700160
250 STARTTLS
>>> STARTTLS
220 Go ahead with TLS
Error in certificate: Peer's certificate issuer is not recognized.
Comparing DNS name: "smtpser:465"
SSL parameters: cipher=missing, keysize=256, secretkeysize=256,
issuer=CN=R3,O=Let's Encrypt,C=US
subject=CN=smtpser:465
>>> EHLO erpsupport
250-smtpser:465
250-8BITMIME
250-SIZE 36700160
250-AUTH PLAIN LOGIN
250 AUTH=PLAIN LOGIN
>>> AUTH LOGIN
334 VXNlcm5hbWU6
>>> c2F0aXNoLmd1ZGRoYXRpQHRpcnVm9yZw==
334 UGFzc3dvcmQ6
>>> U2F0aXNoQD
235 #2.0.0 OK Authenticated
>>> MAIL FROM:<[e-mail]>
250 sender <[e-mail]> ok
>>> RCPT TO:<[e-mail]>
250 recipient <[e-mail]> ok
>>> DATA
354 go ahead
>>> .
250 ok:  Message 105154138 accepted
>>> QUIT
221 smtpser:465
[applsupp@erpsupport ~]$

Thank you

[ErmanArslansOracleBlog]

You got "Error in certificate: Peer's certificate issuer is not recognized." there.
You could send the email using mailx but you need to check the wf mailer and see if it doesn't break the mailer.. In any case, having an incomplete configuration is not good.

Okay basically you will do workflow mailer outbound SSL implementation then.
Check the following blog posts and support note to get the idea.

Using GMAIL's IMAP & SMTP Server Configuring the Oracle Workflow Mailer (Doc ID 2052059.1)

https://ermanarslan.blogspot.com/2014/08/ebs-122-notification-mailer.html

https://ermanarslan.blogspot.com/2015/11/ebs-workflow-mailer-and-gmail.html