Quarantine metadata to database

Hi

Two questions regarding quarantining

1: I would like to quarantine metadata
(to/from/score/tests/etc) to a
database, while keeping the file on disk.  Is this possible,
or should I
write a script which scans the quarantine dir and extracts
metadata for
myself?

2: can I quarantine to a multi-level hash directory: ie,
quarantine/A/V/E/AVEGwyZaKYwt.gz



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

Chris Picton wrote:

> 1: I would like to quarantine metadata
(to/from/score/tests/etc) to a
> database, while keeping the file on disk.  Is this
possible, or should I
> write a script which scans the quarantine dir and
extracts metadata for
> myself?

Some data is there already. Have a look at README.sql-mysql
and table 
structure. Tests are not logged to DB but can go to syslog
maillog.

> 2: can I quarantine to a multi-level hash directory:
ie,
> quarantine/A/V/E/AVEGwyZaKYwt.gz

Yes, the feature is there.

#$quarantine_subdir_levels = 1;  # add level of subdirs to
disperse quarantine

See the amavisd.conf-sample in your distribution directory
for the full list 
of options!

Paolo


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

> Chris Picton wrote:
> > 2: can I quarantine to a multi-level hash
directory: ie,
> > quarantine/A/V/E/AVEGwyZaKYwt.gz

Paolo Cravero wrote,
> Yes, the feature is there.
>
> $quarantine_subdir_levels = 1;
>    # add level of subdirs to disperse quarantine

Almost, but not quite, any value >= 1 is currently
treated as 1.
Multiple dynamic levels are not currently supported.

amavisd.conf-default:
# $quarantine_subdir_levels = undef;  # 0 or 1  (undef
treated as 0)

rtelease notes:
- can add one layer of 62 subdirectories to the quarantine
directory for
  more efficient file system use by uniformly distributing
quarantined mail;
  enabled by setting a new config variable
$quarantine_subdir_levels to 1;


(you may have multiple STATIC levels, e.g.
quarantine/X/Y/A/AVEGwyZaKYwt.gz
where quarantine/X/Y is fixed and A/AVEGwyZaKYwt.gz is one
dynamic level)

  Mark

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

Chris,

> Is it possible to log *only* quarantined mails, and not
all mails
> passing through amavis?  From what I can see, setting
storage_sql_dsn
> will cause logging of all mails.

Not possible without tweaking the code. The storage_sql_dsn is global.
It might be possible to tweak entries in %sql_clause and
replace
a simple INSERT and UPDATE with some conditionalized SQL
magic.
It is also possible to have per-policy-bank %sql_clause,
although
this does not address your particular need. Probably the
least work
would be to modify code.

But do you really want this? The pen pals feature won't work
any longer.

  Mark

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