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: <[email protected]> From: "Lastname,Firstname,CITY,Department" <[email protected]> Message-ID: <[email protected]> Subject: WG: Vanilloccino The message has been quarantined as: CyzWZJfWJryw[111] The message WAS NOT relayed to: <[email protected]>: 250 2.7.0 Ok, discarded, id=10632-05 - INFECTED: PUA.OLE.EmbeddedPDF Virus scanner output: p008: PUA.OLE.EmbeddedPDF FOUND p004: PUA.OLE.EmbeddedPDF FOUND ------------------------------------------------------------ The documentation says that amavisd-release is using the following syntax: amavisd-release mail_file [secret_id [alt_recip1 alt_recip2 ...]] So what is my mail_file and what is my secret_id? I see in the quarantine table that I have a mail_id: mysql> describe quarantine; +---------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------------+------+-----+---------+-------+ | mail_id | varbinary(12) | NO | PRI | | | | chunk_ind | int(10) unsigned | NO | PRI | NULL | | | mail_text | blob | NO | | NULL | | | partition_tag | int(11) | NO | PRI | 0 | | +---------------+------------------+------+-----+---------+-------+ 4 rows in set (0.00 sec) mysql> That mail_id is not constant and changes from record to record. Some records however share the same mail_id. 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? // Steve -- Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de
