We're having a cluster of app machines with one db-server. After trying different setups, for us, the most stable setup is putting the sphinx searchd and indexer on the db machine. Then on all machines you checkout the exact copies of your rails project. The app servers need the code-base off course to host the app, but the db/sphinx machine needs it to generate the production.sphinx.conf. Then comes the sphinx.yml. There is a twist: you need to supply an address; for the application this is the address where it can find the searchd, but this same address is also used by the searchd as where to listen on the specific port.
Maybe thats what is missing. Regards, SO On Feb 6, 1:52 pm, Voldy Jeengle <[email protected]> wrote: > I just had the same error and sphinx and application are on the same > machine. Interesting that before today everything worked pretty nice. > Unfortunately I couldn't catch what changed. But the problem have gone > after I upgraded thinking sphinx from version 1.3.14 installed as a > plug-in to version 1.3.15 installed as a gem. > > On Feb 5, 9:58 pm, Canvas <[email protected]> wrote: > > > > > Hi there guys, > > > I have some problem in configuring so that searchd and indexer are in > > one box and rails app is on another. My configuration is as following: > > > 1. dev_sphinx: sphinx server where searchd and indexer are running: > > > sphinx.yml development section: > > port: 9312 > > mem_limit: 64M > > > # enable wildcard searching > > allow_star: 1 > > min_infix_len: 2 > > > bin_path: "/usr/local/bin" > > pid_file: "/workspace/my_app/tmp/pids/searchd.development.pid" > > searchd_file_path: "/workspace/index/my_app/development" > > > I then ran the following rake tasks to build index and start searchd: > > > rake thinking_sphinx:configure RAILS_ENV=development > > rake thinking_sphinx:index RAILS_ENV=development > > rake thinking_sphinx:start RAILS_ENV=development > > > 2. dev_rails: Rails Server > > > sphinx.yml development section: > > address: dev_sphinx > > port: 9312 > > > But when I search, I got the following error: > > > Riddle::ConnectionError (Connection to dev_sphinx on 9312 failed. > > Connection refused - connect(2)): > > vendor/plugins/thinking-sphinx/rails/./vendor/riddle/lib/riddle/ > > client.rb:516:in `initialise_socket' > > vendor/plugins/thinking-sphinx/rails/./vendor/riddle/lib/riddle/ > > 0.9.9/client.rb:8:in `initialise_connection' > > vendor/plugins/thinking-sphinx/rails/./vendor/riddle/lib/riddle/ > > client.rb:452:in `open_socket' > > vendor/plugins/thinking-sphinx/rails/./vendor/riddle/lib/riddle/ > > client.rb:479:in `connect' > > vendor/plugins/thinking-sphinx/rails/./vendor/riddle/lib/riddle/ > > client.rb:535:in `request' > > vendor/plugins/thinking-sphinx/rails/./vendor/riddle/lib/riddle/ > > client.rb:203:in `run' > > vendor/plugins/thinking-sphinx/rails/./vendor/riddle/lib/riddle/ > > client.rb:310:in `query' > > app/controllers/file_list_controller.rb:408:in `get_project_files' > > -e:2:in `load' > > -e:2 > > > Any advice will be appreciated. Thank you very much. > > > Best wishes, > > > Canvas -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
