oVirt 4.2.x and ManageIQ : Adding 'cfme' credentials

Hello, As for my 4 previous oVirt DCs, I'm trying to add them to ManageIQ providers. I tried to follow this guide : https://access.redhat.com/documentation/en-us/red_hat_cloudforms/4.6/html-si... But when trying to run psql, the shell tells me the command is not found. I made a very simple setup : when running engine-setup, I answered the default question about DWH, so the DB is local. When viewing (with pgAdmin) the roles of this new PostgreSQL DB, I see there is no 'cfme' user. Do I have to re-run the setup and answer different things to ensure other packages and setup are made? I saw https://access.redhat.com/documentation/en-us/red_hat_virtualization/4.1/htm... telling me to re-run. But I see that : rpm -qa|grep -i dwh ovirt-engine-dwh-4.2.1.2-1.el7.centos.noarch ovirt-engine-dwh-setup-4.2.1.2-1.el7.centos.noarch so I thought it was already enough... ? -- Nicolas ECARNOT

On Thu, Mar 1, 2018 at 2:13 PM, Nicolas Ecarnot <nicolas@ecarnot.net> wrote:
Hello,
As for my 4 previous oVirt DCs, I'm trying to add them to ManageIQ providers.
I tried to follow this guide :
https://access.redhat.com/documentation/en-us/red_hat_cloudf orms/4.6/html-single/deployment_planning_guide/#data_collect ion_for_rhev_33_34
But when trying to run psql, the shell tells me the command is not found.
Because you are probably on PG 9.5 SCL, I assume? Something like 'scl enable rh-postgrsql95' should help. Y.
I made a very simple setup : when running engine-setup, I answered the default question about DWH, so the DB is local.
When viewing (with pgAdmin) the roles of this new PostgreSQL DB, I see there is no 'cfme' user. Do I have to re-run the setup and answer different things to ensure other packages and setup are made?
I saw https://access.redhat.com/documentation/en-us/red_hat_virtua lization/4.1/html-single/data_warehouse_guide/#Overview_of_C onfiguring_Data_Warehouse telling me to re-run.
But I see that : rpm -qa|grep -i dwh ovirt-engine-dwh-4.2.1.2-1.el7.centos.noarch ovirt-engine-dwh-setup-4.2.1.2-1.el7.centos.noarch
so I thought it was already enough... ?
-- Nicolas ECARNOT _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users

Le 01/03/2018 à 15:00, Yaniv Kaul a écrit :
On Thu, Mar 1, 2018 at 2:13 PM, Nicolas Ecarnot <nicolas@ecarnot.net <mailto:nicolas@ecarnot.net>> wrote:
Hello,
As for my 4 previous oVirt DCs, I'm trying to add them to ManageIQ providers.
I tried to follow this guide :
https://access.redhat.com/documentation/en-us/red_hat_cloudforms/4.6/html-si... <https://access.redhat.com/documentation/en-us/red_hat_cloudforms/4.6/html-single/deployment_planning_guide/#data_collection_for_rhev_33_34>
But when trying to run psql, the shell tells me the command is not found.
Hello Yanniv, Thank you for answering.
Because you are probably on PG 9.5 SCL, I assume?
I've never heard about that before today. I installed a bare-metal CentOS 7.4 on which I installed oVirt 4.2. I saw no reference to SCL nowhere, neither during the setup, neither in the oVirt install documentation. How an average user is supposed to behave in such a situation? (In my case, as usual, I read and read again) Couldn't the Redhat documentation mentioned above be more accurate?
Something like 'scl enable rh-postgrsql95' should help.
Not that much... root@serv-mvm-prds01:/etc/ovirt-engine-setup.conf.d# cd /tmp root@serv-mvm-prds01:/tmp# su - postgres Dernière connexion : jeudi 1 mars 2018 à 15:42:40 CET sur pts/2 -bash-4.2$ scl enable rh-postgrsql95 Need at least 3 arguments. Run scl --help to get help. -- Nicolas ECARNOT

Le 01/03/2018 à 15:50, Nicolas Ecarnot a écrit :
Couldn't the Redhat documentation mentioned above be more accurate?
Something like 'scl enable rh-postgrsql95' should help.
Not that much...
root@serv-mvm-prds01:/etc/ovirt-engine-setup.conf.d# cd /tmp root@serv-mvm-prds01:/tmp# su - postgres Dernière connexion : jeudi 1 mars 2018 à 15:42:40 CET sur pts/2 -bash-4.2$ scl enable rh-postgrsql95 Need at least 3 arguments. Run scl --help to get help.
After reading and reading again : For the record, here are the steps allowing me to add this user : su - postgres scl enable rh-postgresql95 'psql ovirt_engine_history' CREATE ROLE cfme with LOGIN ENCRYPTED PASSWORD 'xxx'; SELECT 'GRANT SELECT ON ' || relname || ' TO cfme;' FROM pg_class JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace WHERE nspname = 'public' AND relkind IN ('r', 'v','S'); \q exit -- Nicolas ECARNOT

On Thu, Mar 1, 2018 at 4:50 PM, Nicolas Ecarnot <nicolas@ecarnot.net> wrote:
Le 01/03/2018 à 15:00, Yaniv Kaul a écrit :
On Thu, Mar 1, 2018 at 2:13 PM, Nicolas Ecarnot <nicolas@ecarnot.net <mailto:nicolas@ecarnot.net>> wrote:
Hello,
As for my 4 previous oVirt DCs, I'm trying to add them to ManageIQ providers.
I tried to follow this guide :
https://access.redhat.com/documentation/en-us/red_hat_cloudf orms/4.6/html-single/deployment_planning_guide/#data_ collection_for_rhev_33_34 <https://access.redhat.com/documentation/en-us/red_hat_cloud forms/4.6/html-single/deployment_planning_guide/#data_ collection_for_rhev_33_34>
But when trying to run psql, the shell tells me the command is not found.
Hello Yanniv,
Thank you for answering.
Because you are probably on PG 9.5 SCL, I assume?
I've never heard about that before today. I installed a bare-metal CentOS 7.4 on which I installed oVirt 4.2. I saw no reference to SCL nowhere, neither during the setup, neither in the oVirt install documentation.
How an average user is supposed to behave in such a situation? (In my case, as usual, I read and read again)
An average user does not touch the database. But you are right, we should mention it somewhere.
Couldn't the Redhat documentation mentioned above be more accurate?
Red Hat did not release 4.2 yet.
Something like 'scl enable rh-postgrsql95' should help.
Not that much...
root@serv-mvm-prds01:/etc/ovirt-engine-setup.conf.d# cd /tmp root@serv-mvm-prds01:/tmp# su - postgres Dernière connexion : jeudi 1 mars 2018 à 15:42:40 CET sur pts/2 -bash-4.2$ scl enable rh-postgrsql95 Need at least 3 arguments. Run scl --help to get help.
https://www.softwarecollections.org/en/scls/rhscl/rh-postgresql95/ provide better information than I do... Y.
-- Nicolas ECARNOT
participants (2)
-
Nicolas Ecarnot
-
Yaniv Kaul