MailWatch 0.2

[Steve Freegard]

Hi Martin,

Answers to your questions:

1) It logs mail information into the DB, such as Message ID, From, To,
Subject, SA Reports, Viruses found etc. *except* the message body and
attachments.  The information is used purely for reporting purposes only.
At the moment the only way to clean the database out is to manually delete
the data by writing an SQL statement to do so.  I had planned to put some
features in eventually to housekeep the database after a certain period/size
to condense the detail data into summary data, but that won't appear for a
while yet as all the reports will need to be re-written and will take a bit
of planning first.

2) You can already look around your data using the 'Message Listing' report
- but this doesn't enable you to release mails from quarantine because the
actual message is not contained in the database.  I will be looking at
introducing a feature to be able to read the quaratine files from
/var/spool/MailScanner/quarantine and release then in a future version.

Kind regards,
Steve.

--
Steve Freegard
Systems Manager
Littlehampton Book Services Ltd.

-----Original Message-----
From: Martin Hepworth [mailto:maxsec at TOTALISE.CO.UK]
Sent: 17 June 2003 10:24
To: MAILSCANNER at JISCMAIL.AC.UK

Steve
looks like a nice little util.

I have a couple of questions

1) according to the 'blurb' it logs all the mail into the DB. How do I
clean this out as right now we get about 23,000 emails per week, that
vast majority (>80%) are spam. So I really don't want to keep these forever.

2) also in the blurb the front end only shows the last 50, anything in
the pipeline to look at them all, ie navigate around the stored emails,
via date, from, to etc... so I can see what got tagged as spam
incorrectly and 'release' them to the user if I only quaranteen the
email and don't forward spam?

--
Martin
(at home)

--
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.