ovirt upgrade - Failed to execute stage 'Misc configuration' FATAL: Ident authentication failed for user "root"
12:46 a.m.
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
8:37 a.m.
New subject: ovirt upgrade - Failed to execute stage 'Misc configuration' FATAL: Ident authentication failed for user "root"
Hi,
On Tue, Jan 24, 2023 at 1:47 AM marek <cervajs64(a)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
10:04 a.m.
New subject: ovirt upgrade - Failed to execute stage 'Misc configuration' FATAL: Ident authentication failed for user "root" (SOLVED)
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(a)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,
10:26 a.m.
New subject: ovirt upgrade - Failed to execute stage 'Misc configuration' FATAL: Ident authentication failed for user "root" (SOLVED)
On Tue, Jan 24, 2023 at 11:04 AM marek <cervajs64(a)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(a)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
1:25 p.m.
New subject: ovirt upgrade - Failed to execute stage 'Misc configuration' FATAL: Ident authentication failed for user "root" (SOLVED)
Dne 24/01/2023 v 10:26 Yedidyah Bar David napsal(a):
On Tue, Jan 24, 2023 at 11:04 AM marek <cervajs64(a)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
461
days inactive
462
days old
4 comments
2 participants
participants (2)
-
marek -
Yedidyah Bar David