<div dir="ltr"><div>FTS is enabled and working, but it seems to be working only on tickets that were set up when the setup tool was run. According to the docs (rt4/docs/full_text_indexing.pod):<br><br>To keep the index up-to-date, you will need to run:<br><br> /opt/rt4/sbin/rt-fulltext-indexer<br><br>...at regular intervals. By default, this will only tokenize up to 200<br>tickets at a time; you can adjust this upwards by passing C<--limit<br>500>. Larger batch sizes will take longer and consume more memory.<br><br><br></div>What this file never says is how to tell the indexer tool how to connect to the database. It clearly isn't pulling from the RT configuration, nor from /home/www-data/rtrc.<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Dec 9, 2016 at 5:12 PM, Landon Stewart <span dir="ltr"><<a href="mailto:lstewart@internap.com" target="_blank">lstewart@internap.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word">
<div>On Dec 9, 2016, at 2:06 PM, Alex Hall <<a href="mailto:ahall@autodist.com" target="_blank">ahall@autodist.com</a>> wrote:</div>
<div>
<blockquote type="cite"><br class="m_2653475320708332945Apple-interchange-newline">
<div>
<div dir="ltr">I thought the tool I had to run periodically was /opt/rt4/sbin/rt-fulltext-<wbr>indexer. That's the one guides tell me to run; the setup tool seems to be the initial database adjustment tool, but once it runs once, I thought I had to run
the indexer every so often. The indexer is the tool that refuses database credentials. Unless the guides on this are wrong, and the setup one is the one I have to run with cron?<br>
</div>
</div>
</blockquote>
<div><br>
</div>
I haven't enabled Full Text searching in RT before but I have set it up in MySQL for other uses. From my experiences with MySQL I believe you setup the indexes once only with the setup tool for RT and once they are setup there's no need to 're-index' anything
regularly with any crontab or anything.</div>
<div><br>
</div>
<div>Above all though - do this on a copy of your RT installation/database and make sure it works before you potentially interrupt the flow of business in production.</div>
<br>
<div>
<div style="word-wrap:break-word">
<div style="color:rgb(0,0,0);font-family:Helvetica;font-size:18px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
--<br>
Landon Stewart<br>
Lead Analyst - Abuse and Security Management<br>
INTERNAP ®<br>
📧 <a href="mailto:lstewart@internap.com" target="_blank">lstewart@internap.com</a><br>
🌍 <a href="http://www.internap.com" target="_blank">www.internap.com</a></div>
</div>
</div>
<br>
</div>
</blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div>Alex Hall<br></div>Automatic Distributors, IT department<br></div><a href="mailto:ahall@autodist.com" target="_blank">ahall@autodist.com</a><br></div></div>
</div>