Monday, 15 August 2011

mysql - Error running ThinkingSphinx with PostgreSQL -



mysql - Error running ThinkingSphinx with PostgreSQL -

i used have thinking-sphinx , running mysql. now, migrate postgresql. however, thinking-sphinx still configured mysql, got next error:

/users/name/.rvm/gems/ruby-1.9.2-p290/gems/activesupport-3.2.0/lib/active_support/dependencies.rb:251:in `require': no such file load -- mysql2 (loaderror)

i trace thinking_sphinx.rb file in users/name/.rvm/gems/thinking-sphinx-3.0.1/lib , found following:

if ruby_platform == 'java' require 'java' require 'jdbc/mysql' else require 'mysql2' end

how forcefulness thinking-sphinx take pgsql? alternatively, need uninstall thinking-sphinx , sphinx , install them configuration pgsql?

from https://github.com/pat/thinking-sphinx/issues/413#issuecomment-11912232

thinking sphinx v3 communicates sphinx using sphinxql - means sphinx behaves mysql server. hence, mysql2 gem required sending queries sphinx.

so add together gemfile

gem 'mysql2'

mysql postgresql sphinx thinking-sphinx

No comments:

Post a Comment