Build oVirt Reports Using Grafana
Grafana, The open platform for beautiful analytics and monitoring, recently added support for PostgreSQL.
It in now possible to connect Grafana to oVirt DWH, in order to visualize and monitor the oVirt environment.
Grafana dashboard example
Adding a Read-Only User to the History Database
You may want to add a read only user to connect the history database :
Note: In oVirt 4.2 we ship postgres 9.5 through the Software Collection.
-
In order to run psql you will need to run:
# su - postgres $ scl enable rh-postgresql95 -- psql ovirt_engine_history -
Create the user to be granted read-only access to the history database:
ovirt_engine_history=# CREATE ROLE [user name] WITH LOGIN ENCRYPTED PASSWORD '[password]'; -
Grant the newly created user permission to connect to the history database:
ovirt_engine_history=# GRANT CONNECT ON DATABASE ovirt_engine_history TO [user name]; -
Grant the newly created user usage of the public schema:
ovirt_engine_history=# GRANT USAGE ON SCHEMA public TO [user name]; -
Exit the database
ovirt_engine_history=# \q -
Generate the rest of the permissions that will be granted to the newly created user and save them to a file:
$ scl enable rh-postgresql95 -- psql -U postgres -c "SELECT 'GRANT SELECT ON ' || relname Continue reading
Developer concern over Microsoft's $7.5 billion acquisition of GitHub could provide a long-term opportunity in the open source Git repository community.
International Speedway Corporation needed its applications to run as fast as the race cars on its tracks.
T-Mobile’s acquisition of Sprint will mean a larger 5G footprint and a higher capacity network, says Sprint’s CTO. 
The company's stock plunged as much as 13 percent early Friday having just hit a new 52-week high last week.
ZTE stock sinks after U.S. Senate bill; T-Mobile and Sprint advance their proposed merger; and VMware works with the U.S. government and public sector.
