Roalith
November 12, 2018, 10:28pm
1
Expected Behaviour:
Should see queries in Admin Panel.
Actual Behaviour:
"No data available in table"
Debug Token: alwi04ujik
I tried a few steps that I found searching on the web and reddit, but no luck. Trying to determine a domain that is being blocked so I can whitelist it for my wife, but the query log is blank. Also tried clearing cache and switching browsers. Most recently set up current locale and timezone in the OS settings and restarted, but no change in behavior.
jfb
November 13, 2018, 1:54am
2
What is the output of these commands from the Pi terminal?
echo ">stats" | nc localhost 4711
free
1 Like
jfb
November 13, 2018, 2:13am
4
Can you post a few screen captures showing what you are seeing?
Roalith
November 13, 2018, 2:18am
5
adblock@raspberrypi:~ $ echo ">stats" | nc localhost 4711
domains_being_blocked 3742716
dns_queries_today 44866
ads_blocked_today 21415
ads_percentage_today 47.731022
unique_domains 1
queries_forwarded 21206
queries_cached 2245
clients_ever_seen 1
unique_clients 1
dns_queries_all_types 45227
reply_NODATA 119
reply_NXDOMAIN 2
reply_CNAME 0
reply_IP 23539
status enabled
---EOM---
adblock@raspberrypi:~ $ free
total used free shared buff/cache available
Mem: 949448 656220 116112 18880 177116 240464
Swap: 102396 102216 180
jfb
November 13, 2018, 2:33am
7
What are the outputs of the following:
stat /var/log/pihole.log
stat /etc/pihole/pihole-FTL.db
cat /etc/pihole/pihole-FTL.conf
df -a
Roalith
November 13, 2018, 3:11am
8
jfb:
df -a
adblock@raspberrypi:~ $ stat /var/log/pihole.log
File: /var/log/pihole.log
Size: 3066014 Blocks: 6000 IO Block: 4096 regular file
Device: b307h/45831d Inode: 1226 Links: 1
Access: (0644/-rw-r--r--) Uid: ( 999/ pihole) Gid: ( 996/ pihole)
Access: 2018-11-11 04:13:58.799999998 +0000
Modify: 2018-11-13 03:09:43.747672359 +0000
Change: 2018-11-13 03:09:43.747672359 +0000
Birth: -
adblock@raspberrypi:~ $ stat /etc/pihole/pihole-FTL.db
File: /etc/pihole/pihole-FTL.db
Size: 24576 Blocks: 48 IO Block: 4096 regular file
Device: b307h/45831d Inode: 528534 Links: 1
Access: (0644/-rw-r--r--) Uid: ( 999/ pihole) Gid: ( 996/ pihole)
Access: 2018-11-11 04:12:13.436226946 +0000
Modify: 2018-11-13 03:10:00.127676739 +0000
Change: 2018-11-13 03:10:00.127676739 +0000
Birth: -
adblock@raspberrypi:~ $ cat /etc/pihole/pihole-FTL.conf
PRIVACYLEVEL=3
adblock@raspberrypi:~ $ df -a
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/root 13456392 5645228 7183732 45% /
devtmpfs 470116 0 470116 0% /dev
sysfs 0 0 0 - /sys
proc 0 0 0 - /proc
tmpfs 474724 9560 465164 3% /dev/shm
devpts 0 0 0 - /dev/pts
tmpfs 474724 12336 462388 3% /run
tmpfs 5120 4 5116 1% /run/lock
tmpfs 474724 0 474724 0% /sys/fs/cgroup
cgroup 0 0 0 - /sys/fs/cgroup/systemd
cgroup 0 0 0 - /sys/fs/cgroup/blkio
cgroup 0 0 0 - /sys/fs/cgroup/cpuset
cgroup 0 0 0 - /sys/fs/cgroup/net_cls
cgroup 0 0 0 - /sys/fs/cgroup/cpu,cpuacct
cgroup 0 0 0 - /sys/fs/cgroup/devices
cgroup 0 0 0 - /sys/fs/cgroup/freezer
systemd-1 0 0 0 - /proc/sys/fs/binfmt_misc
mqueue 0 0 0 - /dev/mqueue
debugfs 0 0 0 - /sys/kernel/debug
sunrpc 0 0 0 - /run/rpc_pipefs
configfs 0 0 0 - /sys/kernel/config
/dev/mmcblk0p6 69553 22501 47052 33% /boot
tmpfs 94944 0 94944 0% /run/user/999
fusectl 0 0 0 - /sys/fs/fuse/connections
tmpfs 94944 0 94944 0% /run/user/1000
gvfsd-fuse 0 0 0 - /run/user/1000/gvfs
/dev/mmcblk0p5 30701 398 28010 2% /media/adblock/SETTINGS
jfb
November 13, 2018, 3:32am
9
Roalith:
PRIVACYLEVEL=3
You have privacy level at 3. Per the V4 documentation (Privacy levels - Pi-hole documentation ):
### Level 3 - anonymous mode (anonymize everything)
Disable all details except the most anonymous statistics
This setting disables
* Top Domains
* Top Ads
* Top Clients
* Clients over time
* Query Log
* Long-term database logging
1 Like
Roalith
November 13, 2018, 3:44am
10
Perfect, thanks! We're new to this, I changed the setting and everything works. Bonus for me, in the troubleshooting process I learned how to set locale/timezone too!!
Thank you jfb!!!
system
Closed
December 4, 2018, 3:44am
11
This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.