Brilliant, Thanks so much for your patience. PJ On Friday, 30 August 2013 14:38:38 UTC+1, Pat Allan wrote: > > Thinking Sphinx generates sphinx configuration files with the environment > as a prefix, within the config directory of your app - so, > development.sphinx.conf, test.sphinx.conf, production.sphinx.conf (and so > on for other environments if you have them). sphinx.conf is just the > default file name Sphinx expects if nothing else is specified - but TS will > always specify the specific environment file. > > So: you don't need to make one yourself :) > > -- > Pat > > On 30/08/2013, at 7:16 PM, pjderi wrote: > > 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] <javascript:>. > To post to this group, send email to [email protected]<javascript:> > . > Visit this group at http://groups.google.com/group/thinking-sphinx. > For more options, visit https://groups.google.com/groups/opt_out. > > >
-- 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.
