Howto remove user and data?

[teds-it]

I have searched in the documentation but can not find it anywhere.
What is the best practice to remove a user eg user1@domain.com and all imported email messages?

[larsen0815]

You can manually set the "retained" date for the mails of that user:

UPDATE metadata SET retained = 0 WHERE `from` = 'user1@domain.com';

Then wait for the nightly cronjob or run /usr/libexec/piler/pilerpurge.py (use -d for a dry-run).

[teds-it]

My apologies for this late reaction.

If i use this command all email from this address is removed, this is done for all users on this server.

My objective is to remove an user / emailaddress which receives email. I looked in the metadata table but i can't find the TO field or a relation to a specific user / receiving emailaddress.

How can i remove all email send to a user (emailaddress)?

[jsuto]

Use the v_messages view. It combines (=joins) the metadata and rcpt tables. However, be careful when a message is sent to several recipients. In such case do you still want to remove the message?

[teds-it]

So i understand... i have an user user1@example.com which has send emails to userA@otherdomain.com and user2@example.com . When i remove all email TO user1@example.com all this is email is gone including the replies on email send FROM userA and user2 to user1? (all users are on the server)

[jsuto]

Piler stores everything as a single instance. So if userA and user2 received the same email, then it's still stored as 1 copy. So if you delete this email because userA demands it, then it's lost for user2, too.