dhis2-users team mailing list archive

[Lars Helge Øverland <lars@xxxxxxxxx>]

Hi Edward,

there is no way currently to tell the version from the database. As you say
it is recommended to back up the encryption key when enabling encryption,
otherwise you risk losing attribute data for good (it is mentioned in the
installation docs here
<https://docs.dhis2.org/master/en/implementer/html/install_encryption_configuration.html#install_considerations_for_encryption>
).

The constraint error you get might stem from an application rename of that
foreign key. Have a look at the programstage table and see if there is a
foreign key to dataentryform table with another name. If so either rename
it to *fk_programstage_dataentryform* or just delete it and restart the app.

best regards,

Lars




On Mon, Jul 17, 2017 at 1:48 AM, Edward Robinson <
erobinson@xxxxxxxxxxxxxxxxxx> wrote:

> An update on this, it turns out the encryption.password setting in the
> hibernate.properties file was overwritten with an incorrect value.
> Fortunately someone on the team recalled what it was previously as the file
> had not been backed up along with the database.  That accounts for the
> org.jasypt.exceptions. EncryptionOperationNotPossibleException error.  I
> am now able to get the system up and access the UI.  Lesson, always backup
> hibernate.properties along with the database!
>
> I am still getting some errors and warnings, they may be benign, but if
> anyone has insight into them, I would appreciate it greatly, particularly
> the errors:
>
>
>
> * WARN  2017-07-16 19:05:27,445 [127.0.0.1]:5701 [dev] [3.2.1] No join
> method is enabled! Starting standalone. (HazelcastInstanceImpl.java
> [localhost-startStop-1])
>
> ** ERROR 2017-07-16 19:05:45,648 HHH000388: Unsuccessful: alter table
> programstage add constraint fk_programstage_dataentryform foreign key
> (dataentryformid) references dataentryform (SchemaUpdate.java
> [localhost-startStop-1])*
>
> ** ERROR 2017-07-16 19:05:45,649 ERROR: constraint
> "fk_programstage_dataentryform" for relation "programstage" already exists
> (SchemaUpdate.java [localhost-startStop-1])*
>
> * WARN  2017-07-16 19:06:37,114 RP discovery / realm validation disabled;
> (RealmVerifier.java [localhost-startStop-1])
>
> * WARN  2017-07-16 19:07:16,113 Did not find any ViewResolvers to delegate
> to; please configure them using the 'viewResolvers' property on the
> ContentNegotiatingViewResolver (ContentNegotiatingViewResolver.java
> [localhost-startStop-1])
>
> * WARN  2017-07-16 19:07:26,335 Did not find any ViewResolvers to delegate
> to; please configure them using the 'viewResolvers' property on the
> ContentNegotiatingViewResolver (ContentNegotiatingViewResolver.java
> [localhost-startStop-1])
>
> * WARN  2017-07-16 19:07:29,027 Ignoring action package with no actions:
> struts-default (DefaultModuleManager.java [http-bio-8080-exec-7])
>
> * WARN  2017-07-16 19:07:29,028 Ignoring action package with no actions:
> spring-default (DefaultModuleManager.java [http-bio-8080-exec-7])
>
> * WARN  2017-07-16 19:07:29,028 Ignoring action package with no actions:
> dhis-web-commons (DefaultModuleManager.java [http-bio-8080-exec-7])
>
> * WARN  2017-07-16 19:07:29,030 Ignoring action package with no actions:
> dhis-web-ohie (DefaultModuleManager.java [http-bio-8080-exec-7])
>
> * WARN  2017-07-16 19:07:29,030 Ignoring action package with no actions:
> dhis-web-portal (DefaultModuleManager.java [http-bio-8080-exec-7])
>
>
>
> Cheers,
>
> Ed
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
lars@xxxxxxxxx
http://www.dhis2.org <https://www.dhis2.org/>