If it helps: my development.sphinx.conf that is generated is:
indexer
{
}
searchd
{
address = 127.0.0.1
port = 9312
log = /Users/iamtoc/execpastor.org/log/searchd.log
query_log = /Users/iamtoc/execpastor.org/log/searchd.query.log
pid_file = /Users/iamtoc/execpastor.org/log/searchd.development.pid
}
source form_entry_core_0
{
type = mysql
sql_host = 10.0.1.5
sql_user = root
sql_pass = Jjnnww58
sql_db = ep_master
sql_port = 0
sql_query_pre = SET NAMES utf8
sql_query_pre = SET TIME_ZONE = '+0:00'
sql_query = SELECT SQL_NO_CACHE `form_entries`.`id` * CAST(1 AS SIGNED) +
0 AS `id` , `form_entries`.`storage_string` AS `storage_string`,
`form_entries`.`id` AS `sphinx_internal_id`, 0 AS `sphinx_deleted`,
2702525659 AS `class_crc` FROM `form_entries` WHERE `form_entries`.`id`
>= $start AND `form_entries`.`id` <= $end GROUP BY `form_entries`.`id`
ORDER BY NULL
sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM
`form_entries`
sql_range_step = 10000000
sql_attr_uint = sphinx_internal_id
sql_attr_uint = sphinx_deleted
sql_attr_uint = class_crc
sql_query_info = SELECT * FROM `form_entries` WHERE `id` = (($id - 0) / 1)
}
index form_entry_core
{
source = form_entry_core_0
path = /Users/iamtoc/execpastor.org/db/sphinx/development/form_entry_core
charset_type = utf-8
}
index form_entry
{
type = distributed
local = form_entry_core
}
and my config/sphinx.conf is:
development:
bin_path: '/usr/local/Cellar/sphinx/0.9.9/bin'
searchd_binary_name: 'searchd'
indexer_binary_name: 'indexer'
pid_file:
enable_star: true
morphology: stem_en
html_strip: true
min_infix_len: 3
port: 9312
sql_range_step: 10000000
min_infix_len: 3
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/thinking-sphinx/-/DuRhzMuWWuoJ.
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.
