Re: [Dhis2-devs] Permission denied for relation i18nlocale

2014-10-07 Thread Bob Jolliffe
The joys of sed ... Hopefully you will get a chance to try out the dhis2-tools some other time. I have timed my typical installation from a scratch ubuntu with just ssh running, down to 3 minutes - of course without the who web filter :-) One of the important things it deals with is running mult

Re: [Dhis2-devs] Permission denied for relation i18nlocale

2014-10-06 Thread Timothy Harding
Bob, Jason, You are exactly right! It was an ownership issue. The dump probably did not have ownership information, so when I imported it came in as 'postgres': postgres@dhis2-2:~$ pg_dump -s dhis2 | grep -i 'owner to' | head ALTER SCHEMA private OWNER TO postgres; ALTER TABLE private.facilities

Re: [Dhis2-devs] Permission denied for relation i18nlocale

2014-10-06 Thread Bob Jolliffe
Hi Tim Sorry I've been aware of that hanging sentence for a while :-) I guess the problem at the time I was writing that we didn't really have a stable place where this file would be. Since then we moved to github as Knut indicated, so I should just put the link in the documentation. Anyway if

Re: [Dhis2-devs] Permission denied for relation i18nlocale

2014-10-06 Thread Timothy Harding
Thanks Knut, much appreciated :)! Timothy Harding PeaceCorps Volunteer Republic of Vanuatu hardi...@gmail.com +678 5955137 On Tue, Oct 7, 2014 at 8:31 AM, Knut Staring wrote: > Some other pieces > > On Mon, Oct 6, 2014 at 11:29 PM, Knut Staring wrote: > >> You'll find it here https://github.co

Re: [Dhis2-devs] Permission denied for relation i18nlocale

2014-10-06 Thread Knut Staring
Some other pieces On Mon, Oct 6, 2014 at 11:29 PM, Knut Staring wrote: > You'll find it here https://github.com/dhis2/dhis2tools. > > On Mon, Oct 6, 2014 at 11:24 PM, Timothy Harding > wrote: > >> Thank you both Bob and Jason, so much! I will give the suggestions a >> shot. That last link looks

Re: [Dhis2-devs] Permission denied for relation i18nlocale

2014-10-06 Thread Knut Staring
You'll find it here https://github.com/dhis2/dhis2tools. On Mon, Oct 6, 2014 at 11:24 PM, Timothy Harding wrote: > Thank you both Bob and Jason, so much! I will give the suggestions a shot. > That last link looks really promising Bob, but it seems to be very much a > work in progress: > > "Once

Re: [Dhis2-devs] Permission denied for relation i18nlocale

2014-10-06 Thread Timothy Harding
Thank you both Bob and Jason, so much! I will give the suggestions a shot. That last link looks really promising Bob, but it seems to be very much a work in progress: "Once your base system is properly installed and secured you can proceed to install the dhis2-tools package from the apt repository

Re: [Dhis2-devs] Permission denied for relation i18nlocale

2014-10-06 Thread Bob Jolliffe
I suspect Jason is right. People often backup the database with the ownership information intact, which is useful if you want to restore the database on the same system, eg recovering after a crash of some sort, where you want to get everything back to where it was. Having the ownership in the ba

Re: [Dhis2-devs] Permission denied for relation i18nlocale

2014-10-06 Thread Jason Pickering
Hi TIm, Usually, this happens when a local database is restored from a remote dump which belongs to another user not present in your local system. Be sure your database is owned by the user which is present in your hibernate.properties files, and that all tables belong to that user. Otherwise, you

[Dhis2-devs] Permission denied for relation i18nlocale

2014-10-05 Thread Timothy Harding
Hello DHIS2 Developer's List I'm attempting to spin up a couple test instances of DHIS2 inside Ubuntu 14.04 and with both 2.14 and 2.16 and am encountering some problems. If create the postgres user (dhis) and the db (dhis2) and do nothing else, I get the demo version (admin:district) for both 2.