# Trying to use sphinx search engine **URL:** \ **Category:** Rails\ **Created:** [March 24, 2010, 3:49pm UTC](https://www.ruby-forum.com/t/trying-to-use-sphinx-search-engine/185678 "2010-03-24T15:49:28Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Sumeet\_P](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/8e8cbc/32.png) [@Sumeet\_P](https://www.ruby-forum.com/u/Sumeet_P)\ **Post date:** [March 24, 2010, 3:49pm UTC](https://www.ruby-forum.com/t/trying-to-use-sphinx-search-engine/185678/1 "2010-03-24T15:49:28Z")
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 ---
**Author:** ![Sumeet\_P](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/8e8cbc/32.png) [@Sumeet\_P](https://www.ruby-forum.com/u/Sumeet_P)\ **Post date:** [March 25, 2010, 11:28am UTC](https://www.ruby-forum.com/t/trying-to-use-sphinx-search-engine/185678/2 "2010-03-25T11:28:52Z")
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](http://lucene.apache.org/solr/) ) and the acts\_as\_solr\_reloaded ( [GitHub - dcrec1/acts\_as\_solr\_reloaded: ActsAsSolr with new features](http://github.com/dcrec1/acts_as_solr_reloaded) ). 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. ---
**Author:** ![Sumeet\_P](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/8e8cbc/32.png) [@Sumeet\_P](https://www.ruby-forum.com/u/Sumeet_P)\ **Post date:** [March 26, 2010, 3:04pm UTC](https://www.ruby-forum.com/t/trying-to-use-sphinx-search-engine/185678/3 "2010-03-26T15:04:13Z")
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. ---
**Author:** ![Sumeet\_P](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/8e8cbc/32.png) [@Sumeet\_P](https://www.ruby-forum.com/u/Sumeet_P)\ **Post date:** [March 27, 2010, 1:10pm UTC](https://www.ruby-forum.com/t/trying-to-use-sphinx-search-engine/185678/4 "2010-03-27T13:10:22Z")
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/](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/](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. ---
**Author:** ![Sumeet\_P](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/8e8cbc/32.png) [@Sumeet\_P](https://www.ruby-forum.com/u/Sumeet_P)\ **Post date:** [March 25, 2010, 9:22pm UTC](https://www.ruby-forum.com/t/trying-to-use-sphinx-search-engine/185678/5 "2010-03-25T21:22:12Z")
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.