dhis2-users team mailing list archive

[Edward Robinson <erobinson@xxxxxxxxxxxxxxxxxx>]

Thank you Lars, I will do as you suggested and respond with results when I have a chance (hopefully later today)
Regards
Ed

From: Lars Helge Øverland [mailto:lars@xxxxxxxxx]
Sent: Monday, 17 July 2017 8:37 AM
To: Edward Robinson <erobinson@xxxxxxxxxxxxxxxxxx>
Cc: dhis2-users <dhis2-users@xxxxxxxxxxxxxxxxxxx>
Subject: Re: [Dhis2-users] Database version - how to tell

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<mailto: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<mailto: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<mailto:lars@xxxxxxxxx>
http://www.dhis2.org<https://www.dhis2.org/>