Web interface showing no stats

Please follow the below template, it will help us to help you!

Expected Behaviour:

Web interface should be showing stats.

Actual Behaviour:

Web interface is not showing stats. It shows zero for everything except the domains on blocklist.

Debug Token:

x7yrsjltry

Did you flush you cache?

I failed to note that this is a new install, so there shouldn't be a cache. I did try flushing, but FTL quit running overnight and was showing Lost Connection to API just now. I restarted it just now with service pihole-FTL start and tried again. Still showing zero stats. Not sure why FTL quit running overnight. Just rebooted and FTL won't start on its own. Had to do it manually again.

Can you send the full FTL log?

cat /var/log/pihole-FTL.log | pihole tricorder

Done. Token is dj3ney48o2. Thank you for your help.

[2018-04-07 13:39:03.626] Error on binding on Unix socket /var/run/pihole/FTL.sock: No such file or directory (2)

Does the /var/run/pihole exist and is writable/owned by user pihole?

I also see

[2018-04-07 13:45:00.009] dbquery(INSERT OR REPLACE INTO ftl (id, value) VALUES ( 1, 0 );) - SQL error (8): attempt to write a readonly database

so make sure the permissions are writeable there as well.

Here's what everything pihole related in /var/run looks like.
drwxr-xr-x 2 pihole pihole 60 Apr 7 13:55 pihole
-rw-r--r-- 1 pihole pihole 4 Apr 7 13:55 pihole-FTL.pid
-rw-r--r-- 1 pihole pihole 4 Apr 7 13:55 pihole-FTL.port

Not sure what permissions I need to change to fix the dbquery line you mentioned in your last reply.

Can you verify your /etc/init.d/pihole-FTL.service is identical to:

https://github.com/pi-hole/pi-hole/blob/master/advanced/pihole-FTL.service

Yes, it is exactly the same.

Is the file created when you do service pihole-FTL start?

No, but it was there when I first checked for it to compare it with the code you posted above.

I was referring to this file.

Also, what are the permissions on /etc/pihole/pihole-FTL.db?

I rebooted and now FTL won't start at all. I get this message: Failed to start pihole-FTL.service: Unit pihole-FTL.service not found.
Permissions on /etc/pihole/pihole-FTL.db are 644. Also, the Pihole related files in /var/run are just gone. No idea what caused that.
I was planning on using pihole on a BeagleBone Black so I could free up my Raspberry Pi 3 for another project, but I'm starting to think it's more trouble than it's worth. May just stick with the Pi.

I got FTL working again. Regarding your earlier post, /var/run/FTL.sock was showing it was owned by root:root and permissions were srwxrwxrwx. I changed ownership to pihole:pihole, since that was how it was on my other install. pihole-FTL.db permissions look like this: -rw-r--r-- 1 root root 0 Apr 7 20:56 pihole-FTL.db. I changed ownership on that to pihole:pihole to be like my other install that works correctly.

1 Like

The last post wasn't really a solution. After a reboot, FTL still doesn't start. Typing service pihole-FTL start brings the error Failed to start pihole-FTL.service: Unit pihole-FTL.service not found. I ran a new pihole -d and here is the token 78nj80j9jc

I don't see the log-queries directive in your dnsmsasq config file. This would prevent stats from being logged, thus showing zero queries on the dashboard.

Can you try a pihole -r > Repair?

Strange the .service file doesn't exist though since you just mentioned it was the same was what I linked you to on GitHub.

My apologies for taking so long to reply.
I ran a pihole -r and FTL still doesn't start on boot. Running service pihole-FTL start still results in the service not being found.

What is in

ls -l /var/run/pihole
ls -l /etc/init.d

I was out of town all day yesterday. Checked it today and FTL had stopped running at some point. I ran sudo service pihole-FTL start and it started again, but still not showing stats on the web page. Below are the answers to your questions above. Thank you.

$ ls -l /var/run/pihole
total 0
srwxrwxrwx 1 pihole pihole 0 Apr 15 14:49 FTL.sock
ls -l /etc/init.d
total 292
-rwxr-xr-x 1 root root  5340 Oct 18  2013 alsa-utils
-rwxr-xr-x 1 root root 10184 Aug  7  2016 apache2
-rwxr-xr-x 1 root root  1071 Sep 30  2014 atd
-rwxr-xr-x 1 root root  2401 Apr 13  2015 avahi-daemon
-rwxr-xr-x 1 root root  2948 Aug 18  2014 bluetooth
-rwxr-xr-x 1 root root  1276 Apr  6  2015 bootlogs
-rwxr-xr-x 1 root root  1248 Apr  6  2015 bootmisc.sh
-rwxr-xr-x 1 root root  3807 Apr  6  2015 checkfs.sh
-rwxr-xr-x 1 root root  1072 Apr  6  2015 checkroot-bootclean.sh
-rwxr-xr-x 1 root root  9290 Apr  6  2015 checkroot.sh
-rwxr-xr-x 1 root root  1567 Nov 15  2016 connman
-rwxr-xr-x 1 root root  2489 May  6  2012 cpufrequtils
-rwxr-xr-x 1 root root  3049 Jun 11  2015 cron
-rwxr-xr-x 1 root root  2813 Oct 10  2016 dbus
-rwxr-xr-x 1 root root  1879 Nov 19  2014 dhcpcd
-rwxr-xr-x 1 root root  8290 May  5  2015 dnsmasq
-rwxr-xr-x 1 root root  1336 Apr  6  2015 halt
-rwxr-xr-x 1 root root  2363 Feb 26  2014 haveged
-rwxr-xr-x 1 root root 10704 Feb 24  2015 hdparm
-rwxr-xr-x 1 root root  1517 Jul 23  2016 hostapd
-rwxr-xr-x 1 root root  1423 Apr  6  2015 hostname.sh
-rwxr-xr-x 1 root root  3916 Mar 29  2015 hwclock.sh
-rwxr-xr-x 1 root root  1300 Apr  6  2015 killprocs
-rwxr-xr-x 1 root root  1990 Sep 23  2014 kmod
-rwxr-xr-x 1 root root  2944 Aug  2  2016 lighttpd
-rwxr-xr-x 1 root root  6912 May  6  2012 loadcpufreq
-rwxr-xr-x 1 root root   995 Apr  6  2015 motd
-rwxr-xr-x 1 root root   677 Apr  6  2015 mountall-bootclean.sh
-rwxr-xr-x 1 root root  2138 Apr  6  2015 mountall.sh
-rwxr-xr-x 1 root root  1461 Apr  6  2015 mountdevsubfs.sh
-rwxr-xr-x 1 root root  1564 Apr  6  2015 mountkernfs.sh
-rwxr-xr-x 1 root root   685 Apr  6  2015 mountnfs-bootclean.sh
-rwxr-xr-x 1 root root  2456 Apr  6  2015 mountnfs.sh
-rwxr-xr-x 1 root root  4771 Jul 19  2015 networking
-rwxr-xr-x 1 root root  1757 Mar 31  2015 network-manager
-rwxr-xr-x 1 root root  1796 Apr 13 14:49 pihole-FTL
-rwxr-xr-x 1 root root   612 Sep 20  2014 pppd-dns
-rwxr-xr-x 1 root root  1192 Mar  6  2015 procps
-rwxr-xr-x 1 root root  6228 Apr  6  2015 rc
-rwxr-xr-x 1 root root   820 Apr  6  2015 rc.local
-rwxr-xr-x 1 root root   117 Apr  6  2015 rcS
-rw-r--r-- 1 root root  2427 Apr  6  2015 README
-rwxr-xr-x 1 root root   661 Apr  6  2015 reboot
-rwxr-xr-x 1 root root  1042 Apr  6  2015 rmnologin
-rwxr-xr-x 1 root root  4355 Jul 10  2014 rsync
-rwxr-xr-x 1 root root  2796 Dec 14  2015 rsyslog
-rwxr-xr-x 1 root root  1226 Jul 26  2014 screen-cleanup
-rwxr-xr-x 1 root root  3207 Apr  6  2015 sendsigs
-rwxr-xr-x 1 root root   597 Apr  6  2015 single
-rw-r--r-- 1 root root  1087 Apr  6  2015 skeleton
-rwxr-xr-x 1 root root  4077 Apr 14  2016 ssh
-rwxr-xr-x 1 root root   731 Jan  5  2016 sudo
-rwxr-xr-x 1 root root  6087 Jul 27  2016 udev
-rwxr-xr-x 1 root root  1416 Aug  3  2014 udhcpd
-rwxr-xr-x 1 root root  2737 Apr  6  2015 umountfs
-rwxr-xr-x 1 root root  2202 Apr  6  2015 umountnfs.sh
-rwxr-xr-x 1 root root  1129 Apr  6  2015 umountroot
-rwxr-xr-x 1 root root  3111 Apr  6  2015 urandom
-rwxr-xr-x 1 root root  2666 Sep 25  2013 x11-common