Difference between revisions of "Upgrade RT 3.6.7 to 3.8.8 - Debian 5.0(lenny) to 6.0(squeeze)"

From Request Tracker Wiki
Jump to navigation Jump to search
Line 1: Line 1:
Procedure that worked for me(upgrade from RT 3.6.7 with MySQL on debian Lenny 5.0, to RT 3.8.8 on Debian Squeeze 6.0 with MySQL):
Procedure that worked for me(upgrade from RT 3.6.7 with MySQL on debian Lenny 5.0, to RT 3.8.8 on Debian Squeeze 6.0 with MySQL):


First backup.
First backup.


Upgrade lenny to squeeze as usual.
Upgrade lenny to squeeze as usual.


Then
Then


apt-get install request-tracker3.8 rt3.8-db-mysql
apt-get install request-tracker3.8 rt3.8-db-mysql


Use the same name for instance, and choose no for dbconfig.
Use the same name for instance, and choose no for dbconfig.


Copy needed configuration snippets from /etc/request-tracker3.6/RT_SiteConfig.d/ to /etc/request-tracker3.8/RT_SiteConfig.d/ directory.
Copy needed configuration snippets from /etc/request-tracker3.6/RT_SiteConfig.d/ to /etc/request-tracker3.8/RT_SiteConfig.d/ directory.


Remove old RT with:
Remove old RT with:


apt-get --purge remove request-tracker3.6 rt3.6-clients rt3.6-db-sqlite sqlite3 rt3.6-apache2
apt-get --purge remove request-tracker3.6 rt3.6-clients rt3.6-db-sqlite sqlite3 rt3.6-apache2


Run
Run


update-rt-siteconfig to refresh RT_SiteConfig.pm.
update-rt-siteconfig to refresh RT_SiteConfig.pm.


Then we should upgrade database with:
Then we should upgrade database with:


/usr/sbin/rt-setup-database-3.8 --action upgrade --dba rtuser --dba-password
/usr/sbin/rt-setup-database-3.8 --action upgrade --dba rtuser --dba-password


Important: choose versions from 3.6.7 to 3.7.87.
Important: choose versions from 3.6.7 to 3.7.87.


Afterwards do
Afterwards do


perl /usr/share/request-tracker3.8/etc/upgrade/upgrade-mysql-schema.pl rtdb rtuser 'yourRTuserpassword' > queries.sql
perl /usr/share/request-tracker3.8/etc/upgrade/upgrade-mysql-schema.pl rtdb rtuser 'yourRTuserpassword' > queries.sql


mysql -u rtuser -p rtdb < queries.sql
mysql -u rtuser -p rtdb < queries.sql


Then again run:
Then again run:


/usr/sbin/rt-setup-database-3.8 --action upgrade --dba rtuser --dba-password
/usr/sbin/rt-setup-database-3.8 --action upgrade --dba rtuser --dba-password


this time choose version from 3.8.0 till the end.
this time choose version from 3.8.0 till the end.


Then configure apache, something like
Then configure apache, something like


 
Include /etc/request-tracker3.8/apache2-modperl2.conf<br />RedirectMatch ^/$ /rt<br />in /etc/apache2/sites-available/default.
Include /etc/request-tracker3.8/apache2-modperl2.conf<br />RedirectMatch ^/$ /rt<br />
in /etc/apache2/sites-available/default.
 


Restart apache.
Restart apache.


Voila! That should be it! [[File:Placeholder|right|300px]]
Voila! That should be it! [[File:Placeholder|right|300px]]

Revision as of 18:34, 26 February 2011

Procedure that worked for me(upgrade from RT 3.6.7 with MySQL on debian Lenny 5.0, to RT 3.8.8 on Debian Squeeze 6.0 with MySQL):

First backup.

Upgrade lenny to squeeze as usual.

Then

apt-get install request-tracker3.8 rt3.8-db-mysql

Use the same name for instance, and choose no for dbconfig.

Copy needed configuration snippets from /etc/request-tracker3.6/RT_SiteConfig.d/ to /etc/request-tracker3.8/RT_SiteConfig.d/ directory.

Remove old RT with:

apt-get --purge remove request-tracker3.6 rt3.6-clients rt3.6-db-sqlite sqlite3 rt3.6-apache2

Run

update-rt-siteconfig to refresh RT_SiteConfig.pm.

Then we should upgrade database with:

/usr/sbin/rt-setup-database-3.8 --action upgrade --dba rtuser --dba-password

Important: choose versions from 3.6.7 to 3.7.87.

Afterwards do

perl /usr/share/request-tracker3.8/etc/upgrade/upgrade-mysql-schema.pl rtdb rtuser 'yourRTuserpassword' > queries.sql

mysql -u rtuser -p rtdb < queries.sql

Then again run:

/usr/sbin/rt-setup-database-3.8 --action upgrade --dba rtuser --dba-password

this time choose version from 3.8.0 till the end.

Then configure apache, something like

Include /etc/request-tracker3.8/apache2-modperl2.conf
RedirectMatch ^/$ /rt
in /etc/apache2/sites-available/default.

Restart apache.

Voila! That should be it!