Installed sphinxsearch -> configured the config -> created the forum_index index via indexer --all . Records have been indexed all without errors. Connected to the project SphinxQL . I set the parameters and make a request according to the example in ReadMe :

 // create a SphinxQL Connection object to use with SphinxQL $conn = new Connection(); $conn->setParams(array('host' => 'localhost', 'port' => 9306)); 

But suddenly there was an error like

access denied www-data @ localhost password NO

Explicitly indicated the user and password within the location of the call

 mysqli::real_connect() 

Passing the host, username, etc. parameters to it. connected to the database. Now when you run the query:

 $query = SphinxQL::create($conn)->select('column_one', 'colume_two') ->from('forum_index'); $result = $query->execute(); 

and in response to an error

table forum_index does not exist

Tell me which way you can dig? It feels like just the lib does not use the sphinx config and doesn’t interact at all with the sphinx.

    1 answer 1

    Solved the problem by specifying the explicit address 127.0.0.1 as the host in the SphinxQL config