search.php

[zman]

Hi,

I am new to mailpiler and been been using it for six month without issue. Recently, we are unable to search for old email except today email on search.php.

However, we can extract the old mail when I tried to export using pilerexport. Therefore, I am sure we are backing up every single email.

Please help, how do I get the search.php function to work again for all email.

[Janos SUTO]

Please check the size of the sphinx files in /var/piler/sphinx. Also check what is the oldest 'id' in sphinx:

$ mysql -h 127.0.0.1 -P 9306 mysql> select id from main1,dailydelta1,delta1 order by id asc limit 5;

If you can't see 1, 2, 3, 4, 5, and the sphinx files are too small compared to the archived emails, then your sphinx files were truncated. Have you or crontab issued "indexer --all"? Check out FAQ Q5 on how to reindex things.

[zman]

Hi,

It seems doesn't work even though start piler using init.d/rc.searchd. Here is the query result and crontab.

mysql> select id from main1,dailydelta1,delta1 order by id asc limit 5; +------+ | id | +------+ | 1 | | 2 | | 3 | | 4 | | 5 | +------+ 5 rows in set (0.16 sec)

/5 * * LC_ALL=C mpstat | tail -1 | awk '{print $11}' > /var/piler/stat/cpu.stat 5,35 * * /usr/local/libexec/piler/indexer.delta.sh 30 2 * * /usr/local/libexec/piler/indexer.main.sh /15 * * /usr/bin/indexer --quiet tag1 --rotate /15 * * /usr/bin/indexer --quiet note1 --rotate 30 6 * * * /usr/bin/php /usr/local/libexec/piler/generate_stats.php /var/www/html/mailpiler

[Janos SUTO]

If a teamviewer session is possible, then find me on skype (janos.suto)