Building on the work of others before me, below you will find a tutorial to get PiHole logging to InfluxDB using a python script and then to a Grafana Dashboard. All required code available on my GitHub.
SSH into your PiHole: ssh pi@xxx.xxx.xxx.xxx and run the below:
Install python dependencies:
sudo apt-get install python-influxdb
Create the below python file:
sudo nano influx_scripts/piholestats.py
#! /usr/bin/python # History: # 2016: Script originally created by JON HAYWARD: https://fattylewis.com/Graphing-pi-hole-stats/ # 2016 (December) Adapted to work with InfluxDB by /u/tollsjo # 2016 (December) Updated by Cludch https://github.com/sco01/piholestatus # 2020 (March) Updated by http://cactusprojects.com/pihole-logging-to-influxdb-&-grafana-dash import requests import time from influxdb import InfluxDBClient HOSTNAME = "pihole" # Pi-hole hostname to report in InfluxDB for each measurement PIHOLE_API = "http://192.168.1.XXX/admin/api.php" INFLUXDB_SERVER = "192.168.1.XXX" # IP or hostname to InfluxDB server INFLUXDB_PORT = 8086 # Port on InfluxDB server INFLUXDB_USERNAME = "" INFLUXDB_PASSWORD = "" INFLUXDB_DATABASE = "dev_pihole" DELAY = 10 # seconds def send_msg(domains_blocked, dns_queries_today, ads_percentage_today, ads_blocked_today): json_body = [ { "measurement": "piholestats." + HOSTNAME.replace(".", "_"), "tags": { "host": HOSTNAME }, "fields": { "domains_blocked": int(domains_blocked), "dns_queries_today": int(dns_queries_today), "ads_percentage_today": float(ads_percentage_today), "ads_blocked_today": int(ads_blocked_today) } } ] client = InfluxDBClient(INFLUXDB_SERVER, INFLUXDB_PORT, INFLUXDB_USERNAME, INFLUXDB_PASSWORD, INFLUXDB_DATABASE) # InfluxDB host, InfluxDB port, Username, Password, database # client.create_database(INFLUXDB_DATABASE) # Uncomment to create the database (expected to exist prior to feeding it data) client.write_points(json_body) api = requests.get(PIHOLE_API) # URI to pihole server api API_out = api.json() #print (API_out) # Print out full data, there are other parameters not sent to InfluxDB domains_blocked = (API_out['domains_being_blocked'])#.replace(',', '') dns_queries_today = (API_out['dns_queries_today'])#.replace(',', '') ads_percentage_today = (API_out['ads_percentage_today'])# ads_blocked_today = (API_out['ads_blocked_today'])#.replace(',', '') send_msg(domains_blocked, dns_queries_today, ads_percentage_today, ads_blocked_today)
Save and Exit.
I have the file run on a cron job every minute. Others set it up as a service but cron job works just fine for me:
crontab -e
*/1 * * * * /usr/bin/python /home/pi/influx_scripts/piholestats.py
We need to create Influx database next, I carried this out through the Chronograf web interface but add it through the terminal by the below if required:
influx create database dev_pihole exit
Now onto Grafana Dash:
Add the “dev_pihole” database to the Grafana Data Sources list.
Next go to “Import dashboard” and paste in the JSON code on my Github. I tweaked a previous dashboard slightly.
All done!