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!!

Advertisements

Install thinking Sphinx in Ubuntu 13.04 and set up in Rails 3.2

Check sphinx is already installed in your system,

$ search 

If you have already sphinx installed then it will show the sphinx version and other info, else it shows ubuntu information to install.

Download thinking sphinx from
here,

$ tar -xzf sphinx-2.0.8-release.tar.gz
$ cd sphinx-2.0.8-release/
$ ./configure
$ make
$ sudo make install

Type,

$ search 

it will show the sphinx release and the other information.
Add the sphinx gem into your Gemfile

gem 'thinking-sphinx'

Do bundle install

$ bundle install

I assume you already made the model / controller code for sphinx. Else see this
Index all your records

$ rake ts:index -t

While indexing sphinx will generate the configuration file inside RAILS_ROOT/config/config/development.sphinx.conf

If you need to generate only configuration file not indexing you can use this command

$ rake ts:configure -t

Run sphinx searchd daemon

$ rake ts:start -t

You can stop sphinx searchd daemon

$ rake ts:stop -t

You can reindex so that sphinx will re index all records without creating a configuration file.

$ rake ts:reindex -t

Enjoy Sphinx searching!

Install Skype in Ubuntu 13.04

For 32 bit:

Install Dependencies.

$ sudo apt-get install libqt4-webkit

Download and install Skype

$ wget -O skype-linux.deb http://download.skype.com/linux/skype-ubuntu-lucid_4.2.0.11-1_i386.deb
$ sudo dpkg -i skype-linux.deb
$ sudo apt-get -f install

Open the terminal and type

$ skype

Done.

Reference:
noobslab install skype