3,430
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − 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+ − adding the following to your RT_SiteConfig.pm: + Line 20:
Line 25: + Line 25:
Line 31: + Line 56:
Line 63: − + Line 67:
Line 74: + + + + + + + + +
→More output
<pre>
Log into mariadb as root and run <code>INSTALL SONAME 'ha_sphinx';</code> then <code>show engines;</code> to confirm it worked
== Create Table ==
<pre>
CREATE TABLE AttachmentsIndex
(
id BIGINT NOT NULL,
weight INTEGER NOT NULL,
query VARCHAR(3072) NOT NULL,
group_id INTEGER,
INDEX(query)
) ENGINE=SPHINX CONNECTION="sphinx://127.0.0.1:9312/rt" CHARACTER SET utf8;
</pre>
== 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 {
searchd {
searchd {
port = 3312
port = 9312
log = /opt/rt4/var/sphinx/searchd.log
log = /opt/rt4/var/sphinx/searchd.log
query_log = /opt/rt4/var/sphinx/query.log
query_log = /opt/rt4/var/sphinx/query.log
unlink_old = 1
unlink_old = 1
}
}
</pre>
</pre>
== Prime things ==
sudo groupadd sphinx
sudo useradd -g sphinx -d /usr/share/sphinx/ -s /bin/false sphinx
sudo chown -R sphinx:sphinx /var/lib/sphinx/
sudo -u sphinx indexer --all
sudo systemctl start sphinx