[rt-users] docs improvement suggestion for full-text searching
jrhett at netconsonance.com
Mon Dec 1 16:11:22 EST 2014
version 2.0.8-1 rpm package for EL6
On Dec 1, 2014, at 9:21 AM, Alex Vandiver <alexmv at bestpractical.com> wrote:
> On 11/28/2014 03:12 AM, Jo Rhett wrote:
>> 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
> At the time the documentation was written, MySQL only had FTS support
> using MyISAM, not InnoDB. Commits 84066c4 and 77641fc on the unmerged
> 4.2/mysql-native-fts branch clarify the topic, as well as implement
> native FTS support.
>> Likewise, MariaDB has Sphinx support compiled in and available in
>> their packages, which made this process almost trivial to enable.
> RT doesn't officially support MariaDB -- though this is almost purely
> because of lack of documentation and testing infrastucture, not because
> it is known to have failure modes. When MariaDB support is added, the
> Sphinx integration will be noted.
>> 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
>> mkdir /opt/rt4/var/sphinx
>> chown -R sphinx:sphinx /opt/rt4/var/sphinx
> Noted in
>> 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
> What version of sphinx? Neither of those are necessary with 2.0.
> - Alex
+1 (415) 999-1798
Net Consonance : net philanthropy to improve open source and internet projects.
More information about the rt-users