Stats are not generating

[Robert Thomas]

Just installed your OVA and it worked great..

Messages are showing on the admin page but cannot get any search results

I did find this in the crontab

root@piler:/var/log# /usr/bin/php /usr/local/libexec/piler/generate_stats.php /var/www/piler.vom.com -bash: /usr/bin/php: No such file or directory

[Janos SUTO]

Hmm, perhaps a package is missing if /usr/bin/php doesn't exist. Please check if you have the php5-cgi package installed.

For fixing the empty search results, please login as auditor@local (or create an auditor user if there's none), and perform a search (just hit the search button). If you can't see any hit, then make sure you have big enough files under /var/piler/sphinx

[Robert Thomas]

Vanilla install from OVA

root@piler:~# dpkg -l | grep php ii php5-cgi 5.4.4-14+deb7u4 amd64 server-side, HTML-embedded scripting language (CGI binary) ii php5-common 5.4.4-14+deb7u4 amd64 Common files for packages built from the php5 source ii php5-fpm 5.4.4-14+deb7u4 amd64 server-side, HTML-embedded scripting language (FPM-CGI binary) ii php5-gd 5.4.4-14+deb7u4 amd64 GD module for php5 ii php5-ldap 5.4.4-14+deb7u4 amd64 LDAP module for php5 ii php5-memcache 3.0.6-6 amd64 memcache extension module for PHP5 ii php5-mysql 5.4.4-14+deb7u4 amd64 MySQL module for php5 ii php5-xcache 2.0.0-4 amd64 Fast, stable PHP opcode cacher root@piler:~#

We did start seeing results .. just need to read the documentation to understand searches a little more..

[Janos SUTO]

"We did start seeing results .. just need to read the documentation to understand searches a little more.."

OK, tell me if you need some help.

[Robert Thomas]

What about the failing crontab ... should I make a symbolic link

[Janos SUTO]

Eh, I was wrong, the package was called php5-cli, sorry. So please install this package, and you'll have /usr/bin/php

[Robert Thomas]

Installed php-cli

Got these warnings

insserv: warning: script 'rc.piler' missing LSB tags and overrides insserv: warning: script 'rc.searchd' missing LSB tags and overrides

[Robert Thomas]

Also this is the response trying to run crontab

$ /usr/bin/php /usr/local/libexec/piler/generate_stats.php /var/www/piler.vom.com

Usage: generate_stats.php --webui [PATH] [OPTIONS...]

    --webui="[REQUIRED: path to the Piler WebUI Directory]"

options: -a Reruns statistics for all records in the message view -h Prints this help screen and exits --start="Beginning of date range to process, ok values are today, yesterday or DDMMMYYYY...anything php's strtotime can process. Optional, will default to beginning of current day." --stop="End of date range, same parameters as above. Optional (will default to end of current day)"