CODEWITHSUNDEEP
mysqlruby-on-railsrubyruby-on-rails-3thinking-sphinx
spitfire109
spitfire109

Reputation: 10039

Trouble connecting to Sphinx MySQL in development

I have Thinking Sphinx installed in my Rails app. Everything works fine in Heroku, but locally I cannot get anything up and running.

When I try to run rake ts:index, I get

sh: indexer: command not found

When I try to use the search function in the app I get

Error connecting to Sphinx via the MySQL protocol. Error connecting to Sphinx via the MySQL protocol. Can't connect to MySQL server on '127.0.0.1' (61) - SELECT * FROM `book_core` WHERE MATCH('economics') AND `sphinx_deleted` = 0 LIMIT 0, 20 OPTION field_weights=(title=16,author=7); SHOW META

Thanks for the help!

Upvotes: 2

Views: 537

Answers (1)

pat
pat

Reputation: 16226

It sounds like you don't have Sphinx itself installed:

http://pat.github.io/thinking-sphinx/installing_sphinx.html

If you do have it installed but it's still not picking things up, then perhaps the executables are not in your PATH environment variable?

Upvotes: 2

Related Questions