Fulltext Indexing RT 4.0.4

Hello all,

I’ve setup full text indexing in RT4.0.4 as follows:

  • Vanilla install RT 4.0.4 on Ubuntu 10.04 LTS
  • MySQL 5.1.61 built from source with mysqlse added
  • Sphinx 2.0.3 added using the x86 package from the sphinxsearch.com site
  • run /opt/rt4/sbin/rt-setup-fulltext-index etc
    As the version of Sphinx had id64 enabled, I had to change the type of the
    id field in the AttachmentsIndex to bigint to make it 64 bit. Other than
    that, no issues (just a lot of time!!). RT works just fine.

Here are my questions:

  • I can run manual searches (using search) and see hits that RT does not (0
    tickets found), others work OK.
  • A lot of the data we need to search on is in entries that are of type
    html not plain text. How can we index those too?

Any clues on how to proceed. If we can sort this, we want to index our own
RT instance and then offer this as a feature to other potential customers.

Thanks,
Gary

Hello all,

I’ve setup full text indexing in RT4.0.4 as follows:

  • Vanilla install RT 4.0.4 on Ubuntu 10.04 LTS
  • MySQL 5.1.61 built from source with mysqlse added
  • Sphinx 2.0.3 added using the x86 package from the sphinxsearch.com site
  • run /opt/rt4/sbin/rt-setup-fulltext-index etc
    As the version of Sphinx had id64 enabled, I had to change the type of the
    id field in the AttachmentsIndex to bigint to make it 64 bit. Other than
    that, no issues (just a lot of time!!). RT works just fine.

Here are my questions:

  • I can run manual searches (using search) and see hits that RT does not (0
    tickets found), others work OK.
  • A lot of the data we need to search on is in entries that are of type html
    not plain text. How can we index those too?

Take a look inside sbin/rt-fulltext-indexer. It’s designed to process
more than text and can be extended with additional functions to
convert any content type to text or any other format that sphinx
supports.

Any clues on how to proceed. If we can sort this, we want to index our own
RT instance and then offer this as a feature to other potential customers.

Thanks,
Gary


RT Training Sessions (http://bestpractical.com/services/training.html)

  • Boston — March 5 & 6, 2012

Best regards, Ruslan.