Hi Kakani You could try reinstalling the mysql gem - though it wouldn't hurt to look into using the mysql2 gem instead (given it's more actively maintained, though I'm not sure which version is appropriate for Rails 2.x.
It's also worth noting that you seem to have Thinking Sphinx installed as a plugin (in vendor), and for some reason you have ts-delayed-delta in the root of your project? That's a little odd, and certainly not recommended. If at all possible, you should switch to the gem releases for both libraries. And yes, you should definitely remove the searchd_binary_name and indexer_binary_name settings from your sphinx.yml file. As for ensuring your app uses a certain version of the gem, I think you need to have that requirement listed in your config/environment.rb file - that'll ensure it doesn't use a newer version (e.g.: 3.0.0). Cheers -- Pat On 28/01/2013, at 2:42 PM, Kakani Padmaja wrote: > Hi Pat, > > I searched regarding this error "uninitialized constant MysqlCompat::MysqlRes > (NameError)" in this page > http://stackoverflow.com/questions/10505687/uninitialized-constant-error-in-rails-connecting-to-mysql-after-ubuntu-upgrade. > > I am not using mysql2... in my gem list I have mysql(2.8.1). > > Is there any problem with the version? > Is it compulsory to install mysql2? > Thank you. > > On Sunday, January 27, 2013 6:29:35 PM UTC+5:30, Pat Allan wrote: > Hi Kakani > Sorry, I'm not clear - which version of Thinking Sphinx are you using? TS v3 > (and v2) is not compatible with Rails 2 or earlier, so you'll definitely need > to use 1.4.14. > > Also: You don't need the *_binary_name settings - and even if you did, they > don't require the path, so they'd be just 'searchd' and 'indexer' - which are > the defaults anyway. > > As for the "uninitialized constant MysqlCompat::MysqlRes" error - can you run > the rake task with the --trace option to get the full error backtrace? > > -- > Pat > > On 27/01/2013, at 9:45 PM, Kakani Padmaja wrote: > > > > > Hi Pat, > > > > My sphinx.yml file > > > > development: > > port: 9110 > > morphology: stem_en > > enable_star: true > > html_strip: 1 > > min_infix_len: 2 > > bin_path: "/usr/bin" > > searchd_binary_name: "/usr/bin/searchd" > > indexer_binary_name: "/usr/bin/indexer" > > test: > > port: 9111 > > morphology: stem_en > > enable_star: true > > html_strip: 1 > > min_infix_len: 2 > > > > production: > > port: 9112 > > morphology: stem_en > > enable_star: true > > html_strip: 1 > > min_infix_len: 2 > > > > > > I gave bundle exec rake ts:start... I got this message in console.. > > > > Please install RDoc 2.4.2+ to generate documentation. > > > > Sphinx cannot be found on your system. You may need to configure the > > following > > settings in your config/sphinx.yml file: > > * bin_path > > * searchd_binary_name > > * indexer_binary_name > > > > For more information, read the documentation: > > http://freelancing-god.github.com/ts/en/advanced_config.html > > rake aborted! > > uninitialized constant MysqlCompat::MysqlRes > > > > Tasks: TOP => environment > > (See full trace by running task with --trace) > > > > Rails version-- 2.3.14 > > Ruby version-1.8.7 > > Riddle-1.5.4 > > thinking sphinx--3.0.0 .. but i am using thinking-sphinx-1.3.20 > > sphinx-2.04. > > > > > > On Friday, January 18, 2013 5:00:40 PM UTC+5:30, Pat Allan wrote: > > Hi Kakani > > What's the output when you run those rake tasks? And can you share the full > > contents of your config/sphinx.yml file? Perhaps in a gist if it's a big > > file. > > > > Also: what versions of Thinking Sphinx, Riddle, Rails and Sphinx are you > > using? > > > > Cheers > > > > -- > > Pat > > > > On 18/01/2013, at 8:54 PM, Kakani Padmaja wrote: > > > > > Hi Srikanth/Pat, > > > > > > I am using ubuntu 12.04 for my rails project. I have the same issue with > > > sphinx. > > > I followed the steps what all you mentioned in this discussion. But still > > > i am getting the same error. > > > > > > I found my indexer using which indexer, then the path is /usr/bin/indexer > > > > > > I added like this in my config/sphinx.yml file > > > > > > bin_path: "/usr/bin" > > > > > > After that i run this command rake thinking_sphinx:rebuild and rake > > > thinking_sphinx:configure.. nothing worked for you. > > > > > > Can anyone suggest any ideas to resolve this issue.. > > > Thanks in advance. > > > > > > > > > > > > On Saturday, April 3, 2010 8:26:37 AM UTC+5:30, srikanth wrote: > > > Hi Pat, > > > > > > Yeah the Issue was I didn't configure. Thanks for helping me out :):) > > > > > > rake thinking_sphinx:configure > > > rake thinking_sphinx:start > > > > > > I have added the solution for this in my blog. > > > > > > http://srikanthjeeva.blogspot.com/2010/04/thinking-sphinx.html > > > > > > > > > Thanks, > > > Srikanth > > > > > > > > > On Fri, Apr 2, 2010 at 7:59 PM, Pat Allan <[email protected]> > > > wrote: > > > Looks like you got it all figured out, given from your blog post I > > > spotted on Twitter :) > > > > > > (For everyone else: it helps to index your data before starting up > > > Sphinx). > > > > > > -- > > > Pat > > > > > > On 02/04/2010, at 7:46 PM, srikanth wrote: > > > > > > > Hi pat, > > > > > > > > Thanks, Before I didnt install 'Sphinx'. Now I have installed it. > > > > > > > > srikanth@client30:~/projects/registration_desk$ which indexer > > > > /usr/local/bin/indexer > > > > > > > > > > > > But when I start thinking_sphinx, I'm getting this error > > > > > > > > srikanth@client30:~/projects/my project$ rake thinking_sphinx:start > > > > (in /home/srikanth/projects/my project) > > > > Failed to start searchd daemon. Check /home/srikanth/projects/my > > > > project/log/searchd.log. > > > > Failed to start searchd daemon. Check /home/srikanth/projects/my > > > > project/log/searchd.log > > > > > > > > -- > > > > srikanth > > > > > > > > On Fri, Apr 2, 2010 at 12:37 PM, Pat Allan <[email protected]> > > > > wrote: > > > > What's the output when you run 'which indexer' in your shell? > > > > > > > > -- > > > > Pat > > > > > > > > On 02/04/2010, at 6:03 PM, srikanth wrote: > > > > > > > >> srikanth@client30:~/project$ rake thinking_sphinx:index > > > >> (in /home/srikanth/projects/registration_desk) > > > >> > > > >> Sphinx cannot be found on your system. You may need to configure the > > > >> following > > > >> settings in your config/sphinx.yml file: > > > >> * bin_path > > > >> * searchd_binary_name > > > >> * indexer_binary_name > > > >> > > > >> For more information, read the documentation: > > > >> http://freelancing-god.github.com/ts/en/advanced_config.html > > > >> Generating Configuration to > > > >> /home/srikanth/projects/registration_desk/config/development.sphinx.conf > > > >> > > > >> > > > >> This is my sphinx.yml file > > > >> development: > > > >> bin_path: "/usr/local/bin" > > > >> port: 9312 > > > >> > > > >> & still I'm getting the same error. > > > >> > > > >> How to set up > > > >> * searchd_binary_name > > > >> * indexer_binary_name > > > >> > > > >> Please tell me how can i fix this, > > > >> > > > >> -- > > > >> Regards, > > > >> Srikanth J > > > >> > > > >> -- > > > >> 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. > > > > > > > > > > > > > > > > > > > > -- > > > > Regards, > > > > Srikanth J > > > > > > > > -- > > > > 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. > > > > > > > > > > > > > > > -- > > > Regards, > > > Srikanth J > > > > > > -- > > > You received this message because you are subscribed to the Google Groups > > > "Thinking Sphinx" group. > > > To view this discussion on the web visit > > > https://groups.google.com/d/msg/thinking-sphinx/-/ei0lGApLTwUJ. > > > 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 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?hl=en. > > 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?hl=en. > 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
