dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

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 may need to alter the ownership of the database and tables
to the user which is used to access the database.

Best regards,
Jason


On Mon, Oct 6, 2014 at 7:38 AM, Timothy Harding <hardingt@xxxxxxxxx> wrote:

> 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.14 and 2.16. So tomcat
> and postgresql are talking and the server is capable of starting and
> serving pages. I then delete the DB, recreate a blank one and import a
> database dump from our production server (version 2.14). Things go well
> until I execute ./tomcat-dhis/bin/startup.sh this time, the system will
> fail to start either 2.14 or 2.16. Interestingly enough, I can do the exact
> same process in Windows 7 (Postgres and Tomcat again) and 2.14 starts up
> without issue, but I have not tested 2.16 in Windows yet. I'm encountering
> the following error after startup routine 11 of 11 is complete. I've
> included a snippet below from 2.14, and have attached the entire log to
> this email.
>
> System: Ubuntu 14.04
> PostgreSQL 9.3.5
> Tomcat7
>
> * ERROR 2014-10-06 16:06:51,792 ERROR: permission denied for relation
> i18nlocale (SqlExceptionHelper.java [localhost-startStop-1])
> * ERROR 2014-10-06 16:06:51,812
> org.hibernate.exception.SQLGrammarException: could not extract ResultSet
>         at
> org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:122)
>         at
> org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
> (...)
> Caused by: org.postgresql.util.PSQLException: ERROR: permission denied for
> relation i18nlocale
>         at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
>         at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
> (...)
> Oct 06, 2014 4:06:51 PM org.apache.catalina.core.StandardContext
> startInternal
> SEVERE: Error listenerStart
> Oct 06, 2014 4:06:51 PM org.apache.catalina.core.StandardContext
> startInternal
> SEVERE: Context [] startup failed due to previous errors
>
> Any ideas or suggestions are appreciated. I'm both trying to learn how to
> use Ubuntu with DHIS2 (used the following:
> https://www.dhis2.org/doc/snapshot/en/implementer/html/ch08s02.html) and
> attempting to test our migration from 2.14 to 2.16. Thanks!
>
>
>
> Timothy Harding
> PeaceCorps Volunteer
> Republic of Vanuatu
> hardingt@xxxxxxxxx
> +678 5955137
>
> _______________________________________________
> 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
>
>


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049