Sponsored Content
Special Forums IP Networking Sending mails using plsql program Post 302089174 by amol_mudholkar on Monday 18th of September 2006 02:39:32 AM
Old 09-18-2006
Sending mails using plsql program

I am trying to send an email to personal id using plsql program. I have written a code in plsql using UTL_TCP package where opens the connections and then senda a mail. But when i execute the program mails are not being sent.

I typed "mail" command on the unix box and got the below result
==========================================
From MAILER-DAEMON Mon Sep 18 07:03:41 2006
Date: Mon, 18 Sep 2006 07:03:41 +0100 (BST)
From: Mail Delivery Subsystem <MAILER-DAEMON>
Message-Id: <200609180603.k8I63fOH029965@hwnej05.>
To: <artiscat@hwnej05>
Subject: Returned mail: see transcript for details
Content-Length: 4339

This is a MIME-encapsulated message

--k8I63fOH029965.1158559421/hwnej05.

The original message was received at Mon, 18 Sep 2006 07:03:41 +0100 (BST)
from localhost [127.0.0.1]

----- The following addresses had permanent fatal errors -----
<amolm@techmahindra.com>
(reason: 550 Host unknown)

----- Transcript of session follows -----
550 5.1.2 <amolm@techmahindra.com>... Host unknown (Name server: mailhost: host
not found)

--k8I63fOH029965.1158559421/hwnej05.
Content-Type: message/delivery-status

Reporting-MTA: dns; hwnej05.
Received-From-MTA: DNS; localhost
Arrival-Date: Mon, 18 Sep 2006 07:03:41 +0100 (BST)
Final-Recipient: RFC822; amolm@techmahindra.com
Action: failed
Status: 5.1.2
Remote-MTA: DNS; mailhost
Diagnostic-Code: SMTP; 550 Host unknown
Last-Attempt-Date: Mon, 18 Sep 2006 07:03:41 +0100 (BST)

--k8I63fOH029965.1158559421/hwnej05.
Content-Type: message/rfc822

Return-Path: <artiscat@hwnej05>
Received: from hwnej05. (localhost [127.0.0.1])
by hwnej05. (8.12.10+Sun/8.12.10) with ESMTP id k8I63fOH029963
for <amolm@techmahindra.com>; Mon, 18 Sep 2006 07:03:41 +0100 (BST)
Received: (from artiscat@localhost)
by hwnej05. (8.12.10+Sun/8.12.10/Submit) id k8I63fLW029962
for amolm@techmahindra.com; Mon, 18 Sep 2006 07:03:41 +0100 (BST)
Date: Mon, 18 Sep 2006 07:03:41 +0100 (BST)
From: Artisan Application user <artiscat@hwnej05>
Message-Id: <200609180603.k8I63fLW029962@hwnej05.>
==========================================

Could you please let me know what should i do to get rid of this problem.

I just know basics of Unix. Hence finding it difficult to resolve the problem.

Thanks & Regds
Amol
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Sending Mass mails

Hi Forum, I am extremely new to unix.Can somebody please help me out with the following: I am supposed to write a script that will ftp a file which is a .csv and conatins the following: Mail-id Path of file abc@xyz.com D:\xyz\abc.htm ash@sde.com ... (1 Reply)
Discussion started by: iyerdeepa82
1 Replies

2. UNIX for Advanced & Expert Users

sending mails with attachment and also some text in mail body

Hi, Can some one help me with the syntax of the mailx that should send an attachment and also some text in the message body together. When I am using the following syntax it is not sending the attachment but only the message body. unix2dos -ascii $REPORTFILE | uuencode $PCFILE | mailx -s... (7 Replies)
Discussion started by: guptan
7 Replies

3. SuSE

How to configure Suse Enterprise Linux 9.0 for sending mails to smtp server...???

Hi All, I have a system running with Suse Enterprise Linux 9.0. xyz# uname -a Linux xyz 2.4.21-291-smp #1 SMP Tue May 24 14:07:45 UTC 2005 i686 unknown I would like to configure postfix on this system for sending mails as a root user using "mail" command to smtp server (Windows System)... (5 Replies)
Discussion started by: jumadhiya
5 Replies

4. Shell Programming and Scripting

error while sending mails through MKS

#!/bin/ksh email0="dummy@company.com" emails() { # mail Generation echo "Hi" | /mapimail -s "-(Test Mail)From Production- `date`" $email0; } emails i receive the following error IDispatch::new MSMAPI.MAPISession failed: 800401f3 at... (0 Replies)
Discussion started by: Vrgurav
0 Replies

5. UNIX for Dummies Questions & Answers

Sending mails to various users without hard coding the email IDS

Hi Can any one help me out ? I am trying to send an autogenerated mail with an attachment to bulk of users using 'MAILX' and 'UNENCODE' . I have used it as follows X " ( cat /sastemp/body.txt; uuencode Test.xls.gz Test.xls.gz ) | mailx -s 'Testing' ' abcd@yahoo.com , efgh@gmail.com ' " ... (9 Replies)
Discussion started by: manas6
9 Replies

6. Shell Programming and Scripting

cron not sending external mails

This script is to send a email if the IP adress is active when i run this script it is working and sending emails to external users in different domains, but when this script is scheduled in a cron it is unable to send the emails #/bin/sh ifconfig -a | grep 192.168.0.1 if ; then mail -s... (10 Replies)
Discussion started by: robo
10 Replies

7. Shell Programming and Scripting

Sending email from a unix program

Hi, I have create a unix prog file to validate data and send out an email. Below is the command used to send out email in the program. But it is not triggering the email. Please advice on this. (echo ${MESSAGE};uuencode "$FCP_OUT" "ERROR_REPORT.csv"; uuencode "$VALIDATION_RPT"... (1 Reply)
Discussion started by: contactsmrajesh
1 Replies

8. Solaris

Crontab schedule sending two mails insted of one

Hi all, We have scheduled one cronjob which is supposed to show output through mails about 15 systems's current status (whether its up or down) but it send two mails one about 10 system which arrive at 5.30(actual scheduled time) and in second mail about 5 systems. We want all these... (1 Reply)
Discussion started by: manalisharmabe
1 Replies

9. Solaris

Sending Mails to the Multiple Email Address

Hi All, I am pretty new to the mail service in Sun Solaris 5.10. If anybody help me in writing a script for the multiple recipient with subject and the body would be a helpful. Kindly help... Thanks in advance. :) Warm Regards, Pramod (5 Replies)
Discussion started by: Pramod_009
5 Replies
Mail::DeliveryStatus::BounceParser(3pm) 		User Contributed Perl Documentation		   Mail::DeliveryStatus::BounceParser(3pm)

NAME
Mail::DeliveryStatus::BounceParser - Perl extension to analyze bounce messages SYNOPSIS
use Mail::DeliveryStatus::BounceParser; # $message is *io or $fh or "entire message" or @lines my $bounce = eval { Mail::DeliveryStatus::BounceParser->new($message); }; if ($@) { # couldn't parse. } my @addresses = $bounce->addresses; # email address strings my @reports = $bounce->reports; # Mail::Header objects my $orig_message_id = $bounce->orig_message_id; # <ABCD.1234@mx.example.com> my $orig_message = $bounce->orig_message; # Mail::Internet object ABSTRACT
Mail::DeliveryStatus::BounceParser analyzes RFC822 bounce messages and returns a structured description of the addresses that bounced and the reason they bounced; it also returns information about the original returned message including the Message-ID. It works best with RFC1892 delivery reports, but will gamely attempt to understand any bounce message no matter what MTA generated it. DESCRIPTION
Meng Wong wrote this for the Listbox v2 project; good mailing list managers handle bounce messages so listowners don't have to. The best mailing list managers figure out exactly what is going on with each subscriber so the appropriate action can be taken. parse my $bounce = Mail::DeliveryStatus::BounceParser->parse($message, \%arg); OPTIONS. If you pass BounceParser->new(..., {log=>sub { ... }}) That will be used as a logging callback. NON-BOUNCES. If the message is recognizably a vacation autoresponse, or is a report of a transient nonfatal error, or a spam or virus autoresponse, you'll still get back a $bounce, but its "$bounce->is_bounce()" will return false. It is possible that some bounces are not really bounces; such as anything that apears to have a 2XX status code. To include such non- bounces in the reports, pass the option {report_non_bounces=>1}. For historical reasons, "new" is an alias for the "parse" method. log $bounce->log($messages); If a logging callback has been given, the message will be passed to it. is_bounce if ($bounce->is_bounce) { ... } This method returns true if the bounce parser thought the message was a bounce, and false otherwise. reports Each $report returned by $bounce->reports() is basically a Mail::Header object with a few modifications. It includes the email address bouncing, and the reason for the bounce. Consider an RFC1892 error report of the form Reporting-MTA: dns; hydrant.pobox.com Arrival-Date: Fri, 4 Oct 2002 16:49:32 -0400 (EDT) Final-Recipient: rfc822; bogus3@dumbo.pobox.com Action: failed Status: 5.0.0 Diagnostic-Code: X-Postfix; host dumbo.pobox.com[208.210.125.24] said: 550 <bogus3@dumbo.pobox.com>: Nonexistent Mailbox Each "header" above is available through the usual get() mechanism. print $report->get('reporting_mta'); # 'some.host.com' print $report->get('arrival-date'); # 'Fri, 4 Oct 2002 16:49:32 -0400 (EDT)' print $report->get('final-recipient'); # 'rfc822; bogus3@dumbo.pobox.com' print $report->get('action'); # "failed" print $report->get('status'); # "5.0.0" print $report->get('diagnostic-code'); # X-Postfix; ... # BounceParser also inserts a few interpretations of its own: print $report->get('email'); # 'bogus3@dumbo.pobox.com' print $report->get('std_reason'); # 'user_unknown' print $report->get('reason'); # host [199.248.185.2] said: 550 5.1.1 unknown or illegal user: somebody@uss.com print $report->get('host'); # dumbo.pobox.com print $report->get('smtp_code'); # 550 print $report->get('raw') || # the original unstructured text $report->as_string; # the original structured text Probably the two most useful fields are "email" and "std_reason", the standardized reason. At this time BounceParser returns the following standardized reasons: user_unknown over_quota user_disabled domain_error spam message_too_large unknown no_problemo The "spam" standard reason indicates that the message bounced because the recipient considered it spam. (no_problemo will only appear if you set {report_non_bounces=>1}) If the bounce message is not structured according to RFC1892, BounceParser will still try to return as much information as it can; in particular, you can count on "email" and "std_reason" to be present. addresses Returns a list of the addresses which appear to be bouncing. Each member of the list is an email address string of the form 'foo@bar.com'. orig_message_id If possible, returns the message-id of the original message as a string. orig_message If the original message was included in the bounce, it'll be available here as a message/rfc822 MIME entity. my $orig_message = $bounce->orig_message; orig_header If only the original headers were returned in the text/rfc822-headers chunk, they'll be available here as a Mail::Header entity. orig_text If the bounce message was poorly structured, the above two methods won't return anything --- instead, you get back a block of text that may or may not approximate the original message. No guarantees. Good luck. CAVEATS
Bounce messages are generally meant to be read by humans, not computers. A poorly formatted bounce message may fool BounceParser into spreading its net too widely and returning email addresses that didn't actually bounce. Before you do anything with the email addresses you get back, confirm that it makes sense that they might be bouncing --- for example, it doesn't make sense for the sender of the original message to show up in the addresses list, but it could if the bounce message is sufficiently misformatted. Still, please report all bugs! FREE-FLOATING ANXIETY Some bizarre MTAs construct bounce messages using the original headers of the original message. If your application relies on the assumption that all Message-IDs are unique, you need to watch out for these MTAs and program defensively; before doing anything with the Message-ID of a bounce message, first confirm that you haven't already seen it; if you have, change it to something else that you make up on the spot, such as "<antibogus-TIMESTAMP-PID-COUNT@LOCALHOST>". BUGS
BounceParser assumes a sanely constructed bounce message. Input from the real world may cause BounceParser to barf and die horribly when we violate one of MIME::Entity's assumptions; this is why you should always call it inside an eval { }. TODO Provide some translation of the SMTP and DSN error codes into English. Review RFC1891 and RFC1893. KNOWN TO WORK WITH
We understand bounce messages generated by the following MTAs / organizations: Postfix Sendmail Exim AOL Yahoo Hotmail AOL's AirMail sender-blocking Microsoft Exchange* Qmail* Novell Groupwise* * Items marked with an asterisk currently may return incomplete information. SEE ALSO
Used by http://listbox.com/ --- if you like BounceParser and you know it, consider Listbox for your mailing list needs! SVN repository and email list information at: http://emailproject.perl.org/ RFC1892 and RFC1894 RANDOM OBSERVATION
Schwern's modules have the Alexandre Dumas property. AUTHOR
Original author: Meng Weng Wong, <mengwong+bounceparser@pobox.com> Current maintainer: Ricardo SIGNES, <rjbs@cpan.org> Massive contributions to the 1.5xx series were made by William Yardley and Michael Stevens. Ricardo mostly just helped out and managed releases. COPYRIGHT AND LICENSE
Copyright (C) 2003-2006, IC Group, Inc. pobox.com permanent email forwarding with spam filtering listbox.com mailing list services for announcements and discussion This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. WITH A SHOUT OUT TO
coraline, Fletch, TorgoX, mjd, a-mused, Masque, gbarr, sungo, dngor, and all the other hoopy froods on #perl perl v5.14.2 2012-06-12 Mail::DeliveryStatus::BounceParser(3pm)
All times are GMT -4. The time now is 06:53 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy