Delete messages from store

[claros]

Sometimes some phishing messages pass every check and are delivered to my users.
Actually I can perfrom a grep -R on the store, find messages and substitute the phishing site url with an abouth:blank.
But I should be able to delete this messages from zimbra store. I don't know what to do with the database, can you help me ?

Claudio

[dkarp]

Directly editing blobs in the store is generally a bad idea. We're keeping a message size field and a message SHA1 hash field in the database, and making the store inconsistent with the database will eventually get you in trouble. (For instance, the Outlook connector may be very unhappy if you do this.)

I haven't done what you're describing, but I think I know how to do waht you want. You should be able to use zmmailbox to: authenticate as an administrator, then search for your target string in user mailboxes, then delete the matching messages. Warning: Test your script before actually deleting anything!

[claros]

Directly editing blobs in the store is generally a bad idea. We're keeping a message size field and a message SHA1 hash field in the database, and making the store inconsistent with the database will eventually get you in trouble. (For instance, the Outlook connector may be very unhappy if you do this.)

I haven't done what you're describing, but I think I know how to do waht you want. You should be able to use zmmailbox to: authenticate as an administrator, then search for your target string in user mailboxes, then delete the matching messages. Warning: Test your script before actually deleting anything!

Thank you for your answare. This is what I was looking for.
But I can't run zmmailbox aa. I've the following error:

zmmailbox aa admin@domain.com passwd
ERROR: service.UNKNOWN_DOCUMENT (unknown document: AuthRequest)

I've tried a search but found nothing useful... Zimbra version is 4.03 GA