Hi, Looks good. Move on to SQL log and debug log.
On Fri, Dec 23, 2011 at 21:13, Poulter, Dale <[email protected]> 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: [email protected] [mailto:[email protected]] On Behalf Of > Ruslan Zakirov > Sent: Friday, December 23, 2011 8:56 AM > To: Poulter, Dale > Cc: [email protected] > Subject: Re: [rt-users] Sphinx fulltext index v4.0.4 > > On Fri, Dec 23, 2011 at 18:47, Poulter, Dale > <[email protected]> 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" <[email protected]> wrote: >> >>> On Fri, Dec 23, 2011 at 18:22, Poulter, Dale >>> <[email protected]> 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" <[email protected]> >>>> wrote: >>>> >>>>> On Thu, Dec 15, 2011 at 17:32, Poulter, Dale >>>>> <[email protected]> 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. -------- RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
