10:30 a.m.
Hi,
I did this and still struck at that Grafana stage.
CREATE ROLE ovirt_engine_history_grafana;
ALTER DEFAULT PRIVILEGES FOR ROLE ovirt_engine_history IN SCHEMA public GRANT SELECT ON
TABLES TO ovirt_engine_history_grafana;
ALTER ROLE ovirt_engine_history_grafana WITH PASSWORD ‘my_password’;
How to delete Grafana completely from old setup???
I don’t need it.
Thanks in advance.
On 14 Jul 2022, at 17:37, Moritz Baumann
<moritz.baumann(a)inf.ethz.ch> wrote:
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(a)ovirt.org
> To unsubscribe send an email to users-leave(a)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/7JORR5ZWZJT...
_______________________________________________
Users mailing list -- users(a)ovirt.org
To unsubscribe send an email to users-leave(a)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/ZZOUZX65Q2E...