Hi Edwin
Not entirely sure why this isn't working - but perhaps it's worth modifying the
setup so the database settings are environment-driven (in database.yml), and
then run all the Thinking Sphinx rake tasks with RAILS_ENV=whois_sphinx or
similar? That gives you the separation, but also removes the need for
double-model definitions.
Maybe you've got other reasons for taking this approach, though :)
--
Pat
On 16/10/2010, at 9:59 AM, Edwin Knuth wrote:
> 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.
>
--
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.
