How to use Dynamic image panel to show local images

Grafana
1

Hi, I am trying to use Dynamic image panel to show weather forcast image.
I have a field that has the path and image name included that should be shown in this panel.

See mySQL query that I am using:

SELECT 
  $__timeGroup(time_dt, '30s') AS "time",
  weather_img
FROM windDB.wind_data
WHERE location = 'xxxx' AND time_dt BETWEEN (DATE_SUB(UTC_TIMESTAMP(),INTERVAL 5 MINUTE)) AND UTC_TIMESTAMP()

The weather_img has a string like "/home/pi/pressure_info/SunCloud.png"

The grafana server is on a raspberry pi and on the same I have stored the different images for different weather situations.

But, somehow I have not managed to show the image on the panel.
How can I do that?

BR

2
  1. are you seeing any errors in browser console or grafana error log?
  2. does grafana have access to that folder
  3. in relation to where grafana is installed does that folder path make sense?
3

Nice questions. I am new in all this.
Where can I find the grafana error log, because in the panel it self it does not show any error.

Grafana is installed on the raspberry pi where I have also the images so it should be possible to access those, or!?. I am browsing the Grafana panels via my windows pc via https://<raspberry ip>:3000/...

4

Hi,
coming back to this issue here are some more info.
I did meanwhile some changes and have the mySQL and Grafana on my NAS drive as container now and it works very nice. Raspeberry is still providing the sensors data to the db and I can access my grafana via http://<nas drive ip>:3000.
But I still have the problem that the dynamic image panel does not show the icon that I would like depending on the value that db field weather_img has.

See mySQL query that I am using:

SELECT 
  $__timeGroup(time_dt, '1m') AS "time",
  weather_img
FROM windDB.wind_data
WHERE location = 'city' AND time_dt BETWEEN (DATE_SUB(UTC_TIMESTAMP(),INTERVAL 5 MINUTE)) AND UTC_TIMESTAMP()

the weather_img has depending on the forecast a path to the images e.g.
/public/img/SunCloud.png (on the NAS drive) which I would like to show the SunCloud.png image in the dynamic image panel. Is that possible?

5

image
image1919Ă—778 157 KB

6

I did some changes, but:

image
image1907Ă—779 60.4 KB

SELECT 
  $__timeGroup(time_dt, '30s') AS "time",
  weather_img AS img
FROM windDB.wind_data
WHERE location = 'Patra' AND time_dt BETWEEN (DATE_SUB(UTC_TIMESTAMP(),INTERVAL 1 MINUTE)) AND UTC_TIMESTAMP()
LIMIT 1

As you can see instead of showing the image it shows the value (path) of the weather_img from where it should grab the image. Any clue?

7

I continued a bit and changed the location of the images to '/public/img/Sun.jpg' in the grafana container but it still doesn’t show the image but the “Alt field” configured in the Image options of the Dynamic image panel. Do you know if the image must have any specific owner/group?

For now the image is:
-rwx--x--x 1 root root 17247 Feb 18 21:30 Sun.jpg

8

for container you might need to look at /usr/share/grafana/public/img/ folder

9

Yeah, that’s where the images are located /usr/share/grafana/public/img now.

1 Like
10

image
image1875Ă—379 132 KB

11

Is your above example still Dynamic image panel or some other panel??
If it is Dynamin image panel where do you add the html part??