Hello everyoneI had to reboot the piler server and now, when I perform a search (as Auditor too), I get "Empty search result." In the "Health" section, in "Message disposition" I see that there are 3699 messages. - In the table "metadata" I have 5580 records, and I can see the messages with the command "pilerget <piler_id>."
- typing select count (*) from metadata; returns 5580. - typing select count (*) from sph_index; returns 0;
-ls -la /var/piler/sphinx return: -rw-r--r-- 1 piler piler 0 20 mag 13.41 delta1.spa -rw-r--r-- 1 piler piler 1 20 mag 13.41 delta1.spd -rw-r--r-- 1 piler piler 582 20 mag 13.41 delta1.sph -rw-r--r-- 1 piler piler 1 20 mag 13.41 delta1.spi -rw-r--r-- 1 piler piler 0 20 mag 13.41 delta1.spk -rw------- 1 piler piler 0 20 mag 13.41 delta1.spl -rw-r--r-- 1 piler piler 0 20 mag 13.41 delta1.spm -rw-r--r-- 1 piler piler 1 20 mag 13.41 delta1.spp -rw-r--r-- 1 piler piler 1 20 mag 13.41 delta1.sps -rw-r--r-- 1 piler piler 0 20 mag 13.41 main1.spa -rw-r--r-- 1 piler piler 1 20 mag 13.41 main1.spd -rw-r--r-- 1 piler piler 582 20 mag 13.41 main1.sph -rw-r--r-- 1 piler piler 1 20 mag 13.41 main1.spi -rw-r--r-- 1 piler piler 0 20 mag 13.41 main1.spk -rw------- 1 piler piler 0 20 mag 13.41 main1.spl -rw-r--r-- 1 piler piler 0 20 mag 13.41 main1.spm -rw-r--r-- 1 piler piler 1 20 mag 13.41 main1.spp -rw-r--r-- 1 piler piler 1 20 mag 13.41 main1.sps -rw-r--r-- 1 piler piler 0 20 mag 13.41 main2.spa -rw-r--r-- 1 piler piler 1 20 mag 13.41 main2.spd -rw-r--r-- 1 piler piler 582 20 mag 13.41 main2.sph -rw-r--r-- 1 piler piler 1 20 mag 13.41 main2.spi -rw-r--r-- 1 piler piler 0 20 mag 13.41 main2.spk -rw------- 1 piler piler 0 20 mag 13.41 main2.spl -rw-r--r-- 1 piler piler 0 20 mag 13.41 main2.spm -rw-r--r-- 1 piler piler 1 20 mag 13.41 main2.spp -rw-r--r-- 1 piler piler 1 20 mag 13.41 main2.sps -rw-r--r-- 1 piler piler 0 20 mag 13.41 main3.spa -rw-r--r-- 1 piler piler 1 20 mag 13.41 main3.spd -rw-r--r-- 1 piler piler 582 20 mag 13.41 main3.sph -rw-r--r-- 1 piler piler 1 20 mag 13.41 main3.spi -rw-r--r-- 1 piler piler 0 20 mag 13.41 main3.spk -rw------- 1 piler piler 0 20 mag 13.41 main3.spl -rw-r--r-- 1 piler piler 0 20 mag 13.41 main3.spm -rw-r--r-- 1 piler piler 1 20 mag 13.41 main3.spp -rw-r--r-- 1 piler piler 1 20 mag 13.41 main3.sps -rw-r--r-- 1 piler piler 0 20 mag 13.41 main4.spa -rw-r--r-- 1 piler piler 1 20 mag 13.41 main4.spd -rw-r--r-- 1 piler piler 582 20 mag 13.41 main4.sph -rw-r--r-- 1 piler piler 1 20 mag 13.41 main4.spi -rw-r--r-- 1 piler piler 0 20 mag 13.41 main4.spk -rw------- 1 piler piler 0 20 mag 13.41 main4.spl -rw-r--r-- 1 piler piler 0 20 mag 13.41 main4.spm -rw-r--r-- 1 piler piler 1 20 mag 13.41 main4.spp -rw-r--r-- 1 piler piler 1 20 mag 13.41 main4.sps -rw-r--r-- 1 piler piler 0 20 mag 13.45 note1.spa -rw-r--r-- 1 piler piler 1 20 mag 13.45 note1.spd -rw-r--r-- 1 piler piler 289 20 mag 13.45 note1.sph -rw-r--r-- 1 piler piler 1 20 mag 13.45 note1.spi -rw-r--r-- 1 piler piler 0 20 mag 13.45 note1.spk -rw------- 1 piler piler 0 20 mag 13.45 note1.spl -rw-r--r-- 1 piler piler 0 20 mag 13.45 note1.spm -rw-r--r-- 1 piler piler 1 20 mag 13.45 note1.spp -rw-r--r-- 1 piler piler 1 20 mag 13.45 note1.sps -rw-r--r-- 1 piler piler 0 20 mag 13.45 tag1.spa -rw-r--r-- 1 piler piler 1 20 mag 13.45 tag1.spd -rw-r--r-- 1 piler piler 288 20 mag 13.45 tag1.sph -rw-r--r-- 1 piler piler 1 20 mag 13.45 tag1.spi -rw-r--r-- 1 piler piler 0 20 mag 13.45 tag1.spk -rw------- 1 piler piler 0 20 mag 13.45 tag1.spl -rw-r--r-- 1 piler piler 0 20 mag 13.45 tag1.spm -rw-r--r-- 1 piler piler 1 20 mag 13.45 tag1.spp -rw-r--r-- 1 piler piler 1 20 mag 13.45 tag1.spsConnecting to mysql by 9306 port and typing select * from main1; give "Empty set (0.00 sec)".
I tried to execut the crontab command manually but they give no output. I don't what to do, can someone help me please? Many thanks Roberto
smime.p7s
Description: Firma crittografica S/MIME
