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 -~----------~----~----~----~------~----~------~--~---
