Dual TO: names in Mailwatch

[Julian Field]

At 21:27 10/11/2003, you wrote:
>Steve,
>I added these lines in my MailWatch.pm as outlined below:
>
><SNIP>
>use DBI;
>use Sys::Hostname;
>
>my($dbh);
>my($sth);
>my($hostname) = hostname;
>my(%rcpts);
>map { $rcpts{$_}=1; } @{$message->{to}};
>@{$message->{to}} = keys %rcpts;
>
># Modify this as necessary for your configuration
>my($db_name) = "mailscanner";
></SNIP>
>
>
>Restarted processes.  no errors in SQL logging, but still receiving
>duplicates...

You need to add it near the top of the MailWatch subroutine, not at the top
of the file.


>This isn't exactly a pristine environment though...let me re-build my test
>box and try it there...I'll let you know.
>
>THX
>CT
>
>
>
>----- Original Message -----
>From: "Steve Freegard" <steve.freegard at LBSLTD.CO.UK>
>To: <MAILSCANNER at JISCMAIL.AC.UK>
>Sent: Monday, November 10, 2003 11:42 AM
>Subject: Re: Dual TO: names in Mailwatch
>
>
> > Hi Julian,
> >
> > I had to change:
> >
> > $message->{to} = keys %rcpts;
> >  to
> > @{$message->{to}} = keys %rcpts;
> >
> > Otherwise $message->{to} was always blank - seems to work okay with
> > Sendmail, just need someone to test it with Postfix.
> >
> > Thanks,
> > Steve.
> >
> > -----Original Message-----
> > From: Julian Field
> > To: MAILSCANNER at JISCMAIL.AC.UK
> > Sent: 11/10/03 3:35 PM
> > Subject: Re: Dual TO: names in Mailwatch
> >
> > Steve,
> >
> > Can this be done easily in MailWatch by doing something like this very
> > early on with the message?
> >
> > my(%rcpts);
> > map { $rcpts{$_}=1; } @{$message->{to}};
> > $message->{to} = keys %rcpts;
> >
> > That would remove any duplicate "to" addresses from the message object.
> > Try putting the above 3 lines of code right near the start of the
> > MailWatch
> > code.
> >
> > At 15:25 10/11/2003, you wrote:
> > >I tried to respond off list to Julian, but my mail was returned.
> > >
> > >I've been begging for this for months and would entertain the idea of
> > paying
> > >someone (anyone) to escalate the priority of this problem...
> > >
> > >Thanks!
> > >
> > >CT
> > >
> > >
> > >----- Original Message -----
> > >From: "Julian Field" <mailscanner at ECS.SOTON.AC.UK>
> > >To: <MAILSCANNER at JISCMAIL.AC.UK>
> > >Sent: Monday, November 10, 2003 9:03 AM
> > >Subject: Re: Dual TO: names in Mailwatch
> > >
> > >
> > > > It's a known MailScanner bug. I just haven't got around to fixing it
> > yet,
> > > > it's not exactly high priority at the moment.
> > > >
> > > > At 13:59 10/11/2003, you wrote:
> > > > >Hi Pete,
> > > > >
> > > > >This is a MailScanner or Postfix issue as MailWatch only uses
> > information
> > > > >from MailScanner's $message object which is populated by
> > MailScanner
> > > > >parseing the Postfix message file.
> > > > >
> > > > >You'll also find the same problem of duplicated 'To' entries in the
> > admin
> > > > >notices as reported by someone else.
> > > > >
> > > > >The postcat command didn't really give me much to go on at all
> > (thought
> > >it'd
> > > > >be better than that) - so I'll have a Google around and see if I
> > can find
> > > > >any info about the file spec for Postfix and see if I can find the
> > >problem.
> > > > >
> > > > >Regards,
> > > > >Steve.
> > > > >
> > > > >
> > > > >-----Original Message-----
> > > > >From: Pete russell <pete at EATATHOME.COM.AU>
> > > > >To: MAILSCANNER at JISCMAIL.AC.UK <MAILSCANNER at JISCMAIL.AC.UK>
> > > > >Sent: Mon Nov 10 13:47:28 2003
> > > > >Subject: Re: Dual TO: names in Mailwatch
> > > > >
> > > > >Funny, this happened ona %100 fresh install of mailscanner and
> > fedora
> > > > >and MW .4 - my previous post was regarding my existing MW .3
> > machines.
> > > > >
> > > > >If you do find a fault I can repair myself, please le tme know as I
> > > > >would like to fix the .3 install on the production servers - cos I
> > wont
> > > > >be moving to .4 just yet.
> > > > >
> > > > >thanks
> > > > >Pete
> > > > >
> > > > >-----Original Message-----
> > > > >From: MailScanner mailing list [mailto:MAILSCANNER at JISCMAIL.AC.UK]
> > On
> > > > >Behalf Of Steve Freegard
> > > > >Sent: Tuesday, 11 November 2003 12:37 AM
> > > > >To: MAILSCANNER at JISCMAIL.AC.UK
> > > > >Subject: Re: Dual TO: names in Mailwatch
> > > > >
> > > > >Hi Pete,
> > > > >
> > > > >Can you stop the outbound queue runner temporarily to stop the
> > messages
> > > > >that
> > > > >have been processed by MailScanner from being delievered, then run
> > the
> > > > >'postcat' command across one of the messages and post the output to
> > the
> > > > >list.
> > > > >
> > > > >Kind regards,
> > > > >Steve.
> > > > >
> > > > >
> > > > >-----Original Message-----
> > > > >From: Pete russell <pete at EATATHOME.COM.AU>
> > > > >To: MAILSCANNER at JISCMAIL.AC.UK <MAILSCANNER at JISCMAIL.AC.UK>
> > > > >Sent: Mon Nov 10 08:38:36 2003
> > > > >Subject: Dual TO: names in Mailwatch
> > > > >
> > > > >I have the latest version of mailwatch, mailscanner, postfix, mysql
> > and
> > > > >RH9 - in the TO: column, when looking at recent messages, all the
> > names
> > > > >are listed twice - this also makes the Top Recipients by Volume
> > graph
> > > > >unreadable as the legend has 2 entries for each person. Doesn't
> > seem
> > > > >like we are getting 2 deliveries though, and doesn't seem like
> > anything
> > > > >is written twice to the maillog.
> > > > >
> > > > >
> > > > >
> > > > >Any ideas?
> > > > >
> > > > >
> > > > >
> > > > >Pete
> > > > >
> > > > >--
> > > > >This email and any files transmitted with it are confidential and
> > > > >intended solely for the use of the individual or entity to whom
> > they
> > > > >are addressed. If you have received this email in error please
> > notify
> > > > >the sender and delete the message from your mailbox.
> > > > >
> > > > >This footnote also confirms that this email message has been swept
> > by
> > > > >MailScanner (www.mailscanner.info) for the presence of computer
> > viruses.
> > > > >
> > > > >
> > > > >--
> > > > >This email and any files transmitted with it are confidential and
> > > > >intended solely for the use of the individual or entity to whom
> > they
> > > > >are addressed. If you have received this email in error please
> > notify
> > > > >the sender and delete the message from your mailbox.
> > > > >
> > > > >This footnote also confirms that this email message has been swept
> > by
> > > > >MailScanner (www.mailscanner.info) for the presence of computer
> > viruses.
> > > >
> > > > --
> > > > Julian Field
> > > > www.MailScanner.info
> > > > MailScanner thanks transtec Computers for their support
> > > >
> > > > PGP footprint: EE81 D763 3DB0 0BFD E1DC  7222 11F6 5947 1415 B654
> >
> > --
> > Julian Field
> > www.MailScanner.info
> > MailScanner thanks transtec Computers for their support
> >
> > PGP footprint: EE81 D763 3DB0 0BFD E1DC  7222 11F6 5947 1415 B654
> >
> > --
> > This email and any files transmitted with it are confidential and
> > intended solely for the use of the individual or entity to whom they
> > are addressed. If you have received this email in error please notify
> > the sender and delete the message from your mailbox.
> >
> > This footnote also confirms that this email message has been swept by
> > MailScanner (www.mailscanner.info) for the presence of computer viruses.

--
Julian Field
www.MailScanner.info
Professional Support Services at www.MailScanner.biz
MailScanner thanks transtec Computers for their support
PGP footprint: EE81 D763 3DB0 0BFD E1DC  7222 11F6 5947 1415 B654