Using GMail's SMTP and IMAP servers in Notification Mailer

Posted by Saroja Kandepuneni on Oracle Blogs See other posts from Oracle Blogs or by Saroja Kandepuneni
Published on Tue, 13 Nov 2012 18:09:44 +0000 Indexed on 2012/11/13 23:15 UTC
Read the original article Hit count: 432

Filed under:

/Oracle/Oracle E-Business Suite/Workflow Notifications/Notification Mailer

Overview

GMail offers free, reliable, popular SMTP and IMAP services, because of which many people are interested to use it. GMail can be used when there are no in-house SMTP/IMAP servers for testing or debugging purposes. This blog explains how to install GMail SSL certificate in Concurrent Tier, testing the connection using a standalone program, running Mailer diagnostics and configuring GMail IMAP and SMTP servers for Workflow Notification Mailer Inbound and Outbound connections.

GMail servers configuration

SMTP server

Host Name	smtp.gmail.com
SSL Port	465
TLS/SSL required	Yes
User Name	Your full email address (including @gmail.com or @your_domain.com)
Password	Your gmail passwor

IMAP server

Host Name	imap.gmail.com
SSL Port	993
TLS/SSL Required	Yes
User Name	Your full email address (including @gmail.com or @your_domain.com)
Password	Your gmail password

GMail SSL Certificate Installation

The following is the procedure to install the GMail SSL certificate

Copy the below GMail SSL certificate to a file eg: gmail.cer

Install the SSL certificate into the default JRE location or any other location using below command

Installing into a dfeault JRE location in EBS instance

# keytool -import -trustcacerts -keystore $AF_JRE_TOP/lib/security/cacerts -storepass changeit -alias gmail-lnx_chainnedcert -file gmail.cer

Install into a custom location

# keytool -import -trustcacerts -keystore <customLocation> -storepass changeit -alias gmail-lnx_chainnedcert -file gmail.cer
<customLocation> -- directory in instance where the certificate need to be installed

After running the above command you can see the following response

Trust this certificate? [no]: yes
Certificate was added to keystore

Running Mailer Command Line Diagnostics

Run Mailer command line diagnostics from conccurrent tier where Mailer is running, to check the IMAP connection using the below command

$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap -Ddbcfile=$FND_SECURE/$TWO_TASK.dbc -Dserver=imap.gmail.com -Dport=993 -Dssl=Y -Dtruststore=$AF_JRE_TOP/lib/security/cacerts -Daccount=<gmail username> -Dpassword=<password> -Dconnect_timeout=120 -Ddebug=Y -Dlogfile=GmailImapTest.log -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer

Run Mailer command line diagnostics from concurrent tier where Mailer is running, to check the SMTP connection using the below command

$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=smtp -Ddbcfile=$FND_SECURE/$TWO_TASK.dbc -Dserver=smtp.gmail.com -Dport=465 -Dssl=Y -Dtruststore=$AF_JRE_TOP/lib/security/cacerts -Daccount=<gmail username> -Dpassword=<password> -Dconnect_timeout=120 -Ddebug=Y -Dlogfile=GmailSmtpTest.log -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer

Standalone program to verify the IMAP connection

Run the below standalone program from the concurrent tier node where Mailer is running to verify the connection with GMail IMAP server. It connects to the Gmail IMAP server with the given GMail user name and password and lists all the folders that exist in that account. If the Gmail IMAP server is not working for the Mailer check whether the PROCESSED and DISCARD folders exist for the GMail account, if not create manually by logging into GMail account.

Sample program to test GMail IMAP connection

The standalone program can be run as below

 $java GmailIMAPTest GmailUsername GMailUserPassword

Standalone program to verify the SMTP connection

Run the below standalone program from the concurrent tier node where Mailer is running to verify the connection with GMail SMTP server. It connects to the GMail SMTP server by authenticating with the given user name and password and sends a test email message to the give recipient user email address.

Sample program to test GMail SMTP connection

The standalone program can be run as below

 $java GmailSMTPTest GmailUsername gMailPassword recipientEmailAddress

Warnings

As gmail.com is an external domain, the Mailer concurrent tier should allow the connection with GMail server
Please keep in mind when using it for corporate facilities, that the e-mail data would be stored outside the corporate network

Developer IT