linux sphinx配置问题
linux sphinx配置问题
By ✿青歌◞
at 2017-12-22
0人收藏 • 2979人看过
index PostsIndexes
{
source = kms_db
path = /var/lib/sphinxsearch/data/PostsIndexes
docinfo = extern
charset_type = utf-8
min_word_len = 1
charset_table = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F
ngram_len = 1
ngram_chars = U+3000..U+2FA1F
html_strip = 1
}PostsIndexes 索引配置解析 官方给的配置文件 这个表数据库都没有啊？
test1这个是默认sphinx2.3.2版本安装了的 官方给的配置文件数据库也没有PostsIndexes索引表
@lincanbin
- 登录后方可回帖
11 个回复 | 最后更新于 2017-12-23
lincanbin
2017-12-22
#1
PostsIndexes不是表，只是Sphinx索引。
✿青歌◞
2017-12-22
#2
✿青歌◞
2017-12-22
#3
回复#1 @lincanbin :
indexing index 'test1'... ERROR: index 'test1': sql_query: Table 'wk.documents' doesn't exist (DSN=mysql://wk:***@localhost:3306/wk).
✿青歌◞
2017-12-22
#4
回复#3 @✿青歌◞ :
官方给的sphinx.conf 文件是linux用的还是WIN
✿青歌◞
2017-12-22
#5
回复#1 @lincanbin :
Sphinx 2.3.2-id64-beta (4409612) Copyright (c) 2001-2016, Andrew Aksyonoff Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com) using config file '/usr/local/sphinx/etc/sphinx.conf'... WARNING: key 'sql_query_info' was permanently removed from Sphinx configuration. Refer to documentation for details. WARNING: key 'charset_type' was permanently removed from Sphinx configuration. Refer to documentation for details. indexing index 'test1'... collected 2674 docs, 7.1 MB sorted 2.3 Mhits, 100.0% done total 2674 docs, 7052678 bytes total 0.787 sec, 8959410 bytes/sec, 3396.93 docs/sec indexing index 'test1stemmed'... collected 2674 docs, 7.1 MB sorted 2.3 Mhits, 100.0% done total 2674 docs, 7052678 bytes total 0.884 sec, 7976473 bytes/sec, 3024.25 docs/sec skipping non-plain index 'dist1'... skipping non-plain index 'rt'... total 8 reads, 0.006 sec, 1611.8 kb/call avg, 0.8 msec/call avg total 48 writes, 0.020 sec, 559.9 kb/call avg, 0.4 msec/call avg
我现在生成索引成功了 配置文件也填写了 但是前台搜索了无法显示结果
✿青歌◞
2017-12-22
#6
回复#1 @lincanbin :
using config file '/usr/local/sphinx/etc/sphinx.conf'... WARNING: key 'sql_query_info' was permanently removed from Sphinx configuration. Refer to documentation for details. WARNING: key 'charset_type' was permanently removed from Sphinx configuration. Refer to documentation for details. indexing index 'PostsIndexes'... collected 2683 docs, 7.1 MB sorted 2.3 Mhits, 100.0% done total 2683 docs, 7080342 bytes total 0.769 sec, 9199490 bytes/sec, 3486.02 docs/sec total 4 reads, 0.003 sec, 1618.5 kb/call avg, 0.9 msec/call avg total 24 writes, 0.009 sec, 562.2 kb/call avg, 0.4 msec/call avg
按照官方的配置生产索引成功 前台搜索显示不了500错误
@lincanbin
lincanbin
2017-12-23
#7
回复#6 @✿青歌◞ :
能给下错误日志吗？
lincanbin
2017-12-23
#8
回复#2 @✿青歌◞ :
哪来的test1？
✿青歌◞
2017-12-23
#9
回复#7 @lincanbin :
110.84.116.6 - - [23/Dec/2017:14:00:41 +0800] "GET /search/%E9%98%B4%E9%98%B3%E5%B8%88?_pjax=%23main&_=1514008832168 HTTP/2.0" 500 0 "https://www.kai.com/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36" 110.84.116.6 - - [23/Dec/2017:14:00:41 +0800] "GET /favicon.ico HTTP/2.0" 200 16958 "https://www.kai.com/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36" 110.84.116.6 - - [23/Dec/2017:14:00:41 +0800] "GET /search/%E9%98%B4%E9%98%B3%E5%B8%88 HTTP/2.0" 500 0 "https://www.kai.com/" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36"
using config file '/usr/local/sphinx/etc/sphinx.conf'... WARNING: key 'sql_query_info' was permanently removed from Sphinx configuration. Refer to documentation for details. WARNING: key 'charset_type' was permanently removed from Sphinx configuration. Refer to documentation for details. indexing index 'PostsIndexes'... collected 2683 docs, 7.1 MB sorted 2.3 Mhits, 100.0% done total 2683 docs, 7080342 bytes total 0.769 sec, 9199490 bytes/sec, 3486.02 docs/sec total 4 reads, 0.003 sec, 1618.5 kb/call avg, 0.9 msec/call avg total 24 writes, 0.009 sec, 562.2 kb/call avg, 0.4 msec/call avg
前台搜索就显示500 但是索引是创建成功的
✿青歌◞
2017-12-23
#10
✿青歌◞
2017-12-23
#11
