Christian, > 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.
> I use postgres 9.0.4 with amavisd-2.7.0 Apparently this record does not exist in a database. Perhaps it is stored under a different partition tag. Check it manually: select partition_tag, encode(mail_text,'escape') from quarantine where mail_id='s91w1PPZQWPr' order by chunk_ind asc; > Here are my amavis config options that I use. > [...] > 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, Such mix should be alright. Mark
