CentOS5.5 安装 Sphinx 全文检索joolma

安哥网络

CentOS5.5 安装 Sphinx 全文检索joolma
1. 下载Sphinx最新版 http://www.sphinxsearch.com/downloads.html

2. 安装
# tar -zxvf sphinx-0.9.9.tar.gz
# cd sphinx-0.9.9/
# ./configure --prefix=/usr/local/sphinx --with-mysql-includes=/usr/local/mysql/include/mysql/ --with-mysql-libs=/usr/local/mysql/lib/mysql --with-iconv
# make && make install


../depcomp: line 512: exec: g++: not found
make[2]: *** [my_new.o] 错误 127
make[2]: Leaving directory `/tmp/lamp/mysql-5.0.56/mysys'
make[1]: *** [all-recursive] 错误 1
make[1]: Leaving directory `/tmp/lamp/mysql-5.0.56'
make: *** [all] 错误 2
[root@localhost mysql-5.0.56]#

解决办法：
yum install -y gcc-c++

3. 配置
# cd /usr/local/sphinx/etc
# cp sphinx-min.conf.dist joomla.conf
# vi joomla.conf

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

source joomla_src
{
        type                   = mysql

        sql_host               = localhost
        sql_user               = root
        sql_pass               = 123456
        sql_db                 = joomla
        sql_port               = 3306  # optional, default is 3306

        sql_query              = SELECT * FROM jos_content

        sql_attr_uint          = id
        sql_attr_timestamp     = created

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


index joomla_index
{
        source                 = joomla_src
        path                   = /usr/local/sphinx/var/data/joomla_index
        docinfo                = extern
        charset_type           = utf-8
}


indexer
{
        mem_limit              = 32M
}


searchd
{
        port                   = 9312
        log                    = /usr/local/sphinx/var/log/searchd.log
        query_log              = /usr/local/sphinx/var/log/query.log
        read_timeout           = 5
        max_children           = 30
        pid_file               = /usr/local/sphinx/var/log/searchd.pid
        max_matches            = 1000
        seamless_rotate        = 1
        preopen_indexes        = 0
        unlink_old             = 1
}
保存退出

4. 建立索引
# /usr/local/sphinx/bin/indexer  --config joomla.conf  --all joomla_index

5. 启动sphinx后台服务
# /usr/local/sphinx/bin/searchd -c /usr/local/sphinx/etc/joomla.conf  -i joomla_index &

6. 测试
#/usr/local/php/bin/php-cgi test.php -h localhost -p 9312 -i joomla_index -ph title
X-Powered-By: PHP/5.2.10
Content-type: text/html

Query 'title ' retrieved 16 of 16 matches in 0.001 sec.
Query stats:
    'title' found 61 times in 16 documents

Matches:
1. doc_id=44, weight=2, created=1970-01-01 07:33:27
2. doc_id=1, weight=1, created=1970-01-01 07:33:28
3. doc_id=4, weight=1, created=1970-01-01 07:33:28
4. doc_id=5, weight=1, created=1970-01-01 07:33:28
5. doc_id=10, weight=1, created=1970-01-01 07:33:28
6. doc_id=11, weight=1, created=1970-01-01 07:33:28
7. doc_id=20, weight=1, created=1970-01-01 07:33:28
8. doc_id=21, weight=1, created=1970-01-01 07:33:28
9. doc_id=24, weight=1, created=1970-01-01 07:33:28
10. doc_id=25, weight=1, created=1970-01-01 07:33:28
11. doc_id=26, weight=1, created=1970-01-01 07:33:28
12. doc_id=27, weight=1, created=1970-01-01 07:33:28
13. doc_id=28, weight=1, created=1970-01-01 07:33:28
14. doc_id=30, weight=1, created=1970-01-01 07:33:28
15. doc_id=38, weight=1, created=1970-01-01 07:33:28
16. doc_id=45, weight=1, created=1970-01-01 07:33:27
   

CentOS5.5 安装 Sphinx 全文检索joolma