How to use amavisd-release with an SQL quarantine?

[Steve]

-------- Original-Nachricht --------
> Datum: Tue, 13 Mar 2012 06:59:15 -0500
> Von: "McDonald, Dan" <Dan.McDonald at austinenergy.com>
> An: amavis-users at amavis.org
> Betreff: Re: How to use amavisd-release with an SQL quarantine?

> 
> 
> 
> On 3/13/12 4:35 AM, "Steve" <steeeeeveee at gmx.net> wrote:
> 
> > Hello list,
> > 
> > I am lost. How do I use amavisd-release to release a quarantined message
> from
> > an SQL quarantine. The message I would like to release has generated
> this
> > error (I masked some values to protect the innocent):
> > 
> > ------------------------------------------------------------
> > A virus was found: PUA.OLE.EmbeddedPDF
> > 
> > Scanner detecting a virus: ClamAV-clamd
> > 
> > Content type: Virus
> > Internal reference code for the message is 10632-05/CyzWZJfWJryw
> > 
> > First upstream SMTP client IP address: [213.199.154.207]
> >   am1ehsobe004.messaging.microsoft.com
> > According to a 'Received:' trace, the message apparently originated at:
> >   [aaa.bbb.ccc.dd], DEMDCE0028.company.com [aaa.bbb.ccc.dd]
> > 
> > Return-Path: <remote.user at at.company.com>
> > From: "Lastname,Firstname,CITY,Department"
> >   <remote.user at at.company.com>
> > Message-ID:
> <771FEFDDD3F0B04588F78B8471506D31025837F6 at DEMDCE0028.company.com>
> > Subject: WG: Vanilloccino
> > The message has been quarantined as: CyzWZJfWJryw[111]
> 
> > 
> > I have no clue how to extract the mail_id/secret_id from the
> notification I
> > receive from Amavisd-New. Can anyone help me or point me into the proper
> > direction?
> 
> $ /usr/sbin/amavisd-release CyzWZJfWJryw
> 
Ohhh boy! Was that really that easy? I feel stupid now.

theia ~ # amavisd-release CyzWZJfWJryw
250 2.0.0 from MTA(smtp:[127.0.0.1]:10026): 250 2.0.0 Ok: queued as 3B1CB823C01
theia ~ #


> I don't think you need the partition_tag.
> 
You are right. The partition_tag is not needed but makes purging of old messages way, way easier.


> -- 
> Daniel J McDonald, CCIE # 2495, CISSP # 78281
> 
// Steve
-- 
Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir
belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de