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
