Web interface should be showing stats.
Web interface is not showing stats. It shows zero for everything except the domains on blocklist.
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.
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