[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 at serv-mvm-prds01:/etc/ovirt-engine-setup.conf.d# cd /tmp
> root at 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