Yes, I had the same issue. Definitely agreed about having this documented in the upgrade notes.
On Tue, Sep 18, 2018 at 6:04 PM Shurajit Dutta <shurajitdu...@gmail.com> wrote: > Hi everyone > > Thanks for the insights. This has fixed the problem for me. > > Perhaps we can add something to the upgrade notes? > > Nick > > On Mon, Sep 17, 2018, 8:30 PM Bernard Sadaka (IM Advisor) < > lib....@pu-ami.org> wrote: > >> Also in order to detect the problems in other permissions on other tables >> I ran this query: >> >> SELECT * >> >> FROM pg_tables t >> >> WHERE t.tableowner <> 'dhis' – dhis is my DHIS2 db user >> >> and schemaname = 'public'; >> >> >> >> I discovered there’s also the table public.spatial_ref_sys that was not >> under my dhis db user, so I altered its owner too. >> >> Thanks for the help. >> >> >> >> 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....@pu-ami.org >> >> *Cell:* +961 71 004 881 (208) >> >> *Skype:* imapuami >> >> *Website:* https://www.pu-ami.org >> >> >> >> >> >> *From:* Stian Sandvold [mailto:st...@dhis2.org] >> *Sent:* Monday, September 17, 2018 03:28 PM >> *To:* Bob Jolliffe <bobjolli...@gmail.com> >> *Cc:* lib....@pu-ami.org; DHIS 2 Users list < >> dhis2-us...@lists.launchpad.net>; DHIS 2 Developers list < >> dhis2-devs@lists.launchpad.net> >> *Subject:* Re: [Dhis2-users] [Dhis2-devs] Error when upgrading DHIS2 >> from 2.29 to 2.30 - relationships >> >> >> >> Did the sql fix your issues or are you still having issues? The superuser >> and ownership is a tricky challenge since we dont know the name of the >> user, but aside from the postgis extension, the upgradescript should be >> runnable as a non-superuser if I remember correctly. >> >> >> >> On Mon, Sep 17, 2018 at 12:36 PM Bob Jolliffe <bobjolli...@gmail.com> >> wrote: >> >> 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....@pu-ami.org> 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....@pu-ami.org >> >> *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....@lists.launchpad.net] *On Behalf Of *Em Le Hong >> *Sent:* Monday, September 17, 2018 11:51 AM >> *To:* Shurajit Dutta <shurajitdu...@gmail.com>; DHIS 2 Developers list < >> dhis2-devs@lists.launchpad.net> >> *Cc:* DHIS 2 Users list <dhis2-us...@lists.launchpad.net> >> *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 <shurajitdu...@gmail.com> >> 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-us...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >> >> >> >> -- >> >> *Em Le Hong* >> >> DHIS2 Implementation| *HISP Vietnam * >> >> em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com >> >> >> >> [image: Image removed by sender.] >> >> >> >> >> >> >> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-devs@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : dhis2-us...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >> >> >> >> -- >> >> Stian Sandvold >> >> Software developer, DHIS2 >> >> University of Oslo >> >> http://www.dhis2.org >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : dhis2-us...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-us...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
