Hi Pat, Thanks so much for taking to time to help. You got my mind onto the right track and I found these instructions to get sphinx to install with mysql support :
https://gist.github.com/terenceponce/3786784 Followed those and now rake ts:index is working fine now! Can you comment on the lack of the sphinx.conf file? Should I make one? Thanks PJ On Friday, 30 August 2013 03:10:56 UTC+1, Pat Allan wrote: > > Hi PJ > > Your PS holds the clue - Sphinx was compiled without MySQL support, even > though you requested it. How was MySQL installed? It looks like Homebrew > hasn't picked up your existing install, hence it's added the > '--without-mysql' flag. > > -- > Pat > > On 30/08/2013, at 1:47 AM, pjderi wrote: > > > Hello, > I'm trying to get a dev version of an old site up and running so that I > can evaluate it and make decisions about what to do to upgrade it. > Its my first time working with rails so I apologise in advance if my > questions are a bit uninformed. > > From the gemfile I can see that the site is using rails 3.0.7 > The thinking sphinx gem appears in the Gemfile.lock as : > thinking-sphinx (2.0.14) > activerecord (>= 3.0.3) > builder (>= 2.1.2) > riddle (>= 1.5.3) > > The mysql gem: > mysql2 (0.2.6) > > I'm on OSX Lion and have downgraded the mysql version to have version > 5.5.28 installed. > > When I do rake ts:index I get the following output: > > > Generating Configuration to > /Users/pj/railsprojects/thewebsite/config/development.sphinx.conf > Sphinx 2.0.8-release (r3831) > Copyright (c) 2001-2012, Andrew Aksyonoff > Copyright (c) 2008-2012, Sphinx Technologies Inc (http://sphinxsearch.com) > > using config file > '/Users/pj/railsprojects/thewebsite/config/development.sphinx.conf'... > indexing index 'user_core'... > ERROR: source 'user_core_0': unknown type 'mysql'; skipping. > ERROR: index 'user_core': failed to configure some of the sources, will > not index. > skipping non-plain index 'user'... > total 0 reads, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg > total 0 writes, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg > > The thing thats bothering me most is that when I use this same setup on a > Ubuntu 12.04 box then the rake ts:index works just fine. > (the mysql version there is actually 5.5.32) > > I notice also that there is no sphinx.conf file in the files I was given, > there was just a development.sphinx.conf file present in the config folder. > > Could anyone point me in the right direction here at all? > > Thanks > PJ > > PS: when I installed sphinx with brew I noticed that is used a > --without-myql switch... > > $ brew install sphinx -–mysql -–pgsql > Warning: It appears you have MacPorts or Fink installed. > Software installed with other package managers causes known problems for > Homebrew. If a formula fails to build, uninstall MacPorts/Fink and try > again. > ==> Downloading http://sphinxsearch.com/files/sphinx-2.0.8-release.tar.gz > Already downloaded: /Library/Caches/Homebrew/sphinx-2.0.8.tar.gz > Initialized empty Git repository in > /private/tmp/sphinx-Q64o/sphinx-2.0.8-release/.git/ > ==> Downloading http://snowball.tartarus.org/dist/libstemmer_c.tgz > Already downloaded: /Library/Caches/Homebrew/libstemmer_c.tgz > ==> ./configure --prefix=/usr/local/Cellar/sphinx/2.0.8 > --localstatedir=/usr/local/var --with-libstemmer --without-mysql > ==> make install > ==> Caveats > Sphinx has been compiled with libstemmer support. > > Sphinx depends on either MySQL or PostreSQL as a datasource. > > You can install these with Homebrew with: > brew install mysql > For MySQL server. > > brew install mysql-connector-c > For MySQL client libraries only. > > brew install postgresql > For PostgreSQL server. > > We don't install these for you when you install this formula, as > we don't know which datasource you intend to use. > ==> Summary > > -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/thinking-sphinx. For more options, visit https://groups.google.com/groups/opt_out.
