vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Sphinx (https://vborg.vbsupport.ru/forumdisplay.php?f=265)
-   -   Some basic questions to sphinx (https://vborg.vbsupport.ru/showthread.php?t=241739)

ThorstenA 05-02-2010 09:08 PM

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:

    Code:

    (...)
    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 05-02-2010 09:15 PM

Code:

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 05-03-2010 07:21 AM

Quote:

Originally Posted by Lynne (Post 2030762)
Code:

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 05-03-2010 01:04 PM

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 05-05-2010 04:11 PM

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

Quote:

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 05-05-2010 04:28 PM

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

CarlitoBrigante 05-05-2010 06:52 PM

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 05-05-2010 07:18 PM

Quote:

Originally Posted by CarlitoBrigante (Post 2032248)
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 05-05-2010 07:21 PM

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

ThorstenA 05-05-2010 07:25 PM

Quote:

Originally Posted by CarlitoBrigante (Post 2032259)
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.


All times are GMT. The time now is 08:55 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01897 seconds
  • Memory Usage 1,739KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete