First, thank you @gquentin, @codebeaver22, @carbonin for documenting your experience and the steps that resolved this problem for you. I tried following your steps carefully, but get the following errors when I try to start the evm server from the appliance_console:
Job for evmserverd.service failed because the control process exited with error code. See “systemctl status evmserverd.service” and “journalctl -xe” for details.
When I run
systemctl status evmserverd.service did not return any errors
When I run
journalctl -xe I get: (trimmed this, it was long)
-- Unit evmserverd.service has begun starting up.
Aug 31 13:26:59 miq-dev.chq.ei sh: rake aborted!
Aug 31 13:26:59 miq-dev.chq.ei sh: PG::ConnectionBad: FATAL: password authentication failed for user "root"
Aug 31 13:26:59 miq-dev.chq.ei sh: FATAL: no pg_hba.conf entry for host "::1", user "root", database "vmdb_production", SSL off
Aug 31 13:26:59 miq-dev.chq.ei systemd: Failed to start EVM server daemon.
-- Subject: Unit evmserverd.service has failed
-- Unit evmserverd.service has failed.
Aug 31 13:26:59 miq-dev.chq.ei systemd: Unit evmserverd.service entered failed state.
Am I right in guessing that the credential for
root was encrypted using the old v2_key so now it’s not able to authenticate with the db? Any tips on how to resolve?