No worries - good to get it all sorted. Cheers
-- Pat On 21/04/2009, at 3:27 PM, Galen wrote: > > Got it. > > Edited the path variable and voila. > > Thanks for your incredibly prompt replies :) Have a great morning / > afternoon / night. > > On Apr 21, 2:23 pm, Galen <[email protected]> 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 -~----------~----~----~----~------~----~------~--~---
