Hi, I am in the process of deploying my app on a production and successfully installed sphinx and thinking sphinx, but I am getting "Access denied for user 'root'@'localhost' (using password: NO)" when I try to index (rake thinking_sphinx:index).
Production server info: Ubuntu 9.04, using mysql, phusion passenger My dev machine has a similar setup, with the only difference being there is no db password for the dev setup while there is on the production. Here is production.log ... ThinkingSphinx::ConnectionError (Connection to Sphinx Daemon (searchd) failed.): app/controllers/users_controller.rb:57:in `index' passenger (2.2.4) lib/phusion_passenger/rack/request_handler.rb: 91:in `process_request' passenger (2.2.4) lib/phusion_passenger/abstract_request_handler.rb: 206:in `main_loop' passenger (2.2.4) lib/phusion_passenger/railz/application_spawner.rb: 376:in `start_request_handler' passenger (2.2.4) lib/phusion_passenger/railz/application_spawner.rb: 334:in `handle_spawn_application' passenger (2.2.4) lib/phusion_passenger/utils.rb:182:in `safe_fork' passenger (2.2.4) lib/phusion_passenger/railz/application_spawner.rb: 332:in `handle_spawn_application' passenger (2.2.4) lib/phusion_passenger/abstract_server.rb:351:in `__send__' passenger (2.2.4) lib/phusion_passenger/abstract_server.rb:351:in `main_loop' passenger (2.2.4) lib/phusion_passenger/abstract_server.rb:195:in `start_synchronously' passenger (2.2.4) lib/phusion_passenger/abstract_server.rb:162:in `start' passenger (2.2.4) lib/phusion_passenger/railz/application_spawner.rb: 213:in `start' passenger (2.2.4) lib/phusion_passenger/spawn_manager.rb:261:in `spawn_rails_application' passenger (2.2.4) lib/phusion_passenger/ abstract_server_collection.rb:126:in `lookup_or_add' passenger (2.2.4) lib/phusion_passenger/spawn_manager.rb:255:in `spawn_rails_application' passenger (2.2.4) lib/phusion_passenger/ abstract_server_collection.rb:80:in `synchronize' passenger (2.2.4) lib/phusion_passenger/ abstract_server_collection.rb:79:in `synchronize' passenger (2.2.4) lib/phusion_passenger/spawn_manager.rb:254:in `spawn_rails_application' passenger (2.2.4) lib/phusion_passenger/spawn_manager.rb:153:in `spawn_application' passenger (2.2.4) lib/phusion_passenger/spawn_manager.rb:286:in `handle_spawn_application' passenger (2.2.4) lib/phusion_passenger/abstract_server.rb:351:in `__send__' passenger (2.2.4) lib/phusion_passenger/abstract_server.rb:351:in `main_loop' passenger (2.2.4) lib/phusion_passenger/abstract_server.rb:195:in `start_synchronously' Thanks for your help. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
