4:13 a.m.
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...
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/...
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
6 a.m.
On Thu, Mar 1, 2018 at 2:13 PM, Nicolas Ecarnot <nicolas(a)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(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
6:50 a.m.
Le 01/03/2018 à 15:00, Yaniv Kaul a écrit :
On Thu, Mar 1, 2018 at 2:13 PM, Nicolas Ecarnot <nicolas(a)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...
<https://access.redhat.com/documentation/en-us/red_hat_cloudforms/4.6/html...
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
7:41 a.m.
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
12:16 a.m.
On Thu, Mar 1, 2018 at 4:50 PM, Nicolas Ecarnot <nicolas(a)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(a)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
2245
days inactive
2248
days old
4 comments
2 participants
participants (2)
-
Nicolas Ecarnot -
Yaniv Kaul