[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