Using MailScanner with Postfix

[Chris Trudeau]

The thread below asks a simple question about the logging functions built
into MailScanner.

I will summarize:

<LINK FROM ARCHIVES>
http://www.jiscmail.ac.uk/cgi-bin/wa.exe?A2=ind0309&L=mailscanner&P=R4568&I=-1
</LINK>

Turns out postfix queue files are being parsed incorrectly by the logging
functions in MailScanner.  Causing the detail logging that the SQL logging
uses to write lines into the MySQL database as well as everywhere else to be
duplicated.  Seems that this also is causing the duplicate mail addresses to
be included in the notifications generated by MailScanner.

I THOUGHT this was only impacting my sql logging which I can get past, but
it turns out that this is also impacting notifications.

The bug doesn;t appear now to be just with the SQL logging, but with the
MailScanner logging functions.  Anyone have any ideas?

CT



----- Original Message -----
From: "Chris Trudeau" <chris at TRUDEAU.ORG>
To: <MAILSCANNER at JISCMAIL.AC.UK>
Sent: Wednesday, October 15, 2003 1:19 PM
Subject: Re: Using MailScanner with Postfix


> I posted this right before the "Urgent" posting, so its likely it was lost
> int he traffic.
>
> I'd be interested in knowing if there is anything that can be done about
> this?
>
> CT
>
> ----- Original Message -----
> From: "Chris Trudeau" <chris at TRUDEAU.ORG>
> To: <MAILSCANNER at JISCMAIL.AC.UK>
> Sent: Tuesday, October 14, 2003 10:01 AM
> Subject: Re: Using MailScanner with Postfix
>
>
> > you know what...i never thought of that...
> >
> > Julian?  Is it the same logging function that supplies information to
the
> > SQL functions as does the reports?  becuase now that Joshua mentions
> it...I
> > do get these duplicates as well...
> >
> > the problem is referenced here:
> >
> >
>
http://www.jiscmail.ac.uk/cgi-bin/wa.exe?A2=ind0309&L=mailscanner&P=R4568&I=-1
> >
> > I think Steve is working on a fix for the SQL logging module, but this
> > affects more than just the SQL logging...with Joshua's revelation...it
> looks
> > like the problem is in MailScanner logging...any ideas how we can get
this
> > fixed for postfix...I'd MUCH rather NOT have to change MTAs in a
"working"
> > imeplementation.
> >
> > CT
> >
> > ----- Original Message -----
> > From: "Hirsh, Joshua" <joshua.hirsh at PARTNERSOLUTIONS.CA>
> > To: <MAILSCANNER at JISCMAIL.AC.UK>
> > Sent: Tuesday, October 14, 2003 9:35 AM
> > Subject: Re: Using MailScanner with Postfix
> >
> >
> > > Is this the same bug that causes duplicate recipients in the email
> reports
> > > too?
> > >
> > > ie:
> > >
> > >  Recipient: user1 at domain.com, user1 at domain.com
> > >    Subject: great porn!
> > >  MessageID: C22A8183410
> > >     Report: This attachment has been restricted.
> > > (stupid_porn_surfing_user_at_work.wmv)
> > >
> > >
> > >  -Joshua
> > >
> > >
> > > -----Original Message-----
> > > From: Chris Trudeau [mailto:chris at TRUDEAU.ORG]
> > > Sent: Tuesday, October 14, 2003 9:36 AM
> > > To: MAILSCANNER at JISCMAIL.AC.UK
> > > Subject: Re: Using MailScanner with Postfix
> > >
> > >
> > > Postfix runs fine for me...strong and I find it easy to
> > > configure/secure...it performs with no problems for me.
> > >
> > > One small annoying little bug...is the way that it writes its queue
> files
> > > the SQL logging functions in MailScanner pickup redundant email
> addresses
> > in
> > > the to_address field of the logging.
> > >
> > > Steve is working on this, but it remains...and causes my SQL queries
to
> be
> > a
> > > little ugly.
> > >
> > > CT