[ovirt-users] Re: Please help: Failure Restoring Data on Clean Engine After Migration

2022-07-19 Thread Andrei Verovski
> On 19 Jul 2022, at 09:51, Yedidyah Bar David wrote: > > On Tue, Jul 19, 2022 at 9:38 AM Andrei Verovski wrote: >> >> Hi, >> >> >> Thanks, I solved this problem before by means of executing these commands: >> >> su - postgres -s/bin/bash >> psql -d ovirt_engine_history >> >> CREATE ROLE

[ovirt-users] Re: Please help: Failure Restoring Data on Clean Engine After Migration

2022-07-19 Thread Yedidyah Bar David
On Tue, Jul 19, 2022 at 9:38 AM Andrei Verovski wrote: > > Hi, > > > Thanks, I solved this problem before by means of executing these commands: > > su - postgres -s/bin/bash > psql -d ovirt_engine_history > > CREATE ROLE ovirt_engine_history_grafana; > ALTER DEFAULT PRIVILEGES FOR ROLE

[ovirt-users] Re: Please help: Failure Restoring Data on Clean Engine After Migration

2022-07-19 Thread Andrei Verovski
Hi, Thanks, I solved this problem before by means of executing these commands: su - postgres -s/bin/bash psql -d ovirt_engine_history CREATE ROLE ovirt_engine_history_grafana; ALTER DEFAULT PRIVILEGES FOR ROLE ovirt_engine_history IN SCHEMA public GRANT SELECT ON TABLES TO

[ovirt-users] Re: Please help: Failure Restoring Data on Clean Engine After Migration

2022-07-18 Thread Yedidyah Bar David
On Fri, Jul 15, 2022 at 10:31 AM Andrei Verovski wrote: > > 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;

[ovirt-users] Re: Please help: Failure Restoring Data on Clean Engine After Migration

2022-07-15 Thread Andrei Verovski
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’;

[ovirt-users] Re: Please help: Failure Restoring Data on Clean Engine After Migration

2022-07-14 Thread Moritz Baumann
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

[ovirt-users] Re: Please help: Failure Restoring Data on Clean Engine After Migration

2022-07-14 Thread Moritz Baumann
On 7/14/22 16:37, Moritz Baumann 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.