Re: [ovirt-users] oVirt 4.2.x and ManageIQ : Adding 'cfme' credentials

[Yaniv Kaul]

On Thu, Mar 1, 2018 at 4:50 PM, Nicolas Ecarnot  wrote:

> Le 01/03/2018 à 15:00, Yaniv Kaul a écrit :
>
>>
>>
>> On Thu, Mar 1, 2018 at 2:13 PM, Nicolas Ecarnot > > 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
>> > 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
>
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users

Re: [ovirt-users] oVirt 4.2.x and ManageIQ : Adding 'cfme' credentials

[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
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users

Re: [ovirt-users] oVirt 4.2.x and ManageIQ : Adding 'cfme' credentials

[Nicolas Ecarnot]

Le 01/03/2018 à 15:00, Yaniv Kaul a écrit :



On Thu, Mar 1, 2018 at 2:13 PM, Nicolas Ecarnot > 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-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
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users

Re: [ovirt-users] oVirt 4.2.x and ManageIQ : Adding 'cfme' credentials

[Yaniv Kaul]

On Thu, Mar 1, 2018 at 2:13 PM, Nicolas Ecarnot  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
>
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users

[ovirt-users] oVirt 4.2.x and ManageIQ : Adding 'cfme' credentials

[Nicolas Ecarnot]

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-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.

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/html-single/data_warehouse_guide/#Overview_of_Configuring_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