source alps
{
    type = mysql
    sql_host = 192.168.1.15
    sql_user = root
    sql_pass = FeVqvNKSaxZKga6PUhx7
    sql_db = newdevalpsadvisor
    sql_port = 3306
    #sql_sock = /var/run/mysqld/mysqld.sock
    mysql_connect_flags = 32 # enable compression
    sql_query_pre = SET NAMES utf8
}

#############################################################################
## article settings
#############################################################################
source articleru : alps
{
    sql_query = SELECT * FROM article_ru
        sql_field_string    = article_id
}

index articleru
{
    source = articleru
    path =  /opt/sphinx/indexes/articleru/articleru
    docinfo = extern
    #morphology = stem_ru, stem_enru
    morphology = stem_enru, soundex
    min_prefix_len = 2
    enable_star = 1
    charset_type = utf-8
    #html_strip = 1
    #html_remove_elements = style, script, code
}

source articleen : alps
{
    sql_query = SELECT * FROM article_en
        sql_field_string    = article_id
}

index articleen
{
    source = articleen
    path =  /opt/sphinx/indexes/articleen/articleen
    docinfo = extern
    #morphology = stem_en
    morphology = stem_enru, soundex
    min_prefix_len = 2
    enable_star = 1
    charset_type = utf-8
    #html_strip = 1
    #html_remove_elements = style, script, code
}

source articleit : alps
{
    sql_query = SELECT * FROM article_it
        sql_field_string    = article_id
}

index articleit
{
    source = articleit
    path =  /opt/sphinx/indexes/articleit/articleit
    docinfo = extern
    morphology = stem_enru, soundex
    min_prefix_len = 2
    enable_star = 1
    charset_type = utf-8
    #html_strip = 1
    #html_remove_elements = style, script, code
}

source articlede : alps
{
    sql_query = SELECT * FROM article_de
        sql_field_string    = article_id
}

index articlede
{
    source = articlede
    path =  /opt/sphinx/indexes/articlede/articlede
    docinfo = extern
    morphology = stem_enru, soundex
    min_prefix_len = 2
    enable_star = 1
    charset_type = utf-8
    #html_strip = 1
    #html_remove_elements = style, script, code
}

#############################################################################
## resort settings
#############################################################################
source resortru : alps
{
    sql_query = SELECT * FROM resort_ru
        sql_field_string    = resort_id
}

index resortru
{
    source = resortru
    path =  /opt/sphinx/indexes/resortru/resortru
    docinfo = extern
    #morphology = stem_ru, stem_enru
    morphology = stem_enru, soundex
    min_prefix_len = 2
    enable_star = 1
    charset_type = utf-8
    #html_strip = 1
    #html_remove_elements = style, script, code
}

source resorten : alps
{
    sql_query = SELECT * FROM resort_en
        sql_field_string    = resort_id
}

index resorten
{
    source = resorten
    path =  /opt/sphinx/indexes/resorten/resorten
    docinfo = extern
    #morphology = stem_en
    morphology = stem_enru, soundex
    min_prefix_len = 2
    enable_star = 1
    charset_type = utf-8
    #html_strip = 1
    #html_remove_elements = style, script, code
}

source resortit : alps
{
    sql_query = SELECT * FROM resort_it
        sql_field_string    = resort_id
}

index resortit
{
    source = resortit
    path =  /opt/sphinx/indexes/resortit/resortit
    docinfo = extern
    morphology = stem_enru, soundex
    min_prefix_len = 2
    enable_star = 1
    charset_type = utf-8
    #html_strip = 1
    #html_remove_elements = style, script, code
}

source resortde : alps
{
    sql_query = SELECT * FROM resort_de
        sql_field_string    = resort_id
}

index resortde
{
    source = resortde
    path =  /opt/sphinx/indexes/resortde/resortde
    docinfo = extern
    morphology = stem_enru, soundex
    min_prefix_len = 2
    enable_star = 1
    charset_type = utf-8
    #html_strip = 1
    #html_remove_elements = style, script, code
}

#############################################################################
## country settings
#############################################################################
source countryru : alps
{
    sql_query = SELECT * FROM country_ru
        sql_field_string    = country_id
}

index countryru
{
    source = countryru
    path =  /opt/sphinx/indexes/countryru/countryru
    docinfo = extern
    #morphology = stem_ru, stem_enru
    morphology = stem_enru, soundex
    min_prefix_len = 2
    enable_star = 1
    charset_type = utf-8
    #html_strip = 1
    #html_remove_elements = style, script, code
}

source countryen : alps
{
    sql_query = SELECT * FROM country_en
        sql_field_string    = country_id
}

index countryen
{
    source = countryen
    path =  /opt/sphinx/indexes/countryen/countryen
    docinfo = extern
    #morphology = stem_en
    morphology = stem_enru, soundex
    min_prefix_len = 2
    enable_star = 1
    charset_type = utf-8
    #html_strip = 1
    #html_remove_elements = style, script, code
}

source countryit : alps
{
    sql_query = SELECT * FROM country_it
        sql_field_string    = country_id
}

index countryit
{
    source = countryit
    path =  /opt/sphinx/indexes/countryit/countryit
    docinfo = extern
    morphology = stem_enru, soundex
    min_prefix_len = 2
    enable_star = 1
    charset_type = utf-8
    #html_strip = 1
    #html_remove_elements = style, script, code
}

source countryde : alps
{
    sql_query = SELECT * FROM country_de
        sql_field_string    = country_id
}

index countryde
{
    source = countryde
    path =  /opt/sphinx/indexes/countryde/countryde
    docinfo = extern
    morphology = stem_enru, soundex
    min_prefix_len = 2
    enable_star = 1
    charset_type = utf-8
    #html_strip = 1
    #html_remove_elements = style, script, code
}

#############################################################################
## chalet settings
#############################################################################
source chaletru : alps
{
    sql_query_pre = SET NAMES utf8
    sql_query_pre = SET CHARACTER SET utf8

    sql_query = SELECT * FROM chalet_ru
        sql_field_string    = chalet_id
        sql_field_string = name
        sql_field_string = description
}

index chaletru
{
    source = chaletru
    path =  /opt/sphinx/indexes/chaletru/chaletru
    docinfo = extern
    morphology = stem_enru, soundex
    min_prefix_len = 2
    enable_star = 1
    charset_type = utf-8
    #html_strip = 1
    #html_remove_elements = style, script, code
}

source chaleten : alps
{
    sql_query = SELECT * FROM chalet_en
        sql_field_string    = chalet_id
}

index chaleten
{
    source = chaleten
    path =  /opt/sphinx/indexes/chaleten/chaleten
    docinfo = extern
    #morphology = stem_en
    morphology = stem_enru, soundex
    min_prefix_len = 2
    enable_star = 1
    charset_type = utf-8
    #html_strip = 1
    #html_remove_elements = style, script, code
}

source chaletit : alps
{
    sql_query = SELECT * FROM chalet_it
        sql_field_string    = chalet_id
}

index chaletit
{
    source = chaletit
    path =  /opt/sphinx/indexes/chaletit/chaletit
    docinfo = extern
    morphology = stem_enru, soundex
    min_prefix_len = 2
    enable_star = 1
    charset_type = utf-8
    #html_strip = 1
    #html_remove_elements = style, script, code
}

source chaletde : alps
{
    sql_query = SELECT * FROM chalet_de
        sql_field_string    = chalet_id
}

index chaletde
{
    source = chaletde
    path =  /opt/sphinx/indexes/chaletde/chaletde
    docinfo = extern
    morphology = stem_enru, soundex
    min_prefix_len = 2
    enable_star = 1
    charset_type = utf-8
    #html_strip = 1
    #html_remove_elements = style, script, code
}


#############################################################################
## indexer settings
#############################################################################

indexer
{
    mem_limit = 256M
    lemmatizer_cache    = 128M
    lemmatizer_base     = /etc/sphinx/dict/
}

#############################################################################
## searchd settings
#############################################################################

searchd
{
    listen = 127.0.0.1:9306:mysql41

    read_timeout = 5

    client_timeout = 300

    max_children = 100

    pid_file = /var/run/sphinx/searchd.pid

    workers = threads

#    compat_sphinxql_magics = 0

        log                     = /var/log/sphinx/searchd.log
        query_log               = /var/log/sphinx/query.log
}