I'm having a hard time trying to set up a working thinking-sphinx 
configuration.

My setup:

   - Win 7
   - Rails: 3.2.13
   - MySql: 5.5.32
   - Ruby:1.9.3
   - Sphinx:2.0.8
   - thinking_sphinx:3.0.4
   - mysql2: 0.3.12b5

I must say there was hardly no info on how to get started with 
thinking_sphinx.
After adding the gem, and googling a lot, I added a 
config/thinking_sphinx.yml and put this onto it:

development:
  host: localhost
  port: 9306
  bin_path: F:\sw\sphinx-2.0.8-release-win32\bin
  searchd_binary_name: searchd
  indexer_binary_name: indexer

Notice it says port, and not mysql41 as it is explained in thinking_sphinx.

The app/indices part was documented well and I created this folder and 
added a model_index.rb file as explained.

After this, I run:
rake ts:index

and if successfully indexed my model entities and created a 
development.sphinx.conf file:

Generating configuration to 
E:/home/my_project/config/development.sphinx.conf
Sphinx 2.0.8-release (r3831)
Copyright (c) 2001-2012, Andrew Aksyonoff
Copyright (c) 2008-2012, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file 
'E:/home/my_project/rails/music_collect/config/development.sphinx.conf'...
WARNING: key 'address' is deprecated in 
E:/home/my_project/config/development.sphinx.conf line 7; use 'listen' 
instead.
indexing index 'mymodel_core'...
collected 1000 docs, 0.0 MB
sorted 0.0 Mhits, 100.0% done
total 1000 docs, 17768 bytes
total 0.037 sec, 470003 bytes/sec, 26452.22 docs/sec
total 2 reads, 0.000 sec, 21.4 kb/call avg, 0.0 msec/call avg
total 9 writes, 0.000 sec, 11.5 kb/call avg, 0.0 msec/call avg
rotating indices: successfully sent SIGHUP to searchd (pid=7456).

However, when I call MyModel.search in my controller, I get this error:

Mysql2::Error at /mymodels

Lost connection to MySQL server at 'reading initial communication packet', 
system error: 0

It works fine if I do a MyModel.all , which directly talks to MySql backend.

Any help would be appreciated.

-- 
You received this message because you are subscribed to the Google Groups 
"Thinking Sphinx" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/thinking-sphinx.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to