@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 else can be the issue than. Failed to connect to database engine (engine): could not connect to server: Permission denied

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, kushagra2agarwal(a)gmail.com <kushagra2agarwal(a)gmail.com&gt; написа: I am unable to connect to postgres database running on oVirt engine and while troubleshooting found below possible issue. semanage fcontext -a -t postgresql_exec_t /opt/rh/rh-postgresql10/root/usr/bin/psql ValueError: File spec /opt/rh/rh-postgresql10/root/usr/bin/psql conflicts with equivalency rule '/opt/rh/rh-postgresql10/root /'; Try adding '//usr/bin/psql' instead Can someone help to resolve this issue. _______________________________________________ Users mailing list -- users(a)ovirt.org To unsubscribe send an email to users-leave(a)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/JPWYVOHDVRL...

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 <didi(a)redhat.com&gt; написа: On Wed, Oct 21, 2020 at 9:16 PM Strahil Nikolov via Users <users(a)ovirt.org&gt; wrote: This is applicable to 4.3, on el7. For 4.4 this isn't needed. Also, IIRC this isn't the official method to activate an SCL component, but: $ scl enable rh-postgresql10 bash Which is a significant difference - it runs a process ('bash', in this case, but you can run psql directly) "inside" the environment. A somewhat more official (although IIRC still not the recommended) way is: . scl_source enable rh-postgresql10 (Or 'source' instead of '.', although '.' is the POSIX standard).   This works if the engine db is automatically provisioned by engine-setup (which is the default). engine-psql.sh works regardless of version, remote or not, etc. It's a pretty simple script - you can easily read it to see what it does. Best regards,   -- Didi