Some basic questions to sphinx

1. I installed sphinx and I could see the search results.
   
2. After some days I noticed that the vbulletin database table "vbsphinxsearch_queue" had thousands of entries.
   
3. I was unsure if that was right and looked at the cronjobs. They were looking right.
   
4. I then just run the every-10-minutes-cronjob /usr/local/sphinx/cron/delta.sh That took more than one hour and this time my life board went offline.
   
5. As I could not take my board offline as I could not even get to forum.com/admincp, I shut down the /usr/local/sphinx/cron/delta.sh job while it was running by hitting STRG+C.
   
6. My forum works good after that, also the sphinx search.
   
7. But I can not execute /usr/local/sphinx/cron/delta.sh again, then I always get this error message:
   
   

   (...)
   using config file '/usr/local/sphinx/etc/vbulletin-sphinx.php'...
   ERROR: invalid token in /usr/local/sphinx/etc/vbulletin-sphinx.php line 1 col 1.
   ERROR: invalid token in /usr/local/sphinx/etc/vbulletin-sphinx.php line 1 col 1.
   FATAL: failed to parse config file '/usr/local/sphinx/etc/vbulletin-sphinx.php'.
   Sphinx 0.9.8-id64-release (r1371)
   Copyright (c) 2001-2008, Andrew Aksyonoff
   
   using config file '/usr/local/sphinx/etc/vbulletin-sphinx.php'...
   ERROR: invalid token in /usr/local/sphinx/etc/vbulletin-sphinx.php line 1 col 1.
   ERROR: invalid token in /usr/local/sphinx/etc/vbulletin-sphinx.php line 1 col 1.
   FATAL: failed to parse config file '/usr/local/sphinx/etc/vbulletin-sphinx.php'.
   Sphinx 0.9.8-id64-release (r1371)
   Copyright (c) 2001-2008, Andrew Aksyonoff
   (...)

The forum runs now with the usual vbulletin search engine, but I'd like to know how I can setup sphinx search again

[Lynne]

ERROR: invalid token in /usr/local/sphinx/etc/vbulletin-sphinx.php line 1 col 1.

So what is the first line in your file? And is it the correct path for you (I know I had to change it for my path to php).

[ThorstenA]

Originally Posted by Lynne

ERROR: invalid token in /usr/local/sphinx/etc/vbulletin-sphinx.php line 1 col 1.

So what is the first line in your file? And is it the correct path for you (I know I had to change it for my path to php).

It is the #! path to php line and this line is the same as it was before when it was working. Furthermore, in the path to this directory there is a php file. First thing after looking at this error message was that I looked if the vbulletin-sphinx.php file was okay, and it is. Why is it a invalid "token" error?

[sung]

Personally I just ran the vbulletin-sphinx.php script once and saved its output to a file. I don't see the point of calling PHP every time the indexer is run just to generate the same config file.

[Paul M]

You are lucky, I cannot get it to run at all.

Sphinx 0.9.8-id64-release (r1371)
Copyright (c) 2001-2008, Andrew Aksyonoff

using config file '/usr/local/sphinx/etc/vbulletin-sphinx.php'...
ERROR: error executing '/usr/bin/php -q' in /usr/local/sphinx/etc/vbulletin-sphinx.php line 1 col 1.

[pete_brady]

check that you edited the $myforumpath in vbulletin-sphinx.php, not the example $myforumpath path like i did.... doh

[CarlitoBrigante]

The problem is indeed somewhere in the cronjob. Had the same issue Thorsten is reporting in a client's website (he is running litespeed web server). I am trying to look into the delta.sh file to see what could be causing this.

The token error means the PHP path on top is wrong... weird that at first it was running and now it is not running anymore!

[ThorstenA]

Originally Posted by CarlitoBrigante

Had the same issue Thorsten is reporting in a client's website (he is running litespeed web server).

Just a short notice, it may not be because of the litespeed web server, I am running a stock directadmin (that is something like plesk or cpanel) 64bit configuration with apache etc. I have software raid1 but other than that my configuration is pretty usual. The high load is pretty strange as I have an i7 8GB with a less than one million post forum with usual less than 300 users online.

[CarlitoBrigante]

Thorsten, may I ask you if you are running suphp or suexec to run php?

[ThorstenA]

Originally Posted by CarlitoBrigante

Thorsten, may I ask you if you are running suphp or suexec to run php?

I am not so familiar with that, but here is what I found: I have seen mod_suexec on php-info. I did not see suphp on php-info.