1 2 Previous Next 20 Replies Latest reply: Dec 21, 2012 2:23 AM by adrianp RSS

    sending email from apex 4.0 with oracle 11g ee

    Florin
      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
          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
            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
              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
                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
                  Tim St. H.
                  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
                    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
                      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
                        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
                          Tim St. H.
                          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
                            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
                              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
                                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
                                  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
                                    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