Re: [ovirt-users] oVirt 4.2.x and ManageIQ : Adding 'cfme' credentials
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