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 < erobin...@projectbalance.com> 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@lists.launchpad.net > 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 l...@dhis2.org http://www.dhis2.org <https://www.dhis2.org/>
_______________________________________________ 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
