blocks|key|1564039|text|Thinking使用mysql作为内部用途，您必须将mysql2+gem添加到堆栈中，例如：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1564040|gem+'mysql2',+'~>+0.3.13'
gem+'thinking-sphinx',+'~>+3.1.1'|code-block|syntax|javascript|1564041|entityMap^0|Q|6|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

Thinking Sphinx uses mysql for its internal purposes and you have to add <code>mysql2</code> gem to your stack, e.g:

<pre><code>gem 'mysql2', '~&gt; 0.3.13'
gem 'thinking-sphinx', '~&gt; 3.1.1'
</code></pre>

blocks|key|2842073|text|ts:index任务只存储狮身人面像数据，它不启动响应搜索请求的守护进程。您需要运行ts:start+rake任务才能实现这一点。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2842074|另外：ts:rebuild同时完成了所有这一切:停止Sphinx+(如果它正在运行)，索引数据，启动Sphinx。|2842075|entityMap^0|0|8|16|8|0|3|A|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|R|8|@]|D|@]|E|$]]]|I|$]]

The <code>ts:index</code> task just stores the Sphinx data, it doesn't start the daemon which responds to search requests. You need to run <code>ts:start</code> rake task for this to happen.

Also: <code>ts:rebuild</code> does all of this at once: stops Sphinx (if it's running), indexes data, starts Sphinx.

blocks|key|2416828|text|我遇到了同样的错误，最后我发现我没有用这个命令在我的本地系统上安装"Sphinx“，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2416829|sudo+apt-get+update
sudo+apt-get+install+sphinxsearch|code-block|syntax|javascript|2416830|关于安装的更多细节，您可以在这里找到|2416831|https://www.digitalocean.com/community/tutorials/how-to-install-and-configure-sphinx-on-ubuntu-14-04
|blockquote|offset|length|2416832|2416833|确保您还应该在您的系统上安装"mysql-server“来创建连接。|2416834|另外，我看了看，布勒普的回答是我的第二步。你也应该包括那些宝石，这样才能和斯芬克斯一起跑。|2416835|然后移到@pat的答案，这是我要走的最后一步，当你安装了狮身人面像时，它会启动服务，但是你需要停止服务才能运行，|2416836|rake+ts:index
rake+ts:rebuild|2416837|跟狮身人面像一起去。|2416838|entityMap|0|LINK|mutability|MUTABLE|url|https://www.digitalocean.com/community/tutorials/how-to-install-and-configure-sphinx-on-ubuntu-14-04^0|0|0|0|0|2S|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|16|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|17|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|18|8|@]|9|@]|A|$]]|$1|I|3|J|5|K|7|19|8|@]|9|@$L|1A|M|1B|1|1C]]|A|$]]|$1|N|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|1E|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1F|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1G|8|@]|9|@]|A|$]]|$1|U|3|V|5|D|7|1H|8|@]|9|@]|A|$E|F]]|$1|W|3|X|5|6|7|1I|8|@]|9|@]|A|$]]|$1|Y|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]]|Z|$10|$5|11|12|13|A|$14|15]]]]

I was stuck at all and facing the same error, Finally I found that I have not installed "Sphinx" on my local system with this command,

<pre><code>sudo apt-get update
sudo apt-get install sphinxsearch
</code></pre>

More detail regarding installation you can find here

<blockquote>
 <a href="https://www.digitalocean.com/community/tutorials/how-to-install-and-configure-sphinx-on-ubuntu-14-04" rel="nofollow">https://www.digitalocean.com/community/tutorials/how-to-install-and-configure-sphinx-on-ubuntu-14-04</a>
</blockquote>

Make sure you should also have installed "mysql-server" on your system to create connection.

Also I looked @blelump's answer was my second step. You should include those gems too in order to run with sphinx.

Then move to @pat's answer was my final step to go, When you installed sphinx it will start service but you need to stop service to run,

<pre><code>rake ts:index
rake ts:rebuild
</code></pre>

Here to go with SPHINX.

I have a RoR app with Posgresql as database. I'm trying to setup search functionality by using Sphinx as search engine and Thinking Sphinx gem. I've installed sphinx with mysql and postgresql support, thinking sphinx v3 gem and it's dependencies.
The command
<blockquote>
rake ts:index
</blockquote>
performs without errors. Log says that I have 20 docs indexed (all my records of Post model).
Then I've tried to create controller and view for search results page. Here's the Controller's search action
<pre><code>def search
 @query = Riddle::Query.escape(params[:q])
 @posts = Post.search(@query)
end
</code></pre>
And when I try to use @posts variable in search view
<blockquote>
localhost:3000/search?q=hello
</blockquote>
I have following error.
<blockquote>
ThinkingSphinx::ConnectionError in Main#search
Error connecting to Sphinx via the MySQL protocol. Error connecting to Sphinx via the MySQL protocol. Can't connect to MySQL server on '127.0.0.1' (61) - SELECT * FROM <code>post_core</code> WHERE MATCH('hello') AND <code>sphinx_deleted</code> = 0 LIMIT 0, 20; SHOW META
</blockquote>

Sphinx connection error on search results page in Ruby on Rails application

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有一个以Posgresql为数据库的RoR应用程序。我试图通过使用Sphinx作为搜索引擎来设置搜索功能，并考虑Sphinx。我已经安装了mysql和postgresql支持的sphinx，考虑到sphinx v3 gem和它的依赖关系。命令rake ts:索引执行时没有错误。日志说，我有20个文档索引(我的所有记录...

问Rails应用程序中搜索结果页面上的Sphinx连接错误
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Rails应用程序中搜索结果页面上的Sphinx连接错误EN