[rt-users] RES: RE: RES: Sphinx fulltext index v4.0.4

[Alex Vandiver]

On Tue, 2013-12-17 at 23:11 +0100, ms at fv-berlin.de wrote:
> didn't get a response there. Is there a way to solve this? Possibly
> through debugging RT4 to see how its actually trying to connect to
> searchd instead of how the config looks like it should?

This lies firmly in the domain of having to debug MySQL and the SphinxSE
plugin, and not in debugging RT itself.  From recent testing locally,
using 127.0.0.1 instead of localhost works acceptably.  Future versions
of RT may default to 127.0.0.1 instead of localhost in the Sphinx
connection parameters --  though I would be much more comfortable making
that change if the underlying reason for the 'localhost' failure were
clear.  Unfortunately, debugging mysql is rather complex.

You can drop and re-create your SphinxSE table by running 'DROP TABLE
AttachmentsIndex' at a mysql prompt, re-running rt-setup-fulltext-index,
and providing sphinx://127.0.0.1:3312/rt as the URL of the Sphinx
server.

 - Alex