User:Hef/rt search: Difference between revisions

@@ Line 1: / Line 1: @@
 Log into mariadb as root and run <code>INSTALL SONAME 'ha_sphinx';</code> then <code>show engines;</code> to confirm it worked
+== Create Table ==
+CREATE TABLE AttachmentsIndex
+(
+    id          INTEGER UNSIGNED NOT NULL,
+    weight      INTEGER NOT NULL,
+    query       VARCHAR(3072) NOT NULL,
+    group_id    INTEGER,
+    INDEX(query)
+) ENGINE=SPHINX CONNECTION="sphinx://localhost:9312/test";
+== More output ==
 <pre>
-Going to run the following in the DB:
-    CREATE TABLE AttachmentsIndex (
-        id     BIGINT NOT NULL,
-        weight INTEGER NOT NULL,
-        query  VARCHAR(3072) NOT NULL,
-        INDEX(query)
-    ) ENGINE=SPHINX CONNECTION="sphinx://127.0.0.1:3312/rt" CHARACTER SET utf8
 You can now configure RT to use the newly-created full-text index by
@@ Line 58: / Line 59: @@
 searchd {
-     port                    = 3312
+     port                    = 9312
      log                     = /opt/rt4/var/sphinx/searchd.log
      query_log               = /opt/rt4/var/sphinx/query.log