I had a similar issue.
for me, taking the password from
/etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/10-setup-grafana-database.conf
(GRAFANA_DB_PASSWORD)
and set that password in postgres for the
user ovirt_engine_history_grafana did the trick.
Best
Mo
On 7/14/22 16:28, Andrei Verovski wrote:
Hi,
I have oVirt engine 4.4.7 running on dedicated PC (not hosted engine).
After several unsuccessful upgrade attempts of 4.4.7 to 4.4.10 decided to
install clean 4.4.10 and migrate data.
On old engine
engine-backup --scope=all --mode=backup
On new engine
engine-backup --mode=restore --provision-all-databases --no-restore-permissions
--file=ovirt-engine-backup-20220713160717.backup
Result:
[ ERROR ] Failed to execute stage 'Environment setup': Cannot connect to
database for grafana using existing credentials:
ovirt_engine_history_grafana@localhost:5432
How to Remove Grafana Completely During Engine Migration, or skip it during
backup?
In fact it would be nice to delete it on active 4.4.7 setup, I don’t need it
anyway.
Thanks in advance.
# — LOG ———————————————————————
Start of engine-backup with mode 'restore'
scope: all
archive file: ovirt-engine-backup-20220713160717.backup
log file: /var/log/ovirt-engine-backup/ovirt-engine-restore-20220714170603.log
Preparing to restore:
- Unpacking file 'ovirt-engine-backup-20220713160717.backup'
Restoring:
- Files
Provisioning PostgreSQL users/databases:
- user 'engine', database 'engine'
- user 'ovirt_engine_history', database 'ovirt_engine_history'
Restoring:
- Engine database 'engine'
- Cleaning up temporary tables in engine database 'engine'
- Updating DbJustRestored VdcOption in engine database
- Resetting DwhCurrentlyRunning in dwh_history_timekeeping in engine database
- Resetting HA VM status
------------------------------------------------------------------------------
Please note:
The engine database was backed up at 2022-07-13 16:07:21.000000000 +0300 .
Objects that were added, removed or changed after this date, such as virtual
machines, disks, etc., are missing in the engine, and will probably require
recovery or recreation.
------------------------------------------------------------------------------
- DWH database 'ovirt_engine_history'
- Grafana database '/var/lib/grafana/grafana.db'
You should now run engine-setup.
Done.
[root@node00 ovirt-engine-backup]# engine-setup
[ INFO ] Stage: Initializing
[ INFO ] Stage: Environment setup
Configuration files:
/etc/ovirt-engine-setup.conf.d/10-packaging-jboss.conf,
/etc/ovirt-engine-setup.conf.d/10-packaging.conf,
/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf
Log file:
/var/log/ovirt-engine/setup/ovirt-engine-setup-20220714170757-7072xx.log
Version: otopi-1.9.6 (otopi-1.9.6-1.el8)
[ INFO ] The engine DB has been restored from a backup
[ ERROR ] Failed to execute stage 'Environment setup': Cannot connect to
database for grafana using existing credentials:
ovirt_engine_history_grafana@localhost:5432
[ INFO ] Stage: Clean up
Log file is located at
/var/log/ovirt-engine/setup/ovirt-engine-setup-20220714170757-7072xx.log
[ INFO ] Generating answer file
'/var/lib/ovirt-engine/setup/answers/20220714170806-setup.conf'
[ INFO ] Stage: Pre-termination
[ INFO ] Stage: Termination
[ ERROR ] Execution of setup failed
_______________________________________________
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
Privacy Statement: https://www.ovirt.org/privacy-policy.html
oVirt Code of Conduct:
https://www.ovirt.org/community/about/community-guidelines/
List Archives:
https://lists.ovirt.org/archives/list/users@ovirt.org/message/7JORR5ZWZJTGPF2FKDUTVI5DRWB2XI5H/
_______________________________________________
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
Privacy Statement: https://www.ovirt.org/privacy-policy.html
oVirt Code of Conduct:
https://www.ovirt.org/community/about/community-guidelines/
List Archives:
https://lists.ovirt.org/archives/list/users@ovirt.org/message/ZZOUZX65Q2EADSBDVRPID7OQRYGMFSLL/
