I am currently have installed sphinx and using thinking
sphinx v2.0.5. Currently i am using rails 3.0.7 and ruby 1.9.2-p180.
I am using sphinx 0.9.9. I have followed instructions on thinking
sphinx and after fixing some problems was able to install sphinx using
source and it was successful. I have set up indexes on on my model
file name "Recipe" on a simple db column recipeName of type string. I
am using phusion passenger server. Right now i am working on
development server.
This is the index i have defined in my model file:
define_index do
indexes :recipeName
end
After this i have started the rake task for generating configure,then
rake task for build index and started the rake task for searchd
daemon.
Now the problem is i am able to search from the database using rails/
console by using command:
Recipe.search "Query"
and i do get results. I then also tried a command to search from the
application directory and i again got results. The problem is when i
used the same query of
Recipe.search "Query"
i got no results...actually nothing happens...i don't even get an
error from my development log or nginx error file.
I noticed then when i use the command form rails/console i do get an
entry in searchd.query.log file but when i use the same command from
one of controller action there is no entry in this log file which
tells me that even the call is not going to the searchd daemon.
The only configuration file for sphinx is config/
development.sphinx.conf and i can't find any problem. This file was
automatically created when i use index rake task. I have not declared
any configuration for sphinx. Here is the configuration file...i have
intentionally commented out username and password:
indexer
{
}
searchd
{
listen = 127.0.0.1:9312
log = /Users/jawadrashid/RecipeProject/log/searchd.log
query_log = /Users/jawadrashid/RecipeProject/log/searchd.query.log
pid_file = /Users/jawadrashid/RecipeProject/log/
searchd.development.pid
}
source recipe_core_0
{
type = mysql
sql_host = localhost
sql_user = **********
sql_pass = *********
sql_db = RecipeProject_dev
sql_query_pre = SET NAMES utf8
sql_query_pre = SET TIME_ZONE = '+0:00'
sql_query = SELECT SQL_NO_CACHE `recipes`.`id` * CAST(1 AS SIGNED) +
0 AS `id` , `recipes`.`recipeName` AS `recipeName`, `recipes`.`id` AS
`sphinx_internal_id`, 0 AS `sphinx_deleted`, 3710170113 AS `class_crc`
FROM `recipes` WHERE (`recipes`.`id` >= $start AND `recipes`.`id` <=
$end) GROUP BY `recipes`.`id`, `recipes`.`recipeName`, `recipes`.`id`
ORDER BY NULL
sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1)
FROM `recipes`
sql_attr_uint = sphinx_internal_id
sql_attr_uint = sphinx_deleted
sql_attr_uint = class_crc
sql_query_info = SELECT * FROM `recipes` WHERE `id` = (($id - 0) /
1)
}
index recipe_core
{
source = recipe_core_0
path = /Users/jawadrashid/RecipeProject/db/sphinx/development/
recipe_core
charset_type = utf-8
}
index recipe
{
type = distributed
local = recipe_core
}
I don't know what is the problem. I have tried many things by
following common problems and solutions on google but i am not able to
understand what i am doing wrong as i am getting results from rails
console but not from any controller action.
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/thinking-sphinx?hl=en.
