pilerpurge: undefined symbol: p_exec_query
Hi,
when running
pilerpurge -d
i get a
pilerpurge: symbol lookup error: pilerpurge: undefined symbol: p_exec_query
How could i fix that?
Thanks & best regards
Thomas
Comments (12)
-
reporter -
repo owner Yes, please add queuedir=/var/piler/store to piler.conf - provided that you store your emails in this directory.
-
reporter pilerconf outputs
queuedir=/var/piler/store
When running
./pilerpurge.py --config "/usr/local/etc/piler/piler.conf" -d
there is no output.
-
reporter It seems like the query in pilerpurge does not respect retention_rule
This is the executed query:SELECT piler_id, size FROM metadata WHERE deleted=0 AND retained < UNIX_TIMESTAMP(NOW()) AND id NOT IN (SELECT id FROM rcpt WHERE to IN (SELECT email FROM legal_hold)) AND id NOT IN (SELECT id FROM metadata WHERE from IN (SELECT email FROM legal_hold))```
-
reporter Even after a reindex -a it doesn´t want to list the mails, where i recenlty added a retention_rule of 14 days.
-
repo owner pilerpurge.py has nothing to do with retention rules. The rules are processed at archiving time. In other words you define the retention rules, and piler figures out how long you want to keep the message, and sets the retention column accordingly. Then pilerpurge.py selects all messages with a retention timestamp in the past.
-
reporter But isn’t this retention timestamp set by indexer?
-
repo owner No. The piler daemon (or pilerimport) sets it.
-
reporter Thanks for that information.
So it's not possible to change the retention afterwards?
-
repo owner Well, normally no. However, since it’s your archive, you may fix the retained column in the metadata table.
-
reporter Ok, thanks!
-
reporter - changed status to resolved
- Log in to comment
Ok, seems like pilerpurge is outdated (Release Notes… )
i assume that it is save to delete in
Maybe the Docs on mailpiler.org needs an update?
Regarding pilerpurge.py
This tool assumes that the config is in
```/ /etc/piler/
/usr/local/etc/piler/piler.conf
pilerpurge.py --config /usr/local/etc/piler/piler.conf ```
it complains about a missing ‘queuedir’ in section ‘piler’ within the config.
When check the piler.conf in the freshly runned build, its even missing there - i just recognized it in unit_tests/test.conf
What should this config set to?
Thanks in advance & best regards,
Thomas