Making Sphinx respect permissions

hbf

i disabled, overwrote the contents of the plugin directory, re-enabled, then walked through the installation using existing binaries process again.

I've actually done it a couple times now and to no avail.

hbf

in runsearch function,

$Results = $this->SphinxClient->RunQueries();

returns nothing. i've printed the Queries and that looks as expected i believe. the $Results object prints nothing.

hbf

well, im at a loss. i removed the category permission filter for the main and it still didn't return anything.

next i assumed that the indexer just wasn't getting data so i checked the doc count. it is indeed 0 on the main. i manually ran the command

:/var/run$ /usr/bin/indexer vss_main --rotate --config /etc/sphinxsearch/sphinx.conf
Sphinx 2.0.4-release (r3135)
Copyright (c) 2001-2012, Andrew Aksyonoff
Copyright (c) 2008-2012, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file '/etc/sphinxsearch/sphinx.conf'...
WARNING: failed to open pid_file '/var/run/sphinxsearch/searchd.pid'.
indexing index 'vss_main'...
collected 179319 docs, 32.2 MB
collected 1950 attr values
sorted 0.0 Mvalues, 100.0% done
sorted 5.6 Mhits, 100.0% done
total 179319 docs, 32187485 bytes
total 6.829 sec, 4712758 bytes/sec, 26255.14 docs/sec
total 1629 reads, 0.035 sec, 15.3 kb/call avg, 0.0 msec/call avg
total 58 writes, 0.139 sec, 964.3 kb/call avg, 2.3 msec/call avg
WARNING: indices NOT rotated.

so it's connecting and pulling docs. I don't get it.

so now i'm turning of sphinx for today. really bummed, but rolling back isn't an option, i can't have related thread widgets pulling excerpts from closed portions of the forum.

mcu_hq

WARNING: failed to open pid_file '/var/run/sphinxsearch/searchd.pid'. indexing index 'vss_main

O yea, I should probably mention that if you ever get this, this means that you most likely upgraded the plugin and forgot to disable it first.

You can try the "not-so-elegant" solution by rebooting your server so that there is only one instance sphinx running. Or you can do some ps ax and see what user searchd is being run under and then stop it. This is what I do: killall -9 searchd

edit: I just download the latest after uninstalling my current installation and the did a reboot. After the reboot, I FTP'd over the files and went through the install again. I don't see any problems after those steps were followed.

hbf

searchd is not running, i killed it, therefore there is no searchd.pid file.

mcu_hq

Try:

/usr/bin/searchd --config /etc/sphinxsearch/sphinx.conf

That should try to turn on searchd. You need searchd to be on before indexes are rotated.

hbf

as expected it succeeds with indexing and rotating the indices

/usr/bin/indexer vss_main --rotate --config /etc/sphinxsearch/sphinx.conf
Sphinx 2.0.4-release (r3135)
Copyright (c) 2001-2012, Andrew Aksyonoff
Copyright (c) 2008-2012, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file '/etc/sphinxsearch/sphinx.conf'...
indexing index 'vss_main'...
collected 179594 docs, 32.2 MB
collected 1950 attr values
sorted 0.0 Mvalues, 100.0% done
sorted 5.6 Mhits, 100.0% done
total 179594 docs, 32229888 bytes
total 6.748 sec, 4775603 bytes/sec, 26611.00 docs/sec
total 1629 reads, 0.031 sec, 15.4 kb/call avg, 0.0 msec/call avg
total 58 writes, 0.123 sec, 965.7 kb/call avg, 2.1 msec/call avg
rotating indices: succesfully sent SIGHUP to searchd (pid=11372).

the search results still return nothing on even the simplest of searches "beer"

mcu_hq

Try this from the command line: killall -9 searchd

Then, in the sphinxsearch dashboard, enable Searchd and try indexing your docs and the search normally.

hbf

this is the print_r result of the queries going into SphinxClient->RunQueries()

Array ( [0] => Array ( [Name] => MainSearch [Index] => 0 ) [1] => Array ( [Name] => RelatedMainThreads [Index] => 1 ) [2] => Array ( [Name] => RelatedSearches [Index] => 2 ) )

hbf

@mcu_hq said:
Try this from the command line: killall -9 searchd

Then, in the sphinxsearch dashboard, enable Searchd and try indexing your docs and the search normally.

I'm certain that i just started the searchd via dashboard from a clean slate (no processes running). but in the interest of completeness, im going to do it again.

I'm going to Stop Searchd from the dashboard
run killall -9 searchd as root in the shell
then restart searchd via dashboard
then reindex each of the indices via dashboard (i will post the console results)

hbf

searchd: no process found

hbf

the little console window apparently can not be copied, but it show successful index and rotation

hbf

still getting the same result

hbf

does that print_r look right for the queries going into runqueries?

mcu_hq

@hbf said:
does that print_r look right for the queries going into runqueries?

Yes. Queries are being run - that looks correct.

If you uncomment this line here, what is printed?

Does the dashboard say that searchd is running?

hbf

the line i posted is the results of that line being uncommented with the following tweaks

print_r($this->Queries);//die;
$Results = $this->SphinxClient->RunQueries(); //perform all of the queries
echo "Results";
print_r($Results);// die;
echo "end results";

there is nothing between Results and end results.

you can see this print at the top of the page if you click here:

http://homebrewforums.net/search?Search=brew+log

hbf

and yes, the dashboard says searchd is running.

mcu_hq

Can you add this logic after sphinx runs queries:

if ( $Results === false ) { echo "Query failed: " . $this->SphinxClient->GetLastError() . ".\n"; } else { if ( $this->SphinxClient->GetLastWarning() ) { echo "WARNING: " . $this->SphinxClient->GetLastWarning() . ""; }

hbf

ahh... we have found it.

hbf

i have a separate DB server and Webserver, Sphinx is running on the web server.

Query failed: connection to HBF-SQL-1:9312 failed (errno=111, msg=Connection refused).

so when i reinstalled, i specified my DB server name in the inatallation wizard, which made it so i didn't have to manually modify the config file, but apparently it now think that sphinx server is running on my DB host?