Re: [ovirt-users] New post on oVirt blog: Build oVirt Reports Using Grafana

2018-01-24 Thread Shirly Radco 
Hi,

Did you manage to connect Grafana to DWH?

Best regards,

--

SHIRLY RADCO

BI SOFTWARE ENGINEER

Red Hat Israel



TRIED. TESTED. TRUSTED.



On Jan 22, 2018 20:10, "Andrei V"  wrote:

> 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  wrote:
> >
> >> On 22 Jan 2018, at 18:09, Mikhail Krasnobaev  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 :
> >>
> >> 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_to_the_History_Database/
> >>
> >> 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  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 
> >> 
> >> TRIED. TESTED. 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
> >>
>
> ___
> 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

Re: [ovirt-users] New post on oVirt blog: Build oVirt Reports Using Grafana

2018-01-22 Thread Roy Golan 
On Mon, Jan 22, 2018, 8:10 PM Andrei V  wrote:

> 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 ?
>


> I think so.
>

>
> > On Mon, 22 Jan 2018 at 18:19  wrote:
> >
> >> On 22 Jan 2018, at 18:09, Mikhail Krasnobaev  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 :
> >>
> >> 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_to_the_History_Database/
> >>
> >> 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  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 
> >> 
> >> TRIED. TESTED. 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
> >>
>
> ___
> 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

Re: [ovirt-users] New post on oVirt blog: Build oVirt Reports Using Grafana

2018-01-22 Thread Andrei V 
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  wrote:
>
>> On 22 Jan 2018, at 18:09, Mikhail Krasnobaev  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 :
>>
>> 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_to_the_History_Database/
>>
>> 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  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 
>> 
>> TRIED. TESTED. 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
>>

___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users

Re: [ovirt-users] New post on oVirt blog: Build oVirt Reports Using Grafana

2018-01-22 Thread Roy Golan 
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

On Mon, 22 Jan 2018 at 18:19  wrote:

>
> On 22 Jan 2018, at 18:09, Mikhail Krasnobaev  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 :
>
> 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_to_the_History_Database/
>
> 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  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 
> 
> TRIED. TESTED. 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
>
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users

Re: [ovirt-users] New post on oVirt blog: Build oVirt Reports Using Grafana

2018-01-22 Thread andreil1 


> On 22 Jan 2018, at 18:09, Mikhail Krasnobaev  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 :
> 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_to_the_History_Database/
>  
> 
> 
> 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 > > 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 
>>  
>> TRIED. TESTED. 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

Re: [ovirt-users] New post on oVirt blog: Build oVirt Reports Using Grafana

2018-01-22 Thread Mikhail Krasnobaev 
Good day,i had the same issue, you can try running the commands directly from postgres user:su - postgresAnd the run the commands from blog post.Best regards,Mikhail.17:58, 22 января 2018 г., Andrei V :Hi !Thanks a lot for excellent addition !I’ve got a problem with connecting Grafana to oVirt 4.2Followed this instruction and created read-only user usrmonovirt# https://www.ovirt.org/documentation/data-warehouse/Allowing_Read_Only_Access_to_the_History_Database/However, from Grafana login is is always failed:pq: Ident authentication failed for user “usrmonovirt"host = localhost:5432, database = ovirt_engine_history, SSL = disableReset 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_historypsql -U postgres -c "ALTER ROLE usrmonovirt WITH PASSWORD NULL;”  -d ovirt_engine_historyWhat 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  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 RADCOBI SeNIOR SOFTWARE ENGINEERRed Hat IsraelTRIED. TESTED. TRUSTED.

___Users mailing listUsers@ovirt.orghttp://lists.ovirt.org/mailman/listinfo/users___Users mailing listUsers@ovirt.orghttp://lists.ovirt.org/mailman/listinfo/usersSent from Yandex.Mail for mobile: http://m.ya.ru/ymail___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users

Re: [ovirt-users] New post on oVirt blog: Build oVirt Reports Using Grafana

2018-01-22 Thread Andrei V 
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_to_the_History_Database/

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  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 
>   
> TRIED. TESTED. 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