Updated Grafana to 12.2.0, pfblocker stats are not showing

Grafana Table Panel
1

  • Grafana v12.2.0, Debian 12

  • Visualize PFsense pfblocker data

  • I have a single virtual machine that runs Grafana and InfluxDB that gets data from the telegraf plugin installed on PFsense

  • I updated Grafana to the latest version and pfblocker data is now not showing in Influxdb nor Grafana

  • I was trying to fix an issue with Geomaps panel and did not expect the update to break the rest of the pfblocker panels

  • SELECT TOP(“count”,“src_ip”,10) FROM (SELECT count(“action”) FROM “autogen”.“tail_ip_block_log” WHERE (“host” =~ /^$Host$/ AND “action” = ‘block’ AND “direction” = ‘in’) AND $timeFilter GROUP BY “src_ip”) This query config is suppose to show top ten blocked IPs from Pfblocker

  • No errors I can see, just a no data message on the panel

  • I imported this dashboard and followed its steps/configuration, it is a bit old: GitHub - VictorRobellini/pfSense-Dashboard: A functional and useful dashboard for pfSense that utilizes influxdb, grafana and telegraf