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
(Created page with "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....")
 
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 update-rt-siteconfig to refresh RT_SiteConfig.pm.
 
 
Run
 
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 />
Include /etc/request-tracker3.8/apache2-modperl2.conf<br />RedirectMatch ^/$ /rt<br />
in /etc/apache2/sites-available/default.
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:32, 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!