Iupgraded my RT from 3.8.7 to 4.0.9 recently. These were the steps I
followed:
Took the previous RT 3 offline and configured mail redirect.
Re-compiled mysql-server 5.1 with ‘sphinx’ storage engine(sphinxse)
for enabling fulltext support for RT 4.
3.Installed RT 4 and restored the previous database backup. It was
successful and the new RT interface was working fine after restoring
mail flow. All good.
However I didn’t enable fulltext although I compiled mysql with sphinxse
support.
I chose it to do another time since I wasn’t sure of what all the RT
tables to index
and was a bit unsure of Sphinx stuff.
Took the previous RT 3 offline and configured mail redirect.
Re-compiled mysql-server 5.1 with ‘sphinx’ storage engine(sphinxse)
for enabling fulltext support for RT 4.
Installed RT 4 and restored the previous database backup. It was
successful and the new RT interface was working fine after restoring
mail flow. All good.
However I didn’t enable fulltext although I compiled mysql with sphinxse support.
I chose it to do another time since I wasn’t sure of what all the RT tables to index
and was a bit unsure of Sphinx stuff.
So my question is:
Q) If I intended to enable fulltext with RT4 later on like as mentioned here:
I would recommend taking the webserver down. That script creates a new
table in your database. You’ll need to make the table, add in the
configuration, restart apache, run an initial index, etc. These are all
things best tested in a development environment and then deployed during
a scheduled downtime.
Re,On Sunday 27 January 2013 10:51 PM, Kevin Falcone wrote:
On Sun, Jan 27, 2013 at 07:04:11PM +0530, Subin wrote:
1. Took the previous RT 3 offline and configured mail redirect.
2. Re-compiled mysql-server 5.1 with 'sphinx' storage engine(sphinxse)
for enabling fulltext support for RT 4.
3. Installed RT 4 and restored the previous database backup. It was
successful and the new RT interface was working fine after restoring
mail flow. All good.
However I didn't enable fulltext although I compiled mysql with sphinxse support.
I chose it to do another time since I wasn't sure of what all the RT tables to index
and was a bit unsure of Sphinx stuff.
So my question is:
Q) If I intended to enable fulltext with RT4 later on like as mentioned here:
[1]http://www.bestpractical.com/rt/docs/4.0/full_text_indexing.html#Creating-and-configuring-the-index1
starting from the step "sbin/rt-setup-fulltext-index --dba root --dba-password secret"
would I be need to take RT
offline like I did for the upgrade?
I would recommend taking the webserver down. That script creates a new
table in your database. You’ll need to make the table, add in the
configuration, restart apache, run an initial index, etc. These are all
things best tested in a development environment and then deployed during
a scheduled downtime.