<div dir="ltr">On Thu, Apr 25, 2013 at 1:22 PM, saxmad <span dir="ltr"><<a href="mailto:g.mason@fairfx.com" target="_blank">g.mason@fairfx.com</a>></span> wrote:<br><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
I tried setting up the database as Thomas suggested, and it certainly made a<br>
difference. However, I did get the following errors. Should I be worried<br>
by them, or can they be ignored, based on what I am trying to do ?<br>
<div class="im"><br></div></blockquote><div><br></div><div style>No, they can not be ignored. What Thomas suggested just creates empty database</div><div style>and grants rights to rt_user, but it doesn't work as expected. ACL step doesn't grant rights</div>
<div style>as objects (tables, sequences, indexes...) are not there.</div><div style><br></div><div style>What you can do is:</div><div style><br></div><div style>1) create database:</div><div style><br></div><div style><span style="font-family:arial,sans-serif;font-size:13px">rt-setup-database-4 --action create</span><br>
</div><div style><span style="font-family:arial,sans-serif;font-size:13px"><br></span></div><div style><span style="font-family:arial,sans-serif;font-size:13px">2) upload data dump without privileges as DBA user into this new DB, see -x option of pg_dump.</span></div>
<div style><span style="font-family:arial,sans-serif;font-size:13px"><br></span></div><div style><span style="font-family:arial,sans-serif">3) create rt_user and grant him permissions:</span><br></div><div style><div><span style="font-family:arial,sans-serif;font-size:13px"><br class="">
rt-setup-database-4 --action acl</span><br></div><div><br></div><div><br></div><div style>Your log should be clean of all DBD::Pg::st errors.</div><div><br></div></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div class="im">
Working with:<br>
Type: Pg<br>
Host: localhost<br>
Name: rtdb<br>
User: rtuser<br>
DBA: postgres<br>
</div>Now creating a Pg database rtdb for RT.<br>
Done.<br>
Now inserting database ACLs.<br>
DBD::Pg::st execute failed: ERROR: relation "attachments_id_seq" does not<br>
exist at /usr/share/request-tracker4/lib/RT/Handle.pm line 439, <STDIN> line<br>
1.<br>
DBD::Pg::st execute failed: ERROR: relation "attachments_id_seq" does not<br>
exist at /usr/share/request-tracker4/lib/RT/Handle.pm line 439, <STDIN> line<br>
1.<br>
<br>
I carried on with importing my data and ran another upgrade. This time it<br>
got a lot further, but it still stopped early with the following text :-<br>
<br>
Processing 3.9.8<br>
Now populating database schema.<br>
Now inserting data.<br>
[Thu Apr 25 09:20:33 2013] [warning]: DBD::Pg::db table_info failed: ERROR:<br>
column t.spclocation does not exist<br>
LINE 11: ...t(t.spcname) AS "pg_tablespace_name", quote_ident(t.spclocat...<br>
^ at<br>
/usr/share/request-tracker4/etc/upgrade/3.9.8/content line 3.<br>
(/usr/share/request-tracker4/etc/upgrade/3.9.8/content:3)<br>
Couldn't finish 'upgrade' step.<br>
<br>
ERROR: One of initial functions failed: DBD::Pg::db table_info failed:<br>
ERROR: column t.spclocation does not exist<br>
LINE 11: ...t(t.spcname) AS "pg_tablespace_name", quote_ident(t.spclocat...<br>
^ at<br>
/usr/share/request-tracker4/etc/upgrade/3.9.8/content line 3.<br>
<br>
What can I do to get the upgrade past this point ?<br>
<br>
<br>
<br>
<br>
--<br>
View this message in context: <a href="http://requesttracker.8502.n7.nabble.com/Problems-upgrading-from-3-9-3-tp53543p53610.html" target="_blank">http://requesttracker.8502.n7.nabble.com/Problems-upgrading-from-3-9-3-tp53543p53610.html</a><br>
<div class=""><div class="h5">Sent from the Request Tracker - User mailing list archive at Nabble.com.<br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br>Best regards, Ruslan.
</div></div>