<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix"><small>Vas,<br>
<br>
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"<br>
<br>
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:<br>
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>
In order to create or update your RT database, this script needs
to connect to your Pg instance on localhost (port '') as root<br>
Please specify that user's database password below. If the user
has no database<br>
password, just press return.<br>
<br>
Password:<br>
Working with:<br>
Type: Pg<br>
Host: localhost<br>
Port:<br>
Name: rt4<br>
User: rt_user<br>
DBA: root<br>
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>
<br>
</small><br>
<small>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 : ) </small><small><br>
</small>
<pre class="moz-signature" cols="72">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)
<a class="moz-txt-link-abbreviated" href="mailto:wclarke@simons-rock.edu">wclarke@simons-rock.edu</a></pre>
On 10/21/2014 5:01 AM, Vas wrote:<br>
</div>
<blockquote
cite="mid:32514_1413882295_544621B6_32514_4056_1_1413882093458-58875.post@n7.nabble.com"
type="cite">
<pre wrap="">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: <a class="moz-txt-link-freetext" href="http://requesttracker.8502.n7.nabble.com/How-to-move-an-existing-database-to-a-new-server-tp58875.html">http://requesttracker.8502.n7.nabble.com/How-to-move-an-existing-database-to-a-new-server-tp58875.html</a>
Sent from the Request Tracker - User mailing list archive at Nabble.com.
</pre>
</blockquote>
<br>
</body>
</html>