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