Sphinx Search Engine

Yes sure why not please have a look at following result:

root@archive [/home/archives/public_html/wp-content/uploads/sphinx/bin]# ls -la
total 22480
drwxr-xr-x 2 archives archives 4096 Feb 3 03:15 ./
drwxr-xr-x 7 archives archives 4096 Feb 3 05:58 ../
-rwxr-xr-x 1 archives archives 4549671 Feb 3 03:15 indexer*
-rwxr-xr-x 1 archives archives 4367213 Feb 3 03:15 indextool*
-rwxr-xr-x 1 archives archives 4419044 Feb 3 03:15 search*
-rwxr-xr-x 1 archives archives 5280142 Feb 3 03:15 searchd*
-rwxr-xr-x 1 archives archives 4322645 Feb 3 03:15 spelldump*

Yes sure why not please have a look at following result:

I see nothing which would not allow to run searchd.
Could you provide output of ‘./searchd’ run in the same dir where you ran ‘ls -la’?

please see the result:

root@archive [/home/archives/public_html/wp-content/uploads/sphinx/bin]# ls -la
total 22480
drwxr-xr-x 2 archives archives 4096 Feb 3 03:15 ./
drwxr-xr-x 7 archives archives 4096 Feb 3 05:58 ../
-rwxr-xr-x 1 archives archives 4549671 Feb 3 03:15 indexer*
-rwxr-xr-x 1 archives archives 4367213 Feb 3 03:15 indextool*
-rwxr-xr-x 1 archives archives 4419044 Feb 3 03:15 search*
-rwxr-xr-x 1 archives archives 5280142 Feb 3 03:15 searchd*
-rwxr-xr-x 1 archives archives 4322645 Feb 3 03:15 spelldump*
root@archive [/home/archives/public_html/wp-content/uploads/sphinx/bin]# searchd
-bash: searchd: command not found
root@archive [/home/archives/public_html/wp-content/uploads/sphinx/bin]# search
Usage: grep [OPTION]… PATTERN [FILE]…
Try `grep –help’ for more information.

root@archive [/home/archives/public_html/wp-content/uploads/sphinx/bin]# searchd

from local directory you should run it as: ./searchd

root@dawnarchive [/home/archives/public_html/wp-content/uploads/sphinx/bin]# ./s earchd
Sphinx 0.9.9-release (r2117)
Copyright (c) 2001-2009, Andrew Aksyonoff

using config file ‘/home/archives/public_html/wp-content/uploads/sphinx/etc/sphi nx.conf’…
ERROR: invalid section type ‘X-Powered-By’ in /home/archives/public_html/wp-cont ent/uploads/sphinx/etc/sphinx.conf line 1 col 13.
ERROR: invalid section type ‘X-Powered-By’ in /home/archives/public_html/wp-cont ent/uploads/sphinx/etc/sphinx.conf line 1 col 1.
FATAL: failed to parse config file ‘/home/archives/public_html/wp-content/upload s/sphinx/etc/sphinx.conf’
root@archive [/home/archives/public_html/wp-content/uploads/sphinx/bin]#

You should specify config file,
right command is: ./searchd -c sphinx.conf

root@archive [/home/archives/public_html/wp-content/uploads/sphinx/bin]# ./searchd -c sphinx.conf
Sphinx 0.9.9-release (r2117)
Copyright (c) 2001-2009, Andrew Aksyonoff

using config file ‘sphinx.conf’…
FATAL: failed to parse config file ‘sphinx.conf’
root@archive [/home/archives/public_html/wp-content/uploads/sphinx/bin]#

Sorry, I give you wrong command, the right one is, sphinx.conf in the parent directory, so command is:
./searchd -c ../sphinx.conf

No use sir still getting the error:

root@archive [/home/archives/public_html/wp-content/uploads/sphinx/bin]# ./searchd -c ../sphinx.conf
Sphinx 0.9.9-release (r2117)
Copyright (c) 2001-2009, Andrew Aksyonoff

using config file ‘../sphinx.conf’…
ERROR: invalid section type ‘X-Powered-By’ in ../sphinx.conf line 1 col 13.
ERROR: invalid section type ‘X-Powered-By’ in ../sphinx.conf line 1 col 1.
FATAL: failed to parse config file ‘../sphinx.conf’
root@archive [/home/archives/public_html/wp-content/uploads/sphinx/bin]#

Something wrong with you config, please generate new one through the Configuration Wizard and skip the installation step, finish the configuration, sphinx conf should be fixed.
If you still get error with sphinx.conf, then share you sphinx.conf configuration, we will check it.

I generrated new config file through the configuration wizard and skip the installation step,finish the configuration wizard but still same result. My sphinx.conf is as follows:

#!/usr/bin/php
<?php
require_once(‘/home/archives/public_html/wp-config.php’);
ini_set(‘short_open_tag’, 0);
?>
##########################
# WARNING: it is not original sphinx.conf – this file adopted to sphinx
# which installed by wordpress Sphinx Search plugin.
# Don’t use this file as example of sphinx configuration,
# better visit the official doc page at https://www.sphinxsearch.com/doc.html
##########################

source wp_main_posts
{
type = mysql
sql_host = <?php echo DB_HOST.”\n”?>
sql_user = <?php echo DB_USER.”\n”?>
sql_pass = <?php echo DB_PASSWORD.”\n”?>
sql_db = <?php echo DB_NAME.”\n”?>

sql_port = 3306 # optional, default is 3306
sql_query_pre = SET NAMES utf8
sql_query_pre = REPLACE INTO <?php echo $table_prefix?>sph_counter SELECT 1, MAX(id) FROM wp_posts
sql_query_range = SELECT MIN(id),( SELECT max_doc_id FROM <?php echo $table_prefix?>sph_counter WHERE counter_id=1 ) FROM wp_posts
sql_range_step = 1000

sql_query = select \
p.ID*2+1 as ID, \
0 as comment_ID,\
p.ID as post_ID,\
p.post_title as title, \
p.post_content as body, \
t.name as category, \
IF(p.post_type = ‘post’, 1, 0) as isPost, \
0 as isComment, \
IF(p.post_type = ‘page’, 1, 0) as isPage, \
IF(p.post_type = ‘post’, 0, IF(p.post_type = ‘page’, 1, 2)) as post_type, \
UNIX_TIMESTAMP(post_date) AS date_added \
from \
wp_posts as p \
left join \
wp_term_relationships tr on (p.ID = tr.object_id) \
left join \
wp_term_taxonomy tt on (tt.term_taxonomy_id = tr.term_taxonomy_id and tt.taxonomy = ‘category’) \
left join \
wp_terms t on (tt.term_id = t.term_id) \
where \
p.id>=$start AND p.id<=$end and \
p.post_status = ‘publish’ \
group by p.ID

sql_attr_uint = comment_ID
sql_attr_uint = post_ID
sql_attr_uint = isPost
sql_attr_uint = isPage
sql_attr_uint = isComment
sql_attr_uint = post_type
sql_attr_timestamp = date_added
}

source wp_main_comments
{
type = mysql
sql_host = <?php echo DB_HOST.”\n”?>
sql_user = <?php echo DB_USER.”\n”?>
sql_pass = <?php echo DB_PASSWORD.”\n”?>
sql_db = <?php echo DB_NAME.”\n”?>

sql_port = 3306 # optional, default is 3306
sql_query_pre = SET NAMES utf8
sql_query_pre = REPLACE INTO <?php echo $table_prefix?>sph_counter SELECT 2, MAX(comment_id) FROM wp_comments
sql_query_range = SELECT MIN(comment_id),( SELECT max_doc_id FROM <?php echo $table_prefix?>sph_counter WHERE counter_id=2 ) FROM wp_comments
sql_range_step = 1000

sql_query = select \
c.comment_ID*2 as ID, \
c.comment_ID as comment_ID,\
c.comment_post_ID as post_ID,\
” as title, \
c.comment_content as body, \
” as category, \
0 as isPost, \
1 as isComment, \
0 as isPage, \
2 as post_type, \
UNIX_TIMESTAMP(comment_date) AS date_added \
from \
wp_comments as c \
where \
c.comment_id>=$start AND c.comment_id<=$end and \
c.comment_approved = ‘1’;

sql_attr_uint = comment_ID
sql_attr_uint = post_ID
sql_attr_uint = isPost
sql_attr_uint = isPage
sql_attr_uint = isComment
sql_attr_uint = post_type
sql_attr_timestamp = date_added
}

source wp_delta_posts : wp_main_posts
{
sql_query_range = SELECT ( SELECT max_doc_id FROM <?php echo $table_prefix?>sph_counter where counter_id = 1 ), MAX(id) FROM wp_posts
sql_range_step = 1000
sql_query_pre = SET NAMES utf8

sql_query = select \
p.ID*2+1 as ID, \
0 as comment_ID,\
p.ID as post_ID,\
p.post_title as title, \
p.post_content as body, \
t.name as category, \
IF(p.post_type = ‘post’, 1, 0) as isPost, \
0 as isComment, \
IF(p.post_type = ‘page’, 1, 0) as isPage, \
IF(p.post_type = ‘post’, 0, IF(p.post_type = ‘page’, 1, 2)) as post_type, \
UNIX_TIMESTAMP(post_date) AS date_added \
from \
wp_posts as p \
left join \
wp_term_relationships tr on (p.ID = tr.object_id) \
left join \
wp_term_taxonomy tt on (tt.term_taxonomy_id = tr.term_taxonomy_id and tt.taxonomy = ‘category’) \
left join \
wp_terms t on (tt.term_id = t.term_id) \
where \
p.id>$start AND p.id<=$end and \
p.post_status = ‘publish’ \
group by p.ID ;
}

source wp_delta_comments : wp_main_comments
{
sql_query_range = SELECT ( SELECT max_doc_id FROM <?php echo $table_prefix?>sph_counter where counter_id = 2 ), MAX(comment_id) FROM wp_comments
sql_range_step = 1000
sql_query_pre = SET NAMES utf8

sql_query = select \
c.comment_ID*2 as ID, \
c.comment_ID as comment_ID,\
c.comment_post_ID as post_ID,\
” as title, \
c.comment_content as body, \
” as category, \
0 as isPost, \
1 as isComment, \
0 as isPage, \
2 as post_type, \
UNIX_TIMESTAMP(comment_date) AS date_added \
from \
wp_comments as c \
where \
c.comment_id>$start AND c.comment_id<=$end and \
c.comment_approved = ‘1’;
}

index wp_main
{
source = wp_main_posts
source = wp_main_comments
path = /home/archives/public_html/wp-content/uploads/sphinx/var/data/wp_main
docinfo = extern
morphology = stem_enru
html_strip = 1
charset_type = utf-8
charset_table = 0..9,U+41..U+5a->U+61..U+7a, U+61..U+7a, U+aa, U+b5, U+ba, U+c0..U+d6->U+e0..U+f6, U+d8..U+de->U+f8..U+fe, U+df..U+f6, U+f8..U+ff, U+100..U+12f/2, U+130->U+69, U+131, U+132..U+137/2, U+138, U+139..U+148/2, U+149, U+14a..U+177/2, U+178->U+ff, U+179..U+17e/2, U+17f..U+180, U+181->U+253, U+182..U+185/2, U+186->U+254, U+187..U+188/2, U+189..U+18a->U+256..U+257, U+18b..U+18c/2, U+18d, U+18e->U+1dd, U+18f->U+259, U+190->U+25b, U+191..U+192/2, U+193->U+260, U+194->U+263, U+195, U+196->U+269, U+197->U+268, U+198..U+199/2, U+19a..U+19b, U+19c->U+26f, U+19d->U+272, U+19e, U+19f->U+275, U+1a0..U+1a5/2, U+1a6->U+280, U+1a7..U+1a8/2, U+1a9->U+283, U+1aa..U+1ab, U+1ac..U+1ad/2, U+1ae->U+288, U+1af..U+1b0/2, U+1b1..U+1b2->U+28a..U+28b, U+1b3..U+1b6/2, U+1b7->U+292, U+1b8..U+1b9/2, U+1ba..U+1bb, U+1bc..U+1bd/2, U+1be..U+1c3, U+1c4->U+1c6, U+1c5..U+1c6/2, U+1c7->U+1c9, U+1c8..U+1c9/2, U+1ca->U+1cc, U+1cb..U+1dc/2, U+1dd, U+1de..U+1ef/2, U+1f0, U+1f1->U+1f3, U+1f2..U+1f5/2, U+1f6->U+195, U+1f7->U+1bf, U+1f8..U+21f/2, U+220->U+19e, U+221, U+222..U+233/2, U+234..U+23a, U+23b..U+23c/2, U+23d->U+19a, U+23e..U+240, U+241->U+294, U+250..U+2c1, U+2c6..U+2d1, U+2e0..U+2e4, U+2ee, U+37a, U+386..U+389->U+3ac..U+3af, U+38c..U+38e->U+3cc..U+3ce, U+390, U+391..U+3a1->U+3b1..U+3c1, U+3a3..U+3ab->U+3c3..U+3cb, U+3ac..U+3ce, U+3d0..U+3d7, U+3d8..U+3ef/2, U+3f0..U+3f3, U+3f4->U+3b8, U+3f5, U+3f7..U+3f8/2, U+3f9->U+3f2, U+3fa..U+3fb/2, U+3fc..U+3ff, U+400..U+40f->U+450..U+45f, U+410..U+42f->U+430..U+44f, U+430..U+45f, U+460..U+481/2, U+48a..U+4bf/2, U+4c0, U+4c1..U+4ce/2, U+4d0..U+4f9/2, U+500..U+50f/2, U+531..U+556->U+561..U+586, U+559, U+561..U+587, U+5d0..U+5ea, U+5f0..U+5f2, U+621..U+63a, U+640..U+64a, U+66e..U+66f, U+671..U+6d3, U+6d5, U+6e5..U+6e6, U+6ee..U+6ef, U+6fa..U+6fc, U+6ff, U+e01..U+e30, U+e32..U+e33, U+e40..U+e46, U+e81..U+e82, U+e84, U+e87..U+e88, U+e8a, U+e8d, U+e94..U+e97, U+e99..U+e9f, U+ea1..U+ea3, U+ea5, U+ea7, U+eaa..U+eab, U+ead..U+eb0, U+eb2..U+eb3, U+ebd, U+ec0..U+ec4, U+ec6, U+edc..U+edd, U+1000..U+1021, U+1023..U+1027, U+1029..U+102a, U+1050..U+1055, U+10a0..U+10c5->U+2d00..U+2d25, U+10d0..U+10fa, U+10fc, U+2d00..U+2d25, U+1d00..U+1dbf, U+1e00..U+1e95/2, U+1e96..U+1e9b, U+1ea0..U+1ef9/2, U+3005..U+3006, U+3031..U+3035, U+303b..U+303c, U+3041..U+3096, U+309d..U+309f, U+30a1..U+30fa, U+30fc..U+30ff, U+31f0..U+31ff

}

index wp_delta : wp_main
{
source = wp_delta_posts
source = wp_delta_comments
path = /home/archives/public_html/wp-content/uploads/sphinx/var/data/wp_delta
}

index wp_
{
type = distributed
local = wp_main
local = wp_delta
}

indexer
{
mem_limit = 32M
}

searchd
{
port = 9312
read_timeout = 5
max_children = 30
pid_file = /home/archives/public_html/wp-content/uploads/sphinx/var/log/searchd.pid
max_matches = 1000
log = /home/archives/public_html/wp-content/uploads/sphinx/var/log/searchd.log
query_log = /home/archives/public_html/wp-content/uploads/sphinx/var/log/query.log
}

# –eof–

sasad
check what ever you haven’t any white spaces before this line:
#!/usr/bin/php
This line should be the first line starting from the first position of the sphinx.conf file.
The same check for this line:
<?php
it should be start from beginning of the second line, no white spaces before it.

It seems I figured out the what happened,
you has CGI version of php, by default it show the http headers like those:
X-Powered-By: PHP/4.3.6
Content-type: text/html

To prevent this, PHP needs to be invoked with the ‘-q’ option for ‘quiet’, it is the first option:
#!/usr/bin/php -q

Or you may specify path to the command line version of PHP, it may be located at:
/usr/bin/php-cli
So, the second option is to change path in the configuration to:
#!/usr/bin/php-cli

It seems I figured out the what happened,

I specified the -q option in the sphinx.conf file but now i get following error

root@archive [/home/archives/public_html/wp-content/uploads/sphinx/bin]# ./searchd
Sphinx 0.9.9-release (r2117)
Copyright (c) 2001-2009, Andrew Aksyonoff

using config file ‘/home/archives/public_html/wp-content/uploads/sphinx/etc/sphinx.conf’…
listening on all interfaces, port=9312
WARNING: index ‘wp_main’: preload: failed to open /home/archives/public_html/wp-content/uploads/sphinx/var/data/wp_main.sph: No such file or directory; NOT SERVING
WARNING: index ‘wp_delta’: preload: failed to open /home/archives/public_html/wp-content/uploads/sphinx/var/data/wp_delta.sph: No such file or directory; NOT SERVING
root@archive [/home/archives/public_html/wp-content/uploads/sphinx/bin]#

It is not the error, it is warnings that said you haven’t indexes to serve.
You need to build them…

You may do it from WP Sphinx admin panel or manually.

I suggest to try from WP Sphinx admin panel (Re-index WordPress index).

Or use this command:
./indexer ../etc/sphinx.conf –all –rotate

Use –rotate if searchd already running.
Use –all to rebuild all indexes.