Databases
StackOverflow2013
Postsdbo
POCan't connect to MySQL server on '127.0.0.1' (61) rails thinking_sphinx
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCan't connect to MySQL server on '127.0.0.1' (61) rails thinking_sphinx
    text
    copied!<p>I was upgrading from thinking_sphinx ~2.5 to 3.0.3 to follow the setup instructions for the heroku add-on flying_sphinx. The upgrade might not be necessary at all, but now I'm at it so might as well get it done.</p> <p>When I try to search (e.g. Post.search("search term")) I get the following:</p> <pre><code>Can't connect to MySQL server on '127.0.0.1' (61) </code></pre> <p>I have my indices folder setup with the post_index.rb</p> <pre><code>ThinkingSphinx::Index.define :post, :with =&gt; :active_record do (. . . code here . . .) end </code></pre> <p>and I have my config/thinking_sphinx.yml file</p> <pre><code>development: version: 3.0.3 mysql41: 9110 morphology: stem_en html_strip: 1 min_infix_len: 2 bin_path: "/usr/local/bin" searchd_binary_name: searchd indexer_binary_name: indexer host: 127.0.0.1 test: version: 3.0.3 mysql41: 9110 morphology: stem_en html_strip: 1 min_infix_len: 2 production: version: 3.0.3 mysql41: 9110 morphology: stem_en html_strip: 1 min_infix_len: 2 </code></pre> <p>and Gemfile</p> <pre><code>gem 'mysql2', '0.3.12b5' gem 'thinking-sphinx', '3.0.3' #'2.0.11' gem 'flying-sphinx', '1.0.0' #'0.8.4' </code></pre> <p>I am running postgres locally and on heroku</p> <p>Thanks!</p> <h1>Edit</h1> <p>Now my thinking_sphinx.yml looks like this:</p> <pre><code>development: mysql41: 9110 morphology: stem_en html_strip: 1 min_infix_len: 2 bin_path: "/usr/local/bin" host: 127.0.0.1 test: mysql41: 9111 morphology: stem_en html_strip: 1 min_infix_len: 2 production: morphology: stem_en html_strip: 1 min_infix_len: 2 </code></pre> <p>When I tried to searchd is not currently running.</p> <pre><code>Stopped searchd daemon (pid: ). Generating configuration to /Users/Achilles/Desktop/dev/mocs/config/development.sphinx.conf Sphinx 2.0.6-release (r3473) Copyright (c) 2001-2012, Andrew Aksyonoff Copyright (c) 2008-2012, Sphinx Technologies Inc (http://sphinxsearch.com) using config file '/blah/blah/blah/development.sphinx.conf'... indexing index 'post_core'... ERROR: index 'post_core': infixes and morphology are enabled, enable_star=0 total 0 reads, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg total 0 writes, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg Failed to start searchd daemon. Check /Users/Achilles/Desktop/dev/mocs/log/development.searchd.log. Failed to start searchd. Check the log files for more information. </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload