dhis2-devs team mailing list archive

[ola testuser <727779@xxxxxxxxxxxxxxxxxx>]

I always set the 'dhis database user' (the user in hibernate.properties) to
be the owner of the database.

Any potential problems with that approach?

----------------------------------
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps
link<http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=Vetlandsvn.+95B,+0685+Oslo,+Norway>


On 2 March 2011 16:48, jason.p.pickering <727779@xxxxxxxxxxxxxxxxxx> wrote:

> I suspect what is happening is the following.
>
> New tables are created and columns perhaps added to table, but
> permissions are not set explicitly for the DHIS2 user, so these
> operations may fail somewhere during the process. This is not a
> problem when the DB owner is the same as the DHIS2 database user.
> However, when the DB owner and DHIS2 database user are different, new
> tables are created, but DHIS2 does not have any permissions to operate
> on those tables.
> ...
> Not sure about this one
>
>
> On Wed, Mar 2, 2011 at 4:40 PM, jason.p.pickering
> <727779@xxxxxxxxxxxxxxxxxx> wrote:
> > These types of errors seem to result from incorrect permission settings
> > on the DB for the user which DHIS2 connects to the DB with.
> >
> > ** Changed in: dhis2
> >       Status: New => Invalid
> >
> > --
> > You received this bug notification because you are a direct subscriber
> > of the bug.
> > https://bugs.launchpad.net/bugs/727779
> >
> > Title:
> >  startup-routines-fail-when-database-user-permissions-are-not-set
> >
> > Status in DHIS 2 - District Health Information Software:
> >  Invalid
> >
> > Bug description:
> >  * INFO  13:33:49,514 System property dhis2.home not set
> >  (DefaultLocationManager.java [Thread-2])
> >  * INFO  13:33:49,520 Environment variable DHIS2_HOME points to
> >  /etc/dhis2/ghain/ (DefaultLocationManager.java [Thread-2])
> >  * INFO  13:35:37,796 Executing startup routine [1 of 12, runlevel 1]:
> >  TableAlteror (DefaultStartupRoutineExecutor.java [Thread-2])
> >  * INFO  13:35:42,926 Tables updated (TableAlteror.java [Thread-2])
> >  * INFO  13:35:42,971 Executing startup routine [2 of 12, runlevel 2]:
> >  PeriodTypePopulator (DefaultStartupRoutineExecutor.java [Thread-2])
> >  * INFO  13:35:43,171 Executing startup routine [3 of 12, runlevel 3]:
> >  TableCreator (DefaultStartupRoutineExecutor.java [Thread-2])
> >  * INFO  13:35:43,311 Table aggregateddatavalue exists
> >  (TableCreator.java [Thread-2])
> >  * INFO  13:35:43,326 Table aggregatedindicatorvalue exists
> >  (TableCreator.java [Thread-2])
> >  * INFO  13:35:43,345 Index crosstab exists on table datavalue
> >  (TableCreator.java [Thread-2])
> >  * INFO  13:35:43,349 Table aggregateddatasetcompleteness exists
> >  (TableCreator.java [Thread-2])
> >  * INFO  13:35:43,354 Table datavaluearchive exists (TableCreator.java
> >  [Thread-2])
> >  * INFO  13:35:43,358 Table patientdatavaluearchive exists
> >  (TableCreator.java [Thread-2])
> >  * INFO  13:35:43,359 Executing startup routine [4 of 12, runlevel 3]:
> >  DataElementDefaultDimensionPopulator
> >  (DefaultStartupRoutineExecutor.java [Thread-2])
> >  * INFO  13:35:43,431 Linked default category with default concept
> >  (DataElementDefaultDimensionPopulator.java [Thread-2])
> >  * INFO  13:35:46,037 Executing startup routine [5 of 12, runlevel 3]:
> >  MultiDimensionExpressionUpgrader (DefaultStartupRoutineExecutor.java
> >  [Thread-2])
> >  * WARN  13:35:46,078 SQL Error: 0, SQLState: 42703
> >  (JDBCExceptionReporter.java [Thread-2])
> >  * ERROR 13:35:46,079 ERROR: column dataelemen1_.uuid does not exist
> >   Position: 166 (JDBCExceptionReporter.java [Thread-2])
> >
> > To unsubscribe from this bug, go to:
> > https://bugs.launchpad.net/dhis2/+bug/727779/+subscribe
> >
>
>
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+260974901293
>
> --
> You received this bug notification because you are a member of DHIS 2
> coordinators, which is the registrant for DHIS.
> https://bugs.launchpad.net/bugs/727779
>
> Title:
>  startup-routines-fail-when-database-user-permissions-are-not-set
>
> Status in DHIS 2 - District Health Information Software:
>  Invalid
>
> Bug description:
>  * INFO  13:33:49,514 System property dhis2.home not set
>  (DefaultLocationManager.java [Thread-2])
>  * INFO  13:33:49,520 Environment variable DHIS2_HOME points to
>  /etc/dhis2/ghain/ (DefaultLocationManager.java [Thread-2])
>  * INFO  13:35:37,796 Executing startup routine [1 of 12, runlevel 1]:
>  TableAlteror (DefaultStartupRoutineExecutor.java [Thread-2])
>  * INFO  13:35:42,926 Tables updated (TableAlteror.java [Thread-2])
>  * INFO  13:35:42,971 Executing startup routine [2 of 12, runlevel 2]:
>  PeriodTypePopulator (DefaultStartupRoutineExecutor.java [Thread-2])
>  * INFO  13:35:43,171 Executing startup routine [3 of 12, runlevel 3]:
>  TableCreator (DefaultStartupRoutineExecutor.java [Thread-2])
>  * INFO  13:35:43,311 Table aggregateddatavalue exists
>  (TableCreator.java [Thread-2])
>  * INFO  13:35:43,326 Table aggregatedindicatorvalue exists
>  (TableCreator.java [Thread-2])
>  * INFO  13:35:43,345 Index crosstab exists on table datavalue
>  (TableCreator.java [Thread-2])
>  * INFO  13:35:43,349 Table aggregateddatasetcompleteness exists
>  (TableCreator.java [Thread-2])
>  * INFO  13:35:43,354 Table datavaluearchive exists (TableCreator.java
>  [Thread-2])
>  * INFO  13:35:43,358 Table patientdatavaluearchive exists
>  (TableCreator.java [Thread-2])
>  * INFO  13:35:43,359 Executing startup routine [4 of 12, runlevel 3]:
>  DataElementDefaultDimensionPopulator
>  (DefaultStartupRoutineExecutor.java [Thread-2])
>  * INFO  13:35:43,431 Linked default category with default concept
>  (DataElementDefaultDimensionPopulator.java [Thread-2])
>  * INFO  13:35:46,037 Executing startup routine [5 of 12, runlevel 3]:
>  MultiDimensionExpressionUpgrader (DefaultStartupRoutineExecutor.java
>  [Thread-2])
>  * WARN  13:35:46,078 SQL Error: 0, SQLState: 42703
>  (JDBCExceptionReporter.java [Thread-2])
>  * ERROR 13:35:46,079 ERROR: column dataelemen1_.uuid does not exist
>   Position: 166 (JDBCExceptionReporter.java [Thread-2])
>

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/727779

Title:
  startup-routines-fail-when-database-user-permissions-are-not-set

Status in DHIS 2 - District Health Information Software:
  Invalid

Bug description:
  * INFO  13:33:49,514 System property dhis2.home not set
  (DefaultLocationManager.java [Thread-2])
  * INFO  13:33:49,520 Environment variable DHIS2_HOME points to
  /etc/dhis2/ghain/ (DefaultLocationManager.java [Thread-2])
  * INFO  13:35:37,796 Executing startup routine [1 of 12, runlevel 1]:
  TableAlteror (DefaultStartupRoutineExecutor.java [Thread-2])
  * INFO  13:35:42,926 Tables updated (TableAlteror.java [Thread-2])
  * INFO  13:35:42,971 Executing startup routine [2 of 12, runlevel 2]:
  PeriodTypePopulator (DefaultStartupRoutineExecutor.java [Thread-2])
  * INFO  13:35:43,171 Executing startup routine [3 of 12, runlevel 3]:
  TableCreator (DefaultStartupRoutineExecutor.java [Thread-2])
  * INFO  13:35:43,311 Table aggregateddatavalue exists
  (TableCreator.java [Thread-2])
  * INFO  13:35:43,326 Table aggregatedindicatorvalue exists
  (TableCreator.java [Thread-2])
  * INFO  13:35:43,345 Index crosstab exists on table datavalue
  (TableCreator.java [Thread-2])
  * INFO  13:35:43,349 Table aggregateddatasetcompleteness exists
  (TableCreator.java [Thread-2])
  * INFO  13:35:43,354 Table datavaluearchive exists (TableCreator.java
  [Thread-2])
  * INFO  13:35:43,358 Table patientdatavaluearchive exists
  (TableCreator.java [Thread-2])
  * INFO  13:35:43,359 Executing startup routine [4 of 12, runlevel 3]:
  DataElementDefaultDimensionPopulator
  (DefaultStartupRoutineExecutor.java [Thread-2])
  * INFO  13:35:43,431 Linked default category with default concept
  (DataElementDefaultDimensionPopulator.java [Thread-2])
  * INFO  13:35:46,037 Executing startup routine [5 of 12, runlevel 3]:
  MultiDimensionExpressionUpgrader (DefaultStartupRoutineExecutor.java
  [Thread-2])
  * WARN  13:35:46,078 SQL Error: 0, SQLState: 42703
  (JDBCExceptionReporter.java [Thread-2])
  * ERROR 13:35:46,079 ERROR: column dataelemen1_.uuid does not exist
   Position: 166 (JDBCExceptionReporter.java [Thread-2])