Re: dev Digest, Vol 103, Issue 7

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Re: dev Digest, Vol 103, Issue 7

Zacher, Stacy
Thanks to everyone who has offered me assistance with this issue.
It appears that I have changed the owner of each database to the new user I created (ratmine_user), but the objects in that database are not automatically owned by my new user!   I am used to Oracle, where the schema owner owns the objects and no one else can own them.

Is there an easy way to change all objects in each database/schema to be owned by the new user without having to alter each one individually?   I apologize if I am not using the appropriate postgres terminology.

Best regards,
Stacy

-----Original Message-----
From: dev [mailto:[hidden email]] On Behalf Of [hidden email]
Sent: Friday, January 26, 2018 6:00 AM
To: [hidden email]
Subject: dev Digest, Vol 103, Issue 7

ATTENTION: This email originated from a sender outside of MCW. Use caution when clicking on links or opening attachments.
________________________________

Send dev mailing list submissions to
        [hidden email]

To subscribe or unsubscribe via the World Wide Web, visit
        https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.intermine.org_mailman_listinfo_dev&d=DwIGaQ&c=aFamLAsxMIDYjNglYHTMV0iqFn3z4pVFYPQkjgspw4Y&r=gOVZb7TNzY8wrQkgFJZGpQ&m=AALwBcyKRpd8BtWtoeIMGuuhXoX1Ir1O3ZjW56-9iUs&s=yN7Q5yfHMEAzEBOMKvQ9k_jXN_5dqYb70jras7hK0fg&e=
or, via email, send a message with subject or body 'help' to
        [hidden email]

You can reach the person managing the list at
        [hidden email]

When replying, please edit your Subject line so it is more specific than "Re: Contents of dev digest..."


Today's Topics:

   1. Error (Zacher, Stacy)
   2. Re: Error (Julie Sullivan)


----------------------------------------------------------------------

Message: 1
Date: Thu, 25 Jan 2018 23:35:41 +0000
From: "Zacher, Stacy" <[hidden email]>
To: "[hidden email]" <[hidden email]>
Subject: [InterMine Dev] Error
Message-ID: <[hidden email]>
Content-Type: text/plain; charset="utf-8"

Hello:

Our developer is getting an error when trying to get intermine up and running on a server that we just rebuilt.   Originally these databases were built years ago and whoever built intermine chose the postgres superuser to own all the databases.  If possible, we would like to appoint a different database owner instead of postgres.
Is that possible or will intermine not cooperate?   Is it a matter of just altering the database and selecting a new owner or would other permissions in postgres need to be changed as well.

Here is the error the developer is getting:

/data/intermine/git_ratmine/intermine/imbuild/objectstore.xml:98: org.postgresql.util.PSQLException: ERROR: permission denied for relation intermine_metadata

Any assistance would be appreciate.

Thanks!

Stacy Zacher
Database Administrator | Information Services Medical College of Wisconsin [hidden email]<mailto:[hidden email]>
414-955-5654

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.intermine.org_pipermail_dev_attachments_20180125_23250f0e_attachment-2D0001.html&d=DwIGaQ&c=aFamLAsxMIDYjNglYHTMV0iqFn3z4pVFYPQkjgspw4Y&r=gOVZb7TNzY8wrQkgFJZGpQ&m=AALwBcyKRpd8BtWtoeIMGuuhXoX1Ir1O3ZjW56-9iUs&s=lCdutUD4RllV-OWskIXYdIxzATXAlCWv5kMHMUxgqc4&e=>

------------------------------

Message: 2
Date: Fri, 26 Jan 2018 08:43:22 +0000
From: Julie Sullivan <[hidden email]>
To: "Zacher, Stacy" <[hidden email]>, "[hidden email]"
        <[hidden email]>
Subject: Re: [InterMine Dev] Error
Message-ID: <[hidden email]>
Content-Type: text/plain; charset=windows-1252; format=flowed

Hi Stacy

Yes! You can change the owner of the database in postgres, then update the credentials in your ratmine.properties file. You'll have to redeploy your webapp to apply these changes however.

intermine.readthedocs.io/en/latest/webapp/properties/intermine-properties/

If you have more troubles, I am happy to skype! You can also pop onto our discord server: chat.intermine.org

Cheers
Julie

On 01/25/2018 11:35 PM, Zacher, Stacy wrote:

> Hello:
>
> Our developer is getting an error when trying to get intermine up and
> running on a server that we just rebuilt.   Originally these databases
> were built years ago and whoever built intermine chose the postgres
> superuser to own all the databases. If possible, we would like to
> appoint a different database owner instead of postgres.
>
> Is that possible or will intermine not cooperate?   Is it a matter of
> just altering the database and selecting a new owner or would other
> permissions in postgres need to be changed as well.
>
>
> Here is the error the developer is getting:
>
> /data/intermine/git_ratmine/intermine/imbuild/objectstore.xml:98:
> org.postgresql.util.PSQLException: ERROR: permission denied for
> relation intermine_metadata
>
> Any assistance would be appreciate.
>
>
> Thanks!
>
> *Stacy Zacher*
>
> Database Administrator | Information Services
>
> *Medical College of Wisconsin*
>
> [hidden email] <mailto:[hidden email]>
>
> 414-955-5654
>
>
>
> _______________________________________________
> dev mailing list
> [hidden email]
> https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.intermine.o
> rg_mailman_listinfo_dev&d=DwIGaQ&c=aFamLAsxMIDYjNglYHTMV0iqFn3z4pVFYPQ
> kjgspw4Y&r=gOVZb7TNzY8wrQkgFJZGpQ&m=AALwBcyKRpd8BtWtoeIMGuuhXoX1Ir1O3Z
> jW56-9iUs&s=yN7Q5yfHMEAzEBOMKvQ9k_jXN_5dqYb70jras7hK0fg&e=
>


------------------------------

Subject: Digest Footer

_______________________________________________
dev mailing list
[hidden email]
https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.intermine.org_mailman_listinfo_dev&d=DwIGaQ&c=aFamLAsxMIDYjNglYHTMV0iqFn3z4pVFYPQkjgspw4Y&r=gOVZb7TNzY8wrQkgFJZGpQ&m=AALwBcyKRpd8BtWtoeIMGuuhXoX1Ir1O3ZjW56-9iUs&s=yN7Q5yfHMEAzEBOMKvQ9k_jXN_5dqYb70jras7hK0fg&e=


------------------------------

End of dev Digest, Vol 103, Issue 7
***********************************
_______________________________________________
dev mailing list
[hidden email]
https://lists.intermine.org/mailman/listinfo/dev