[ovirt-users] Re: Unable to connect to postgres database on oVirt engine

2020-10-25 Thread Yedidyah Bar David
On Thu, Oct 22, 2020 at 9:05 PM Strahil Nikolov wrote: > Hi Didi, > > thanks for the info - I learned it the hard way (trial & error) and so far > it was working. > > Do we have an entry about that topic in the documentation ? > I do not think we have very much about the engine DB or how to acce

[ovirt-users] Re: Unable to connect to postgres database on oVirt engine

2020-10-22 Thread Strahil Nikolov via Users
Hi Didi, thanks for the info - I learned it the hard way (trial & error) and so far it was working. Do we have an entry about that topic in the documentation ? Best Regards, Strahil Nikolov В четвъртък, 22 октомври 2020 г., 08:27:08 Гринуич+3, Yedidyah Bar David написа: On Wed,

[ovirt-users] Re: Unable to connect to postgres database on oVirt engine

2020-10-21 Thread Yedidyah Bar David
On Wed, Oct 21, 2020 at 9:16 PM Strahil Nikolov via Users wrote: > I usually run the following (HostedEngine): > > [root@engine ~]# su - postgres > > -bash-4.2$ source /opt/rh/rh-postgresql10/enable > This is applicable to 4.3, on el7. For 4.4 this isn't needed. Also, IIRC this isn't the officia

[ovirt-users] Re: Unable to connect to postgres database on oVirt engine

2020-10-21 Thread Strahil Nikolov via Users
I usually run the following (HostedEngine): [root@engine ~]# su - postgres   -bash-4.2$ source /opt/rh/rh-postgresql10/enable   -bash-4.2$ psql engine How did you try to access the Engine's DB ? Best Regards, Strahil Nikolov В вторник, 20 октомври 2020 г., 17:00:37 Гринуич+3, kushagra2a

[ovirt-users] Re: Unable to connect to postgres database on oVirt engine

2020-10-20 Thread Yedidyah Bar David
On Tue, Oct 20, 2020 at 5:25 PM wrote: > > @Didi thanks for your response, we are trying to pull postgres db metrics > using collectd agent but while trying to get metrics we are getting below > error. We are pulling creds from file > '/etc/ovirt-engine/engine.conf.d/10-setup-database.conf' > >

[ovirt-users] Re: Unable to connect to postgres database on oVirt engine

2020-10-20 Thread kushagra2agarwal
@Didi thanks for your response, we are trying to pull postgres db metrics using collectd agent but while trying to get metrics we are getting below error. We are pulling creds from file '/etc/ovirt-engine/engine.conf.d/10-setup-database.conf' oVirt engine version 4.3.10 Any thoughts on what e

[ovirt-users] Re: Unable to connect to postgres database on oVirt engine

2020-10-20 Thread Yedidyah Bar David
Hi, Which version of the engine are you using? On Tue, Oct 20, 2020 at 4:59 PM wrote: > > I am unable to connect to postgres database running on oVirt engine and while > troubleshooting found below possible issue. How do you try to connect? > > semanage fcontext -a -t postgresql_exec_t > /op