<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>Greetings,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>We are testing an upgrade to version 4.0.4 from 3.8.7. The upgrade went fine and we are able to view, submit, edit, etc. We also want to implement the fulltext index using sphinx. We have compiled sphinx, added it to mysql as a plugin and successfully ran the sbin/rt-setup-fulltext-index script. We also added:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Set( %FullTextSearch,<o:p></o:p></p><p class=MsoNormal> Enable => 1,<o:p></o:p></p><p class=MsoNormal> Indexed => 1,<o:p></o:p></p><p class=MsoNormal> Table => 'AttachmentsIndex',<o:p></o:p></p><p class=MsoNormal> MaxMatches => '10000',<o:p></o:p></p><p class=MsoNormal>);<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>to the RT_SiteConfig.pm. However, Request Tracker does not seem to be searching the index. If we search for any term that is only in the contents of the ticket and not the header we do not get any hits. We do get hits for terms in the ticket header though. If I search sphinx directly for a term everything works correctly. It seems as if RT is not searching Sphinx. Have I missed a step in the setup process? Any assistance will be appreciated. Thanks.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>--Dale</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'> <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>---------------------------------------<br>Dale Poulter<br>Automation Coordinator</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Library Information Technology Services<br>Vanderbilt University<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>419 21st Avenue South, Room 812 <br>Nashville, TN 37203-2427<br>(615)343-5388<br>(615)343-8834 (fax)<br>(615)207-9705 (cell)<br><a href="mailto:dale.poulter@vanderbilt.edu"><span style='color:windowtext'>dale.poulter@vanderbilt.edu</span></a></span><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>