On 01/22/2018 06:37 PM, Roy Golan wrote:
We ship postgres 9.5 through the Software Collection. Its missing from your path by default, so in order to run psql you need to:
su - postgres scl enable rh-postgresql95 -- psql engine engine
scl enable rh-postgresql95 -- psql engine engine psql: FATAL: Peer authentication failed for user "engine" Sorry, should it be:? scl enable rh-postgresql95 -- psql engine Do I need to re-enter everything for read-only oVirt DWH user ?
On Mon, 22 Jan 2018 at 18:19 <andreil1@starlett.lv> wrote:
On 22 Jan 2018, at 18:09, Mikhail Krasnobaev <milo1@ya.ru> wrote:
Good day,
i had the same issue, you can try running the commands directly from postgres user: su - postgres And the run the commands from blog post.
I did everything as user postgres, otherwise it doesn’t work at all.
Best regards,
Mikhail.
17:58, 22 января 2018 г., Andrei V <andreil1@starlett.lv>:
Hi !
Thanks a lot for excellent addition !
I’ve got a problem with connecting Grafana to oVirt 4.2 Followed this instruction and created read-only user usrmonovirt # https://www.ovirt.org/documentation/data-warehouse/Allowing_Read_Only_Access...
However, from Grafana login is is always failed: pq: Ident authentication failed for user “usrmonovirt" host = localhost:5432, database = ovirt_engine_history, SSL = disable
Reset password with another or even NULL don’t help, still can’t connect. psql -U postgres -c "ALTER ROLE usrmonovirt WITH PASSWORD ‘mypassword';" -d ovirt_engine_history psql -U postgres -c "ALTER ROLE usrmonovirt WITH PASSWORD NULL;” -d ovirt_engine_history
What went wrong? I can’t understand.
PS. Looks like oVirt engine spawns PostgreSQL with its own data dir, standard restart via systemcll returns an error (data dir is empty). Yet "ps -aux | grep postgres" shows process is running.
Thanks in advance for any suggestion(s).
On 21 Jan 2018, at 14:21, Shirly Radco <sradco@redhat.com> wrote:
Hello everyone,
A new oVirt blog post has been published, on how to build oVirt reports using Grafana. This allows connecting to oVirt DWH and create dashboards for System, Hosts, VMs, Storage domains etc.
See https://ovirt.org/blog/2018/01/ovirt-report-using-grafana/ for the full post.
For more information you can contact me.
Best regards,
--
SHIRLY RADCO
BI SeNIOR SOFTWARE ENGINEER Red Hat Israel <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> _______________________________________________ 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
Sent from Yandex.Mail for mobile: http://m.ya.ru/ymail
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users