[rt-users] Upgrading from RT 3.6.5

[Kevin Falcone]

On Tue, Jun 29, 2010 at 10:42:44AM -0400, Patton, Brandon wrote:
> I'm in the process of trying to upgrade now and I've gotten to the part of updating the database and I get the following error. Can anyone help me?
> 
> 
> root at nethealth:/opt/rt3/sbin# ./rt-setup-database --dba root --prompt-for-dba-password --action upgrade
> In order to create or update your RT database, this script needs to connect to your  mysql instance on localhost as root
> Please specify that user's database password below. If the user has no database
> password, just press return.
> 
> Password:
> Working with:
> Type:   mysql
> Host:   localhost
> Name:   rtdb
> User:   rtuser
> DBA:    root
> Couldn't finish 'upgrade' step.
> 
> ERROR: Couldn't read dir './etc/upgrade' with upgrade data

The error message is telling you that there is no /opt/rt3/sbin/etc/upgrade directory
You need to run the command from a higher directory, or optionally you
could explicity pass --datadir.
Usually you run this from the unpacked tarball that you ran make
upgrade from.

-kevin


> 
> The upgrade directory is there, not sure why it can't read it. Of course, I'm not an expert on permissions either.
> 
> root at nethealth:/opt/rt3/etc# ls -l
> total 196
> -r--------  1 root          www              90 2010-06-28 15:53 acl.Informix
> -r--------  1 root          www             859 2010-06-28 15:53 acl.mysql
> -r--------  1 root          www              27 2010-06-28 15:53 acl.Oracle
> -r--------  1 root          www            1912 2010-06-28 15:53 acl.Pg
> -r--------  1 root          www             232 2010-06-28 15:53 acl.Sybase
> -r--------  1 root          www           22776 2010-06-28 15:53 initialdata
> -r--r-----  1 root          www           46335 2010-06-28 15:53 RT_Config.pm
> -rw-r-----  1 root          www            1027 2010-06-28 16:11 RT_SiteConfig.pm
> -r--------  1 root          www           10518 2010-06-28 15:53 schema.Informix
> -r--------  1 root          www           13236 2010-06-28 15:53 schema.mysql-4.0
> -r--------  1 root          www           14164 2010-06-28 15:53 schema.mysql-4.1
> -r--------  1 root          www           11776 2010-06-28 15:53 schema.Oracle
> -r--------  1 root          www           13904 2010-06-28 15:53 schema.Pg
> -r--------  1 root          www           10769 2010-06-28 15:53 schema.SQLite
> -r--------  1 root          www           11550 2010-06-28 15:53 schema.Sybase
> drwxr-xr-x 25 administrator administrator  4096 2010-06-28 15:52 upgrade
> 
> 
> 
> 
> 
> 
> 
> 
> 
> -----Original Message-----
> From: Jerrad Pierce [mailto:jpierce at cambridgeenergyalliance.org] 
> Sent: Friday, June 25, 2010 2:14 PM
> To: Patton, Brandon
> Cc: rt-users at lists.bestpractical.com
> Subject: Re: [rt-users] Upgrading from RT 3.6.5
> 
> Ungh, Ubuntu as a server.
> 
> Leaving that aside, simply use the package manager (something like
> Synaptic in the GUI) to check where the files for the rt package are
> installed.
> Back those up if you have concerns about possible customizations done
> to core instead of local code. Backup your database. Then:
> 
> A) Update your system to something more modern, and install the
> corresponding rt package
> B) Download the source tarball from Best Practical, and follow the
> enclosed directions
> 
> P.S. /opt/rt3 is the default path, for some reason several
> distributions like Ubuntu like to shove stuff under
> /usr/local/packageName and give users longer pathnames to deal with.
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20100629/4b56098d/attachment.sig>