<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Ruslan,<br>
first of all thank you very much for your help.<br>
Your solution worked like a charm!<br>
<br>
Now, reading the document you sent me I see that Sphinx allows to override the index (or indexes) name on the query text.
<br>
I tried it and it is actually working very well: it's sufficient to append ";index=indexname1,indexname2" to the query text.<br>
<br>
Don't you think it would be nice (and better from a usability point of view) to add a new configuration option to RT_Config.pm so that RT administrators that want to fine-tune their Sphinx configuration don't have to ALTER the AttachmentsIndex table? You should
only change RT code so that every query sent to Sphinx gets the new token appended.<br>
Well, just my 2 cents :-).<br>
<br>
Thank you<br>
Bye<br>
Cris<br>
<br>
<div class="moz-cite-prefix">
<hr>
<b>Da:</b> Ruslan Zakirov <a class="moz-txt-link-rfc2396E" href="mailto:ruz@bestpractical.com">
<ruz@bestpractical.com></a><br>
<b>Inviato:</b> Wed Sep 11 2013 14:25:56 GMT+0200 (CEST)<br>
<b>A:</b> Guadagnino Cristiano <a class="moz-txt-link-rfc2396E" href="mailto:guadagnino.cristiano@creval.it">
<guadagnino.cristiano@creval.it></a><br>
<b>Cc:</b> <a class="moz-txt-link-rfc2396E" href="mailto:rt-users@lists.bestpractical.com">
"rt-users@lists.bestpractical.com"</a> <a class="moz-txt-link-rfc2396E" href="mailto:rt-users@lists.bestpractical.com">
<rt-users@lists.bestpractical.com></a><br>
<b>Oggetto:</b> Re: [rt-users] Rt search does not work with sphinx main+delta index<br>
</div>
<blockquote cite="mid:CAMOxC8uiTPAfzynfdG-XAHB2CXNb7WUYK=0r4=871UA-gwmn4Q@mail.gmail.com" type="cite">
<div dir="ltr">Hi,
<div><br>
</div>
<div>RT defines index in the CONNECTION attribute of the table, so you have to adjust it to use several indexes, see the following doc:</div>
<div><br>
</div>
<div><a moz-do-not-send="true" href="http://sphinxsearch.com/docs/2.0.9/sphinxse-using.html">http://sphinxsearch.com/docs/2.0.9/sphinxse-using.html</a><br>
</div>
<div><br>
</div>
<div>It's not clear how, but it implies that you can do the following:</div>
<div><br>
</div>
<div>
<pre class="" style="color:rgb(51,51,51);font-size:12px;line-height:16px">ALTER TABLE t1 CONNECTION="sphinx://NEWHOST:NEWPORT/index1,index2,index3";</pre>
</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Wed, Sep 11, 2013 at 11:07 AM, Guadagnino Cristiano <span dir="ltr">
<<a moz-do-not-send="true" href="mailto:guadagnino.cristiano@creval.it" target="_blank">guadagnino.cristiano@creval.it</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">Well, it turned out that the problem with 4.0.17 not returning any result was due to a stale searchd process.<br>
Restarting the daemon reverted behavior to that of RT 4.0.10, which was anyway wrong.<br>
<br>
So, to restate it clearly: <b>RT is only returning results from the main index, completely ignoring the delta index</b>.<br>
<br>
Please help.<br>
<br>
Bye<br>
Cris
<div>
<div class="h5"><br>
<br>
<br>
<div>Guadagnino Cristiano wrote:<br>
</div>
<blockquote type="cite">I am having trouble with RT fulltext searches. I am using RT 4.0.17 with Mysql and Sphinx 4.0.8.<br>
Sphinx is configured to use a main+delta index (configuration attached). Main index is created once every morning, while the delta index is created every 5 minutes.<br>
If I search using the "search" command line tool from Sphinx everything is correct.<br>
<br>
Fulltext search with RT <b>4.0.10</b> instead seemed to return only the results from the main index, disregarding anything from the delta index.<br>
So I updated to the latest RT release (<b>4.0.17</b>) just to be sure. Now fulltext search with RT does not return anything at all!!<br>
<br>
<u>Example from the CLI: </u><br>
<blockquote>
<pre><big>search CrevalPublic --rsort=date -q -l 500</big></pre>
</blockquote>
This returns 73 hits on the main index and 39 ihits on the delta index.<br>
<br>
<u>Simple search with RT:</u><br>
<blockquote>
<pre><big>fulltext:CrevalPublic any</big></pre>
</blockquote>
This returns 0 results.<br>
<br>
Any suggestions?<br>
<br>
T.I.A.<br>
Bye<br>
Cris<br>
<div>-- <br>
<b><i>Cristiano Guadagnino</i></b><br>
<small>Servizio Data Administration<br>
Bankadati S.I.<br>
Gruppo Credito Valtellinese<br>
<br>
</small></div>
</blockquote>
<br>
<div>-- <br>
<b><i>Cristiano Guadagnino</i></b><br>
<small>Servizio Data Administration<br>
Bankadati S.I.<br>
Gruppo Credito Valtellinese<br>
</small><br>
<br>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
Best regards, Ruslan. </div>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<b><i>Cristiano Guadagnino</i></b><br>
<small>Servizio Data Administration<br>
Bankadati S.I.<br>
Gruppo Credito Valtellinese<br>
Tel. +39-0342-522172</small><br>
<br>
<small><small><i></i></small></small></div>
</body>
</html>