首页
学习
活动
专区
圈层
工具
发布
首页
学习
活动
专区
圈层
工具
MCP广场
社区首页 >问答首页 >msyql不与sphinxsearch连接

msyql不与sphinxsearch连接
EN

Stack Overflow用户
提问于 2016-04-27 10:32:50
回答 2查看 991关注 0票数 0

我无法与sphinxsearch mysql -h0 -P3306连接。

错误2003 (HY000):无法连接到'0‘(111)上的MySQL服务器

如何删除此错误?

这是我的配置文件代码sphinx.conf

我们需要开始什么服务吗?

代码语言:javascript
运行
复制
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
{
}
EN

回答 2

Stack Overflow用户

发布于 2016-04-27 14:56:11

mysql -h0 -P3306

在那里,您正在尝试连接到端口3306。为什么?

你好像在监听9306端口

听= 9306:mysql41 41

..。是的,您需要实际运行searchd。在不同的网络分布中,“服务”可以被称为不同的东西。

票数 0
EN

Stack Overflow用户

发布于 2017-06-04 00:56:09

确保sphinx用户对此文件夹具有权限!

chown -R sphinx:sphinx /var/lib/sphinxsearch/

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/36887291

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档