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