tag:support.flying-sphinx.com,2011-01-05:/discussions/problems/2037-no-erros-but-search-is-not-working-on-herokuFlying Sphinx: Discussion 2016-04-14T10:03:32Ztag:support.flying-sphinx.com,2011-01-05:Comment/384758792015-11-16T19:28:17Z2016-04-14T10:03:32ZNo erros, but search is not working on Heroku<div><p>Hello,</p>
<p>I've been trying to get Sphinx to run on Heroku since a few days
to no avail.<br>
<code>heroku run bundle exec flying-sphinx configure</code> gives
no error messages <code>heroku run bundle exec flying-sphinx
index</code> runs perfectly fine <code>heroku run bundle exec
flying-sphinx start</code> runs fine too</p>
<p>Here is my current stack:<br>
Heroku (swapmywatch.herokuapp.com)<br>
Sharetribe CMS (Ruby 2.1.2 & Rails 3.2.21)<br>
ClearDB<br>
thinking-sphinx 3.1.3<br>
flying-sphinx 1.2.0</p>
<p>Let me know if you guys need more info from me. Thanks in
advance for any help!</p></div>jevin9tag:support.flying-sphinx.com,2011-01-05:Comment/384758792015-11-16T23:18:57Z2015-11-16T23:18:57ZNo erros, but search is not working on Heroku<div><p>Hi Jevin</p>
<p>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.</p>
<p>The relevant Sphinx settings for MySQL and SSL are listed
here:<br>
<a href="http://sphinxsearch.com/docs/current.html#conf-mysql-ssl">http://sphinxsearch.com/docs/current.html#conf-mysql-ssl</a></p>
<p>If you set these in <code>config/thinking_sphinx.yml</code> 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 <code>rebuild</code> or
<code>configure</code>, those settings will be pushed up to the
Flying Sphinx servers, and indexing should work after that.</p>
<p>If anything's not clear with this, or a new issue appears, do
let me know.</p>
<p>Kind regards,</p>
<p>Pat</p></div>Pat Allan