The issue I am facing:
RPi is working as evidenced by the Dashboard. But when I look at the Query Log it is empty. I search for domains and nothing shows up.
I actually drafted this about a week ago, but when I ran the update to Pi-hole, the Query log started showing up again. However, when I went to check today, the same problem recurred and my Query log I blank again. If I run pihole -r it shows up again and my Dashboard is empty and only starts to populate but the Query Log is showing entries again
I had a previous challenge with this that was resolved back in January
Details about my system:
My New (today Jun 10) Debug token: https://tricorder.pi-hole.net/EQWRst3d/
Nothing jumped out to my untrained noob eye
sudo cat /var/log/lighttpd/error.log - Empty
** Things I have tried and threads I have looked at. **
So I found a similar thread
Query Log Always Empty
And followed along
And tried the command suggested by @deHakkelaar
echo 'SELECT count(*) FROM queries WHERE timestamp BETWEEN "'$(date --date="2020-09-4 00:00:00" +%s)'" AND "'$(date --date="2020-09-5 23:59:59" +%s)'";' | sqlite3 /etc/pihole/pihole-FTL.d
Resolved the problem of sqlite3 not installed by updating everything and installing this
But then reached an impasse
Error: unable to open database "/etc/pihole/pihole-FTL.db": unable to open database file
I verified that the file exists
drwxr-xr-x 2 pihole pihole 4096 Feb 28 16:50 migration_backup_v6
-rw-r----- 1 pihole pihole 1984991232 Jun 1 09:53 pihole-FTL.db
-rw-r----- 1 pihole pihole 32768 Jun 1 09:53 pihole-FTL.db-shm
-rw-r----- 1 pihole pihole 12392 Jun 1 09:54 pihole-FTL.db-wal
-rw-r--r-- 1 pihole pihole 56161 Jun 5 19:06 pihole.toml
Tried to 'sudo' the above command but same response.
Noted the odd fact that the date on that file is Jun 1 (today is Jun 6)
Attempting to get ahead of questions, I am answering the requests for additional info below
hostnamectl | tail -3
Operating System: Debian GNU/Linux 12 (bookworm)
Kernel: Linux 6.12.20+rpt-rpi-v8
Architecture: arm64lsb_release -a
No LSB modules are available.
Distributor ID: Debian
Description: Debian GNU/Linux 12 (bookworm)
Release: 12
Codename: bookwormsudo netstat -nltup | grep 'Proto|:53 |:67 |:80 |:547 |:471[1-8] '
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:53 0.0.0.0:* LISTEN 1828475/pihole-FTL
tcp6 0 0 :::53 :::* LISTEN 1828475/pihole-FTL
udp 0 0 0.0.0.0:53 0.0.0.0:* 1828475/pihole-FTL
udp6 0 0 :::53 :::* 1828475/pihole-FTLphp-cgi -m
[PHP Modules]
calendar
cgi-fcgi
Core
ctype
date
dom
exif
FFI
fileinfo
filter
ftp
gettext
hash
iconv
intl
json
libxml
openssl
pcntl
pcre
PDO
pdo_sqlite
Phar
posix
random
readline
Reflection
session
shmop
SimpleXML
sockets
sodium
SPL
sqlite3
standard
sysvmsg
sysvsem
sysvshm
tokenizer
xml
xmlreader
xmlwriter
xsl
Zend OPcache
zlib[Zend Modules]
Zend OPcacheuptime && dmesg -T | grep -i voltage
12:19:53 up 53 days, 19:38, 2 users, load average: 0.30, 0.43, 0.70And added a whitelist domain while this was running, but log remained empty (whitelisted domain showed up in the list)
udo tail -f /var/log/lighttpd/{access,error}.log
==> /var/log/lighttpd/access.log <====> /var/log/lighttpd/error.log <==
<<<<<< END of Diagnostic Info
Not a browser cache problem as this occurs in all browsers I try some of which have never accessed the RpI
What I have changed since installing Pi-hole:
Not changed much aside from adding additional blocked domains and lists and excluding some