Hello, I have updated the blog "Build oVirt Reports Using Grafana" , I used latest Grafana. https://ovirt.org/blog/2018/06/ovirt-report-using-grafana/
It was also tested by our QE. Thank you for your input on this issue and I hope this blog will make it easier for you to use Grafana with oVirt DWH and get the statistics that you need. 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> On Wed, May 23, 2018 at 11:37 AM, Alejandro Cortina < alejandro.corti...@gmail.com> wrote: > Hi Shirly, > > I went through your instructions just yesterday and they work but some > troubleshooting was needed. This is what I have found: > > * When adding the graph I also got syntax errors: '*pq: syntax error at > or near "$"'*, maybe add an "ignore this error" line to the docs would be > an improvement > * I am new to grafana then I could not understand about templating. Took > me a few *trips* to http://docs.grafana.org/reference/templating/ to > understand it. Maybe some simple instructions would make experience better. > * Regarding tremplating: > > cluster_name > - fails: SELECT cluster_name FROM v4_2_configuration_history_clusters > WHERE datacenter_id = $datacenter_id > - not fail: SELECT cluster_name FROM v4_2_configuration_history_clusters > WHERE datacenter_id='$datacenter_id' > > cluster_id > - fails: SELECT cluster_id FROM v4_2_configuration_history_clusters WHERE > datacenter_id = $datacenter_id > - not fail: SELECT cluster_id FROM v4_2_configuration_history_clusters > WHERE datacenter_id ='$datacenter_id' > > there are many more. > > * Modifying DB, even DWH views are stable I think it would be better to > instruct to make backup. > > Regarding modifying DB, Is it possible to revert these changes? > > Thanks! > > On Tue, May 22, 2018 at 6:09 PM, Shirly Radco <sra...@redhat.com> wrote: > >> >> >> -- >> >> SHIRLY RADCO >> >> BI SENIOR SOFTWARE ENGINEER >> >> Red Hat Israel >> >> >> TRIED. TESTED. TRUSTED. >> >> >> >> On Fri, May 18, 2018, 16:02 Vincent Royer <vinc...@epicenergy.ca> wrote: >> >>> Yes I agree, because the database contains so many version specific >>> pointers, all of them will stop working when you upgrade. So that's no good! >>> >> >> Not sure what you mean. The DWH views are stable and we currently >> support 3.6 and above views. It means you do not have to update the version >> of the view. >> Also DWH is pretty stable. So you should not expect many changes. >> >> >>> If you ever get something decent working with Grafana, I'd be very >>> interested. I'm still not happy with the integration with the engine >>> history database, I was never really able to get predictable output from >>> it, and spent way too many hours messing around with it. >>> >> >> Ill try and add a few more meaningful examples if that will help. >> >> Is the problem is how to join the tables together? >> >> >>> >>> On Thu, May 17, 2018 at 11:21 PM Karli Sjöberg <ka...@inparadise.se> >>> wrote: >>> >>>> On Thu, 2018-05-17 at 10:37 -0700, Vincent Royer wrote: >>>> > These are the same issues I ran into. I did get it working, look up >>>> > my post history and you'll find some solutions to the errors >>>> >>>> Big thanks, now I understand what the problem was! >>>> >>>> But I must say, after reading that thread, I´m actually more interested >>>> in setting up the metrics store as it seems you get way more data out >>>> of it without having to access the database directly. The point being, >>>> the less manual stuff you do to alter the original setup in the engine, >>>> the less issues you are going to have later on, with upgrades and such. >>>> >>>> /K >>>> >>>> > >>>> > On Thu, May 17, 2018, 1:01 AM Sandro Bonazzola, <sbona...@redhat.com> >>>> > wrote: >>>> > > Shirly, can you please update the blog post pointing to an updated >>>> > > documentation page? >>>> > > >>>> > > 2018-05-17 9:35 GMT+02:00 Karli Sjöberg <ka...@inparadise.se>: >>>> > > > Heya! >>>> > > > >>>> > > > I've been whishing for reports in oVirt ever since the old >>>> > > > 'Jasper >>>> > > > Reports' was removed. For an Enterprise, having pretty graphs to >>>> > > > look >>>> > > > at is a must. >>>> > > > >>>> > > > Searching the subject, I've found this[*] and have managed to get >>>> > > > it >>>> > > > installed OK but having issues trying to follow the guide setting >>>> > > > it >>>> > > > up. >>>> > > > >>>> > > > First of all, I think the guide should have at least mentioned >>>> > > > that >>>> > > > 'pg_hba.conf' needs to be edited for the read only user to be >>>> > > > able to >>>> > > > connect to the database, I scratched my head around that for a >>>> > > > while >>>> > > > before I got it. >>>> > > > >>>> > > > When I first type in the query example, I got syntax errors: >>>> > > > 'pq: syntax error at or near "$"'. I continued anyways since I >>>> > > > figured >>>> > > > it would be solved at a later point, which turned out to be true, >>>> > > > since >>>> > > > the next step is to use the "Templating feature" to add >>>> > > > variables. >>>> > > > >>>> > > > Unfortunately this doesn't go so well, even though I followed the >>>> > > > instructions very carefully. After hitting save on the first >>>> > > > variable I >>>> > > > am rewarded with the error message: >>>> > > > 'Template variables could not be initialized: pq: column "en_us" >>>> > > > does >>>> > > > not exist.' >>>> > > > >>>> > > > Are the queries stated in the guide still correct? This is for >>>> > > > 'user_locale': >>>> > > > "SELECT DISTINCT language_code from enum_translator" >>>> > > > >>>> > > > [*]:https://www.ovirt.org/blog/2018/01/ovirt-report-using-grafana >>>> > > > / >>>> > > > >>>> > > > TIA >>>> > > > /K >>>> > > > _______________________________________________ >>>> > > > Users mailing list -- users@ovirt.org >>>> > > > To unsubscribe send an email to users-le...@ovirt.org >>>> > > >>>> > > >>>> > > >>> >>> >> _______________________________________________ >> Users mailing list -- users@ovirt.org >> To unsubscribe send an email to users-le...@ovirt.org >> >> >
_______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org Privacy Statement: https://www.ovirt.org/site/privacy-policy/ oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/SX76AMSQKNVDXSCVS67GHYLYMM6KR56O/
