Sphinx Config

#
# Minimal Sphinx configuration sample (clean, simple, functional)
#

source articles
{
        type                    = mysql

        sql_host                = localhost
        sql_user                = sql_username
        sql_pass                = sql_pwd
        sql_db                  = sql_database
        sql_port                = 3306  # optional, default is 3306

        sql_query               = SELECT ID, PublicationID AS pub_id, 1 AS table_id, Title, Description FROM articles

    sql_attr_uint       = table_id
    sql_attr_uint       = pub_id
}

index articles
{
        source                  = articles
        path                    = data/articles
        docinfo                 = extern
        charset_type            = utf-8
        min_word_len            = 3
        min_prefix_len          = 0
        min_infix_len           = 3
}

source library_content
{
        type                    = mysql

        sql_host                = localhost
        sql_user                = sql_username
        sql_pass                = sql_pwd
        sql_db                  = sql_database
        sql_port                = 3306  # optional, default is 3306

        sql_query               = SELECT articles.ID, articles.PublicationID, articles.PublicationID AS pub_id, \
                   articles.Title, library_article_content.ArticleID, 3 AS table_id, library_article_content.FileText FROM \
                  library_article_content \
                                  INNER JOIN articles ON articles.id = library_article_content.ArticleID \
                                  WHERE ( \
                                (       SELECT Live FROM publications \
                                        WHERE publications.Title_ID=articles.PublicationID \
                                ) = 1 \
                                OR isNULL(articles.PublicationID) \
                                OR ( \
                                        articles.PublicationID = -1 \
                                        AND ( \
                                                SELECT COUNT(*) \
                                                FROM library_article_content \
                                                WHERE library_article_content.ArticleID=articles.ID \
                                        ) = 0 \
                                    ) \
                            )
    sql_attr_uint       = table_id
    sql_attr_uint       = pub_id
}

index library_content
{
        source                  = library_content
        path                    = data/library_content
        docinfo                 = extern
        charset_type            = utf-8
        min_word_len            = 3
        min_prefix_len          = 0
        min_infix_len           = 3
}

source tt_content
{
        type                    = mysql

        sql_host                = localhost
        sql_user                = sql_username
        sql_pass                = sql_pwd
        sql_db                  = sql_database
        sql_port                = 3306  # optional, default is 3306

        sql_query               = SELECT articles.ID, articles.PublicationID, articles.PublicationID AS pub_id, articles.Title, tt_article_content.ArticleID, 4 AS table_id, \
                                    tt_article_content.PageContent FROM tt_article_content \
                                INNER JOIN articles ON articles.id = tt_article_content.ArticleID \
                                  WHERE ( \
                                (       SELECT Live FROM publications \
                                        WHERE publications.Title_ID=articles.PublicationID \
                                ) = 1 \
                                OR isNULL(articles.PublicationID) \
                                OR ( \
                                        articles.PublicationID = -1 \
                                        AND ( \
                                                SELECT COUNT(*) \
                                                FROM tt_article_content \
                                                WHERE tt_article_content.ArticleID=articles.ID \
                                        ) = 0 \
                                ) \
                        )
    sql_attr_uint       = table_id
    sql_attr_uint       = pub_id
}

index tt_content
{
        source                  = tt_content
        path                    = data/tt_content
        docinfo                 = extern
        charset_type            = utf-8
        min_word_len            = 3
        min_prefix_len          = 0
        min_infix_len           = 3
}

indexer
{
        mem_limit               = 32M
}

searchd
{
        listen                  = 9312
        listen                  = 3312:mysql41
        log                     = /var/log/searchd.log
        query_log               = /var/log/query.log
        read_timeout            = 5
        max_children            = 0
        pid_file                = /var/log/searchd.pid
        max_matches             = 1000
        seamless_rotate         = 1
        preopen_indexes         = 1
        unlink_old              = 1
        workers                 = threads # for RT to work
        binlog_path             = /var/data
}