dhis2-users team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

Good point Bernard.

Interestingly this is the reverse problem to that of creating the postgis
extension. You have to be a superuser role in the database to create the
postgis extension in the database.  But ...

If you have run the upgrade script from
https://github.com/dhis2/dhis2-releases/blob/master/releases/2.30/upgrade-230.sql
as a superuser (eg postgres) then you are going to be left with two new
tables (and a function?) owned by the postgres user.

So you should, in fact, have to do afterwards both:
ALTER TABLE public.relationshipitem OWNER to dhis;
ALTER TABLE public.relationshipconstraint OWNER to dhis;

Which is a little messy :-)  But hard to figure the neatest way around
because we cannot know in advance the name of the dhis db user.

Cheers
Bob

On 17 September 2018 at 09:58, Bernard Sadaka (IM Advisor) <
lib.ima@xxxxxxxxxx> wrote:

> I faced this same error before: “'permission denied for relation XXX”
>
> and I fixed it using this query in the DB:
>
>
>
> ALTER TABLE public.relationshipitem OWNER to dhis;
>
>
>
> Replace dhis with your DB user
>
>
>
> All the best,
>
> Bernard
>
>
>
> [image: cid:image002.png@01D36F50.572585A0]
>
> *Bernard Sadaka*
>
> *Information Management Advisor*
>
> Première Urgence - Aide Médicale Internationale
>
> Nehmeh Building, Sanine Street, Chiyah, 3rd Floor
>
> Ain el Remmaneh, Beirut, Lebanon
>
> *E-mail:* lib.ima@xxxxxxxxxx
>
> *Cell:* +961 71 004 881 (208)
>
> *Skype:* imapuami
>
> *Website:* https://www.pu-ami.org
>
>
>
>
>
> *From:* Dhis2-users [mailto:dhis2-users-bounces+lib.ima=pu-ami.org@lists.
> launchpad.net] *On Behalf Of *Em Le Hong
> *Sent:* Monday, September 17, 2018 11:51 AM
> *To:* Shurajit Dutta <shurajitdutta@xxxxxxxxx>; DHIS 2 Developers list <
> dhis2-devs@xxxxxxxxxxxxxxxxxxx>
> *Cc:* DHIS 2 Users list <dhis2-users@xxxxxxxxxxxxxxxxxxx>
> *Subject:* Re: [Dhis2-users] Error when upgrading DHIS2 from 2.29 to 2.30
> - relationships
>
>
>
> Hi all,
>
>
>
> I got the same problem with Nick.
>
> It says 'permission denied for relation relationshipitem',
>
>
>
> [image: image.png]
>
>
>
> On Tue, Sep 11, 2018 at 11:18 PM Shurajit Dutta <shurajitdutta@xxxxxxxxx>
> wrote:
>
> Hi everyone,
>
>
>
> I am trying to upgrade a DHIS2 instance from 2.29 to 2.30. I have done
> this on a couple other instances successfully. The issue I seem to be
> having here is with the relationship types. In 2.29, I have the following
> relationships:
>
>
>
> [image: image.png]
>
>
>
> This changes to the following (as per the release notes this is expected)
> in 2.30:
>
>
>
> [image: image.png]
>
>
>
> There are a couple issues I seem to be running into.
>
>
>
> 1. I can not seem to edit these relationship types at all (the log error
> says "permission denied for relation relationshipconstraint"
>
>
>
> [image: image.png]
>
>
>
> 2. I can not seem to open any tracker programs in tracker capture (the log
> error says "permission denied for relation relationshipitem")
>
>
>
> [image: image.png]
>
>
>
> Has anyone encountered this error? Any suggestions on how to fix it?
>
>
>
> Thanks
>
>
>
> --
>
> Shurajit Dutta (MPH, MHI)
>
> Health Information Systems Adviser
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
>
>
> --
>
> *Em Le Hong*
>
> DHIS2 Implementation| *HISP Vietnam *
>
> em.hispvietnam@xxxxxxxxx | *Skype:* em.hispvietnam@xxxxxxxxx
>
>
>
> [image: Image removed by sender.]
>
>
>
>
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>