dhis2-devs team mailing list archive

["jason.p.pickering" <727779@xxxxxxxxxxxxxxxxxx>]

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
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])