Ah :) Is Sphinx installed? And is it available through the paths in your current PATH environment variable?
-- Pat On 21/04/2009, at 3:23 PM, Galen wrote: > > Well, that might be important: > > $ indexer --config /Users/galen/Sites/sa/config/ > development.sphinx.conf --all > -bash: indexer: command not found > > > On Apr 21, 2:20 pm, Pat Allan <[email protected]> wrote: >> 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 -~----------~----~----~----~------~----~------~--~---
