Trying to use sphinx search engine

Rails
1

Hi,

All any kind of help is appreciated. and thanks a lot.

I have to apply sphinx search on my project.
My development environment is windows, My SQL, Ruby R. but the
project is deployed on Ubuntu.

Q1 ) Can I use sphinx. Will it be a problem if the development is on
windows and deployment is on Ubuntu.

Q2) Also I want to use sphinx search to fetch records, and the result
should only have certain columns which I want to
Q3) fetch for example. I have an object Note(id, name, text, date) and
I want to grab only name and text.

Q4) Can I use thinking sphinx?
Q5) I am not using apache will it be a problem?

Thanks
Sumeet

2

We have used sphinx in a couple of projects and its pretty solid. You
can
also check apache solr ( Welcome to Apache Solr - Apache Solr )
and the acts_as_solr_reloaded (
GitHub - dcrec1/acts_as_solr_reloaded: ActsAsSolr with new features ).

Thinking sphinx is the de facto standard if you use sphinx.

Hava a look at thinking sphinx manual for Q2 and Q3.

I don’t think that you will have any problems by having different
development and deployment systems.

As for not using apache, I don’t think that has anything to do with the
search functionality of your app.

3

Hi,

I am trying to install sphinx on windows with mySql support. I am
doing the way told on the sphinx site.
but some how it do not install properly. I am not able to see
sphinx.conf file and sphinx.yml file.

please let me know about SOME THING I m missing.

1)Download .zip file from sphinx site.
2)Extract everything from the .zip file you have downloaded -
sphinx-0.9.8-win32.zip (or sphinx-0.9.8-win32-pgsql.zip if you need
PostgresSQL support as well.)
3)For the remainder of this guide, we will assume that the folders are
unzipped into C:\Sphinx, such that searchd.exe can be found in C:
\Sphinx\bin\searchd.exe. If you decide to use any different location
for the folders or configuration file, please change it accordingly.
4)set the path variable in windows environment for searchd
5)Install the searchd system as a Windows service:

C:\Sphinx> searchd --install --config C:\Sphinx\sphinx.conf –
servicename SphinxSearch
6)The searchd service will now be listed in the Services panel within
the Management Console, available from Administrative Tools. It will
not have been started, as you will need to configure it and build your
indexes with indexer before starting the service. A guide to do this
can be found under

Now its not installed properly, I am not able to see sphinx.conf and
sphinx.yml.

  1. Then I installed thinking-sphinx gem and also tried plugin

(Please tell me which one is the best, plug-in or GEM)

  1. how to uninstall the improperly installed sphinx and again install
    it properly.

Thanks and regards
Sumeet P.

4

I would take a look at the instructions for Thinking Sphinx, a great
plugin for integrating Sphinx with Ruby…

http://freelancing-god.github.com/ts/en/

and a post about installing it on Windows…

http://www.espace.com.eg/blog/2009/03/23/thinking-sphinx-on-windows/

-stephen

Sumeet P. wrote:

Hi,

I am trying to install sphinx on windows with mySql support. I am
doing the way told on the sphinx site.
but some how it do not install properly. I am not able to see
sphinx.conf file and sphinx.yml file.

please let me know about SOME THING I m missing.

1)Download .zip file from sphinx site.
2)Extract everything from the .zip file you have downloaded -
sphinx-0.9.8-win32.zip (or sphinx-0.9.8-win32-pgsql.zip if you need
PostgresSQL support as well.)
3)For the remainder of this guide, we will assume that the folders are
unzipped into C:\Sphinx, such that searchd.exe can be found in C:
\Sphinx\bin\searchd.exe. If you decide to use any different location
for the folders or configuration file, please change it accordingly.
4)set the path variable in windows environment for searchd
5)Install the searchd system as a Windows service:

C:\Sphinx> searchd --install --config C:\Sphinx\sphinx.conf –
servicename SphinxSearch
6)The searchd service will now be listed in the Services panel within
the Management Console, available from Administrative Tools. It will
not have been started, as you will need to configure it and build your
indexes with indexer before starting the service. A guide to do this
can be found under

Now its not installed properly, I am not able to see sphinx.conf and
sphinx.yml.

  1. Then I installed thinking-sphinx gem and also tried plugin

(Please tell me which one is the best, plug-in or GEM)

  1. how to uninstall the improperly installed sphinx and again install
    it properly.

Thanks and regards
Sumeet P.

5

Sumeet P. wrote:

Hi,

All any kind of help is appreciated. and thanks a lot.

I have to apply sphinx search on my project.
My development environment is windows, My SQL, Ruby R. but the
project is deployed on Ubuntu.

Q1 ) Can I use sphinx. Will it be a problem if the development is on
windows and deployment is on Ubuntu.

Q2) Also I want to use sphinx search to fetch records, and the result
should only have certain columns which I want to
Q3) fetch for example. I have an object Note(id, name, text, date) and
I want to grab only name and text.

Q4) Can I use thinking sphinx?
Q5) I am not using apache will it be a problem?

Thanks
Sumeet

  1. Although you should be able to get it running in both environments I
    would suggest that you keep both the development and production
    environments as close as possible. There are lots of little differences
    between the operating systems and you will spend time cleaning up bugs
    that you wouldn’t run into otherwise. I have been playing with Virtual
    Box quite a bit recently both at work and at home and it works great as
    a development environment.

  2. The “result” will be the record and you can display it any way you
    want in your view. If you only want to display name and text then
    create your form with just those fields. Be aware that you define what
    gets indexed so if your question was whether you could limit your
    searches to specific fields, the answer is still yes. You just only
    index the fields you want to be searchable.

  3. Not sure what the question here is but yes, you should be able to
    use it.

  4. Apache just provides a conduit to your application server and serves
    up static content. It makes no difference whether you are using Apache
    or another server.