I have the same problem. I run piler under Debian Squeeze, using sphinx2 from the official .deb archive. I have sent 1 message to piler, ad it has been fed into the database. The next messages, are not :-(
Here are the infos: $ mysql -u piler -p piler mysql> select count(*) from metadata; +----------+ | count(*) | +----------+ | 1 | +----------+ 1 row in set (0.00 sec) mysql> select count(*) from sph_index; +----------+ | count(*) | +----------+ | 0 | +----------+ 1 row in set (0.00 sec) $ sudo -u piler ls -la /var/piler/sphinx total 96 drwx------ 2 piler piler 4096 Oct 30 16:30 . drwxr-xr-x 7 root root 4096 Oct 30 16:15 .. -rw-r--r-- 1 piler piler 0 Oct 30 16:30 delta1.spa -rw-r--r-- 1 piler piler 1 Oct 30 16:30 delta1.spd -rw-r--r-- 1 piler piler 582 Oct 30 16:30 delta1.sph -rw-r--r-- 1 piler piler 1 Oct 30 16:30 delta1.spi -rw-r--r-- 1 piler piler 0 Oct 30 16:30 delta1.spk -rw------- 1 piler piler 0 Oct 30 16:30 delta1.spl -rw-r--r-- 1 piler piler 0 Oct 30 16:30 delta1.spm -rw-r--r-- 1 piler piler 1 Oct 30 16:30 delta1.spp -rw-r--r-- 1 piler piler 1 Oct 30 16:30 delta1.sps -rw-r--r-- 1 piler piler 64 Oct 30 16:30 main1.spa -rw-r--r-- 1 piler piler 1 Oct 30 16:30 main1.spd -rw-r--r-- 1 piler piler 582 Oct 30 16:30 main1.sph -rw-r--r-- 1 piler piler 1 Oct 30 16:30 main1.spi -rw-r--r-- 1 piler piler 0 Oct 30 16:30 main1.spk -rw------- 1 piler piler 0 Oct 30 16:30 main1.spl -rw-r--r-- 1 piler piler 0 Oct 30 16:30 main1.spm -rw-r--r-- 1 piler piler 1 Oct 30 16:30 main1.spp -rw-r--r-- 1 piler piler 1 Oct 30 16:30 main1.sps -rw-r--r-- 1 piler piler 0 Oct 30 16:30 note1.spa -rw-r--r-- 1 piler piler 1 Oct 30 16:30 note1.spd -rw-r--r-- 1 piler piler 289 Oct 30 16:30 note1.sph -rw-r--r-- 1 piler piler 1 Oct 30 16:30 note1.spi -rw-r--r-- 1 piler piler 0 Oct 30 16:30 note1.spk -rw------- 1 piler piler 0 Oct 30 16:30 note1.spl -rw-r--r-- 1 piler piler 0 Oct 30 16:30 note1.spm -rw-r--r-- 1 piler piler 1 Oct 30 16:30 note1.spp -rw-r--r-- 1 piler piler 1 Oct 30 16:30 note1.sps -rw------- 1 piler piler 6 Oct 30 16:16 searchd.pid -rw-r--r-- 1 piler piler 0 Oct 30 16:30 tag1.spa -rw-r--r-- 1 piler piler 1 Oct 30 16:30 tag1.spd -rw-r--r-- 1 piler piler 288 Oct 30 16:30 tag1.sph -rw-r--r-- 1 piler piler 1 Oct 30 16:30 tag1.spi -rw-r--r-- 1 piler piler 0 Oct 30 16:30 tag1.spk -rw------- 1 piler piler 0 Oct 30 16:30 tag1.spl -rw-r--r-- 1 piler piler 0 Oct 30 16:30 tag1.spm -rw-r--r-- 1 piler piler 1 Oct 30 16:30 tag1.spp -rw-r--r-- 1 piler piler 1 Oct 30 16:30 tag1.sps $ mysql -u piler -p piler -h 127.0.0.1 --port 9306 mysql> select * from main1; Empty set (0.00 sec) It seems there are two problems here, one woth piler itself, and one with sphinx ... Thank you -- Gabriele
