Re: [rt-users] How to move an existing database to a new server
Hi Kevin, once again thank you for your reply. So If understood correctly: 1)/opt/rt4/sbin/rt-setup-database --action drop database (drop the existing rt4 database which I created when first install rt4.2.9) Followed this guide http://binarynature.blogspot.co.uk/2013/10/install-request-tracker-4-on-ubuntu-server.html so I have done initdb and don't need to do again? 2)/opt/rt4/sbin/rt-setup-database --action create database,acl (create a new database with acl) 3)gunzip -c rt-mydump.sql.gz | mysql -uroot -p rt4 4)/opt/rt4/sbin/rt-setup-database --action upgrade On step 4 I get Error: Couldn't read dir './etc/upgrade' with upgrade data Having a read around, this error comes up if you are not running from the extracted source directory. But my understanding was that /opt/rt4/sbin is the correct location because step 12 work with no problems. Thank you Vas -- View this message in context: http://requesttracker.8502.n7.nabble.com/How-to-move-an-existing-database-to-a-new-server-tp58875p58999.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
Re: [rt-users] How to move an existing database to a new server
On Fri, Nov 07, 2014 at 05:03:49AM -0700, Vas wrote: A little update. I have manage to install rt 4.2.9 on a dev server on ubuntu 14.4.1 :) I have followed as you recommended this: http://bestpractical.com/docs/rt/latest/backups.html#Restoring-from-backups and have made the rt-dump.sql.gz and moved it to the new dev server. Since this is a fresh install with no data do I still need to /opt/rt4/sbin/rt-setup-database --action drop /opt/rt4/sbin/rt-setup-database --action create ? Or do I go gunzip -c rt-dump.sql.gz | psql rt4 and then /opt/rt4/sbin/rt-setup-database --action upgrade? If it's a fresh install, how did you install it? Did you already run 'make initdb' from the tarball? If so, then you will have tables you shouldn't have already and yes, will want to drop and create before running upgrade. If you've not run make initdb then you'll want to run /opt/rt4/sbin/rt-setup-database --action create,acl Which is documented under the catastrophic part of those docs. I would be most grateful if I could get an answer to my problem. I'll note that the mailing lists don't have an SLA, in fact they have no guarantee of a response (especially not on a Sunday, or when the engineers who monitor the list are on vacation). If you need an SLA, that's what Best Practical's commercial services are for. -kevin pgp7pGTX6cx6H.pgp Description: PGP signature
Re: [rt-users] How to move an existing database to a new server
Hi all, I would be most grateful if I could get an answer to my problem. thank you kind regards Vas -- View this message in context: http://requesttracker.8502.n7.nabble.com/How-to-move-an-existing-database-to-a-new-server-tp58875p58984.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
Re: [rt-users] How to move an existing database to a new server
A little update. I have manage to install rt 4.2.9 on a dev server on ubuntu 14.4.1 :) I have followed as you recommended this: http://bestpractical.com/docs/rt/latest/backups.html#Restoring-from-backups and have made the rt-dump.sql.gz and moved it to the new dev server. Since this is a fresh install with no data do I still need to /opt/rt4/sbin/rt-setup-database --action drop /opt/rt4/sbin/rt-setup-database --action create ? Or do I go gunzip -c rt-dump.sql.gz | psql rt4 and then /opt/rt4/sbin/rt-setup-database --action upgrade? Thank you Vas -- View this message in context: http://requesttracker.8502.n7.nabble.com/How-to-move-an-existing-database-to-a-new-server-tp58875p58966.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
Re: [rt-users] How to move an existing database to a new server
Thank you for the input Kevin. Is there an installation guide for RT 4.2.9 with a LTS Ubuntu? So far I have only found a 4.2 with Ubuntu 13.10 which is not supported anymore. http://binarynature.blogspot.co.uk/2013/10/install-request-tracker-4-on-ubuntu-server.html And with a LTS Ubuntu on 4.0.4 which is similiar to what I used http://burn.co.nz/blog/?p=245 RT Wiki page also does not contains any recent installation guides. Vas -- View this message in context: http://requesttracker.8502.n7.nabble.com/How-to-move-an-existing-database-to-a-new-server-tp58875p58930.html Sent from the Request Tracker - User mailing list archive at Nabble.com. -- RT Training November 4 5 Los Angeles http://bestpractical.com/training
Re: [rt-users] How to move an existing database to a new server
William, thank you for your input. I tried what you suggested and it gave me the following error: http://requesttracker.8502.n7.nabble.com/file/n58916/rtupgrade.png I would be grateful for some advice on what the problem may be. I tried looking at the debug log but I get no file or directory when I tail -n 10 /var/log/debug Advice on how to view log files would be appreciated also. Thank you Vas -- View this message in context: http://requesttracker.8502.n7.nabble.com/How-to-move-an-existing-database-to-a-new-server-tp58875p58916.html Sent from the Request Tracker - User mailing list archive at Nabble.com. -- RT Training November 4 5 Los Angeles http://bestpractical.com/training
Re: [rt-users] How to move an existing database to a new server
On Mon, Nov 03, 2014 at 03:22:13AM -0700, Vas wrote: thank you for your input. I tried what you suggested and it gave me the following error: http://requesttracker.8502.n7.nabble.com/file/n58916/rtupgrade.png I would be grateful for some advice on what the problem may be. I assume you've created an initialized 4.0 database, restored your 3.8 database into it and then run the upgrade steps, which attempts to create the Classes table. This table already existed in your initialized 4.0 database. A few points. 4.0.4 is from November 2011. If you're going to upgrade, I suggest RT 4.2.9 or at least a later RT 4.0 release. Assuming this is a dev server, I would drop your database /opt/rt4/sbin/rt-setup-database --action drop and then follow the database restoration procedures we document here for a new server http://bestpractical.com/docs/rt/latest/backups.html#Restoring-from-backups which create an empty database before restoring your backup into it. But again, ask yourself why you're upgrading to a 3 year old release of the software, one with published security flaws. -kevin pgpAreGRxAhkp.pgp Description: PGP signature -- RT Training November 4 5 Los Angeles http://bestpractical.com/training
Re: [rt-users] How to move an existing database to a new server
Vas, Not being familiar with Ubuntu so I don't know where your rt4 install directory is but on CentOS\RHEL it would be /opt/rt4 so I would run something like this: /opt/rt4/sbin/rt-setup-database --action upgrade I had a database from rt 3.8.6 build and similarly did a dump \ restore to rt 4.2.8 build. When running above command it asked me what version am I upgrading from and it ran the necessary updates. After running the upgrade command did you see something like the following: In order to create or update your RT database, this script needs to connect to your Pg instance on localhost (port '') as root Please specify that user's database password below. If the user has no database password, just press return. Password: Working with: Type: Pg Host: localhost Port: Name: rt4 User: rt_user DBA:root - Try setting your LogLevel to debug. I'm sure it will provide some helpful info. If you pass it along I'm confident somebody from the list can provide further assistance besides a RT newbie like myself : ) William Clarke ITS System Administrator Bard College at Simon's Rock 84 Alford Road Great Barrington, MA 01230 (413) 528-7428 (voice) (413) 528-7405 (fax) wcla...@simons-rock.edu On 10/21/2014 5:01 AM, Vas wrote: Hi all, I am trying to move an existing RT database (3.8.11) to a new server running 4.0.4. I have succesfully done a dump and scp and imported the database on the new server. When I log in to RT via the browser I can see the database but when I try to take a ticket I get the following error- Could not change owner: Couldn't add member to group Which I am assuming means that the database is actually not connected or something else needs to happen in the back end for it to work. I am using Ubuntu server 12.04.5 LTS on a vm machine. I do have a snapshot of the new server prior to importing the old database if other steps are required first prior to importing. I would be most grateful for any input. Having searched around on the internet I did try rt-setup-database --schema and upgrade with no result. Thank you Vas -- View this message in context:http://requesttracker.8502.n7.nabble.com/How-to-move-an-existing-database-to-a-new-server-tp58875.html Sent from the Request Tracker - User mailing list archive at Nabble.com. -- RT Training November 4 5 Los Angeles http://bestpractical.com/training