[rt-users] Fulltext Indexing RT 4.0.4

[Gary Holmes]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120207/ed50503e/attachment.htm>