Sphinx full-text search engine in RT

Hi all,
I just wanted to let everyone know that I have finished integrating the Sphinx search engine in our RT.

It is simply great: full-text searches on the whole RT db in just fractions of a second!

I am slowly documenting the whole thing on the RT wiki. You can find it by looking for “IntegratingSphinx”. It is not yet complete though.

I hope it will be useful to somebody else.

Bye
Cris

Hi.

Thanks for your great work. I am currently trying to follow your documentation to integrate sphinx in our RT setup, and I have run into some problems.

In sphinx.php, you include MySql.class.php and Timer.class.php. What are these? Have you written them yourself, or are they available for download somewhere?

Best Regards,
JohanFrom: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Guadagnino Cristiano
Sent: den 13 september 2010 15:22
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Sphinx full-text search engine in RT

Hi all,
I just wanted to let everyone know that I have finished integrating the Sphinx search engine in our RT.

It is simply great: full-text searches on the whole RT db in just fractions of a second!

I am slowly documenting the whole thing on the RT wiki. You can find it by looking for “IntegratingSphinx”. It is not yet complete though.

I hope it will be useful to somebody else.

Bye
Cris

Hi Johan,
I am attaching the missing files to this message.

You’ll also find “sorttable-RT.js”, which we implemented after I wrote the article: with this you can sort the results table by clicking on the field names in the table header (like other tables in RT). It still lacks feedback when you hover the table headers, but it works very well otherwise.

To enable table sorting you have to modify sphinx.php and insert the following code in the section (obviosuly you’ll have to adapt the path):

Before doing this, please reget the sphinx.php script from the wiki because I’m going to add a few lines of necessary code there.

Hope this helps!

Bye
Cristiano

Da: Johan Sjöberg [mailto:johan.sjoberg@deltamanagement.se]
Inviato: Tuesday, January 11, 2011 10:39 AM
A: Guadagnino Cristiano; rt-users@lists.bestpractical.com
Oggetto: RE: Sphinx full-text search engine in RT

Hi.

Thanks for your great work. I am currently trying to follow your documentation to integrate sphinx in our RT setup, and I have run into some problems.

In sphinx.php, you include MySql.class.php and Timer.class.php. What are these? Have you written them yourself, or are they available for download somewhere?

Best Regards,
JohanFrom: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Guadagnino Cristiano
Sent: den 13 september 2010 15:22
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Sphinx full-text search engine in RT

Hi all,
I just wanted to let everyone know that I have finished integrating the Sphinx search engine in our RT.

It is simply great: full-text searches on the whole RT db in just fractions of a second!

I am slowly documenting the whole thing on the RT wiki. You can find it by looking for “IntegratingSphinx”. It is not yet complete though.

I hope it will be useful to somebody else.

Bye
Cris

more_code.zip.txt (52 Bytes)

This looks great, I hope to be trying this soon.
I’ll also try to integrate antiword, docx2text and pdftotext so we can
search our RTFM documents.

If/When I do, I’ll be sure to update wiki!

Steve

Message: 3Date: Tue, 11 Jan 2011 10:38:54 +0100
From: Johan Sj?berg johan.sjoberg@deltamanagement.se
To: Guadagnino Cristiano guadagnino.cristiano@creval.it,
rt-users@lists.bestpractical.com
rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Sphinx full-text search engine in RT
Message-ID:

B08F3F3D67451844A7A8A029FCC71E4C18832A69E5@WIN01.ad.deltamanagement.se

Content-Type: text/plain; charset=“iso-8859-1”

Hi.

Thanks for your great work. I am currently trying to follow your
documentation to integrate sphinx in our RT setup, and I have run into some
problems.

In sphinx.php, you include MySql.class.php and Timer.class.php. What are
these? Have you written them yourself, or are they available for download
somewhere?

Best Regards,
Johan

From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Guadagnino
Cristiano
Sent: den 13 september 2010 15:22
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Sphinx full-text search engine in RT

Hi all,
I just wanted to let everyone know that I have finished integrating the
Sphinx search engine in our RT.

It is simply great: full-text searches on the whole RT db in just fractions
of a second!

I am slowly documenting the whole thing on the RT wiki. You can find it by
looking for “IntegratingSphinx”. It is not yet complete though.

I hope it will be useful to somebody else.

Bye
Cris

This looks great, I hope to be trying this soon.
I’ll also try to integrate antiword, docx2text and pdftotext so we can
search our RTFM documents.

If/When I do, I’ll be sure to update wiki!

Steve

I am not using sphinx for FTS but hopefully your patch for these
will also work with PostgreSQL FTS and Oracle FTS. I can test
PostgreSQL if you need a tester.

Cheers,
Ken

Hi Cristiano.

Thanks for your reply.
It seems like your attached zip file was removed somewhere on the way, probably in your end, since it is missing both in your mail to me and in the one to rt-users. It has been replaced by a text file containing “This attachment was removed by Edge3 Transport Agent”. Is it a lot of code, or could you add it to the wiki as well?

/JohanFrom: Guadagnino Cristiano [mailto:guadagnino.cristiano@creval.it]
Sent: den 11 januari 2011 12:22
To: Johan Sjöberg
Cc: rt-users@lists.bestpractical.com
Subject: R: Sphinx full-text search engine in RT

Hi Johan,
I am attaching the missing files to this message.

You’ll also find “sorttable-RT.js”, which we implemented after I wrote the article: with this you can sort the results table by clicking on the field names in the table header (like other tables in RT). It still lacks feedback when you hover the table headers, but it works very well otherwise.

To enable table sorting you have to modify sphinx.php and insert the following code in the section (obviosuly you’ll have to adapt the path):

Before doing this, please reget the sphinx.php script from the wiki because I’m going to add a few lines of necessary code there.

Hope this helps!

Bye
Cristiano

Da: Johan Sjöberg [mailto:johan.sjoberg@deltamanagement.se]
Inviato: Tuesday, January 11, 2011 10:39 AM
A: Guadagnino Cristiano; rt-users@lists.bestpractical.com
Oggetto: RE: Sphinx full-text search engine in RT

Hi.

Thanks for your great work. I am currently trying to follow your documentation to integrate sphinx in our RT setup, and I have run into some problems.

In sphinx.php, you include MySql.class.php and Timer.class.php. What are these? Have you written them yourself, or are they available for download somewhere?

Best Regards,
Johan

From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Guadagnino Cristiano
Sent: den 13 september 2010 15:22
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Sphinx full-text search engine in RT

Hi all,
I just wanted to let everyone know that I have finished integrating the Sphinx search engine in our RT.

It is simply great: full-text searches on the whole RT db in just fractions of a second!

I am slowly documenting the whole thing on the RT wiki. You can find it by looking for “IntegratingSphinx”. It is not yet complete though.

I hope it will be useful to somebody else.

Bye
Cris