I get a collection of reports from Sphinx with the follow query:
@reports = Report.search params[:q], :match_mode => :extended, :page => params[:page], :per_page => 50
which works fine in development with Thinking Sphinx, but on Heroku with Flying Sphinx Wooden and a shared database, I get a 500 on the view for this action with the following error in the logs:
ActionView::TemplateError (searchd error (status: 1): invalid client key '') on line #3 of app/views/reports/search.html.erb:
line #3 is simply:
<%= will_paginate @reports -%>
I'm not finding 'invalid client key' referenced as a Sphinx error anywhere, and I'm wondering if this is a problem with the configuration of my Heroku account or its connection to Flying Sphinx.
Any insights? Thanks.
Brian
#1 Posted by Pat Allan Support staff on 03 Aug, 2011 12:57 AM
Hi Brian
What versions of Thinking Sphinx and Riddle are you using? The client key setting is something I've patched onto Sphinx to ensure connections are secure (as otherwise it's just an open port for anyone to connect to), and recent versions of Thinking Sphinx/Riddle cover this.
Pat
#2 Posted by Brian Jones on 03 Aug, 2011 01:20 AM
That was the problem. Thanks, Pat. I upgrade to thinking-sphinx 1.4.5 and it works.
Thanks for the quick response; sorry it was just a case of my not following directions.
Best,
Brian
>
#3 Posted by Pat Allan Support staff on 03 Aug, 2011 01:22 AM
No worries, good to know it's all working now :)
Pat Allan closed this discussion on 03 Aug, 2011 01:22 AM.