Forum Stats

  • 3,827,547 Users
  • 2,260,791 Discussions
  • 7,897,297 Comments

Discussions

Unable to send email from oracle APEX with no error displayed

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;


Tagged:

Answers

  • Billy Verreynne
    Billy Verreynne Software Engineer Member Posts: 28,830 Red Diamond

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

  • Mohamed Heba
    Mohamed Heba Member Posts: 12 Green Ribbon

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

  • Billy Verreynne
    Billy Verreynne Software Engineer Member Posts: 28,830 Red Diamond

    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
    Mohamed Heba Member Posts: 12 Green Ribbon

    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?