Details
-
Bug
-
Status: Resolved
-
Resolution: Done
-
None
-
None
-
None
-
Operating System: All
Platform: All
-
3820
Description
H2 database initialization parameters were left "as is" verbatim from sqlite3 which is
1. Incorrect
2. Reduces functionality
Background: It was possible to recover, reset or otherwise "fix" the database in Helium using a range of tools - command line sqlite3 utility, python, perl, etc.
That functionality should be possible with the H2 database as well due to H2 providing reasonable level of support for the Postgresql connection protocol.
Unfortunately, it is not possible to use it because the specific H2 postgresql protocol implementation insists on valid username and password.
As a result it is no longer possible to recover, reset, backup cleanly in non-binary form for upgrade and migration purposes the database.
Solution - add username and password to database instantiation (unfortunately not backwards compatible as the current Li database is not created correctly).