Not spotting anything obvious in the conf file. If you just run  
searchd without any arguments from the command line, does it say  
anything odd (beyond complaining about needing a conf file)? I'm  
assuming this all works fine in development, yeah?

-- 
Pat

On 06/08/2009, at 7:43 PM, Kevin Beck wrote:

>
> staging.sphinx.config - http://gist.github.com/163487
>
> Do you have any tips on how to check that the sphinx install is OK?
>
> Again, thank you for your help.
>
> KMB
>
>
> On Aug 6, 10:48 am, Pat Allan <[email protected]> wrote:
>> Well, I've no idea about that checkpackage stuff, but I'm not super-
>> familiar with Debian, so let's assume that's okay...
>>
>> Can you put your development.sphinx.conf (or production.sphinx.conf,
>> if this is your server) file onto pastie or gist (make sure you  
>> remove
>> database password)? Maybe there's some clues in there.
>>
>> --
>> Pat
>>
>> On 06/08/2009, at 6:29 PM, Kevin Beck wrote:
>>
>>
>>
>>> In case this helps troubleshoot the problem I followed the
>>> installation instructions for sphnix from here:
>>
>>> http://sphinxsearch.com/wiki/doku.php?id=sphinx_on_debian_gnu_linux
>>
>>> KMB
>>
>>> On Aug 6, 10:25 am, Kevin Beck <[email protected]> wrote:
>>>> Still fails after stripping it back to:
>>>>  define_index do
>>>>    indexes display_name
>>>>  end
>>
>>>> I tried a different column name as well and same results...
>>
>>>> Rails 2.3.2
>>>> TS Plugin: 1.1.18? (found in install.rb)
>>>> MySQL Ver 14.12 Distrib 5.0.32
>>
>>>> KMB
>>
>>>> On Aug 6, 10:08 am, Pat Allan <[email protected]> wrote:
>>
>>>>> Let's just see if we can figure out the source of the error... try
>>>>> stripping back the define_index block to just 'indexes
>>>>> display_name',
>>>>> see if that works, and if so, add the rest of the lines back one
>>>>> by one.
>>
>>>>> If it doesn't work with just the one field, then that makes it
>>>>> tricky.
>>>>> What version of TS and Rails are you using? Are you using MySQL or
>>>>> PostgreSQL?
>>
>>>>> --
>>>>> Pat
>>
>>>>> On 06/08/2009, at 6:03 PM, Kevin Beck wrote:
>>
>>>>>> Hello Pat,
>>
>>>>>> Here is my index block:
>>
>>>>>>  define_index do
>>>>>>    indexes display_name, tags
>>>>>>    has part_group.part_category_id, :as => :part_category_id
>>>>>>    has view_order
>>
>>>>>>    set_property :field_weights => {
>>>>>>      "display_name" => 100,
>>>>>>      "tags"        => 25
>>>>>>    }
>>>>>>  end
>>
>>>>>> tags is just a field in the table that contains alternate words  
>>>>>> for
>>>>>> the description.
>>
>>>>>> Thank you for the quick response.
>>
>>>>>> KMB
>>
>>>>>> On Aug 6, 9:38 am, Pat Allan <[email protected]> wrote:
>>>>>>> Hi Kevin
>>
>>>>>>> It's pretty annoying that Sphinx isn't providing a useful error
>>>>>>> message. What does your define_index block look like for the
>>>>>>> PartDescription model?
>>
>>>>>>> --
>>>>>>> Pat
>>
>>>>>>> On 06/08/2009, at 5:14 PM, Kevin Beck wrote:
>>
>>>>>>>> I am trying to get my application released to our staging  
>>>>>>>> server
>>>>>>>> but I
>>>>>>>> am unable to run ts:index.  Below is stack trace from my
>>>>>>>> attempts.
>>>>>>>> When I run 'which searchd' and 'which indexer' both are in / 
>>>>>>>> usr/
>>>>>>>> local/
>>>>>>>> bin/ so my PATH should be fine.  Any advice would be greatly
>>>>>>>> appreciated.
>>
>>>>>>>> KMB
>>
>>>>>>>> ** Invoke ts:index (first_time)
>>>>>>>> ** Invoke thinking_sphinx:index (first_time)
>>>>>>>> ** Invoke thinking_sphinx:app_env (first_time)
>>>>>>>> ** Execute thinking_sphinx:app_env
>>>>>>>> ** Invoke environment (first_time)
>>>>>>>> ** Execute environment
>>>>>>>> ** Execute thinking_sphinx:index
>>>>>>>> Generating Configuration to /var/www/staging/project/releases/
>>>>>>>> 20090806051452/config/staging.sphinx.conf
>>>>>>>> Sphinx 0.9.8-dev (r1112)
>>>>>>>> Copyright (c) 2001-2008, Andrew Aksyonoff
>>
>>>>>>>> using config file '/var/www/staging/project/releases/
>>>>>>>> 20090806051452/
>>>>>>>> config/staging.sphinx.conf'...
>>>>>>>> indexing index 'part_description_core'...
>>>>>>>> collected 4298 docs, 0.1 MB
>>>>>>>> ERROR: index 'part_description_core': (no error message).
>>>>>>>> total 4298 docs, 93839 bytes
>>>>>>>> total 0.015 sec, 6390125.85 bytes/sec, 292679.60 docs/sec
>>>>>>>> distributed index 'part_description' can not be directly  
>>>>>>>> indexed;
>>>>>>>> skipping.
>>>>>>>> rake aborted!
>>>>>>>> The following command failed:
>>>>>>>>  indexer --config /var/www/staging/project/releases/
>>>>>>>> 20090806051452/
>>>>>>>> config/staging.sphinx.conf --all
>>
>>>>>>>> This could be caused by a PATH issue in the environment of  
>>>>>>>> cron/
>>>>>>>> passenger/etc. Your current PATH:
>>>>>>>>  /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/
>>>>>>>> usr/
>>>>>>>> X11R6/bin
>>>>>>>> You can set the path to your indexer and searchd binaries using
>>>>>>>> the
>>>>>>>> bin_path property in config/sphinx.yml:
>>>>>>>>  production:
>>>>>>>>    bin_path: '/usr/local/bin'
>>>>>>>> /var/www/staging/project/releases/20090806051452/vendor/ 
>>>>>>>> plugins/
>>>>>>>> thinking_sphinx/tasks/../lib/thinking_sphinx/tasks.rb:152:in
>>>>>>>> `system!'
>>>>>>>> /var/www/staging/project/releases/20090806051452/vendor/ 
>>>>>>>> plugins/
>>>>>>>> thinking_sphinx/tasks/../lib/thinking_sphinx/tasks.rb:77
>>>>>>>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:617:in  
>>>>>>>> `call'
>>>>>>>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:617:in
>>>>>>>> `execute'
>>>>>>>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:612:in  
>>>>>>>> `each'
>>>>>>>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:612:in
>>>>>>>> `execute'
>>>>>>>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:578:in
>>>>>>>> `invoke_with_call_chain'
>>>>>>>> /usr/lib/ruby/1.8/monitor.rb:238:in `synchronize'
>>>>>>>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:571:in
>>>>>>>> `invoke_with_call_chain'
>>>>>>>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:588:in
>>>>>>>> `invoke_prerequisites'
>>>>>>>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:585:in  
>>>>>>>> `each'
>>>>>>>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:585:in
>>>>>>>> `invoke_prerequisites'
>>>>>>>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:577:in
>>>>>>>> `invoke_with_call_chain'
>>>>>>>> /usr/lib/ruby/1.8/monitor.rb:238:in `synchronize'
>>>>>>>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:571:in
>>>>>>>> `invoke_with_call_chain'
>>>>>>>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:564:in
>>>>>>>> `invoke'
>>>>>>>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:2019:in
>>>>>>>> `invoke_task'
>>>>>>>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1997:in
>>>>>>>> `top_level'
>>>>>>>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1997:in  
>>>>>>>> `each'
>>>>>>>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1997:in
>>>>>>>> `top_level'
>>>>>>>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:2036:in
>>>>>>>> `standard_exception_handling'
>>>>>>>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1991:in
>>>>>>>> `top_level'
>>>>>>>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1970:in  
>>>>>>>> `run'
>>>>>>>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:2036:in
>>>>>>>> `standard_exception_handling'
>>>>>>>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1967:in  
>>>>>>>> `run'
>>>>>>>> /usr/lib/ruby/gems/1.8/gems/rake-0.8.3/bin/rake:31
>>>>>>>> /usr/bin/rake:19:in `load'
>>>>>>>> /usr/bin/rake:19
>>
>>
> >


--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to