What's the output of the following, when you run it in Terminal:
indexer --config /Users/galen/Sites/sa/config/
development.sphinx.conf --all
On 21/04/2009, at 3:18 PM, Galen wrote:
>
> Yep, there is.
>
> Here's the entire configuration file.
>
> Is there anyway I can see more about what's going wrong? (The logfile
> isn't writing!)
>
> indexer
> {
> }
>
> searchd
> {
> address = 127.0.0.1
> port = 3312
> log = /Users/galen/Sites/sa/log/searchd.log
> query_log = /Users/galen/Sites/sa/log/searchd.query.log
> pid_file = /Users/galen/Sites/sa/log/searchd.development.pid
> }
>
> source share_core_0
> {
> type = mysql
> sql_host = localhost
> sql_user = root
> sql_pass =
> sql_db = sharearchy_development
> sql_sock = /tmp/mysql.sock
> sql_query_pre = SET NAMES utf8
> sql_query = SELECT `shares`.`id` * 1 + 0 AS `id` , CAST
> (`shares`.`title` AS CHAR) AS `title`, CAST(`shares`.`description` AS
> CHAR) AS `description`, UNIX_TIMESTAMP(`shares`.`created_at`) AS
> `created_at`, `shares`.`active` AS `active`, `shares`.`id` AS
> `sphinx_internal_id`, 784839262 AS `class_crc`, '784839262' AS
> `subclass_crcs`, 0 AS `sphinx_deleted` FROM shares WHERE
> `shares`.`id` >= $start AND `shares`.`id` <= $end GROUP BY
> `shares`.`id` ORDER BY NULL
> sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1)
> FROM `shares`
> sql_attr_uint = sphinx_internal_id
> sql_attr_uint = class_crc
> sql_attr_uint = sphinx_deleted
> sql_attr_bool = active
> sql_attr_timestamp = created_at
> sql_attr_multi = uint subclass_crcs from field
> sql_query_info = SELECT * FROM `shares` WHERE `id` = (($id - 0) /
> 1)
> }
>
> index share_core
> {
> source = share_core_0
> path = /Users/galen/Sites/sa/db/sphinx/development/share_core
> morphology = stem_en
> charset_type = utf-8
> }
>
> index share
> {
> type = distributed
> local = share_core
> }
>
>
> On Apr 21, 2:12 pm, Pat Allan <[email protected]> wrote:
>> Hi Galen
>>
>> Is there a source declaration (share_core_0) in the config file?
>> Because if there is, thenindexingshould at least *try* to index it.
>>
>> --
>> Pat
>>
>> On 21/04/2009, at 3:10 PM, Galen wrote:
>>
>>
>>
>>> Thanks for your prompt reply!
>>
>>> I used script/console to find and create new records on themodel, so
>>> it seems to be alright.
>>
>>> Here's the source of mymodel:
>>
>>> class Share < ActiveRecord::Base
>>> belongs_to :user
>>
>>> define_index do
>>> indexes title
>>> indexes description
>>
>>> has created_at
>>> has active
>>
>>> end
>>
>>> end
>>
>>> Also, here's the end of the configuration file:
>>
>>> index share_core
>>> {
>>> source = share_core_0
>>> path = /Users/galen/Sites/sa/db/sphinx/development/share_core
>>> morphology = stem_en
>>> charset_type = utf-8
>>> }
>>
>>> index share
>>> {
>>> type = distributed
>>> local = share_core
>>> }
>>
>>> Just to make sure it wasn't an issue with Sphinx I reconfigured,
>>> remade and reinstalled it.
>>> Is there a specific Sphinx version that works best? I'm on the
>>> 0.9.8.1
>>> stable.
>>
>>> Is there a way to force TS to check mymodel?
>>
>>> Thanks for your attention!
>>> Galen
>>
>>> On Apr 21, 8:24 am, Pat Allan <[email protected]> wrote:
>>>> Hi Galen
>>
>>>> Sphinx is fine with one record or one million, so that shouldn't be
>>>> the problem. For some reason though, it'snotpicking up the fact
>>>> that
>>>> you've indexed themodel.
>>
>>>> If you fire up script/console and invoke themodelitself, are there
>>>> any errors? Because if Rails (and thus Thinking Sphinx) can't load
>>>> the
>>>> model, that'd be why it'snotindexing(and if it'snotindexing,
>>>> it's
>>>> notgoing to start the daemon either). You don't need to run the
>>>> tasks
>>>> with sudo either - bestnotto, to avoid any permissions issues.
>>
>>>> Cheers
>>
>>>> --
>>>> Pat
>>
>>>> On 21/04/2009, at 1:08 AM, Galen wrote:
>>
>>>>> Hi, first post here.
>>
>>>>> The rake files don't seem to beindexing. I've searched around but
>>>>> can't figure anything out.
>>
>>>>> Here's what I've got so far:
>>
>>>>> I've installed Sphinx on OS X, with a flag pointing it to the
>>>>> mysql
>>>>> installation.
>>>>> Then I installed thinking_sphinx via git as per the instructions
>>>>> on
>>>>> http://ts.freelancing-gods.com/usage.html. I'm on Rails 2.3.2 so I
>>>>> used the script/plugin install method.
>>
>>>>> I wrote my define_index on mymodelas such:
>>
>>>>> define_index do
>>>>> indexes title
>>>>> indexes description
>>
>>>>> has created_at
>>>>> has active
>>
>>>>> end
>>
>>>>> Then ran the rakes (I ran them with sudo and without):
>>
>>>>> $ sudo rake thinking_sphinx:index
>>>>> (in /Users/galen/Sites/sa)
>>>>> Generating Configuration to /Users/galen/Sites/sa/config/
>>>>> development.sphinx.conf
>>>>> indexer --config /Users/galen/Sites/sa/config/
>>>>> development.sphinx.conf
>>>>> --all
>>
>>>>> $ sudo rake thinking_sphinx:start
>>>>> (in /Users/galen/Sites/sa)
>>>>> searchd --pidfile --config /Users/galen/Sites/sa/config/
>>>>> development.sphinx.conf
>>>>> Failed to start searchd daemon. Check /Users/galen/Sites/sa/log/
>>>>> searchd.log.
>>
>>>>> The log file is empty, as is db/sphinx/development.
>>
>>>>> I went through my config file, and as far as I can tell,
>>>>> everything is
>>>>> set correctly. I'll attach it if you think it's especially
>>>>> relevant.
>>
>>>>> One maybe important thing: my database is super small. 8 test
>>>>> records,
>>>>> as I'm just developing right now. Could that bother sphinx? Does
>>>>> it
>>>>> need millions of records?
>>
>>>>> Any ideas?
> >
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
