-
|
I need to delete all the mail excluding @domain1.com. piler version: 1.3.5 build 997 EDIT: so in my case I want to delete all, excluding mail that have @domain1.com either in the FROM or TO field |
Beta Was this translation helpful? Give feedback.
Replies: 3 comments 8 replies
-
|
what about deleting the records from the db? is it enough? |
Beta Was this translation helpful? Give feedback.
-
|
Well, no. The database contains only the metadata. The actual email files are still on the disk. Try using the v_messages view that contains both the sender and the recipients. I'll write another comment soon to describe how. |
Beta Was this translation helpful? Give feedback.
-
|
Try the following (be sure to backup the piler database and/or perhaps the whole archive before starting). Set the retention column for all messages to the past if they are not sent to or received from "domain1", eg. Then run pilerpurge.py in dry mode, eg. It prints a bunch of files and IDs what it would remove from the system. eg. You may check these IDs in the v_messages view in the piler database to ensure that they are NOT from/to domain1 that you want to preserve, eg. Once you are confident, run pilerpurge.py as user piler to get rid of the unwanted emails:
|
Beta Was this translation helpful? Give feedback.
-
|
Add the following to piler.conf: |
Beta Was this translation helpful? Give feedback.
-
|
so i executed the query and ran the |
Beta Was this translation helpful? Give feedback.
-
strange because i updated the messages with retained 1000000...and some ids were printed using dry-run |
Beta Was this translation helpful? Give feedback.
-
|
It's odd. Run the following mysql query to check if pilerpurge has removed these messages:
|
Beta Was this translation helpful? Give feedback.
-
they are still there...now even using the dry-run does nothing... |
Beta Was this translation helpful? Give feedback.
-
|
The pilerpurge utility does not remove the database entries, only the files from the /var/piler/store dirs.
Then look for files in /var/piler/store/ subdirs like <piler_id>.m, eg. 400000000abcdef378373.m |
Beta Was this translation helpful? Give feedback.
-
|
thanks! they seems to have been deleted correctly. |
Beta Was this translation helpful? Give feedback.
Try the following (be sure to backup the piler database and/or perhaps the whole archive before starting).
Set the retention column for all messages to the past if they are not sent to or received from "domain1", eg.
Then run pilerpurge.py in dry mode, eg.
It prints a bunch of files and IDs what it would remove from the system. eg.
You may check these IDs in the v_messages view in the piler database to ensure that they are NOT from/t…