[rt-users] RT 3.6.1 install question
Frank Saxton
frankie at easyrider.com
Thu Sep 7 19:55:01 EDT 2006
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):
[root at patrol 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
[root at patrol 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.
[root at patrol 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
[root at patrol 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
[root at patrol 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.
[root at patrol 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.
[root at patrol 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.
[root at patrol 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.
[root at patrol 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.
[root at patrol 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.
[root at patrol 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.
[root at patrol 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
[root at patrol 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.
More information about the rt-users
mailing list