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.
