pilerpurge don't delete the emails from manticore RT index

[Eduardo]

I’ve installed piler and imported email from olmailpiler to a new mailpiler with matincore

The mailpurge was enable for 7 years and delete some mails

and the mail purge script is enabled :-(

the emails were deleted as file but they still appear in the piler GUI but without data. (as deleted)

how can i delete the email so they’re gone from the piler GUI.??

I like to reimport the mails from my old server and I change the mailpiler to keep the email for 10 years but at now show as duplicated on the gui one without data as show as deleted.

Another with data (the current imporation).

I don’t know a procedure to delete the e-mail from the GUI on manticore because I have index on RT..

Maybe a I need make a reboot or edit my mysql? or enable some manticore killlist??

I see the query “ sql_query_killlist = SELECT id FROM metadata WHERE deleted=1” on manticore but I don’t why I see the deleted e-mails on my GUI…

Maybe I need enable some on my manticore because is working on RT=1

Regards!

‌

[Janos SUTO]

You don’t need to reimport to change the retention period. Instead go to mysql piler database and a query like

update metadata set retention = retention + 94608000;

This will increment it by 3 years ( 3 * 365 * 86400 sec)

If you use RT index then you don’t need such kill list, instead it can be safely deleted from the manticore database, eg.

delete from piler1 where id=123;

However, the purge script should do that for you. Just checked it, and it seems it doesn’t support RT index at the moment. I’ll address this issue soon.

[Eduardo]

Thanks Janos I was thinking maybe the purge don¡t delete the email.. Now I have a few duplicates the old one (because i was purge and the new one.

‌

Thanks!

[Janos SUTO]

This commit should do it: https://bitbucket.org/jsuto/piler/commits/e2f6a718272585dd99737087b9c63fa7a734461c