Got the vanilla 3.6.1 install going.
Copied the 3.0.1 RT database as follows:
/usr/bin/mysqldump --user=rt_user --password=rt_pass --databases
rt3 > /home/frankie/rt.sql
Copied to the new server
Imported old DB with :
mysql --user=root --password=xxxxx < /home/frankie/rt.sql
Upgraded doing (the 3.0.1 stuff scrolled off the screen but went error free):
[EMAIL PROTECTED] rt-3.6.1]# /opt/rt3/sbin/rt-setup-database --datadir
./etc/upgrade/3.1.15 --dba root --dba-password xxxxx --action schema
Creating database schema.
Couldn't find schema file for mysql
[EMAIL PROTECTED] rt-3.6.1]# /opt/rt3/sbin/rt-setup-database --datadir
./etc/upgrade/3.1.17 --dba dbuser --dba-password dbpass --action insert
Creating ScripActions...16.17.done.
Creating ScripConditions...10.done.
Done setting up database content.
[EMAIL PROTECTED] rt-3.6.1]# /opt/rt3/sbin/rt-setup-database --datadir
./etc/upgrade/3.1.17 --dba root --dba-password xxxxxx --action acl
Couldn't find ACLS for mysql in ./etc/upgrade/3.1.17
[EMAIL PROTECTED] rt-3.6.1]# /opt/rt3/sbin/rt-setup-database --datadir
./etc/upgrade/3.1.17 --dba root --dba-password xxxxxx --action schema
Creating database schema.
Couldn't find schema file for mysql
[EMAIL PROTECTED] rt-3.6.1]# /opt/rt3/sbin/rt-setup-database --datadir
./etc/upgrade/3.3.0 --dba dbuser --dba-password dbpass --action insert
Done setting up database content.
[EMAIL PROTECTED] rt-3.6.1]# /opt/rt3/sbin/rt-setup-database --datadir
./etc/upgrade/3.3.0 --dba root --dba-password xxxx --action acl
Done setting up database ACLs.
[EMAIL PROTECTED] rt-3.6.1]# /opt/rt3/sbin/rt-setup-database --datadir
./etc/upgrade/3.3.0 --dba root --dba-password xxxxx --action schema
Creating database schema.
Done setting up database schema.
[EMAIL PROTECTED] rt-3.6.1]# /opt/rt3/sbin/rt-setup-database --datadir
./etc/upgrade/3.3.11 --dba dbuser --dba-password dbpass --action insert
Done setting up database content.
[EMAIL PROTECTED] rt-3.6.1]# /opt/rt3/sbin/rt-setup-database --datadir
./etc/upgrade/3.3.11 --dba root --dba-password xxxxxx --action acl
Done setting up database ACLs.
[EMAIL PROTECTED] rt-3.6.1]# /opt/rt3/sbin/rt-setup-database --datadir
./etc/upgrade/3.3.11 --dba root --dba-password xxxxxx --action schema
Creating database schema.
Done setting up database schema.
[EMAIL PROTECTED] rt-3.6.1]# /opt/rt3/sbin/rt-setup-database --datadir
./etc/upgrade/3.5.1 --dba dbuser --dba-password dbpass --action insert
Creating predefined searches...1.2.3.done.
Done setting up database content.
[EMAIL PROTECTED] rt-3.6.1]# /opt/rt3/sbin/rt-setup-database --datadir
./etc/upgrade/3.5.1 --dba root --dba-password xxxxxxxx --action acl
Couldn't find ACLS for mysql in ./etc/upgrade/3.5.1
[EMAIL PROTECTED] rt-3.6.1]# /opt/rt3/sbin/rt-setup-database --datadir
./etc/upgrade/3.5.1 --dba root --dba-password xxxxxx --action schema
Creating database schema.
Couldn't find schema file for mysql
I can log in OK and all of the open tickets are listed. If I click
on any ticket, I get text like the following. I also cannot log out
or do anything from there. I'm gathering that I am missing a
critical step. HELP!
%# BEGIN BPS TAGGED BLOCK {{{ %# %# COPYRIGHT: %# %# This software is
Copyright (c) 1996-2006 Best Practical Solutions, LLC %# %# %#
(Except where explicitly superseded by other copyright notices) %# %#
%# LICENSE: %# %# This work is made available to you under the terms
of Version 2 of %# the GNU General Public License. A copy of that
license should have %# been provided with this software, but in any
event can be snarfed %# from www.gnu.org. %# %# This work is
distributed in the hope that it will be useful, but %# WITHOUT ANY
WARRANTY; without even the implied warranty of %# MERCHANTABILITY or
FITNESS FOR A PARTICULAR PURPOSE. See the GNU %# General Public
License for more details. %# %# You should have received a copy of
the GNU General Public License %# along with this program; if not,
write to the Free Software %# Foundation, Inc., 675 Mass Ave,
Cambridge, MA 02139, USA. %# %# %# CONTRIBUTION SUBMISSION POLICY: %#
%# (The following paragraph is not intended to limit the rights
granted %# to you to modify and distribute this software under the
terms of %# the GNU General Public License and is only of importance
to you if %# you choose to contribute your changes and enhancements
to the %# community by submitting them to Best
If you have a look at the RT Tarball, there are some upgrade
instructions. Your best bet is to have a look at the INSTALL file.
From memory it's about point 6 or 7 on there.
There are a few changes from 3.0 to 3.6.1 but they're relatively
easy to apply. Just a case of running:
% rt-setup-database --datadir /path/to/etc/upgrade/<ver> --dba
dbuser --dba-password dbpass --action insert/act/schema
Sadly you've got 6 version updates to do from 3.0, so they'll be
something like:
% rt-setup-database --datadir /etc/request-tracker3.6/upgrade/3.1.0
--dba dbuser --dba-password dbpass --action insert
% rt-setup-database --datadir /etc/request-tracker3.6/upgrade/3.1.0
--dba dbuser --dba-password dbpass --action acl
% rt-setup-database --datadir /etc/request-tracker3.6/upgrade/3.1.0
--dba dbuser --dba-password dbpass --action schema
for each folder. The instructions in the INSTALL file explain it a
bit better than me.
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
