Sphinx Configuration error: Mysql2::Error (Can’t connect to MySQL server on ‘127.0.0.1’ (111))

While setting up a Rails project in my machine, I got this error. First I can’t understand why this error coming, because I am successfully using mysql database in this project, and mysql server is running in my system. The error line number shows near the Sphinx code ‘Model.search’, then I understood this is because of the wrong set up of my sphinx configuration. But why this error? I read some documents and understood that sphinx internally using mysql protocol, so showing this error. Anyway I am checking my sphinx configuration, and no yml config file of sphinx found! So I have some works to do now!

I followed these steps,
Configure Sphinx in Rails 3.2

And all works fine!!

Author: Abhilash

Hey! This is Abhilash - A Ruby developer for years, specialised on web development. Right now working as a freelance Ruby Developer. I am also working on Angular, Sinatra and many other backend infra. Mainly working on Ruby On Rails platform since 2010. This blog is about Ruby, Ruby On Rails and other subjects that I had a chance to go through. You can contact me here: abhilash.amballur@gmail.com Abhilash AK

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s