version 2.0.8-1 rpm package for EL6 On Dec 1, 2014, at 9:21 AM, Alex Vandiver <ale...@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 >> http://dev.mysql.com/doc/refman/5.6/en/innodb-fulltext-index.html > > 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. >> https://mariadb.com/kb/en/mariadb/documentation/storage-engines/sphinx-storage-engine/about-sphinxse/ > > 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 >
-- Jo Rhett +1 (415) 999-1798 Skype: jorhett Net Consonance : net philanthropy to improve open source and internet projects.