Sphinx на Alto CMS

source multiSource
{
type=mysql
sql_host=localhost
sql_user=user
sql_pass=pass
sql_db=base_1
sql_port=3306
sql_sock=/var/run/mysqld/mysqld.sock
mysql_connect_flags=32
sql_query_pre=SET NAMES utf8
sql_query_pre=SET SESSION query_cache_type=OFF
}
source multiTopics : multiSource
{
sql_query= \
SELECT t_fast.topic_id, t_fast.topic_title, UNIX_TIMESTAMP(t_fast.topic_date_add) as topic_date_add, \
                tc.topic_text, t_fast.topic_publish \
                FROM prefix_topic as t_fast, prefix_topic_content AS tc \
                WHERE t_fast.topic_id=tc.topic_id AND t_fast.topic_id>=$start AND t_fast.topic_id<=$end

sql_query_range=SELECT MIN(topic_id),MAX(topic_id) FROM prefix_topic
sql_range_step=1000
sql_attr_uint=topic_publish
sql_attr_timestamp=topic_data_add
sql_attr_multi=uint tag from query; SELECT topic_id, topic_tag_id FROM prefix_topic_tag
sql_ranged_throttle=0
}
source multiComments : multiSource
{
sql_query=\
                        SELECT comment_id, comment_text, UNIX_TIMESTAMP(comment_date) as comment_date, comment_delete \
                        FROM prefix_comment \
                       WHERE target_type='topic' AND comment_id>=$start AND comment_id<=$end


sql_query_range=SELECT MIN(comment_id),MAX(comment_id) FROM prefix_comment
sql_range_step=5000
sql_attr_uint=comment_delete
sql_attr_timestamp=comment_date
}
index multitopicsIndex
{
source=multiTopics
path=/var/lib/data/multiTopics
docinfo=extern
mlock=0
morphology=stem_enru
charset_type=utf-8
html_strip=1
html_remove_elements=style,script,code
}
index multicommentsIndex
{
source=multiComments
path=/var/lib/data/multiComments
docinfo=extern
mlock=0
morphology=stem_enru
charset_type=utf-8
html_strip=1
html_remove_elements=style,script,code
}

####################################################################################
source ptzonlineSource
{
type=mysql
sql_host=localhost
sql_user=user
sql_pass=pass
sql_db=base_2
sql_port=3306
sql_sock=/var/run/mysqld/mysqld.sock
mysql_connect_flags=32
sql_query_pre=SET NAMES utf8
sql_query_pre=SET SESSION query_cache_type=OFF
}
source ptzonlineTopics : ptzonlineSource
{
sql_query= \
SELECT t_fast.topic_id, t_fast.topic_title, UNIX_TIMESTAMP(t_fast.topic_date_add) as topic_date_add, \
                tc.topic_text, t_fast.topic_publish \
                FROM prefix_topic as t_fast, prefix_topic_content AS tc \
                WHERE t_fast.topic_id=tc.topic_id AND t_fast.topic_id>=$start AND t_fast.topic_id<=$end

sql_query_range=SELECT MIN(topic_id),MAX(topic_id) FROM prefix_topic
sql_range_step=1000
sql_attr_uint=topic_publish
sql_attr_timestamp=topic_data_add
sql_attr_multi=uint tag from query; SELECT topic_id, topic_tag_id FROM prefix_topic_tag
sql_ranged_throttle=0
}
source ptzonlineComments : ptzonlineSource
{
sql_query=\
                        SELECT comment_id, comment_text, UNIX_TIMESTAMP(comment_date) as comment_date, comment_delete \
                        FROM prefix_comment \
                       WHERE target_type='topic' AND comment_id>=$start AND comment_id<=$end


sql_query_range=SELECT MIN(comment_id),MAX(comment_id) FROM prefix_comment
sql_range_step=5000
sql_attr_uint=comment_delete
sql_attr_timestamp=comment_date
}
index ptzonlinetopicsIndex
{
source=ptzonlineTopics
path=/var/lib/data/ptzonlineTopics
docinfo=extern
mlock=0
morphology=stem_enru
charset_type=utf-8
html_strip=1
html_remove_elements=style,script,code
}
index ptzonlinecommentsIndex
{
source=ptzonlineComments
path=/var/lib/data/ptzonlineComments
docinfo=extern
mlock=0
morphology=stem_enru
charset_type=utf-8
html_strip=1
html_remove_elements=style,script,code
}

########################################################################################

source ptzmediaSource
{
type=mysql
sql_host=localhost
sql_user=user
sql_pass=pass
sql_db=base_3
sql_port=3306
sql_sock=/var/run/mysqld/mysqld.sock
mysql_connect_flags=32
sql_query_pre=SET NAMES utf8
sql_query_pre=SET SESSION query_cache_type=OFF
}
source ptzmediaTopics : ptzmediaSource
{
sql_query= \
SELECT t_fast.topic_id, t_fast.topic_title, UNIX_TIMESTAMP(t_fast.topic_date_add) as topic_date_add, \
                tc.topic_text, t_fast.topic_publish \
                FROM alto_topic as t_fast, alto_topic_content AS tc \
                WHERE t_fast.topic_id=tc.topic_id AND t_fast.topic_id>=$start AND t_fast.topic_id<=$end

sql_query_range=SELECT MIN(topic_id),MAX(topic_id) FROM alto_topic
sql_range_step=1000
sql_attr_uint=topic_publish
sql_attr_timestamp=topic_data_add
sql_attr_multi=uint tag from query; SELECT topic_id, topic_tag_id FROM alto_topic_tag
sql_ranged_throttle=0
}
source ptzmediaComments : ptzmediaSource
{
sql_query=\
                        SELECT comment_id, comment_text, UNIX_TIMESTAMP(comment_date) as comment_date, comment_delete \
                        FROM alto_comment \
                       WHERE target_type='topic' AND comment_id>=$start AND comment_id<=$end


sql_query_range=SELECT MIN(comment_id),MAX(comment_id) FROM alto_comment
sql_range_step=5000
sql_attr_uint=comment_delete
sql_attr_timestamp=comment_date
}
index ptzmediatopicsIndex
{
source=ptzmediaTopics
path=/var/lib/data/ptzmediaTopics
docinfo=extern
mlock=0
morphology=stem_enru
charset_type=utf-8
html_strip=1
html_remove_elements=style,script,code
}
index ptzmediacommentsIndex
{
source=ptzmediaComments
path=/var/lib/data/ptzmediaComments
docinfo=extern
mlock=0
morphology=stem_enru
charset_type=utf-8
html_strip=1
html_remove_elements=style,script,code
}

indexer
{
mem_limit=512M
}searchd
{
listen=127.0.0.1:3312
log=/var/log/sphinx/searchd.log
query_log=/var/log/sphinx/query.log
read_timeout=5
max_children=30
pid_file=/var/log/sphinx/searchd.pid
max_matches=100000
}

$config['host'] = '127.0.0.1:3312';
$config['db_socket'] = '/var/run/mysqld/mysqld.sock';

$config['prefix'] = Config::Get('db.params.dbname') . '_' . Config::Get('db.table.prefix');

$config['path'] = '/var/lib/sphinxsearch/';

return $config;

Exception: Class "ModuleSphinx" not found!
See details in error.log

WARNING: index 'alto_prefix_topicsIndex': preload: failed to open /var/lib/data/data/alto_prefix_data/topicsIndex.sph: No such file or directory; NOT SERVING
precaching index 'alto_prefix_commentsIndex'
WARNING: index 'alto_prefix_commentsIndex': preload: failed to open /var/lib/data/data/alto_prefix_data/commentsIndex.sph: No such file or directory; NOT SERVING

indexing index 'alto_prefix_topicsIndex'...
ERROR: index 'alto_prefix_topicsIndex': sql_connect: Can't connect to local MySQL server through socket '' (111) (DSN=mysql://zaox:***@localhost:3306/sovunion).
total 0 docs, 0 bytes
total 0.000 sec, 0 bytes/sec, 0.00 docs/sec
indexing index 'alto_prefix_commentsIndex'...
ERROR: index 'alto_prefix_commentsIndex': sql_connect: Can't connect to local MySQL server through socket '' (111) (DSN=mysql://zaox:***@localhost:3306/sovunion).