We currently run two RT 4.0.19 systems on Ubuntu 12.04LTS and MySQL 5.5.35. Management is now asking me to enable full text searching on the sites so we can search inside the body of the tickets. From what I've read, our current configuration won't support it due to MySQL 5.5.x not supporting it natively. It looks like I have two options: * Migrate our databases from MySQL 5.5.x to Postgres SQL to get the full text index functionality * Create a new MySQL Server that has the Sphinx add-on running & restore my databases into that.
Has anyone had to do this before? Suggestions? Warnings? Stephen J. Cena Systems Administrator - MIS/IT Dept Quality Vision International 850 Hudson Ave Rochester,NY 14620 Phone: 585-544-0450 x300 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Please report email problems to: [email protected] QVII MIS/IT Dept - We do what we must because we can. "Thank you for helping us help you help us all." * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
-- RT Training London, March 19-20 and Dallas May 20-21 http://bestpractical.com/training
