We’re using RT 4.4.4 with MySQL 5.7, and working on full text searching. It’s quite confusing as there are many web pages out there saying it doesn’t work and you have to use something like Sphinx, however my understanding is that it will work in MySQL 5.6 and above.
We’ve run /opt/rt4/sbin/rt-setup-fulltext-index and it apparently completed successfully, and after adding the %FullTextSearch bit to our configuration under /etc/request-tracker4/RT_SiteConfig.d full text searches appear to be working. The words “You can search for any word in full ticket history by typing fulltext: word” appear on the Search page. So far so good…
We then ran /opt/rt4/sbin/rt-fulltext-indexer which as per the documentation is needed to keep the indexes up to date, however it gives an error:
Full text search is disabled in your RT configuration. Run /opt/rt4/sbin/rt-setup-fulltext-index to configure and enable it.
This error is incorrect as full text searches are enabled in the RT configuration, as evidenced by it being available on RT’s Search page. So my questions are:
- Can someone confirm whether we really need to run rt-setup-fulltext-index?
- How can we fix this “Full text search is disabled in your RT configuration” error?
Thanks very much for any assistance.