Re: UTL_MAIL - Trying to find a smtp server that works...

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Sat, 22 Mar 2008 09:24:20 -0700 (PDT)
Message-ID: <71878.93331.qm@web38910.mail.mud.yahoo.com>


EHLO yerself!

I've done the lower level utl_smtp mail stuff before. I was trying to put together asimple demo of ACL's in 11g and trying to use utl_mail which provides apretty short and clean example of the whole thing (much cleaner and easier to understand than a long utl_smtp example). I've run into thisbefore and I think the lack of any ability to configure authenticationwith utl_mail makes it almost useless.

BLAH!!! Thanks for your response though...

RF  

Robert G. Freeman
Author:
Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Feature
Blog: http://robertgfreeman.blogspot.com (Oracle Press)

  • Original Message ---- From: Dan Norris <dannorris_at_dannorris.com> To: robertgfreeman_at_yahoo.com Cc: oracle-l <oracle-l_at_freelists.org> Sent: Saturday, March 22, 2008 10:15:54 AM Subject: Re: UTL_MAIL - Trying to find a smtp server that works...

  EHLO Robert (the smtp geeks probably get that),

I think you'll have to resort to the lower-level SMTP commands toperform the necessary authentication from PL/SQL as shown in someexamples at http://forums.oracle.com/forums/thread.jspa?messageID=896035

You shouldn't be able to use any ol' SMTP server without authenticationor at least SMTP servers shouldn't allow you to use them without somesort of authentication (even if just based on an IP range). SMTP serverthat do allow you to send mail through them unauthenticated are knownas open mail relays (http://en.wikipedia.org/wiki/Open_mail_relay) andare officially Bad Things on the internet. Many open relays are used byspammers to send loads of email (to me, mostly). As a result, manyblacklists (http://en.wikipedia.org/wiki/Mail_Abuse_Prevention_System)have been created to help limit the amount of email delivered by theseopen relays.

So, if you do find an SMTP server willing to accept your messagewithout any authentication, there's a fairly decent chance that itwon't end up at its final destination unless it's an SMTP server onyour laptop. A search for "free windows smtp server" turns up severalhits, but as these are likely to be downloaded by spammers (and somepossibly created specifically for that purpose), I'm not sure I'd gonear any of them.

Happy mailing!

Dan

Robert Freeman wrote: Anyoneknow of an SMTP server that I can use with utl_mail? I've tried about 4different ones (e.g. smtp.yahoo.com) that I have access too but I geterrors. If I remember correctly this is because many of them requireyou include your password (like yahoo mail) and utl_mail does notprovide for this.   

Any suggestions?   

RF       

Robert G. Freeman
Author:
Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Feature
  Blog: http://robertgfreeman.blogspot.com(Oracle Press)         

--http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Sat Mar 22 2008 - 11:24:20 CDT

Original text of this message