[ovirt-users] Re: 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 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 ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/6BOXJM3UJWLCTBJGIVO6SRU6NIBOARUM/
[ovirt-users] Re: 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 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 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 ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/AUGH6LZCSJWRU55OH6MSLJXZX55NKATT/
[ovirt-users] Re: 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 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, ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/RLH4ITLEKBX5MXBD5OISZAHRKXJXQPE5/
[ovirt-users] Re: 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 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 ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@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/M6M4KN3YNOATAYY3IWV2ZTUEMCHLOPWN/