Restore failed. Cannot connect to DWH database using existing credentials.

On Sat, Dec 26, 2020 at 8:12 PM Николаев Алексей <alexeynikolaev.post@yandex.ru> wrote:
Hi community!
I have issue when trying to restore 4.3.10.4 hosted engine.
hosted-engine --deploy --restore-from-file=/opt/engine-backup.dump If I not use --restore-from-file I can not correctly restore my hosted engine datacenter and cluster. But another DCs restored fine.
If the source engine machine has DWH DB on the engine machine, provisioned automatically by engine-setup, then above should not fail. If it does, it might be a bug. Please check/share relevant logs. Thanks.
[ ERROR ] Failed to execute stage 'Environment setup': Cannot connect to DWH database using existing credentials: ovirt_engine_history@localhost:5432
I know that i can fix problem by editing PostgreSQL pg_hba.conf and set ACLs to trust. Is any way to customize hosted engine appliance to replace pg_hba.conf to my version? Is any way to pause deploy proccess and access to hosted engine VM to edit PostgreSQL config?
Yes, you can place a "enginevm_before_engine_setup" hook, it will be ran before engine-setup. Good luck and best regards, -- Didi

Thx for answer! 27.12.2020 12:05, Yedidyah Bar David пишет:
Hi community!
I have issue when trying to restore 4.3.10.4 hosted engine.
hosted-engine --deploy --restore-from-file=/opt/engine-backup.dump If I not use --restore-from-file I can not correctly restore my hosted engine datacenter and cluster. But another DCs restored fine. If the source engine machine has DWH DB on the engine machine,
On Sat, Dec 26, 2020 at 8:12 PM Николаев Алексей <alexeynikolaev.post@yandex.ru> wrote: provisioned automatically by engine-setup, then above should not fail. If it does, it might be a bug. Please check/share relevant logs. Thanks.
Link for install log https://gist.github.com/virtio-technique/bca620fbbca90e7f707f0b3b40575ee2
[ ERROR ] Failed to execute stage 'Environment setup': Cannot connect to DWH database using existing credentials: ovirt_engine_history@localhost:5432
I know that i can fix problem by editing PostgreSQL pg_hba.conf and set ACLs to trust. Is any way to customize hosted engine appliance to replace pg_hba.conf to my version? Is any way to pause deploy proccess and access to hosted engine VM to edit PostgreSQL config? Yes, you can place a "enginevm_before_engine_setup" hook, it will be ran before engine-setup.
Great, but I can't find the example file in my installation /usr/share/ovirt-hosted-engine-setup/ansible/hooks/enginevm_before_engine_setup/enginevm_before_engine_setup.yml.example. Is there any documentation to engine setup hooks?
Good luck and best regards,

On Sun, Dec 27, 2020 at 12:17 PM Alexey Nikolaev <alexeynikolaev.post@yandex.ru> wrote:
Thx for answer!
27.12.2020 12:05, Yedidyah Bar David пишет:
Hi community!
I have issue when trying to restore 4.3.10.4 hosted engine.
hosted-engine --deploy --restore-from-file=/opt/engine-backup.dump If I not use --restore-from-file I can not correctly restore my hosted engine datacenter and cluster. But another DCs restored fine. If the source engine machine has DWH DB on the engine machine,
On Sat, Dec 26, 2020 at 8:12 PM Николаев Алексей <alexeynikolaev.post@yandex.ru> wrote: provisioned automatically by engine-setup, then above should not fail. If it does, it might be a bug. Please check/share relevant logs. Thanks.
Link for install log https://gist.github.com/virtio-technique/bca620fbbca90e7f707f0b3b40575ee2
That's not enough - please check/share all files there. Thanks. From the log, it seems like dwh db was not included, which probably means that it was either remote (dwh on a separate machine) or you passed '--scope=files --scope=db' when taking the backup. If latter: 1. Where did you find instructions to do this? This should be fixed. 2. Please try again, either without --scope, or with --scope=all, or '--scope=files --scope=db --scope=dwhdb'. If it's former (dwh+its db are on a separate machine), then the documentation is not yet up-to-date - please see also: https://bugzilla.redhat.com/show_bug.cgi?id=1874904
[ ERROR ] Failed to execute stage 'Environment setup': Cannot connect to DWH database using existing credentials: ovirt_engine_history@localhost:5432
I know that i can fix problem by editing PostgreSQL pg_hba.conf and set ACLs to trust. Is any way to customize hosted engine appliance to replace pg_hba.conf to my version? Is any way to pause deploy proccess and access to hosted engine VM to edit PostgreSQL config? Yes, you can place a "enginevm_before_engine_setup" hook, it will be ran before engine-setup.
Great, but I can't find the example file in my installation /usr/share/ovirt-hosted-engine-setup/ansible/hooks/enginevm_before_engine_setup/enginevm_before_engine_setup.yml.example.
Is there any documentation to engine setup hooks?
I am only aware of: https://github.com/oVirt/ovirt-ansible-collection/tree/master/roles/hosted_e... The code moved there recently - before that, it was in: https://github.com/oVirt/ovirt-ansible-hosted-engine-setup There are a few examples scattered around the net, in this mailing list, bugzilla, etc. One I wrote myself recently is "required_networks_fix.yml" mentioned there (and included inside examples/). Best regards, -- Didi

27.12.2020 13:55, Yedidyah Bar David пишет:
On Sun, Dec 27, 2020 at 12:17 PM Alexey Nikolaev <alexeynikolaev.post@yandex.ru> wrote:
Thx for answer!
27.12.2020 12:05, Yedidyah Bar David пишет:
Hi community!
I have issue when trying to restore 4.3.10.4 hosted engine.
hosted-engine --deploy --restore-from-file=/opt/engine-backup.dump If I not use --restore-from-file I can not correctly restore my hosted engine datacenter and cluster. But another DCs restored fine. If the source engine machine has DWH DB on the engine machine,
On Sat, Dec 26, 2020 at 8:12 PM Николаев Алексей <alexeynikolaev.post@yandex.ru> wrote: provisioned automatically by engine-setup, then above should not fail. If it does, it might be a bug. Please check/share relevant logs. Thanks. Link for install log https://gist.github.com/virtio-technique/bca620fbbca90e7f707f0b3b40575ee2 That's not enough - please check/share all files there. Thanks.
From the log, it seems like dwh db was not included, which probably means that it was either remote (dwh on a separate machine) or you passed '--scope=files --scope=db' when taking the backup.
Wow, the --scope=files --scope=db parameters were actually used. The worst thing is that the internal wiki has the correct parameter "--scope=all". I'll try to perform the backup again and redeploy engine. Many thanks.
If latter:
1. Where did you find instructions to do this? This should be fixed.
Well, I suspect that this link was mistakenly used https://www.ovirt.org/documentation/installing_ovirt_as_a_self-hosted_engine... (Migrating the Self-Hosted Engine Database to a Remote Server -> 3. Create the engine database backup)
2. Please try again, either without --scope, or with --scope=all, or '--scope=files --scope=db --scope=dwhdb'.
If it's former (dwh+its db are on a separate machine), then the documentation is not yet up-to-date - please see also:
https://bugzilla.redhat.com/show_bug.cgi?id=1874904
[ ERROR ] Failed to execute stage 'Environment setup': Cannot connect to DWH database using existing credentials: ovirt_engine_history@localhost:5432
I know that i can fix problem by editing PostgreSQL pg_hba.conf and set ACLs to trust. Is any way to customize hosted engine appliance to replace pg_hba.conf to my version? Is any way to pause deploy proccess and access to hosted engine VM to edit PostgreSQL config? Yes, you can place a "enginevm_before_engine_setup" hook, it will be ran before engine-setup. Great, but I can't find the example file in my installation /usr/share/ovirt-hosted-engine-setup/ansible/hooks/enginevm_before_engine_setup/enginevm_before_engine_setup.yml.example.
Is there any documentation to engine setup hooks? I am only aware of:
https://github.com/oVirt/ovirt-ansible-collection/tree/master/roles/hosted_e...
The code moved there recently - before that, it was in:
https://github.com/oVirt/ovirt-ansible-hosted-engine-setup
There are a few examples scattered around the net, in this mailing list, bugzilla, etc. One I wrote myself recently is "required_networks_fix.yml" mentioned there (and included inside examples/).
Best regards,

On Mon, Dec 28, 2020 at 12:05 AM Alexey Nikolaev <alexeynikolaev.post@yandex.ru> wrote:
27.12.2020 13:55, Yedidyah Bar David пишет:
On Sun, Dec 27, 2020 at 12:17 PM Alexey Nikolaev <alexeynikolaev.post@yandex.ru> wrote:
Thx for answer!
27.12.2020 12:05, Yedidyah Bar David пишет:
Hi community!
I have issue when trying to restore 4.3.10.4 hosted engine.
hosted-engine --deploy --restore-from-file=/opt/engine-backup.dump If I not use --restore-from-file I can not correctly restore my hosted engine datacenter and cluster. But another DCs restored fine. If the source engine machine has DWH DB on the engine machine,
On Sat, Dec 26, 2020 at 8:12 PM Николаев Алексей <alexeynikolaev.post@yandex.ru> wrote: provisioned automatically by engine-setup, then above should not fail. If it does, it might be a bug. Please check/share relevant logs. Thanks. Link for install log https://gist.github.com/virtio-technique/bca620fbbca90e7f707f0b3b40575ee2 That's not enough - please check/share all files there. Thanks.
From the log, it seems like dwh db was not included, which probably means that it was either remote (dwh on a separate machine) or you passed '--scope=files --scope=db' when taking the backup.
Wow, the --scope=files --scope=db parameters were actually used. The worst thing is that the internal wiki has the correct parameter "--scope=all".
I'll try to perform the backup again and redeploy engine. Many thanks.
Good luck!
If latter:
1. Where did you find instructions to do this? This should be fixed.
Well, I suspect that this link was mistakenly used
https://www.ovirt.org/documentation/installing_ovirt_as_a_self-hosted_engine...
Thanks for the report, now filed: https://bugzilla.redhat.com/show_bug.cgi?id=1911202 Best regards, -- Didi
participants (3)
-
Alexey Nikolaev
-
Yedidyah Bar David
-
Николаев Алексей