Home → Problems →

No erros, but search is not working on Heroku

• Edit

jevin9

16 Nov, 2015 07:28 PM

Hello,

I've been trying to get Sphinx to run on Heroku since a few days to no avail.
heroku run bundle exec flying-sphinx configure gives no error messages heroku run bundle exec flying-sphinx index runs perfectly fine heroku run bundle exec flying-sphinx start runs fine too

Here is my current stack:
Heroku (swapmywatch.herokuapp.com)
Sharetribe CMS (Ruby 2.1.2 & Rails 3.2.21)
ClearDB
thinking-sphinx 3.1.3
flying-sphinx 1.2.0

Let me know if you guys need more info from me. Thanks in advance for any help!

1. Support Staff 1 Posted by Pat Allan on 16 Nov, 2015 11:18 PM

   

   Hi Jevin

   Indexing is running, but it's raising errors (which should be visible when you run it) because ClearDB uses SSL for the database connections, and you'll need to configure your Sphinx installation with that certificate too.

   The relevant Sphinx settings for MySQL and SSL are listed here:
   http://sphinxsearch.com/docs/current.html#conf-mysql-ssl

   If you set these in config/thinking_sphinx.yml for the correct environment (each refer to a file), and then deploy that change with the appropriate files (which will need to be within your repo, referred to via relative paths from your project root), the next time you run rebuild or configure, those settings will be pushed up to the Flying Sphinx servers, and indexing should work after that.

   If anything's not clear with this, or a new issue appears, do let me know.

   Kind regards,

   Pat

   • Edit