[rt-users] How to move an existing database to a new server
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
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
[rt-users] Migrations from ZenDesk
Has anyone every imported a csv from Zendesk? We're migrating our company from Zendesk and don't want to lose that data. I've seen some on the zendesk export but not really the importing. -- RT Training November 4 5 Los Angeles http://bestpractical.com/training
Re: [rt-users] Migrations from ZenDesk
Hi I posted the importer I wrote/used to import from 2 systems (one csv/xls and the other direct db) here: http://parishnetworks.blogspot.com/2014/10/importing-into-rt-from-another-helpdesk.html It’s a pretty simplistic script, take it for what it’s worth! (usual disclaimers apply) Obviously much depends on hardware, custom fields, etc but we imported about 11,000 tickets in 90 min or so. Hopefully someone has something a bit more robust/adaptable/tricky, but if nothing else, it may give you a starting point to roll your own. Whatever you end up with, I strongly recommend having a (highly) disposable dev/test environment to run the importers in! We ran ours countless times as we twiddled, fiddled, and adjusted things. - Brent From: rt-users [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Matt Wells Sent: Tuesday, October 21, 2014 1:49 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] Migrations from ZenDesk Has anyone every imported a csv from Zendesk? We're migrating our company from Zendesk and don't want to lose that data. I've seen some on the zendesk export but not really the importing. -- RT Training November 4 5 Los Angeles http://bestpractical.com/training
