- edited description
sphinx db tables always empty
hello, I installed and configured piler 1.3.4 and shpinx 2.3.2. Mysql, rc.piler and rc.searchd services are running. The folder /var/piler/sphinx contains all of the index files, the piler database is accessible and filled with first indexed emails per pilerimport. The web interface shows the indexed records ( 326 ) in the statusmonitor. All seems to be working - but the sphinx database tables are always empty. I tried all I found in the docs and what others tried - but no success.
I tryed to complete reset the index:
/etc/init.d/rc.searchd stop
rm -rf /var/piler/sphinx/*
su piler
indexer --config /usr/local/etc/piler/sphinx.conf --all
/etc/init.d/rc.searchd start
/usr/local/libexec/piler/indexer.delta.sh
/usr/local/libexec/piler/indexer.main.sh
mysql -h 127.0.0.1 -P 9306
mysql select * from main1,dailydelta1,delta1;
-> always empty
I tryed to run all the commands from the crontab ... they are all running without any error.
There is no error message and I don't know why are the sphinx tables empty??
All the other parts seems to be working fine.
Hope somebody can help me! John
Comments (5)
-
reporter -
repo owner You say that the gui shows you the records. It means it can read sphinx data from somewhere. Check the sphinx query in the mail log, and see where it reads data from.
-
reporter Hello,
there are only the statistics - the messages itself are missing in the gui - the search page is empty,
How can I activate the logwriting? In the gui log folder there is only a lock file. I also tryed to set the logging mode to debug but there will be no logfile generated.
Thank you for assisting me with my problem.
-
repo owner Well, both the piler binaries and the gui use syslog to write its entries to the mail log. Also I'd like to see the ls -la /var/piler/sphinx output (be sure to use bitbucket formatting features!).
-
repo owner - changed status to closed
No news is good news.
- Log in to comment