You shouldn't need to manually set a port to get things started - but if you
are, you must use mysql41 with the 3.x releases of Thinking Sphinx, *not* port.
So:
development:
mysql41: 9306 # this is the default anyway!
bin_path: F:\sw\sphinx-2.0.8-release-win32\bin
You were using the default binary names and host, so there's no need to set
them.
Also: you need to run the ts:start rake task to get the Sphinx daemon running.
On 12/07/2013, at 3:28 AM, J. Garcia wrote:
> 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.
>
>
--
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.
