This discussion is archived
1 2 Previous Next 20 Replies Latest reply: Dec 21, 2012 12:23 AM by adrianp RSS

sending email from apex 4.0 with oracle 11g ee

Florin Newbie
Currently Being Moderated
Hi,

I the past when working with apex 3 I was able to work with apex mailsend very nice.
In apex 4.0 with oracle 11g ee I'm not able to send emails anymore.

Last error message in the queue is:

ORA-29279: SMTP permanent error: 550 through this server without authentication.
the smtp server has not been changed, the code is fine

How I can go further?

Many thanks,
Florin
  • 1. Re: sending email from apex 4.0 with oracle 11g ee
    Mindmap Pro
    Currently Being Moderated
    Hello,

    There is a security issue when sending emails. Please read this:
    http://docs.oracle.com/cd/E17556_01/doc/apirefs.40/e15519/apex_mail.htm

    This one could be helpful also, and if you search the forum you find more:
    Re: Scheduling email in apex

    Best Regards,
    Fateh
  • 2. Re: sending email from apex 4.0 with oracle 11g ee
    Florin Newbie
    Currently Being Moderated
    Thank you Fateh,

    I will use your example with scheduler later :)


    But the problem still stands.
    I'm zero on Oracle dba.
    I just created some apex apps until now.

    I followed some posts here at otn and I think util package has been installed.
    And the acl list, that part I didn't do it.

    I may be rude but what are the exact steps in order to start the email functionality in Apex 4.0 with 11g EE.
    (I remember that for apex 3 with XE I've installed 1package and after that it worked)

    Many thanks,
    Florin
  • 3. Re: sending email from apex 4.0 with oracle 11g ee
    Mindmap Pro
    Currently Being Moderated
    Hello,
    You do not need to install any package, nor do you need to knew DBA....

    First you should Enable the Network Services:
    http://docs.oracle.com/cd/E37097_01/doc/install.42/e35123/otn_install.htm#BABBHCID

    Then you set the SMTP settings:
    http://docs.oracle.com/cd/E37097_01/doc/doc.42/e35129/adm_mg_service_set.htm#AEADM194

    Lastly,
    http://docs.oracle.com/cd/E37097_01/doc/doc.42/e35127/apex_mail.htm#AEAPI341

    You Should be able to do it after reading those Docs ...

    Best Luck,
    Fateh
  • 4. Re: sending email from apex 4.0 with oracle 11g ee
    Florin Newbie
    Currently Being Moderated
    I tried to enable the network services and the script returns:

    Error report:
    ORA-01435: user does not exist
    ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 644
    ORA-06512: at line 7
    01435. 00000 - "user does not exist"
    *Cause:   
    *Action:
    commited.
  • 5. Re: sending email from apex 4.0 with oracle 11g ee
    TimSt.H. Explorer
    Currently Being Moderated
    Florin,

    Make sure you are using the instructions relevent to your version.
    If you are using 4.0 - you probably want the same script- with proper APEX_040000 user.

    See the document POST INSTALLATION steps.

    http://docs.oracle.com/cd/E17556_01/doc/install.40/e15513/otn_install.htm#CBHBABCC

    Also - make sure you do not DROP any old apex framework users before updating / removing them from the ACL. It may cause you issues.

    --Tim St.

    P.S. take a minute to update your profile so your name is clear.

    Edited by: Tim St. H. on Dec 11, 2012 4:54 PM
  • 6. Re: sending email from apex 4.0 with oracle 11g ee
    Florin Newbie
    Currently Being Moderated
    Thank you Tim,


    You were right, in Apex 4 default user is APEX_040000.
  • 7. Re: sending email from apex 4.0 with oracle 11g ee
    adrianp Newbie
    Currently Being Moderated
    Hmm... sounds like your SMTP requires authentication before relaying mails on your behalf. You might want to check with your administrator and enter an appropriate user/password in your instance settings.
  • 8. Re: sending email from apex 4.0 with oracle 11g ee
    977575 Newbie
    Currently Being Moderated
    Hello All,

    Could you please help me out..

    I have a apex report via SQL query i.e. I hve mentione below

    select
    ab.service_registration_id,
    ef."PDF",

    Click Here , i.e. href="file:///E:/Echo Destination/1212040003.docx"
    . . . . . . . from XYZ

    I want to open a document i.e. placed in different folder in local drive.

    Here I am unable to open this document via click on this column link on report............

    Kindly help me if you have some solution...

    Thanks..
  • 9. Re: Apex Reports and links to external content
    TimSt.H. Explorer
    Currently Being Moderated
    This is a different subject:

    Apex Reports and links to external content

    What you are asking should be possible.

    Risk: everyone who uses the link needs to have the same drive mapping if you are using letters on a Windows PC. As long as that is not a usability issue, you are fine.

    I would recommend you review the LINK syntax in the report column.
    Your text seems like you have already attempted this.

    >
    Click Here , i.e. href="file:///E:/Echo Destination/1212040003.docx"
    . . . . . . . from XYZ

    Here I am unable to open this document via click on this column link on report............
    Thanks..
    To confirm the link syntax you want first, Write a simple HTML file with the link to make sure you have the correct quoting and the link content is correct.

    What does the REPORT resulting HTML look like when you examine it on the page?
    I would expect something like:
    <a href=file:///E:/Echo Destination/1212040003.docx> go to file </a>
    If the result is different, then we can discuss why it isn't what you are expecting.

    --Tim St.
    http://enkitec.com
  • 10. Re: sending email from apex 4.0 with oracle 11g ee
    Florin Newbie
    Currently Being Moderated
    Thanks,

    How I can put user name/pasword in my instance?

    I have only smtp mail and port.
    No user/pass

    Thanks,
    Florin
  • 11. Re: sending email from apex 4.0 with oracle 11g ee
    adrianp Newbie
    Currently Being Moderated
    Steps 4 (e) and (f):
    http://docs.oracle.com/cd/E37097_01/doc/doc.42/e35129/adm_mg_service_set.htm#BEJBCEEH

    Talk your network administrators about what is needed to relay emails through your corporate SMTP servers.
  • 12. Re: sending email from apex 4.0 with oracle 11g ee
    Florin Newbie
    Currently Being Moderated
    Thank you Adrain,

    Problem is that the amnual you are reffering to is for apex 4.2
    My instalation is on 4.0

    Manual for 4.0 is bellow
    http://docs.oracle.com/cd/E17556_01/doc/admin.40/e15521/adm_mg_service_set.htm#AEADM210
    Problem is that we don't have extra steps e and f

    Exactly wht you poited on it's not an option on my 4.0
    :(

    e.SMTP Authentication Username - If you enter a username, Oracle Application Express authenticates against it when sending emails. Prior to Oracle Database 11g Release 2 (11.2.0.2), only the SMTP authentication scheme "LOGIN" is supported. On newer database versions, all authentication schemes of UTL_SMTP are supported.

    f.SMTP Authentication Password - If you enter a password, Oracle Application Express authenticates against it when sending emails. Prior to Oracle Database 11g Release 2, Release 11.2.0.2, only the SMTP authentication scheme "LOGIN" is supported. On newer database versions, all authentication schemes of UTL_SMTP are supported.
  • 13. Re: sending email from apex 4.0 with oracle 11g ee
    Kenny Hanberg Explorer
    Currently Being Moderated
    Hi Florin,

    I had a similar experience last month.

    Our system admin upgraded our MS Exchange server from 2007 to 2010.
    Everything should work without any changes, except it didn´t off cause.

    The security is a bit tighter in the Exchange 2010 installation.
    Now the FROM-email address must be a valid email address on the Exchange server :(
    Just Changed the FROM email address to my company email, as a test, and every thing worked again!!

    The problem was reviled using telnet from a console on the db server it self.

    Search for "test smtp telnet" on Google. It is actually quite simple.

    Regards
    Kenny
  • 14. Re: sending email from apex 4.0 with oracle 11g ee
    adrianp Newbie
    Currently Being Moderated
    My bad. Seems like 4.0 didn't give you that added option to enter SMTP credentials. Did you give Kenny's suggestion a try? In any case, you should talk to your admins and see what can be arranged. One alternative I could suggest - not necessarily a good idea - is to set up a local SMTP relay that then forwards the email to your corporate SMTP servers using the appropriate credentials. You can then configure your APEX instance to send emails out using your local mail server.

    It is an added security risk and you should find out if it goes against your corporate IT policies.
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points