Retention rules not working

[larrylu]

Hi ALL , I use PilerImport to import some EML file , after importing , I found that some emails were Duplicate, one was correct, another without sender .

so i make a retention rules to delete the emails without sender , but it not working.

how can i fix it.

[Janos SUTO]

Run pilertest against such a message having no sender info, and verify that the retention rule matches it.

[larrylu]

i try

[larrylu]

I run pillertest, the retention rule can match it, but the email will not be deleted.

[Janos SUTO]

Check if the periodic purge is enabled on the gui (as administrator). Also check if you have the purge utility in piler's crontab.

[larrylu]

How to add purge utility in piler's crontab?

[Janos SUTO]

Add the following:

30 2 * * * /usr/local/libexec/piler/pilerpurge.py

[larrylu]

run pilerpurge.py error， how to fix it .

[Janos SUTO]

Use the -c option to use /usr/local/etc/piler/piler.conf

[larrylu]

error again.

[Janos SUTO]

OK, fear not, we are getting closer. Run 'pilerget -q queuedir', then add its output to piler.conf. Then try running pilerpurge.py again.

[larrylu]

command error.

[Janos SUTO]

Ehh, I made a typo. This is the correct one: pilerconf -q queuedir

[larrylu]

command can run now , but some emails still can't delete.

[Janos SUTO]

That's nice! You managed to purge 2 million emails or so. For the "still can't delete" emails, check the 'retained' column value, and figure out why it's not 1 day.

[larrylu]

The rules can match , but i don't understand why the email won't be deleted.

[Janos SUTO]

Please show me the following sql query output (be sure to use the body digest value from the above output!):

select * from metadata where bodydigest='884b...';

[larrylu]

Resetting the sphinx database, everything is ok now. Thank you!