[ovirt-users] Re: oVirt reports using Grafana

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(a)redhat.com&gt; > 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(a)inparadise.se&gt;: > > > 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(a)ovirt.org > > > To unsubscribe send an email to users-leave(a)ovirt.org > > > > > >