[rt-users] docs improvement suggestion for full-text searching

[Jo Rhett]

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.
	https://mariadb.com/kb/en/mariadb/documentation/storage-engines/sphinx-storage-engine/about-sphinxse/

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

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 

Easy fixes…

-- 
Jo Rhett
+1 (415) 999-1798
Skype: jorhett
Net Consonance : net philanthropy to improve open source and internet projects.