[rt-users] Table creation question (v4.0.6)

Poulter, Dale dale.poulter at Vanderbilt.Edu
Wed Jun 13 11:02:35 EDT 2012

Good morning,

We are upgrading to  4.0.6 and changing our architecture a little.  We will be running RT on one server and connect to the database on another server.  This works fine for most functions but I am attempting to determine how the sphinx server should be setup.  This is how I THINK is should be but would like to hear back from anyone that has attempted this scenario

DB server:  mysql
Sphinx should run on the RT server and not the Sphinx server.

Creation of Attachementsindex should be

CREATE TABLE AttachmentsIndex (
        weight INTEGER NOT NULL,
        query  VARCHAR(3072) NOT NULL,
    ) ENGINE=SPHINX CONNECTION="sphinx://rtserver.org:9312/rt" CHARACTER SET utf8

Is this correct or should the SPHINX CONNECTION be the localhost?  Thanks.


Dale Poulter
Coordinator, Search and Core Services
Library Digital Services
Vanderbilt University
419 21st Avenue South, Room 812
Nashville, TN  37203-2427
(615)343-8834 (fax)
(615)207-9705 (cell)
dale.poulter at vanderbilt.edu<mailto:dale.poulter at vanderbilt.edu>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120613/9c7d3f08/attachment.htm>

More information about the rt-users mailing list