
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! 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. On Thu, May 17, 2018 at 11:21 PM Karli Sjöberg <karli@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, <sbonazzo@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 <karli@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-leave@ovirt.org