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 (
id INTEGER UNSIGNED NOT NULL,
weight INTEGER NOT NULL,
query VARCHAR(3072) NOT NULL,
INDEX(query)
) ENGINE=SPHINX CONNECTION="sphinx://rtserver.org:9312/rt" CHARACTER SET
utf8
Is this correct or should the SPHINX CONNECTION be the localhost? Thanks.
--Dale
---------------------------------------
Dale Poulter
Coordinator, Search and Core Services
Library Digital Services
Vanderbilt University
419 21st Avenue South, Room 812
Nashville, TN 37203-2427
(615)343-5388
(615)343-8834 (fax)
(615)207-9705 (cell)
[email protected]<mailto:[email protected]>
