User:Hef/rt search: Difference between revisions
From Pumping Station One
| (8 intermediate revisions by the same user not shown) | |||
| Line 6: | Line 6: | ||
CREATE TABLE AttachmentsIndex | CREATE TABLE AttachmentsIndex | ||
( | ( | ||
id | 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:// | ) ENGINE=SPHINX CONNECTION="sphinx://127.0.0.1:9312/rt" CHARACTER SET utf8; | ||
</pre> | </pre> | ||
== More output == | == More output == | ||
I added The following to RT_SiteConfig.pm | |||
<pre> | |||
Set( %FullTextSearch, | Set( %FullTextSearch, | ||
Enable => 1, | Enable => 1, | ||
| Line 26: | Line 25: | ||
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 | ||
| Line 31: | Line 31: | ||
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 { | ||
| Line 73: | Line 74: | ||
unlink_old = 1 | unlink_old = 1 | ||
} | } | ||
</pre> | </pre> | ||
== Prime things == | == Prime things == | ||
