source journal
{
    type                            = mysql
    sql_host                        = localhost
    sql_user                        = journal_user
    sql_pass                        = journal_password
    sql_db                          = journal
#    sql_sock                        =  /var/run/mysqld/mysqld.sock
    sql_port                        = 3306                  

    # indexer query
    # document_id MUST be the very first field
    # document_id MUST be positive (non-zero, non-negative)
    # document_id MUST fit into 32 bits
    # document_id MUST be unique
    sql_query                       = \
            SELECT \
                    `id`, `fulltext`, `image_url` \
            FROM \
                    journals;
#
#    sql_group_column                = assembly
#    sql_group_column                = model

    # document info query
    # ONLY used by search utility to display document information
    # MUST be able to fetch document info by its id, therefore
    # MUST contain '$id' macro 
    #

    sql_query_info          = SELECT * FROM journals WHERE id=$id
}

index journal
{
    source                  = journal
    path                    = /home/pepper/sphinx/journal
    morphology              = stem_en

    min_word_len            = 3
    min_prefix_len          = 0
    min_infix_len           = 3
}

searchd
{
  port        = 3312
  log         = /var/log/searchd/searchd.log
  query_log     = /var/log/searchd/query.log
  pid_file      = /var/log/searchd/searchd.pid
}