[rt-users] docs improvement suggestion for full-text searching
jrhett at netconsonance.com
Fri Nov 28 03:12:21 EST 2014
On Nov 27, 2014, at 6:55 AM, Alex Vandiver <alexmv at bestpractical.com> wrote:
> On 11/26/2014 06:35 PM, Jo Rhett wrote:
>> However [doc/full_text_indexing] contains only information on how to
>> enable full text indexing, and no information on how to enable it
>> without the indexing.
> Mostly because we're afraid of users shooting themselves in the foot.
> Regardless, I've committed 2551dca5 which details how to do so.
> - Alex
Understood. Just a clarity nitpick :) Although I am confused by your statements that full text indexing isn’t available in MySQL. I’ve used this quite successfully in the past http://dev.mysql.com/doc/refman/5.6/en/innodb-fulltext-index.html
Likewise, MariaDB has Sphinx support compiled in and available in their packages, which made this process almost trivial to enable.
I found three problems in the config pushed out by the sbin/rt-setup-fulltext-index command:
1. You need to create and chown the var/sphinx directory it references
chown -R sphinx:sphinx /opt/rt4/var/sphinx
2. You need to add this binlog path line
binlog_path = /opt/rt4/var/sphinx
3. You need to add this compat line or searchd won’t start
compat_sphinxql_magics = 0
+1 (415) 999-1798
Net Consonance : net philanthropy to improve open source and internet projects.
More information about the rt-users