Unable to send email from oracle APEX with no error displayed

Mohamed Heba

Hi,

I am using APEX 21.1.0 on oracle XE 18.0.0.0.0, I am trying to send email from APEX using mailtrap.io service.

 I gave APEX schema required ACL and configured SMTP as below.

The problem is that all emails stuck in the Mail Queue and not sent to mail server nor giving me any error.

Is there any chance to know where is the problem or how can I resolve this issue?

--- ACL

BEGIN

     DBMS_NETWORK_ACL_ADMIN.DROP_ACL(ACL => 'mydba.xml');

     DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(ACL => 'mydba.xml', DESCRIPTION => 'SMTP, MAIL, HTTP Access', PRINCIPAL => 'APEX_210100', IS_GRANT => TRUE, PRIVILEGE => 'connect', START_DATE => NULL, END_DATE => NULL);

     DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(ACL => 'mydba.xml', HOST => '*', LOWER_PORT => NULL, UPPER_PORT => NULL);

     DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL => 'mydba.xml', PRINCIPAL => 'MY_APEX_USER', IS_GRANT => TRUE, PRIVILEGE => 'connect', START_DATE => NULL, END_DATE => NULL);

     DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL => 'mydba.xml', PRINCIPAL => 'MY_APEX_USER', IS_GRANT => TRUE, PRIVILEGE => 'resolve', START_DATE => NULL, END_DATE => NULL);

     COMMIT;

END;

/

-- APEX Email configuration

-- Code used to send email

APEX_MAIL.SEND(P_TO => '[email protected]', P_FROM => '[email protected]', P_BODY => 'My Email Body.', P_SUBJ => 'Mail subject');

 APEX_MAIL.PUSH_QUEUE;

Billy Verreynne

Using a clear text 25/tcp port connection and supplying credentials via it - it is not secure and unusual.

Mohamed Heba

Thanks Billy, I am trying to send the first email then i will change the port.

Billy Verreynne

The port is fine - the credentials supplied are not. Typically SMTP servers do not request credentials for connections via port 25/tcp. Such credentials will be send as clear text across the network. This will be a serious security risk.

Mohamed Heba

I have been trying to resolve this issue with no sucess so far.

I found after changing the port to 465 and set Use SSL/TLS as No mail sent. but when i try to set SSL/TLS to Yes mail never sent.

Now i have 4 questions

1- Why mail never get sent when using SSL/TLS as yes or after connection is established with both ports 456 and 587?

2- Why there is no error appears in the Mail queue page or database tables after trying to send the email?

3- Why i receive message "Successfully sent mail" and mail not sent?

4- Is there anyway i can see the logs generated from APEX while sending emails?