Hello Sphinxers,

I've got sphinx up and running and indexing 150 million records.  I've
built a little search app with ThinkingSphinx and it works great!  I'm
extremely impressed with how easy it was to get going.  I am running
into a little trouble using TS with multiple database connections.

I want to integrate the same models, controllers and views it into our
main rails app, but I'd like to keep the searchable data in a separate
database.  I've subclassed ActiveRecord::Base for the new model and
normal ActiveRecord stuff works, but I'm not having any luck with
search.  I'm using Rails 2.3.9-p173, TS 1.3.20, and Sphinx  0.9.9-
release (r2117).

None of the index definitions are making into the sphinx.conf file.
When I run rake thinking_sphinx:index I get this:

using config file '/Users/edwinknuth/proj/legitweb/config/
development.sphinx.conf'...
FATAL: no indexes found in config file '/Users/edwinknuth/proj/
legitweb/config/development.sphinx.conf'

My model looks like this:
class WhoisDB < ActiveRecord::Base
  establish_connection $config['whois_database']
end

class Domain < WhoisDB

  define_index do
    indexes text

  end
end

and the sphinx conf file looks like:

indexer
{
}

searchd
{
  listen = 127.0.0.1:9312
  log = /Users/edwinknuth/proj/legitweb/log/searchd.log
  query_log = /Users/edwinknuth/proj/legitweb/log/searchd.query.log
  pid_file = /Users/edwinknuth/proj/legitweb/log/
searchd.development.pid
}


Thank you very much for your help.  This is an awesome bit of
software.
Edwin Knuth

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