Retention rules not applying
Issue #454
resolved
I'm running the OVA vmware image and can't seem to get the retention policy to delete aged emails beyond the retention date that i've set via browser and piler.conf file. When I perform a search, the result are beyond the retention day set.
Comments (12)
-
-
btw, i've ran the pilerpurge command -d and without.
-
repo owner
pilerpurge removes any message where the 'retained' value is less than the current timestamp. So run "mysql -u piler -p piler", then execute the following query:
select id from metadata where retained < NOW() limit 100;to see what messages pilerpurge should remove. The -d option instructs pilerpurge to dry run, ie. just show what it would remove.
-
The select statement resulted in this.
mysql> select id from metadata where retained < NOW() limit 100; Empty set (0.00 sec)
-
repo owner
OK, then it means that no message is aged yet. See the default retention value in piler.conf
-
Well, I started with the default retention policy (7 years) and later modified it to 3 days.
-
repo owner
If you didn't forget to reload piler, then you should have aged messages in 3 days.
-
i've rebooted and ran /etc/init.d/rc.piler reload. is that what you're asking me to do or is it a different command?
-
repo owner
Yes, though rebooting is not necessary, /etc/init.d/rc.piler reload is good enough.
-
so i've reloaded the ova image and started from scratch and edited the default retention period to 3 days. After I run the Pilerpurge command, I still get search result for messages older than 3 days.
Do I need to create an Archive Rule & Retention Rule or will a single Retention Run be okay?
-
repo owner
When the daemon archives a message, it syslogs the retention period. Please show me some log entries.
-
repo owner
- changed status to resolved
No news is good news.
- Log in to comment
it's me who created this problem ticket.