Just wondering if anyone has succeeded in getting emails sent from an Oracle Cloud Database instance?
Outgoing email is a key part of the application I am trying to get working on a database as a service instance.
Forget the database level stuff, I am just trying to get email sent from the Linux level before I try at the database level.
First step I created and enabled Security Rule to allow inbound traffic on the mail port 25 (outbound is permitted by default). This didn't work so guessed that sendmail wasn't configured out of the box. As I prefer postfix I removed sendmail, installed postfix with a config that I know works on another server (non Oracle cloud). The mail transfer agent is failing with:-
connect to alt4.gmail-smtp-in.l.google.com[64.233.190.26]:25: Connection timed out
I ran:-
sudo traceroute -n -T -p 25 gmail-smtp-in.l.google.com
to see what was happening in the connect attempts and the packets stopped 3 hops from my cloud server instance at 10.199.223.198. Looks like Oracle is blocking outgoing emails?
A few doc searches found the only reference to email in the cloud service doco that I could find (not directly related to my service or what I am doing but an interesting paragraph...).
In http://docs.oracle.com/cloud/latest/dbcs_dbaas/CSDBI/GUID-9CDB4228-4537-4637-B61F-57018F5EB866.htm#GUID-9CDB4228-4537-4637-B61F-57018F5EB866__CONFIGURINGEMAIL-PDBSS
Under the section "Setting the Password for a New User", I find the paragraph:-
"As a security measure, Oracle Cloud prohibits outgoing email from service instances." which is what it looks like to me. I have had a couple of SR's with Oracle Support in the process of trying to debug the issue and noone has told me yet that it can't be done.
I would be surprised if this is the case as I would expect most applications today to be trying to send emails (for password resets if nothing else) and if this is blocked in Oracle Cloud that would significantly reduce the usefulness of the whole service to anyone??
Can anyone from Oracle or the user community shed any light on this as I have wasted a day so far trying to debug this and get outgoing mail delivered.....
Thanks,
Phil.