I’m trying to retrieve a database that was dumped in 2016 from a Windows NT server (with Postgresql < 9.4). I don’t know the Omero version.
The strategy I used so far was to
de-dump the db on my local postgresql 11 server and reset the database name and user to
omeroto get back to something standard.
dump the corrected version with the same postrgresql.
use doker-compose from docker-example-omero to spin the three dockers (database, omeroserver, omeroweb).
stop the omeroserver and omeroweb services.
log into the database docker and drop the existing omero database
dedump the archive with:
docker-compose exec database psql -U omero -d omero -f /backups/omero.dump.sql
codker-compose upthe services again
I know this looks very convoluted, but it got me close to what I wanted .The problem I can’t seem to fix is that after that, the root omero user password is no longer valid (it should be set by the
ROOTPASS variable in
docker-compose.yml). When I long into the database server, I can see the omero database, and that it is not empty. I tried logging into omero from the web client and directly from a shell in omeroserver via
omero login, neither work.
TL;DR from here, is there a way to reset the root omero user password, so that I can try to login again?
Am I doing this very wrong and should I take a completely different approach?