StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to Install Sphinx on LINUX(ubuntu)
text
Body
copied!<p>This is Raja, I'm using PHP for my web development. Recently i was supposed to install "Sphinx" search into my application with LINUX as OS.</p> <p>I've followed the instruction given in this website </p> <p><a href="http://www.howtoforge.com/how-to-install-sphinx-on-ubuntu-10.10" rel="nofollow">http://www.howtoforge.com/how-to-install-sphinx-on-ubuntu-10.10 </a></p> <p>to install sphinx in LINUX(Ubuntu) OS and I've tested the application in the terminal, i got the results like this</p> <pre><code>root@dev2:/# search "test" Sphinx 0.9.9-release (r2117) Copyright (c) 2001-2009, Andrew Aksyonoff using config file '/etc/sphinxsearch/sphinx.conf'... index 'test1': query 'test ': returned 3 matches of 3 total in 0.000 sec displaying matches: 1. document=1, weight=2, group_id=1, date_added=Thu Jan 5 18:18:55 2012 id=1 group_id=1 group_id2=5 date_added=2012-01-05 18:18:55 title=test one content=this is my test document number one. also checking search within phrases. 2. document=2, weight=2, group_id=1, date_added=Thu Jan 5 18:18:55 2012 id=2 group_id=1 group_id2=6 date_added=2012-01-05 18:18:55 title=test two content=this is my test document number two 3. document=4, weight=1, group_id=2, date_added=Thu Jan 5 18:18:55 2012 id=4 group_id=2 group_id2=8 date_added=2012-01-05 18:18:55 title=doc number four content=this is to test groups words: 1. 'test': 3 documents, 5 hits </code></pre> <p>The Problem is that, I've created the directory in the location "/var/www/sphinx_search", which contains sphinx.conf, sphinxapi.php and test.php files. </p> <p>the code behind sphinx.conf is</p> <pre><code>source src1 { type = mysql sql_host = localhost sql_user = user sql_pass = pwd sql_db = test sql_port = 3306 # optional, default is 3306 sql_query = \ SELECT id, group_id, UNIX_TIMESTAMP(date_added) AS date_added, title, content \ FROM documents sql_attr_uint = group_id sql_attr_timestamp = date_added sql_query_info = SELECT * FROM documents WHERE id=$id } index test1 { source = src1 path = /var/lib/sphinxsearch/data/test1 docinfo = extern charset_type = sbcs } indexer { mem_limit = 32M } searchd { port = 9312 log = /var/log/sphinxsearch/searchd.log query_log = /var/log/sphinxsearch/query.log read_timeout = 5 max_children = 30 pid_file = /var/run/searchd.pid max_matches = 1000 seamless_rotate = 1 preopen_indexes = 0 unlink_old = 1 } </code></pre> <p>and the code behind test.php is</p> <pre><code>require_once('sphinxapi.php'); //require_once('api/sphinxapi.php'); $s = new SphinxClient; $s->setServer("123.123.123.123", 9312); // NOT "localhost" under Windows 7! $s->setMatchMode(SPH_MATCH_EXTENDED2); $result = $s->Query("group"); echo '<pre>';print_r($result); </code></pre> <p>when i'm trying to run this application in browser (http://localhost/Raja/search_engine/sphinx/) this error is getting displayed.</p> <pre><code>{"status":"failed","status_message":"connection to localhost:9312 failed (errno=10060, msg=A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)"} </code></pre> <p>As i'm new to Sphinx, i cant get it right away. Can anybody help me to proceed further.</p> <p>Curiously looking for a solution earlier,</p> <p>Thanks in Advance, Raja.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload