Database upgrade permissions

RT Users
1

Hi all,

I’m about to perform an upgrade on an old RT instance (3.8.7) in the hopes of moving to 5.0.0

Essentially, I’m on a new host with a fresh install of RT 5.0.0 but without an initialised DB.

I’ve had the DBA’s at work clone the database to a dev instance and my plan is to point the rt-setup-database script at this dev copy and give it a try (using the args “–action upgrade --prompt-for-dba-password”).

Noting those args, I see looking inside the scripts that using the upgrade function there is no option to “not use DBA” and I won’t be given DBA privileges, but rather user privileges to everything in the existing RT database (we’re talking oracle here).

Is this merely a programmatic oversight and in-fact it will “just work” without DBA privs (but proving the user creds when prompted), or will things actually fail without true DBA privs?

Everything moves slow here and if I bugger this up, it’ll no doubt be 2 weeks before I get another copy to try again with, so thus why I’m reaching out in the first instance.

Help, info and advice would be really appreciated.

Cheers!
Aaron.

2

So the database does exist already or do you only have a sql dump? You need create/drop rights I believe

3

Database already exists, exact working mirror of the 3.8.7 installation.

4

Anyone able to shed any further light on this one?

5

You can try running the upgrade and setting the “dba” user to whichever user you are able to connect to:

sbin/rt-setup-database --action upgrade --prompt-for-dba-password --dba some_user

So long as your user has the necessary rights I don’t see why the upgrade would fail. They need to be able to edit/drop/add tables, since the database already exists you may be able to get around the create/drop database rights

1 Like
6

Thanks!

That’s pretty much exactly what I was after… now I’m just fighting SID issues…
Do you know, does RT looks for a TNS names entry on the local Oracle install? (vanilla instant client).

Reason is I cannot get past:

DBI connect('sid=SOMETHING;host=myhost.mydomain;port=1521','RT',...) failed: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)

That SID exists on the db at myhost, but its almost like the client is falling over without even trying to connect.