Once you have installed Sphinx, you need to configure it so that it can access your database, be accessible from your scripts. Configuration files are stored in the etc directory of the installion directory.

$ cd /usr/local/sphinx/etc

A default copy of sphinx.conf file we need to edit is called sphinx.conf.dist. Copy this file to sphinx.conf and start editing.

$ cp sphinx.conf.dist sphinx.conf
$ sphinx.conf contains the config info for sphinx
$ vi sphinx.conf

Specifically, we need to specify the data source, index or indices, indexer settings, and search daemon (searchd) settings.

• source defines the database parameters necessary to connect and select
• index tells sphinx what to index and in which format
• indexer is a utility which creates fulltext indices. We can define parameter such as memory limit.
• searchd is a daemon which enables application to search through fulltext indices. Make sure the port is correct.

Here is a sample sphinx.conf file

  1 # define your data source here.
  2 source phonesource
  3 {
  4   type      = mysql
  5   sql_host  = localhost
  6   sql_user  = type_your_database_username_here
  7   sql_pass  = type_your_password_here
  8   sql_db    = type_your_database_name_here
  9   sql_port  = 3306  # optional, default is 3306
 10
 11   # define the primary fetch query. You can define up
 12   # to 32 full-text fields but the first field must be
 13   # unique unsigned positve integer.
 14   sql_query = select id, name, phone from dg_phonebook;
 15   
 16   # display information on each selected id
 17   # only used for search CLI
 18   sql_query_info = SELECT name, phone FROM phonebook WHERE id=$id;
 19 }
 20
 21 # define an index
 22 index phoneindex
 23 {
 24   source = phonesource
 25   path = /usr/local/sphinx/var/data/phone
 26   morphology = none
 27
 28   # for stemming
 29   min_word_len = 3 
 30   min_prefix_len = 0
 31   min_infix_len = 3
 32   enable_star = 1 
 33   # * means any
 34 }
 35
 36 # indexer settings
 37 indexer
 38 {
 39   recommended 256M to 1024M     
 40   mem_limit = 1024M
 41 }
 42
 43 # search daemon settings
 44 searchd
 45 {
 46   port             = 3312
 47   log              = /usr/local/sphinx/var/log/searchd.log
 48   query_log        = /usr/local/sphinx/var/log/query.log
 49   read_timeout     = 5
 50   max_children     = 30
 51   pid_file         = /usr/local/sphinx/var/log/searchd.pid
 52   max_matches      = 1000
 53   seamless_rotate  = 1
 54   preopen_indexes  = 0
 55   unlink_old       = 1
 56 }

Once we have configure sphinx.conf, we need to run the indexer.

$ /usr/local/sphinx/bin/indexer --config /usr/local/sphinx/etc/sphinx.conf --all

Finally we test

$ /usr/local/sphinx/bin/search John
$ /usr/local/sphinx/bin/search J*
$ /usr/local/sphinx/bin/search *e