Great to know that was the reason, and that it was easily fixed – it's not something I'd seen before, so doubly good to have it on record :)
-- Pat On 02/10/2010, at 3:31 AM, mpokress wrote: > Pat- > > As it turns out, LD_LIBRARY_PATH was the culprit. We install > Postgresql into its own directory, /usr/local/pgsql. I added this to > environment.rb: > > ENV['LD_LIBRARY_PATH'] = '/usr/local/pgsql/lib' > > Now everything is happy. Thanks for your help. > > Matt > > On Oct 1, 10:52 am, mpokress <[email protected]> wrote: >> Yes, the delta indexing output is visible in console, and when running >> script/server. >> >> I just had a small breakthrough on additional examination of the httpd >> error.log. On startup I get this: >> >> [Fri Oct 01 10:41:43 2010] [notice] Apache/2.2.9 (Unix) DAV/2 >> Phusion_Passenger/2.2.15 mod_ssl/2.2.9 OpenSSL/0.9.8b configured -- >> resuming normal operations >> /usr/local/lib/ruby/gems/1.8/gems/rails-2.3.5/lib/rails/ >> gem_dependency.rb:119:Warning: Gem::Dependency#version_requirements is >> deprecated and will be removed on or after August 2010. Use >> #requirement >> >> Sphinx cannot be found on your system. You may need to configure the >> following >> settings in your config/sphinx.yml file: >> * bin_path >> * searchd_binary_name >> * indexer_binary_name >> >> For more information, read the >> documentation:http://freelancing-god.github.com/ts/en/advanced_config.html >> >> Every time I perform an action that runs a search, this shows in the >> error.log: >> >> <error.log> >> Riddle cannot detect Sphinx on your machine, and so can't determine >> which >> version of Sphinx you are planning on using. Please use one of the >> following >> lines after "require 'riddle'" to avoid this warning. >> >> require 'riddle/0.9.8' >> # or >> require 'riddle/0.9.9' >> # or >> require 'riddle/1.10' >> </error.log> >> >> When I perform an action that should trigger a delta, I see this: >> >> <error.log> >> /usr/local/bin/indexer: error while loading shared libraries: libpq.so. >> 5: cannot open shared object file: No such file or directory >> </error.log> >> >> That last one leads me to believe that the LD_LIBRARY_PATH variable is >> not properly set. I am going to set that in environment.rb and see if >> that helps. Next I will set it in httpd.conf. >> >> Let me know if you have seen this before, there may be another place I >> need to set it. >> >> On Oct 1, 10:20 am, Pat Allan <[email protected]> wrote: >> >> >> >>> Hi Matt >> >>> So when you try it in script/console, you see the delta indexing output? Is >>> there *anything* beyond that warning in the Apache error log? What about >>> searchd.log? >> >>> Cheers >> >>> -- >>> Pat >> >>> On 02/10/2010, at 12:04 AM, mpokress wrote: >> >>>> It does not work with Apache/Phusion, only with script/console. That >>>> is the warning I see in the Apache error log. >> >>>> On Oct 1, 9:42 am, Pat Allan <[email protected]> wrote: >>>>> Hi Matt >> >>>>> Just to clarify: beyond the warning from Thinking Sphinx/Riddle, does >>>>> delta indexing work? Are altered records available in search results a >>>>> few seconds after they've been changed? >> >>>>> -- >>>>> Pat >> >>>>> On 01/10/2010, at 11:31 PM, mpokress wrote: >> >>>>>> Pat- >> >>>>>> Running that path, I get the correct path: "/usr/local/bin". >> >>>>>> This particular machine is running Sphinx 0.9.9 and TS 1.3.20 (plugin >>>>>> not gem). I have the same problem with 0.9.8 and 1.3.16, I just >>>>>> wanted to test against the newest stuff and not add confusion due to >>>>>> out of date software. >> >>>>>> What you say about Passenger is consistent with what I thought. Prior >>>>>> to explicitly setting the user I did see that the Passenger spawner >>>>>> was running as the correct user, I jut wanted to remove all doubt. >> >>>>>> I do believe that somehow the Passenger/Rails environment is not >>>>>> picking up the path. I just don't know where else to set it. >> >>>>>> Thanks, >> >>>>>> Matt >> >>>>>> On Oct 1, 9:04 am, Pat Allan <[email protected]> wrote: >>>>>>> Hi Matt >> >>>>>>> Maybe you've edited the spacing in the email, or maybe YAML isn't fussy >>>>>>> - but should it be two spaces indentation? (ie: each key/value pair >>>>>>> under production). >> >>>>>>> I guess let's start with double-checking the bin_path value is coming >>>>>>> through correctly - in script/console on your server, does the >>>>>>> following output '/usr/local/bin'? >> >>>>>>> ThinkingSphinx::Configuration.instance.bin_path >> >>>>>>> Also: which versions of Sphinx and Thinking Sphinx are you using? >> >>>>>>> And you shouldn't need to set the user explicitly in Apache - Passenger >>>>>>> automatically detects the user from the owner of the Rails app files. >>>>>>> The overall Apache process can still run as root. >> >>>>>>> Cheers >> >>>>>>> -- >>>>>>> Pat >> >>>>>>> On 01/10/2010, at 6:44 AM, mpokress wrote: >> >>>>>>>> Something to add to this: >> >>>>>>>> I see this in my apache error log every time a search is executed: >> >>>>>>>> Riddle cannot detect Sphinx on your machine, and so can't determine >>>>>>>> which >>>>>>>> version of Sphinx you are planning on using. Please use one of the >>>>>>>> following >>>>>>>> lines after "require 'riddle'" to avoid this warning. >> >>>>>>>> require 'riddle/0.9.8' >>>>>>>> # or >>>>>>>> require 'riddle/0.9.9' >>>>>>>> # or >>>>>>>> require 'riddle/1.10' >> >>>>>>>> Running TS 1.3.20 and Sphinx 0.9.9. Have the same problems in >>>>>>>> environments with 0.9.8 and 1.3.16. >> >>>>>>>> Matt >> >>>>>>>> On Sep 30, 4:29 pm, mpokress <[email protected]> wrote: >>>>>>>>> Good afternoon- >> >>>>>>>>> I have read a number of threads that make reference to the issue I am >>>>>>>>> having - delta indexing does not work in production. Like many, it >>>>>>>>> works without issue under script/server or script/console. In >>>>>>>>> production (Apache/Passenger) it does not. >> >>>>>>>>> For this example, let's say my rails app is owned by "matt". The >>>>>>>>> binaries are in /usr/local/bin, and the relevant section os sphinx.yml >>>>>>>>> is this: >> >>>>>>>>> production: >>>>>>>>> mem_limit: 512M >>>>>>>>> enable_star: 1 >>>>>>>>> min_infix_len: 3 >>>>>>>>> max_matches: 100000 >>>>>>>>> bin_path: /usr/local/bin >>>>>>>>> charset_table: "+, -, 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U >>>>>>>>> +430..U+44F, U+430..U+44F" >> >>>>>>>>> I have set the apache directives to force it to run as "matt" (not too >>>>>>>>> comfortable with this). These directives are snipped from the globals >>>>>>>>> section of the httpd.conf. >> >>>>>>>>> User matt >>>>>>>>> Group matt >>>>>>>>> PassengerDefaultUser matt >> >>>>>>>>> I really appreciate any help. This has been driving me absolutely >>>>>>>>> nuts for two days, and I really tried to RTFM/RTFP (posts) before >>>>>>>>> asking a question that seems to have been answered many times. >> >>>>>>>>> Best, >> >>>>>>>>> Matt >> >>>>>>>> -- >>>>>>>> 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 >>>>>>>> athttp://groups.google.com/group/thinking-sphinx?hl=en. >> >>>>>> -- >>>>>> 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 >>>>>> athttp://groups.google.com/group/thinking-sphinx?hl=en. >> >>>> -- >>>> 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 >>>> athttp://groups.google.com/group/thinking-sphinx?hl=en. > > -- > 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. > -- 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.
