Can only search current day's email in GUI

[Dee Booth]

Piler version is 1.2.0, Debian. There is no sphinxsearch under /etc/default

mysql> select * from main1; ERROR 1064 (42000): no enabled local indexes to search

Please let me know if you need more information to help me debug this. Thank you.

[Janos SUTO]

How long do you use piler? 1.2.0 is a pretty old version. Not sure why this issue occurs now. Please elaborate what's going on.

[Dee Booth]

We have used Piler since 2016 but just now have a request to find a particular email message in the archive. When I search for messages using the GUI, the only results I get are for the current day, nothing in the past. I know the messages are in the archive because I can see them in the metadata tables. The FAQ suggests changing a setting in /etc/default/sphinxsearch and running the reindex, but this file does not exist under /etc/default.

When I run a select from main1, I get the error message that I pasted into my initial posting. Was Piler installed incorrectly?

[Janos SUTO]

Please show me the output of ls -la /var/piler/sphinx. Make sure to use the formatting options of bitbucket before you hit the 'comment' button.

[Janos SUTO]

You don't have a main index at all. I suggest you to stop searchd, create the main1 index running 'indexer main1' as user piler, then start searchd, and verify that it exists. Then run indexer.main.sh as user piler. Check piler's crontab where it is, then verify that the main1 files are updated. Then run 'reindex -a' to repopulate the indexes.

[Dee Booth]

Janos, we followed the steps and can see that the indexer is working now but there are still failures. See the screenshot below. Is there anything we can do about these?

[Janos SUTO]

I made a mistake: you should have run indexer.delta.sh (as user piler), and then indexer.delta.sh. However, you should be fine by now. Show me ls -la output again.

[Dee Booth]

Thank you, Janos. That worked.

Is there a way I can delete email from Piler?

[Janos SUTO]

Recent piler builds feature a delete feature reserved for auditors. However, 1.2.0 doesn't have it. However, all is not lost: you may delete them with the purging utility.

All you have to do is to set the retained column to 10000000 for those messages you want to get rid of. Then run the pilerpurge utility as user piler, and it will remove all messages having the retained column value in the past. (Note that it stores unix time).