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 : 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) - 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 |