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
