On Tue, 2013-12-17 at 23:11 +0100, m...@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