With mysql41: 9306 in thinking_sphinx.yml: > rake ts:index --trace ** Invoke ts:index (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute ts:index Generating configuration to E:/home/myproject/config/development.sphinx.conf rake aborted! Riddle::Configuration::ConfigurationError C:/Ruby193/lib/ruby/gems/1.9.1/gems/riddle-1.5.7/lib/riddle/configuration/searchd.rb:24:in `render' C:/Ruby193/lib/ruby/gems/1.9.1/gems/riddle-1.5.7/lib/riddle/configuration.rb:37:in `render' C:/Ruby193/lib/ruby/gems/1.9.1/gems/thinking-sphinx-3.0.4/lib/thinking_sphinx/configuration.rb:84:in `render' C:/Ruby193/lib/ruby/gems/1.9.1/gems/thinking-sphinx-3.0.4/lib/thinking_sphinx/configuration.rb:90:in `block in render_to_file' C:/Ruby193/lib/ruby/1.9.1/open-uri.rb:35:in `open' C:/Ruby193/lib/ruby/1.9.1/open-uri.rb:35:in `open' ...
If I just delete the 9306 line, the same error. If I revert it back to port: 9306, it works well: E:\home\elektrik\proyectos\rails\music_collect>rake ts:index --trace ** Invoke ts:index (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute ts:index Generating configuration to E:/home/myproject/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/myproject/config/development.sphinx.conf'... WARNING: key 'address' is deprecated in E:/home/myproject/config/development.sphinx.conf line 7; use 'listen' instead. indexing index 'brand_core'... collected 1000 docs, 0.0 MB sorted 0.0 Mhits, 100.0% done total 1000 docs, 17768 bytes total 0.093 sec, 189041 bytes/sec, 10639.42 docs/sec total 2 reads, 0.000 sec, 21.4 kb/call avg, 0.0 msec/call avg total 9 writes, 0.001 sec, 11.5 kb/call avg, 0.1 msec/call avg Also, the ts:start produces this log in development.searchd.log file: [Fri Jul 12 14:50:18.387 2013] [ 2768] listening on 127.0.0.1:9306 [Fri Jul 12 14:50:18.391 2013] [ 2768] binlog: replaying log E:/home/elektrik/proyectos/rails/music_collect/tmp/binlog/development/binlog.001 [Fri Jul 12 14:50:18.391 2013] [ 2768] binlog: replay stats: 0 rows in 0 commits; 0 updates; 0 indexes [Fri Jul 12 14:50:18.391 2013] [ 2768] binlog: finished replaying E:/home/myproject/tmp/binlog/development/binlog.001; 0.0 MB in 0.000 sec [Fri Jul 12 14:50:18.391 2013] [ 2768] binlog: replaying log E:/home/myproject/tmp/binlog/development/binlog.002 [Fri Jul 12 14:50:18.391 2013] [ 2768] binlog: replay stats: 0 rows in 0 commits; 0 updates; 0 indexes [Fri Jul 12 14:50:18.391 2013] [ 2768] binlog: finished replaying E:/home/myproject/tmp/binlog/development/binlog.002; 0.0 MB in 0.000 sec [Fri Jul 12 14:50:18.391 2013] [ 2768] binlog: replaying log E:/home/myproject/tmp/binlog/development/binlog.003 [Fri Jul 12 14:50:18.392 2013] [ 2768] binlog: replay stats: 0 rows in 0 commits; 0 updates; 0 indexes [Fri Jul 12 14:50:18.392 2013] [ 2768] binlog: finished replaying E:/home/myproject/tmp/binlog/development/binlog.003; 0.0 MB in 0.000 sec [Fri Jul 12 14:50:18.392 2013] [ 2768] binlog: replaying log E:/home/myproject/tmp/binlog/development/binlog.004 [Fri Jul 12 14:50:18.392 2013] [ 2768] binlog: replay stats: 0 rows in 0 commits; 0 updates; 0 indexes [Fri Jul 12 14:50:18.392 2013] [ 2768] binlog: finished replaying E:/home/myproject/tmp/binlog/development/binlog.004; 0.0 MB in 0.000 sec [Fri Jul 12 14:50:18.392 2013] [ 2768] binlog: replaying log E:/home/myproject/tmp/binlog/development/binlog.005 [Fri Jul 12 14:50:18.392 2013] [ 2768] binlog: replay stats: 0 rows in 0 commits; 0 updates; 0 indexes [Fri Jul 12 14:50:18.392 2013] [ 2768] binlog: finished replaying E:/home/myproject/tmp/binlog/development/binlog.005; 0.0 MB in 0.000 sec [Fri Jul 12 14:50:18.392 2013] [ 2768] binlog: finished replaying total 5 in 0.001 sec [Fri Jul 12 14:50:18.394 2013] [ 2768] accepting connections On Thursday, July 11, 2013 7:28:27 PM UTC+2, 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.
