This is all from memory - I'm not a UNIX expert either. But... I think generally with passenger, it runs the Rails app using the user who owns the app files. However, it seems Sphinx is running using the root user - you need to run all the rake tasks using the rails app user (after using root/sudo to stop the Sphinx daemon first).
-- Pat On 30/07/2009, at 6:31 PM, Michael wrote: > > Ok so i noticed that the elf command lists the pid numbers. > > PID 6236 is my "production.sphinx.conf" and its is user root > > On Jul 30, 1:26 pm, Michael <[email protected]> wrote: >> Rabble. I'm so lost. Ok so i looked around and got this command "ps - >> elf " which lists all the running processes. >> >> I'm guessing that i should be looking for anything that says >> passenger >> correct? >> Passenger ApplicationSpawner: PATHTOSITE/current >> >> Everything else is listed with the UID of root except for this and a >> few other things that are "1000" and apache which is "www-data" >> >> actually there are two other things that are passenger that are >> running under "root" >> >> /usr/lib/ruby/gems/1.8/gems/passenger-2.2.4/ext/apache2/ >> ApplicationPoolServerExecutable 0 /usr/lib/ruby/gems/1.8/gems/ >> passenger-2.2.4/bin/passenger-spawn-server /usr/bin/ruby1.8 /t >> >> Passenger spawn server >> >> so yes at this point i am officially over my head. Anyone for a >> lifevest? >> >> On Jul 30, 1:13 pm, Pat Allan <[email protected]> wrote: >> >>> Ah, permissions error. Are you indexing the files with a different >>> user to what the web process is being run by? This is necessary for >>> delta indexing, so passenger can update the index files. >> >>> -- >>> Pat >> >>> On 30/07/2009, at 6:09 PM, Michael wrote: >> >>>> ok so i did some more mucking around in the console. this is the >>>> error >>>> i get. >> >>>> indexing index 'project_delta'... >>>> collected 8 docs, 0.0 MB >>>> collected 0 attr values >>>> sorted 0.0 Mvalues, 100.0% done >>>> sorted 0.0 Mhits, 100.0% done >>>> total 8 docs, 3055 bytes >>>> total 0.016 sec, 190925.58 bytes/sec, 499.97 docs/sec >>>> WARNING: access denied to PID 6236. >>>> WARNING: indices NOT rotated. >> >>>> It was giving me some permission errors like this >> >>>> ATAL: failed to open PATHTOSITE/releases/20090729221806/db/sphinx/ >>>> production/project_delta.spl: Permission denied, will not index. >>>> Try >>>> -- >>>> rotate option. >> >>>> But i fixed that up with chmod. >> >>>> On Jul 30, 11:52 am, Pat Allan <[email protected]> wrote: >>>>> Michael: >>>>> Just to be clear: the bin_path should be set to /usr/local/bin - >>>>> searchd is appended by Thinking Sphinx automatically. >>>>> Does delta indexing work via script/console for you? >> >>>>> Mattias: >>>>> I don't think the PATH problem is something that happens with >>>>> mongrels. >>>>> Is there any output in production.log when a change is made? >> >>>>> -- >>>>> Pat >> >>>>> On 30/07/2009, at 10:36 AM, Mattias wrote: >> >>>>>> Hi Michael, >> >>>>>> I'm having the exact same problem. There was a post about this >>>>>> not >>>>>> too >>>>>> long agohttp://to.ly/nGzwhichrefersto the instructions you've >>>>>> cited. I''ve also tried setting the bin path to '/usr/local/ >>>>>> bin' (which searchd gives me the same output you're receiving), >>>>>> however this yields no improvement. >> >>>>>> On my local machine, on development mode, it works like a charm. >>>>>> Same >>>>>> goes using script/console in the production environment on my >>>>>> production machine. The query log outputs something like the >>>>>> following: >> >>>>>> [Thu Jul 30 05:07:55.539 2009] 0.000 sec [scan/2/rel 1 (0,20)] >>>>>> [activity_core] >> >>>>>> everytime a change is made using the console. However, via the >>>>>> web >>>>>> interface, it just won't work. Any pointers would be greatly >>>>>> appreciated. >> >>>>>> I'm running mongrel_cluster behind Apache 2.2 via ec2onrails, if >>>>>> that >>>>>> is of any interest. I'll inform you of any updates and would >>>>>> appreciate if you did so too =) >> >>>>>> Thanks in advance, >>>>>> Mattias >> >>>>>> On 30 Juli, 02:15, Michael <[email protected]> wrote: >>>>>>> I can't get deltas working in production for my site and its >>>>>>> driving >>>>>>> me nuts. >> >>>>>>> If i run the index rake task then it works fine ZERO errors >>>>>>> but for >>>>>>> somereason the delta index does not update on its own. >> >>>>>>> I say the post >>>>>>> onhttp://freelancing-god.github.com/ts/en/common_issues.html >>>>>>> about using deltas with passenger and followed those >>>>>>> instructions >>>>>>> but >>>>>>> that did not solve the problem. >> >>>>>>> ---------------------------------------------------------------- >>>>>>> Running Delta Indexing with Passenger >> >>>>>>> If you’re using Phusion Passenger on your production server, >>>>>>> with >>>>>>> delta indexing on some models, a common issue people find is >>>>>>> that >>>>>>> their delta indexes don’t get processed. This is because >>>>>>> Passenger >>>>>>> has >>>>>>> it’s own PATH set up, and can’t execute the Sphinx binaries >>>>>>> (indexer >>>>>>> and searchd) implicitly. >> >>>>>>> The way around this is to find out where your binaries are on >>>>>>> the >>>>>>> server: >> >>>>>>> which searchd >> >>>>>>> And then set the bin_path option in your config/sphinx.yml >>>>>>> file for >>>>>>> the production environment: >> >>>>>>> production: >>>>>>> bin_path: '/usr/local/bin' >>>>>>> ---------------------------------------------------------------- >> >>>>>>> When i run "which searchd" i get "/usr/local/bin/searchd" >>>>>>> I tired the yml file with both "/usr/local/bin" and "/usr/local/ >>>>>>> bin/ >>>>>>> searchd" just to be safe but the results were the same. >> >>>>>>> This is driving me nuts. any help would really really be >>>>>>> appreciated >> >>>>>>> Thanks, >>>>>>> Mike > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
