Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to configure GMAIL with Oracle Apex using stunnel (application express) 5.0.3

egudai-OracleApr 10 2016 — edited Apr 10 2016

0down votefavorite

Hello All,

writing down as is it helps someone :-)

This was enabled by me on both linux & windows. no SMTP is required.

I am in the middle of project, so don't have much time for editing ....feel free to take care.

Background :

  • Apex 5.0.3 is installed with Oracle XE 11.2 installed on Centos (linux) 6.x
  • SMTP is not required to be enabled on centos. We will use gmail one directly.
  • Solution is based on windows one published by : HÅVARD KRISTIANSEN at :http://monkeyonoracle.blogspot.com/2009/11/plsql-and-gmail-or-utlsmtp-with-ssl.html
  • Will use stunnel to communicate with gmail directly.
  • I am not going to go over Apex / Oracle XE installation.
Installation (written out of my head) :

1.Install stunnel as root :

yum install stunnel -y

2.create a conf file for stunnel using nano or vi (to install nano : yum install nano -y )

nano /etc/stunnel/stunnel.conf

3.Enter the following to new stunnel.conf created:

; Use it for client mode

client = yes


[ssmtp]

accept  = 1925

connect = smtp.gmail.com:465

4.restart stunnel using whatever method, e.g kill -9 and start using the following command :

/usr/bin/stunnel

5.Log in to apex as admin : http://yourhost:port/ords/apex_admin

Go to : Manage instance -> instance settings.

6.Put the following settings :

SMTP Host Address : 127.0.0.1 (or your local)

SMTP Host Port : 1925 (as u can see in stunnel.conf above).

SMTP Authentication Username : your gmail username : etai.guday (WITHOUT @gmail.com)

SMTP Authentication Password : gmail password

Use SSL/TLS : NO

Default Email From Address : etai.guday@gmail.com (including @gmail.com)

7.Due to gmail restrictions YOU MUST enable : https://g.co/allowaccess to use the above method (with relevant gmail account)

  1. Enable Oracle DB ACL by using example bellowhttps://www.dropbox.com/s/2ieaawy5gme9a50/email_configuration_acl_for_apex.txt?dl=0

9 . should work :-) didn't have time to test it further or refer to security issues etc

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 8 2016
Added on Apr 10 2016
1 comment
2,053 views