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