3,430
edits
Changes
Jump to navigation
Jump to search
Line 2:
Line 2: + + − + − + + − <pre> − You can now configure RT to use the newly-created full-text index by+ − adding the following to your RT_SiteConfig.pm: + Line 23:
Line 25: + Line 28:
Line 31: + Line 70:
Line 74: + −
→More output
== Create Table ==
== Create Table ==
<pre>
CREATE TABLE AttachmentsIndex
CREATE TABLE AttachmentsIndex
(
(
id INTEGER UNSIGNED NOT NULL,
id BIGINT NOT NULL,
weight INTEGER NOT NULL,
weight INTEGER NOT NULL,
query VARCHAR(3072) NOT NULL,
query VARCHAR(3072) NOT NULL,
group_id INTEGER,
group_id INTEGER,
INDEX(query)
INDEX(query)
) ENGINE=SPHINX CONNECTION="sphinx://localhost:9312/test";
) ENGINE=SPHINX CONNECTION="sphinx://127.0.0.1:9312/rt" CHARACTER SET utf8;
</pre>
== More output ==
== More output ==
I added The following to RT_SiteConfig.pm
<pre>
Set( %FullTextSearch,
Set( %FullTextSearch,
Enable => 1,
Enable => 1,
Table => 'AttachmentsIndex',
Table => 'AttachmentsIndex',
);
);
</pre>
Below is a simple Sphinx configuration which can be used to index all
Below is a simple Sphinx configuration which can be used to index all
ideal; you should read the Sphinx documentation to understand how to
ideal; you should read the Sphinx documentation to understand how to
configure it to better suit your needs.
configure it to better suit your needs.
<pre>
source rt {
source rt {
unlink_old = 1
unlink_old = 1
}
}
</pre>
</pre>
== Prime things ==
== Prime things ==