[rt-users] Sphinx fulltext index v4.0.4

Ruslan Zakirov ruz at bestpractical.com
Fri Dec 23 12:26:40 EST 2011


Hi,

Looks good. Move on to SQL log and debug log.

On Fri, Dec 23, 2011 at 21:13, Poulter,   Dale
<dale.poulter at vanderbilt.edu> wrote:
> Here is the output.  Thanks.
>
> mysql> show create table AttachmentsIndex;
> +------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
> | Table            | Create Table                                                                                                                                                                                                                                  |
> +------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
> | AttachmentsIndex | CREATE TABLE `AttachmentsIndex` (
>  `id` int(10) unsigned NOT NULL,
>  `weight` int(11) NOT NULL,
>  `query` varchar(3072) NOT NULL,
>  KEY `query` (`query`(1024))
> ) ENGINE=SPHINX DEFAULT CHARSET=utf8 CONNECTION='sphinx://localhost:9312/rt' |
> +------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
> 1 row in set (0.00 sec)
>
> -----Original Message-----
> From: ruslan.zakirov at gmail.com [mailto:ruslan.zakirov at gmail.com] On Behalf Of Ruslan Zakirov
> Sent: Friday, December 23, 2011 8:56 AM
> To: Poulter, Dale
> Cc: rt-users at lists.bestpractical.com
> Subject: Re: [rt-users] Sphinx fulltext index v4.0.4
>
> On Fri, Dec 23, 2011 at 18:47, Poulter,   Dale
> <dale.poulter at vanderbilt.edu> wrote:
>> Correct.  The index and table seems to have been created.  One strange item is that the attatchmentindex table in MySQL is empty. Thanks for your help.
>
> It's sort of empty as it's dynamic. It's a special table that connects mysql to sphinx. Run 'show create table AttachmentsIndex' and send us output.
>
>>
>>
>> Sent from iphone
>>
>>
>> On Dec 23, 2011, at 8:29 AM, "Ruslan Zakirov" <ruz at bestpractical.com> wrote:
>>
>>> On Fri, Dec 23, 2011 at 18:22, Poulter,   Dale
>>> <dale.poulter at vanderbilt.edu> wrote:
>>>> I actually tried with and without the fulltext without any success.
>>>
>>> It's hard to say what went wrong. Just for clarification, you've
>>> created required tables with a script, configured RT's config,
>>> configured sphinx, setup indexer that puts data into sphinx index.
>>> Right?
>>>
>>> To diagnose this start with RT's debug log. Enable logging of SQL
>>> statements in RT. Use command line sphinx client to make sure data is
>>> in the index. At this moment we don't have any info to help you.
>>>
>>>> Sent from iphone
>>>>
>>>>
>>>> On Dec 23, 2011, at 3:09 AM, "Ruslan Zakirov" <ruz at bestpractical.com> wrote:
>>>>
>>>>> On Thu, Dec 15, 2011 at 17:32, Poulter,   Dale
>>>>> <dale.poulter at vanderbilt.edu> wrote:
>>>>>> 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.
>>>>>
>>>>> How do you search? It's still required to use fulltext:x in simple
>>>>> search and Content in the query builder.
>>>>>
>>>>> --
>>>>> Best regards, Ruslan.
>>>>>
>>>>
>>>
>>>
>>>
>>> --
>>> Best regards, Ruslan.
>>>
>>
>> --------
>> RT Training Sessions (http://bestpractical.com/services/training.html)
>> * Boston  March 5 & 6, 2012
>
>
>
> --
> Best regards, Ruslan.
>



-- 
Best regards, Ruslan.



More information about the rt-users mailing list