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 Posted by Pat Allan Support staff 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.ymlfor 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 runrebuildorconfigure, 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