Can not release quarantined mail

Christian Roessner c+amavis at roessner-network-solutions.com
Tue Aug 2 14:07:00 CEST 2011


Hi,

I have (some) false-positive mail in virus quarantine, which I would
like to release. I tried:

amavisd-release s91w1PPZQWPr

And got:

450 4.5.0 Failure: Can't open sql obj for reading: No such file or
directory at (eval 122) line 362, <GEN51> line 4.

In mail.log I see lines like this:

Aug  2 13:55:33 mx0 amavis[31847]: (rel-s91w1PPZQWPr)
Amavis::IO::SQL::open key=s91w1PPZQWPr, p_tag=0: no such record
Aug  2 13:55:33 mx0 amavis[31847]: (rel-s91w1PPZQWPr) (!!)policy_server
FAILED: Can't open sql obj for reading: No such file or directory at
(eval 122) line 362, <GEN51> line 4.

Here are my amavis config options that I use. Maybe I have done
something wrong?

$sql_allow_8bit_address = 1;
@storage_sql_dsn =
  (
['DBI:Pg:dbname=amavisrw;host=db.example.de;port=5432;sslmode=require',
'amavisrw', '****'] );
@lookup_sql_dsn =
  (
['DBI:Pg:dbname=amavisro;host=db.example.de;port=5432;sslmode=require',
'amavisro', '****'] );

$virus_admin = $RNSPOSTMASTER;
$QUARANTINEDIR = '/var/lib/amavis/quarantine';
$virus_quarantine_method = 'local:virus/%m.gz';

I put spam and banned files to sql: Only virus mail go to flat files, as
I currently have no web interface to surf through the SQL stored
messages. Using Sanesecurity has some false positives, which I want to
release, if possible,

I use postgres 9.0.4 with amavisd-2.7.0

Thanks for your help in advance

Christian
-- 
Roessner-Network-Solutions
Bachelor of Science Informatik
50°34.725'N, 08°40.904'O, Nahrungsberg 81, 35390 Giessen
F: +49 641 5879091, M: +49 176 93118939
USt-IdNr.: DE225643613
http://www.roessner-network-solutions.com


More information about the amavis-users mailing list