Error when running curl command

Support - Assistance technique
#1

Hi everyone,

  We are working with a copy of a country's DHIS2 instance to build

a push mechanism to transfer data from our databases to DHIS2.
DHIS2 is relatively new to our team and we’ve run into an error
that our first line of support wasn’t able to answer and wanted to
see if anyone here had any advice.

  We are running the following command:

      curl -k -H "Accept:application/json" -u [username]:[password]

and are seeing the following error in catalina.out:
==> catalina.out <==

  • INFO 2016-04-06
    15:12:07,665 Login success for user: ‘clinipak’, ip:
    ‘127.0.0.1’ (DefaultUserAuditService.java [tomcat-http-7] )

  • INFO 2016-04-06
    15:12:07,691 ‘clinipak’ create org.hisp.dhis.period.Period,
    name: 2016, uid: 2016 (AuditLogUtil.java [tomcat-http-7] )

  • WARN 2016-04-06
    15:12:07,693 SQL Error: 0, SQLState: 42501
    (SqlExceptionHelper.java [tomcat-http-7] )

  • ERROR 2016-04-06
    15:12:07,693 ERROR: permission denied for sequence
    hibernate_sequence (SqlExceptionHelper.java [tomcat-http-7])

         Apr 06, 2016 3:12:07 PM

org.apache.catalina.core.StandardWrapperValve invoke

        SEVERE: Servlet.service() for servlet [webapi]
        in context with path [/dhis] threw

exception [Request processing failed;
nested exception is
org.hibernate.exception.SQLGrammarException: could not
extract ResultSet] with root cause

        org.postgresql.util.PSQLException: ERROR: permission denied

for sequence hibernate_sequence

        at

org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)

        at

org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)

        at

org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

        at

org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)

        at

org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)

        at

org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304)
Any help is
appreciated.

Thanks!

Seth

···

“https:///dhis/api/dataValueSets?dataSet=lyVV9bPLlVy&period=2016&orgUnit=BnmNOtKZ12G”


-- Information is Power

http://vecnacares.org

#2

Hi Seth,

Check your permissions on the postgres database

ERROR: permission denied for sequence hibernate_sequence

means that the user dhis2 is connecting with does not have access to the postgres sequence.

Check who owns the sequence, and change it to the same user as the one you are using to connect to the database with from DHIS2.

Regards,

Jason

···

On Fri, Apr 15, 2016 at 8:15 AM, Seth Reddy seth.reddy@vecna.com wrote:

Hi everyone,

  We are working with a copy of a country's DHIS2 instance to build a push mechanism to transfer data from our databases to DHIS2. DHIS2 is relatively new to our team and we've run into an error that our first line of support wasn't able to answer and wanted to see if anyone here had any advice.



  We are running the following command:





curl -k ["https:///dhis/api/dataValueSets?dataSet=lyVV9bPLlVy&period=2016&orgUnit=BnmNOtKZ12G"](https://nigeria-dhis2.vecnacares.org/dhis/api/dataValueSets?dataSet=lyVV9bPLlVy&period=2016&orgUnit=BnmNOtKZ12G)
  -H "Accept:application/json" -u [username]:[password]



  and are seeing the following error in catalina.out:

==> catalina.out <==

  • INFO 2016-04-06 15:12:07,665 Login success for user: ‘clinipak’, ip: ‘127.0.0.1’ (DefaultUserAuditService.java [tomcat-http-7] )

  • INFO 2016-04-06 15:12:07,691 ‘clinipak’ create org.hisp.dhis.period.Period, name: 2016, uid: 2016 (AuditLogUtil.java [tomcat-http-7] )

  • WARN 2016-04-06 15:12:07,693 SQL Error: 0, SQLState: 42501 (SqlExceptionHelper.java [tomcat-http-7] )

  • ERROR 2016-04-06 15:12:07,693 ERROR: permission denied for sequence hibernate_sequence (SqlExceptionHelper.java [tomcat-http-7])

         Apr 06, 2016 3:12:07 PM org.apache.catalina.core.StandardWrapperValve invoke

     SEVERE: Servlet.service() for servlet [webapi]
     in context with path [/dhis] threw exception             [Request processing failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet] with root cause

     org.postgresql.util.PSQLException: ERROR: permission denied for sequence hibernate_sequence

     at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)

     at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)

     at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

     at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)

     at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)

     at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304)
 Any help is appreciated.

Thanks!

Seth

-- [http://vecnacares.org](http://vecnacares.org)
Information is Power

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049