Use Management of Quarantine Queues?

Hello,

I'm fairly new to AmavisNew.  I help run a shared colo
server with some
friends.  We're looking for a flexible mail system with
anti-spam/virus
capabilities that can be opted in on a per-domain basis. 
From everything
I've tried, Postfix + AmavisNew (with SA and Clam) seems to
fit the bill
very nicely.

My problem is with user-level management and tweaking of
quarantine queues,
SA rules, and even AmavisNew policies.  The Squirrelmail
plugin AmavisNewSQL
looked to fit the bill, but it seems like it hasn't been
developed for a
while and, at least on my first go round with it, it doesn't
seem to work
with the 2.5.2 version of AmavisNew.  (The AmavisNew SQL
schema and the
AmavisNewSQL schemas don't seem to play well together.)  Is
this correct?

I've looked at Mailzu and for queue management, this might
be fine, but, as
far as I can tell, there are no tweaking abilities.

Any other suggestions?  I like the cronjobs for nightly
digesting and
notification of quarantine queue status that come with
AmavisNewSQL, but
they don't seem to work with the AmavisNew SQL schema and I
can't find any
up-to-date versions.

Thanks,
pete
------------------------------------------------------------
-------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and
a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
_______________________________________________
AMaViS-user mailing list
AMaViS-userlists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user

AMaViS-FAQ:http://www.amav
is.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/ho
wto/

On 8/27/07, Pete Toscano <shubnub+amavisgmail.com> wrote:
> Hello,
>
> I'm fairly new to AmavisNew.  I help run a shared colo
server with some
> friends.  We're looking for a flexible mail system with
anti-spam/virus
> capabilities that can be opted in on a per-domain
basis.  From everything
> I've tried, Postfix + AmavisNew (with SA and Clam)
seems to fit the bill
> very nicely.
>
> My problem is with user-level management and tweaking
of quarantine queues,
> SA rules, and even AmavisNew policies.  The
Squirrelmail plugin AmavisNewSQL
> looked to fit the bill, but it seems like it hasn't
been developed for a
> while and, at least on my first go round with it, it
doesn't seem to work
> with the 2.5.2 version of AmavisNew.  (The AmavisNew
SQL schema and the
> AmavisNewSQL schemas don't seem to play well together.)
 Is this correct?
>
> I've looked at Mailzu and for queue management, this
might be fine, but, as
> far as I can tell, there are no tweaking abilities.
>
> Any other suggestions?  I like the cronjobs for nightly
digesting and
> notification of quarantine queue status that come with
AmavisNewSQL, but
> they don't seem to work with the AmavisNew SQL schema
and I can't find any
> up-to-date versions.
>
> Thanks,
> pete

I found that the amavisnewsql quarantine system is
essentially broken,
but I was otherwise able to create a schema that seems to
play nice
with both amavisnewsql and amavisd-new:

http://www200.pair.com/mecham/spam/amavis-sqmail.sql.txt


I chose to use a combination of 'plus addressing' to a Spam
folder
and/or quarantine to MailZu. I also modified amavisnewsql to
allow
modification of spam_quarantine_cutoff_level (in addition
to
spam_tag2_level and spam_kill_level).
This illustrates how the system work (from a user's
standpoint):

http://www200.pair.com/mecham/spam/virtual.index.html

I document my adventures here:

http:
//www200.pair.com/mecham/spam/virtual.html

-- 
Gary V

------------------------------------------------------------
-------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and
a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
_______________________________________________
AMaViS-user mailing list
AMaViS-userlists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user

AMaViS-FAQ:http://www.amav
is.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/ho
wto/

Thanks, Gary.  I've been using your docs for some of my
configuration.
Although I'm doing it on a Fedora box, it's mostly
translating smoothly.
------------------------------------------------------------
-------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and
a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
_______________________________________________
AMaViS-user mailing list
AMaViS-userlists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user

AMaViS-FAQ:http://www.amav
is.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/ho
wto/