You shouldn't get any error or warning when running delta indexer. What sphinx version do you have?
Janos On Jun 21, 2016, 09:07, at 09:07, Mahmoud Ramadan <mahmoud.ramadan....@gmail.com> wrote: >I used this command to give Piler all the permissions og the sphinx >directory root@Piler-VM:~# chmod -R 777 /var/piler/sphinx > >and all the file in the directory have the permissions like that: > >root@Piler-VM:~# ls -l /var/piler/sphinx/ >total 168 >-rwxrwxrwx 1 piler piler 32 Jun 21 02:26 dailydelta1.spa >-rwxrwxrwx 1 piler piler 1 Jun 21 02:26 dailydelta1.spd >-rwxrwxrwx 1 piler piler 582 Jun 21 02:26 dailydelta1.sph > >Also i used the command indexer.delta.sh as below but sill no search >results in the search console. > >root@Piler-VM:~# su piler >$ /usr/local/libexec/piler/indexer.delta.sh >WARNING: IsEmpty != attribute size (32) > >Thanks in advance. > > >Best Regards, > >Mahmoud Ramadan Ali > >Network and VOIP Specialist. > >Mobil: (+2) 01276877112 > >Blog <http://hotciscolabs.blogspot.com/>| Website ><http://telecomandsecurity.com/>| LinkedIn ><http://ch.linkedin.com/pub/mahmoud-ali/99/923/421/en> > >On Mon, Jun 20, 2016 at 9:35 AM, Janos SUTO <s...@acts.hu> wrote: > >> Your cron jobs are either not running or you have a permission >problem on >> /var/piler/sphinx. >> >> So switch to user piler, run indexer.delta.sh, and verify that the >sphinx >> files are update and increased in size. >> >> Janos >> On Jun 20, 2016, at 13:25, Mahmoud Ramadan ><mahmoud.ramadan....@gmail.com> >> wrote: >>> >>> Any updates ? need help to solve this issue please , thanks in >advance. >>> >>> Best Regards, >>> >>> Mahmoud Ramadan Ali >>> >>> Network and VOIP Specialist. >>> >>> Mobil: (+2) 01276877112 >>> >>> Blog <http://hotciscolabs.blogspot.com/>| Website >>> <http://telecomandsecurity.com/>| LinkedIn >>> <http://ch.linkedin.com/pub/mahmoud-ali/99/923/421/en> >>> >>> On Sun, Jun 19, 2016 at 1:36 AM, Mahmoud Ramadan < >>> mahmoud.ramadan....@gmail.com> wrote: >>> >>>> Hi, >>>> I did the following troubleshooting steps; >>>> >>>> *Checking the crontab jobs:* >>>> >>>> root@Piler-VM:~# crontab -l -u piler >>>> ### PILERSTART >>>> 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 >>>> --webui /var/www/piler >>>> */5 * * * * /usr/bin/find /var/www/piler/tmp -type f -name i.\* >-exec rm >>>> -f {} \; >>>> ### PILEREND >>>> >>>> *Reading log files:* >>>> >>>> root@Piler-VM:~# tail -f /var/log/sphinxsearch/query.log >>>> [Sat Jun 18 14:20:18.899 2016] 0.000 sec [ext2/0/ext 0 (0,1000)] >>>> [main1,dailydelta1,delta1] >>>> [Sat Jun 18 14:21:48.727 2016] 0.000 sec [ext2/0/ext 0 (0,1000)] >>>> [main1,dailydelta1,delta1] >>>> >>>> >>>> >>>> *Checking permissions:*root@Piler-VM:~# ls -l /var/piler/sphinx >>>> total 168 >>>> -rw-r--r-- 1 piler piler 32 Jun 19 03:05 dailydelta1.spa >>>> -rw-r--r-- 1 piler piler 1 Jun 19 03:05 dailydelta1.spd >>>> -rw-r--r-- 1 piler piler 582 Jun 19 03:05 dailydelta1.sph >>>> -rw-r--r-- 1 piler piler 1 Jun 19 03:05 dailydelta1.spi >>>> -rw-r--r-- 1 piler piler 0 Jun 19 03:05 dailydelta1.spk >>>> -rw------- 1 piler piler 0 Jun 19 03:05 dailydelta1.spl >>>> >>>> >>>> >>>> *Reading log files:*root@Piler-VM:~# tail -f /var/log/mail.log >>>> Jun 19 03:06:17 Piler-VM piler-webui[4484]: sphinx query: 'SELECT >id >>>> FROM main1,dailydelta1,delta1 WHERE MATCH('') ORDER BY >`sent` DESC >>>> LIMIT 0,1000 OPTION max_matches=1000' in 0.00 s, 0 hits, 0 total >found >>>> >>>> Notice: i executed the " select * main1,daildelta1,delta1; " >command >>>> from the web GUI because i tried to know how to execute it from CLI >and >>>> whenever i use the command from the Mysql CLI i get this error. >>>> >>>> root@Piler-VM:~# mysql -h localhost -u piler -p piler -P 9306 >>>> mysql> show databases; >>>> +--------------------+ >>>> | Database | >>>> +--------------------+ >>>> | information_schema | >>>> | piler | >>>> +--------------------+ >>>> 2 rows in set (0.00 sec) >>>> >>>> mysql> use piler; >>>> Database changed >>>> mysql> select * main1,daildelta1,delta1; >>>> ERROR 1064 (42000): You have an error in your SQL syntax; check the >>>> manual that corresponds to your MySQL server version for the right >syntax >>>> to use near 'main1,daildelta1,delta1' at line 1 >>>> >>>> Thanks in advance. >>>> >>>> Best Regards, >>>> >>>> Mahmoud Ramadan Ali >>>> >>>> Network and VOIP Specialist. >>>> >>>> Mobil: (+2) 01276877112 >>>> >>>> Blog <http://hotciscolabs.blogspot.com/>| Website >>>> <http://telecomandsecurity.com/>| LinkedIn >>>> <http://ch.linkedin.com/pub/mahmoud-ali/99/923/421/en> >>>> >>>> On Sat, Jun 18, 2016 at 8:08 AM, Janos SUTO <s...@acts.hu> wrote: >>>> >>>>> >>>>> as with any software if you encountered a problem, you should >check the >>>>> logs. Piler logs everything to the mail log, so be sure to read >it. >>>>> >>>>> To address your problem, if you get no search results, then check >the >>>>> sphinx database. Don't try to select from v_messages, because it's >in >>>>> the mysql database (not in sphinx). >>>>> >>>>> Rather, try this query: >>>>> >>>>> select * main1,daildelta1,delta1; >>>>> >>>>> If it's empty, then check why the sphinx database is not updated. >>>>> Missing cron entries? Bad permissions on /var/piler/sphinx? >>>>> >>>>> So I'd expect some troubleshooting on your behalf. >>>>> >>>>> Janos >>>>> >>>>> PS: don't call me/us your dears. In this culture it means >something >>>>> very different from what you might have had in mind... >>>>> >>>>> >>>>> On Sat, 18 Jun 2016, Mahmoud Ramadan wrote: >>>>> >>>>> Hi dears, >>>>>> I've installed Piler manually and it is receiving archived emails >from >>>>>> my mail server , i can see this is the admin page and the number >of the >>>>>> received messages also the archived mails can be found in the >mysql DB by >>>>>> using the commands below BUT the issue is that none of the >archived mails >>>>>> appear in the auditor >>>>>> page and i get " Empty search result." , any ideas please how to >solve >>>>>> this issue , thanks in advance. >>>>>> >>>>>> >>>>>> root@Piler-VM:~/piler-1.1.1# mysql -h localhost -u piler -p piler >-P >>>>>> 9306 >>>>>> mysql> select * from v_messages; >>>>>> >>>>>> Best Regards, >>>>>> >>>>>> Mahmoud Ramadan Ali >>>>>> >>>>>> Network and VOIP Specialist. >>>>>> >>>>>> Mobil: (+2) 01276877112 >>>>>> >>>>>> Blog | Website | LinkedIn >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>> >>>
