[LRUG] Sphinx and Sphincter

[Nick Ludlam]

On 30 Jan 2008, at 17:07, Andrew Stewart wrote:

> On 30 Jan 2008, at 16:43, Nick Ludlam wrote:
>> I've been using Sphinx trunk and Ultrasphinx, successfully indexing a
>> large, simplistic data set (2 columns).
>>
>> I'd be happy to lend another pair of eyes to the problem. Is the
>> problem with Sphinx or your plugin?
>
> Hi Nick,
>
> Thanks for offering to help.  I appreciate it.
>
> I'm not sure whether the problem lies with (my installation of)
> Sphinx or with the plugin.  I'm going to try to find out by getting
> Sphinx to generate an index from the command line.  Do you have any
> pointers for doing this?
>
> I wrote up my problem here:
>
> http://rubyforge.org/tracker/index.php?
> func=detail&aid=17589&group_id=1513&atid=5922
>
> If I can show the problem lies with the plugin then I'll go with
> Ultrasphinx instead.  On the other hand I may have simply mis-
> installed Sphinx.


Well from the looks of it, the initial index is failing. You're  
getting a bunch
of warnings about deprecated configuration statements, but that's OK as
I had the same when running the snapshot of 0.9.8. You just comment
them out with no ill effects.

The main problem is that the index is not reporting any errors , as  
far as
I can tell from the rake output. Searchd is failing to find any index  
files:
   WARNING: index 'users': preload: failed to open /path/to/app/sphinx/ 
development/users.sph: No such file or directory;
The files that sphinx indexing has created on my system are:

/opt/sphinx/var/data/sphinx_index_complete.spa
/opt/sphinx/var/data/sphinx_index_complete.spd
/opt/sphinx/var/data/sphinx_index_complete.sph
/opt/sphinx/var/data/sphinx_index_complete.spi
/opt/sphinx/var/data/sphinx_index_complete.spm
/opt/sphinx/var/data/sphinx_index_complete.spp

So can you run the index by hand, as you mentioned?

   /opt/sphinx/bin/indexer --config <your sphinx file> users

What does it say then?

Also comment out the following lines in your 'source' section:

   #index_html_attrs =
   #sql_group_column = sphincter_index_id
   #strip_html = 0

to get the output cleaned up.


Nick

--
Nick Ludlam
nick at recoil.org