ovirt upgrade - Failed to execute stage 'Misc configuration' FATAL: Ident authentication failed for user "root"
upgrade from ovirt 4.4.4 to 4.5.5 engine-setup 2023-01-24 00:35:17,885+0100 DEBUG otopi.context context._executeMethod:145 method exception Traceback (most recent call last): File "/usr/lib/python3.6/site-packages/otopi/context.py", line 132, in _executeMethod method['method']() File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine-grafana-dwh/db/default_privileges.py", line 51, in _misc_set_default_privileges user=self.environment[ogdwhcons.GrafanaDBEnv.USER], File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/database.py", line 1808, in setDefaultPrivilegesReadOnlyForUser ownConnection=True, File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/database.py", line 249, in execute database=database, File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/database.py", line 182, in connect sslmode=sslmode, File "/usr/lib64/python3.6/site-packages/psycopg2/__init__.py", line 127, in connect conn = _connect(dsn, connection_factory=connection_factory, **kwasync) psycopg2.OperationalError: FATAL: Ident authentication failed for user "root" FATAL: Ident authentication failed for user "root" 2023-01-24 00:35:17,886+0100 ERROR otopi.context context._executeMethod:154 Failed to execute stage 'Misc configuration': FATAL: Ident authentication failed for user "root" FATAL: Ident authentication failed for user "root" any tips? Marek
Hi, On Tue, Jan 24, 2023 at 1:47 AM marek <cervajs64@gmail.com> wrote:
upgrade from ovirt 4.4.4 to 4.5.5
Please provide more details, thanks. Is everything set up on the same machine - engine, dwh, grafana? If on separate machines, what's where and how was it set up? Did you have grafana already set up in 4.4.4? Do you have any custom local changes?
engine-setup
2023-01-24 00:35:17,885+0100 DEBUG otopi.context context._executeMethod:145 method exception Traceback (most recent call last): File "/usr/lib/python3.6/site-packages/otopi/context.py", line 132, in _executeMethod method['method']() File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine-grafana-dwh/db/default_privileges.py", line 51, in _misc_set_default_privileges user=self.environment[ogdwhcons.GrafanaDBEnv.USER], File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/database.py", line 1808, in setDefaultPrivilegesReadOnlyForUser ownConnection=True, File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/database.py", line 249, in execute database=database, File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/database.py", line 182, in connect sslmode=sslmode, File "/usr/lib64/python3.6/site-packages/psycopg2/__init__.py", line 127, in connect conn = _connect(dsn, connection_factory=connection_factory, **kwasync) psycopg2.OperationalError: FATAL: Ident authentication failed for user "root" FATAL: Ident authentication failed for user "root"
This might be due to changes in /var/lib/pgsql/data/pg_hba.conf . Please check/ share it. Thanks. Best regards, -- Didi
its all on one machine i'm not sure if grafana was used in 4.4.4 (dashboard was working) after repeated engine-setup and playing with /etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf OVESETUP_GRAFANA_CORE/enable=bool:True OVESETUP_GRAFANA_CORE/grafanaDbCreatedByUs=none:None OVESETUP_DWH_CORE/enable=bool:True its "somehow" solved now Dne 24/01/2023 v 08:37 Yedidyah Bar David napsal(a):
Hi,
On Tue, Jan 24, 2023 at 1:47 AM marek <cervajs64@gmail.com> wrote:
upgrade from ovirt 4.4.4 to 4.5.5 Please provide more details, thanks.
Is everything set up on the same machine - engine, dwh, grafana? If on separate machines, what's where and how was it set up? Did you have grafana already set up in 4.4.4? Do you have any custom local changes?
engine-setup
2023-01-24 00:35:17,885+0100 DEBUG otopi.context context._executeMethod:145 method exception Traceback (most recent call last): File "/usr/lib/python3.6/site-packages/otopi/context.py", line 132, in _executeMethod method['method']() File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine-grafana-dwh/db/default_privileges.py", line 51, in _misc_set_default_privileges user=self.environment[ogdwhcons.GrafanaDBEnv.USER], File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/database.py", line 1808, in setDefaultPrivilegesReadOnlyForUser ownConnection=True, File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/database.py", line 249, in execute database=database, File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/database.py", line 182, in connect sslmode=sslmode, File "/usr/lib64/python3.6/site-packages/psycopg2/__init__.py", line 127, in connect conn = _connect(dsn, connection_factory=connection_factory, **kwasync) psycopg2.OperationalError: FATAL: Ident authentication failed for user "root" FATAL: Ident authentication failed for user "root" This might be due to changes in /var/lib/pgsql/data/pg_hba.conf . Please check/ share it. Thanks.
Best regards,
On Tue, Jan 24, 2023 at 11:04 AM marek <cervajs64@gmail.com> wrote:
its all on one machine
i'm not sure if grafana was used in 4.4.4 (dashboard was working)
after repeated engine-setup and playing with
/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf
OVESETUP_GRAFANA_CORE/enable=bool:True
Was it False? I think the failure you described can only happen if it's True.
OVESETUP_GRAFANA_CORE/grafanaDbCreatedByUs=none:None OVESETUP_DWH_CORE/enable=bool:True
Can't see how the last two settings can affect your issue. Perhaps you changed other things?
its "somehow" solved now
Fine, but if it's due to changes around pg_hba.conf, you might face other issues later on - around backup/restore, integrating other things, etc. Thanks for the update! Best regards,
Dne 24/01/2023 v 08:37 Yedidyah Bar David napsal(a):
Hi,
On Tue, Jan 24, 2023 at 1:47 AM marek <cervajs64@gmail.com> wrote:
upgrade from ovirt 4.4.4 to 4.5.5 Please provide more details, thanks.
Is everything set up on the same machine - engine, dwh, grafana? If on separate machines, what's where and how was it set up? Did you have grafana already set up in 4.4.4? Do you have any custom local changes?
engine-setup
2023-01-24 00:35:17,885+0100 DEBUG otopi.context context._executeMethod:145 method exception Traceback (most recent call last): File "/usr/lib/python3.6/site-packages/otopi/context.py", line 132, in _executeMethod method['method']() File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine-grafana-dwh/db/default_privileges.py", line 51, in _misc_set_default_privileges user=self.environment[ogdwhcons.GrafanaDBEnv.USER], File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/database.py", line 1808, in setDefaultPrivilegesReadOnlyForUser ownConnection=True, File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/database.py", line 249, in execute database=database, File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/database.py", line 182, in connect sslmode=sslmode, File "/usr/lib64/python3.6/site-packages/psycopg2/__init__.py", line 127, in connect conn = _connect(dsn, connection_factory=connection_factory, **kwasync) psycopg2.OperationalError: FATAL: Ident authentication failed for user "root" FATAL: Ident authentication failed for user "root" This might be due to changes in /var/lib/pgsql/data/pg_hba.conf . Please check/ share it. Thanks.
Best regards,
-- Didi
Dne 24/01/2023 v 10:26 Yedidyah Bar David napsal(a):
On Tue, Jan 24, 2023 at 11:04 AM marek <cervajs64@gmail.com> wrote:
its all on one machine
i'm not sure if grafana was used in 4.4.4 (dashboard was working)
after repeated engine-setup and playing with
/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf
OVESETUP_GRAFANA_CORE/enable=bool:True Was it False? I think the failure you described can only happen if it's True.
first attempt was with true and failed then disabled OVESETUP_GRAFANA* ovirt-engine passed then after a while played with OVESETUP_GRAFANA* and OVESETUP_DWH* and ovirt-engine passed but i dont have notes and exact steps.sorry (2:00 AM. my eyes held matches) Marek
OVESETUP_GRAFANA_CORE/grafanaDbCreatedByUs=none:None OVESETUP_DWH_CORE/enable=bool:True Can't see how the last two settings can affect your issue. Perhaps you changed other things?
its possible. i'm not sure
participants (2)
-
marek -
Yedidyah Bar David