Creating Dashboard to graph data from LibreNMS using MySQL

  • What Grafana version and what operating system are you using?
    10.3.1 on Ubuntu 22.04

  • What are you trying to achieve?
    I’m trying to get grafana to graph the data that LibreNMS has collected in MySQL. The things I’m specifically trying to graph are bandwidth and latency to network devices.

  • How are you trying to achieve it?
    I’m trying to create a new dashboard but the query part is tripping me up. I’m not sure how to use it to accomplish my task.

  • What happened?
    I go to create a New Dashboard>Add Visualization>select MySQL for the data course(it’s already connected) and then it has the query at the bottom. This is where I’m stumped. I’ve been searching through the help docs for hours and I can’t seem to find what I need to get these queries to work.

  • What did you expect to happen?
    I expected it to make pretty graphs :slight_smile:

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    I’m sure I’m doing this wrong, but when trying the dropdown boxes in the query section, and then running the query, the error I’m getting is “Data is missing a time field”.

  • Did you follow any online instructions? If so, what is the URL?
    Numerous pages from the grafana help docs.