我无法与sphinxsearch mysql -h0 -P3306连接。
错误2003 (HY000):无法连接到'0‘(111)上的MySQL服务器
如何删除此错误?
这是我的配置文件代码sphinx.conf
我们需要开始什么服务吗?
source src1
{
type = mysql
sql_host = localhost
sql_user = root
sql_pass = india@123
sql_db = test
sql_port = 3306
sql_query = \
SELECT id, group_id, UNIX_TIMESTAMP(date_added) AS date_added, title, content \
FROM documents
sql_attr_uint = group_id
sql_attr_timestamp = date_added
sql_ranged_throttle = 0
sql_query_info = SELECT * FROM documents WHERE id=$id
}
source src1throttled : src1
{
sql_ranged_throttle = 100
}
index test1
{
source = src1
path = /var/lib/sphinxsearch/data/test1
docinfo = extern
dict = keywords
mlock = 0
morphology = none
min_word_len = 1
html_strip = 0
}
index test1stemmed : test1
{
path = /var/lib/sphinxsearch/data/test1stemmed
morphology = stem_en
}
index dist1
{
type = distributed
local = test1
local = test1stemmed
agent = localhost:9313:remote1
agent = localhost:9314:remote2,remote3
agent_connect_timeout = 1000
agent_query_timeout = 3000
}
index rt
{
type = rt
path = /var/lib/sphinxsearch/data/rt
rt_field = title
rt_field = content
rt_attr_uint = gid
}
indexer
{
mem_limit = 128M
}
searchd
{
listen = 9312
listen = 9306:mysql41
log = /var/log/sphinxsearch/searchd.log
query_log = /var/log/sphinxsearch/query.log
read_timeout = 5
client_timeout = 300
max_children = 30
persistent_connections_limit = 30
pid_file = /var/run/sphinxsearch/searchd.pid
seamless_rotate = 1
preopen_indexes = 1
unlink_old = 1
mva_updates_pool = 1M
max_packet_size = 8M
max_filters = 256
max_filter_values = 4096
max_batch_queries = 32
workers = threads # for RT to work
}
common
{
}发布于 2016-04-27 14:56:11
mysql -h0 -P3306
在那里,您正在尝试连接到端口3306。为什么?
你好像在监听9306端口
听= 9306:mysql41 41
..。是的,您需要实际运行searchd。在不同的网络分布中,“服务”可以被称为不同的东西。
发布于 2017-06-04 00:56:09
确保sphinx用户对此文件夹具有权限!
chown -R sphinx:sphinx /var/lib/sphinxsearch/
https://stackoverflow.com/questions/36887291
复制相似问题