*** [ INITIALIZING ] [i] 2024-03-29:18:26:16 debug log has been initialized. [i] System has been running for 0 days, 1 hours, 44 minutes *** [ INITIALIZING ] Sourcing setup variables [i] Sourcing /etc/pihole/setupVars.conf... *** [ DIAGNOSING ]: Core version [✓] Version: v5.17.3 [i] Remotes: origin https://github.com/pi-hole/pi-hole.git (fetch) origin https://github.com/pi-hole/pi-hole.git (push) [i] Branch: master [i] Commit: v5.17.3-0-g19bfa08 *** [ DIAGNOSING ]: Web version [✓] Version: v5.21 [i] Remotes: origin https://github.com/pi-hole/web.git (fetch) origin https://github.com/pi-hole/web.git (push) [i] Branch: master [i] Commit: v5.21-0-gbe05b0f *** [ DIAGNOSING ]: FTL version [✓] Version: v5.25.1 [i] Branch: master [i] Commit: 1c2257be *** [ DIAGNOSING ]: lighttpd version [i] 1.4.59 *** [ DIAGNOSING ]: php version [i] 7.4.33 *** [ DIAGNOSING ]: Operating system [i] Pi-hole Docker Container: 2024.02.2 [✓] Distro: Debian [✓] Version: 11 [✓] dig return code: 0 [i] dig response: "Raspbian=10,11,12 Ubuntu=20,22,23 Debian=10,11,12 Fedora=38,39 CentOS=8,9" [✓] Distro and version supported *** [ DIAGNOSING ]: SELinux [i] SELinux not detected *** [ DIAGNOSING ]: FirewallD [✓] Firewalld service not detected *** [ DIAGNOSING ]: Processor [✓] x86_64 *** [ DIAGNOSING ]: Disk usage Filesystem Size Used Avail Use% Mounted on overlay 98G 41G 53G 44% / tmpfs 64M 0 64M 0% /dev shm 64M 1.2M 63M 2% /dev/shm /dev/mapper/ubuntu--vg-ubuntu--lv 98G 41G 53G 44% /etc/pihole tmpfs 1.9G 0 1.9G 0% /proc/asound tmpfs 1.9G 0 1.9G 0% /proc/acpi tmpfs 1.9G 0 1.9G 0% /proc/scsi tmpfs 1.9G 0 1.9G 0% /sys/firmware *** [ DIAGNOSING ]: Network interfaces and addresses 1: lo: mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000 link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00 inet 127.0.0.1/8 scope host lo valid_lft forever preferred_lft forever 7: eth0@if2: mtu 1500 qdisc noqueue state UP group default link/ether 02:42:c0:a8:01:63 brd ff:ff:ff:ff:ff:ff link-netnsid 0 inet 192.168.1.99/24 brd 192.168.1.255 scope global eth0 valid_lft forever preferred_lft forever *** [ DIAGNOSING ]: Network routing table default via 192.168.1.1 dev eth0 192.168.1.0/24 dev eth0 proto kernel scope link src 192.168.1.99 *** [ DIAGNOSING ]: Networking [✓] IPv4 address(es) bound to the eth0 interface: 192.168.1.99/24 [✗] No IPv6 address(es) found on the eth0 interface. [i] Default IPv4 gateway(s): 192.168.1.1 * Pinging first gateway 192.168.1.1... [✓] Gateway responded. [i] Default IPv6 gateway(s): *** [ DIAGNOSING ]: Name resolution (IPv4) using a random blocked domain and a known ad-serving domain [✓] afront.io is 0.0.0.0 on lo (127.0.0.1) [✓] afront.io is 0.0.0.0 on eth0 (192.168.1.99) [✓] doubleclick.com is 172.217.165.142 via a remote, public DNS server (8.8.8.8) *** [ DIAGNOSING ]: Name resolution (IPv6) using a random blocked domain and a known ad-serving domain [✓] No IPv6 address available on lo [✓] No IPv6 address available on eth0 [✗] Failed to resolve doubleclick.com via a remote, public DNS server (2001:4860:4860::8888) *** [ DIAGNOSING ]: Discovering active DHCP servers (takes 10 seconds) Scanning all your interfaces for DHCP servers Timeout: 10 seconds * Received 308 bytes from eth0:192.168.1.1 Offered IP address: 192.168.1.106 Server IP address: 192.168.1.1 Relay-agent IP address: N/A BOOTP server: (empty) BOOTP file: (empty) DHCP options: Message type: DHCPOFFER (2) server-identifier: 192.168.1.1 lease-time: 86400 ( 1d ) renewal-time: 43200 ( 12h ) rebinding-time: 75600 ( 21h ) netmask: 255.255.255.0 router: 192.168.1.1 dns-server: 192.168.1.99 domain-name: "hsd1.ma.comcast.net." --- end of options --- DHCP packets received on interface eth0: 1 *** [ DIAGNOSING ]: Pi-hole processes [✓] lighttpd daemon is active [✓] pihole-FTL daemon is active *** [ DIAGNOSING ]: Pi-hole-FTL full status [i] systemctl: command not found *** [ DIAGNOSING ]: Lighttpd configuration test [✓] No error in lighttpd configuration *** [ DIAGNOSING ]: Setup variables INSTALL_WEB_INTERFACE=true PIHOLE_DNS_1=8.8.8.8 PIHOLE_DNS_2=8.8.4.4 PIHOLE_INTERFACE=eth0 QUERY_LOGGING=true BLOCKING_ENABLED=true WEBUIBOXEDLAYOUT=boxed WEBTHEME=lcars DHCP_ACTIVE=false DHCP_START=192.168.1.100 DHCP_END=192.168.1.199 DHCP_ROUTER=192.168.1.1 DHCP_LEASETIME=24 PIHOLE_DOMAIN=lan DHCP_IPv6=false DHCP_rapid_commit=false *** [ DIAGNOSING ]: Dashboard headers [✓] Web interface X-Header: X-Pi-hole: The Pi-hole Web interface is working! *** [ DIAGNOSING ]: Pi-hole FTL Query Database -rw-rw-r-- 1 pihole pihole 20M Mar 29 18:26 /etc/pihole/pihole-FTL.db *** [ DIAGNOSING ]: Gravity Database -rw-rw-r-- 1 pihole pihole 21M Mar 29 16:44 /etc/pihole/gravity.db *** [ DIAGNOSING ]: Info table property value -------------------- ---------------------------------------- version 15 updated 1711745062 gravity_count 292849 Last gravity run finished at: Fri Mar 29 16:44:22 EDT 2024 ----- First 10 Gravity Domains ----- localhost.localdomain ck.getcookiestxt.com eu1.clevertap-prod.com wizhumpgyros.com coccyxwickimp.com webmail-who-int.000webhostapp.com 010sec.com 01mspmd5yalky8.com 0byv9mgbn0.com ns6.0pendns.org *** [ DIAGNOSING ]: Groups id enabled name date_added date_modified description ---- ------- -------------------------------------------------- ------------------- ------------------- -------------------------------------------------- 0 1 Default 2024-03-13 08:07:40 2024-03-13 08:07:40 The default group *** [ DIAGNOSING ]: Domainlist (0/1 = exact white-/blacklist, 2/3 = regex white-/blacklist) id type enabled group_ids domain date_added date_modified comment ----- ---- ------- ------------ ---------------------------------------------------------------------------------------------------- ------------------- ------------------- -------------------------------------------------- 1 0 1 0 incoming.telemetry.mozilla.org 2024-03-13 11:57:36 2024-03-13 11:57:36 Added from Query Log *** [ DIAGNOSING ]: Clients *** [ DIAGNOSING ]: Adlists id enabled group_ids address date_added date_modified comment ----- ------- ------------ ---------------------------------------------------------------------------------------------------- ------------------- ------------------- -------------------------------------------------- 1 1 0 https://raw.githubusercontent.com/StevenBlack/hosts/master/hosts 2024-03-13 08:07:40 2024-03-13 08:07:40 Migrated from /etc/pihole/adlists.list 2 1 0 https://adaway.org/hosts.txt 2024-03-13 10:14:29 2024-03-13 10:15:09 Advertising 3 1 0 https://v.firebog.net/hosts/AdguardDNS.txt 2024-03-13 10:14:29 2024-03-13 10:15:11 Advertising 4 1 0 https://v.firebog.net/hosts/Admiral.txt 2024-03-13 10:14:29 2024-03-13 10:15:15 Advertising 5 1 0 https://raw.githubusercontent.com/anudeepND/blacklist/master/adservers.txt 2024-03-13 10:14:29 2024-03-13 10:15:16 Advertising 6 1 0 https://v.firebog.net/hosts/Easylist.txt 2024-03-13 10:14:29 2024-03-13 10:15:19 Advertising 7 1 0 https://pgl.yoyo.org/adservers/serverlist.php?hostformat=hosts&showintro=0&mimetype=plaintext 2024-03-13 10:14:29 2024-03-13 10:15:22 Advertising 8 1 0 https://raw.githubusercontent.com/FadeMind/hosts.extras/master/UncheckyAds/hosts 2024-03-13 10:14:41 2024-03-13 10:15:24 Advertising 9 1 0 https://raw.githubusercontent.com/bigdargon/hostsVN/master/hosts 2024-03-13 10:14:55 2024-03-13 10:15:27 Advertising *** [ DIAGNOSING ]: contents of /etc/pihole -rwxr-xr-x 1 nobody nogroup 57 Mar 18 13:42 /etc/pihole/custom.list 192.168.1.103 pihole.local 192.168.1.1 routerlogin.local -rw-r--r-- 1 nobody nogroup 65 Mar 29 16:44 /etc/pihole/local.list -rwxr-xr-x 1 nobody nogroup 241 Mar 13 08:07 /etc/pihole/logrotate /var/log/pihole/pihole.log { su root root daily copytruncate rotate 5 compress delaycompress notifempty nomail } /var/log/pihole/FTL.log { su root root weekly copytruncate rotate 3 compress delaycompress notifempty nomail } -rwxr-xr-x 1 nobody nogroup 157 Mar 29 16:42 /etc/pihole/pihole-FTL.conf MACVENDORDB=/macvendor.db LOCAL_IPV4=0.0.0.0 -rw-r--r-- 1 nobody nogroup 382 Mar 29 18:02 /etc/pihole/versions CORE_VERSION=v5.17.3 CORE_BRANCH=master CORE_HASH=19bfa08b GITHUB_CORE_VERSION=v5.18.1 GITHUB_CORE_HASH=74a44cad WEB_VERSION=v5.21 WEB_BRANCH=master WEB_HASH=be05b0f6 GITHUB_WEB_VERSION=v5.21 GITHUB_WEB_HASH=be05b0f6 FTL_VERSION=v5.25.1 FTL_BRANCH=master FTL_HASH=1c2257be GITHUB_FTL_VERSION=v5.25.1 GITHUB_FTL_HASH=1c2257be DOCKER_VERSION=2024.02.2 GITHUB_DOCKER_VERSION=2024.03.1 *** [ DIAGNOSING ]: contents of /etc/dnsmasq.d -rw-r--r-- 1 root root 1.4K Mar 29 16:42 /etc/dnsmasq.d/01-pihole.conf addn-hosts=/etc/pihole/local.list addn-hosts=/etc/pihole/custom.list localise-queries no-resolv log-queries log-facility=/var/log/pihole/pihole.log log-async cache-size=10000 server=8.8.8.8 server=8.8.4.4 interface=eth0 -rw-r--r-- 1 root root 0 Mar 18 13:41 /etc/dnsmasq.d/05-pihole-custom-cname.conf -rw-r--r-- 1 root root 2.2K Mar 29 16:42 /etc/dnsmasq.d/06-rfc6761.conf server=/test/ server=/localhost/ server=/invalid/ server=/bind/ server=/onion/ *** [ DIAGNOSING ]: contents of /etc/lighttpd -rw-r--r-- 1 root root 2.2K Jan 19 2022 /etc/lighttpd/lighttpd.conf server.modules = ( "mod_indexfile", "mod_access", "mod_alias", "mod_redirect", ) server.document-root = "/var/www/html" server.upload-dirs = ( "/var/cache/lighttpd/uploads" ) server.errorlog = "/var/log/lighttpd/error.log" server.pid-file = "/run/lighttpd.pid" server.username = "www-data" server.groupname = "www-data" server.port = 80 server.feature-flags += ("server.h2proto" => "enable") server.feature-flags += ("server.h2c" => "enable") server.feature-flags += ("server.graceful-shutdown-timeout" => 5) server.http-parseopts = ( "header-strict" => "enable",# default "host-strict" => "enable",# default "host-normalize" => "enable",# default "url-normalize-unreserved"=> "enable",# recommended highly "url-normalize-required" => "enable",# recommended "url-ctrls-reject" => "enable",# recommended "url-path-2f-decode" => "enable",# recommended highly (unless breaks app) "url-path-dotseg-remove" => "enable",# recommended highly (unless breaks app) ) index-file.names = ( "index.php", "index.html" ) url.access-deny = ( "~", ".inc" ) static-file.exclude-extensions = ( ".php", ".pl", ".fcgi" ) include_shell "/usr/share/lighttpd/use-ipv6.pl " + server.port include_shell "/usr/share/lighttpd/create-mime.conf.pl" include "/etc/lighttpd/conf-enabled/*.conf" server.modules += ( "mod_dirlisting", "mod_staticfile", ) *** [ DIAGNOSING ]: contents of /etc/lighttpd/conf.d /etc/lighttpd/conf.d does not exist. *** [ DIAGNOSING ]: contents of /etc/lighttpd/conf-enabled total 4.0K lrwxrwxrwx 1 root root 32 Feb 26 16:36 05-setenv.conf -> ../conf-available/05-setenv.conf lrwxrwxrwx 1 root root 35 Feb 26 16:36 10-accesslog.conf -> ../conf-available/10-accesslog.conf lrwxrwxrwx 1 root root 33 Feb 26 16:36 10-fastcgi.conf -> ../conf-available/10-fastcgi.conf -rw-r--r-- 1 root root 215 Mar 29 16:42 15-pihole-admin-redirect-docker.conf lrwxrwxrwx 1 root root 38 Feb 26 16:36 15-pihole-admin.conf -> ../conf-available/15-pihole-admin.conf lrwxrwxrwx 1 root root 38 Feb 26 16:36 /etc/lighttpd/conf-enabled/15-pihole-admin.conf -> ../conf-available/15-pihole-admin.conf server.errorlog := "/var/log/lighttpd/error-pihole.log" $HTTP["url"] =~ "^/admin/" { server.document-root = "/var/www/html" server.stream-response-body = 1 accesslog.filename = "/var/log/lighttpd/access-pihole.log" accesslog.format = "%{%s}t|%h|%V|%r|%s|%b" fastcgi.server = ( ".php" => ( "localhost" => ( "socket" => "/run/lighttpd/pihole-php-fastcgi.socket", "bin-path" => "/usr/bin/php-cgi", "min-procs" => 1, "max-procs" => 1, "bin-environment" => ( "TZ" => "America/New_York", "PIHOLE_DOCKER_TAG" => "", "PHP_ERROR_LOG" => "/var/log/lighttpd/error-pihole.log", "CORS_HOSTS" => "", "VIRTUAL_HOST" => "pihole", "PHP_FCGI_CHILDREN" => "4", "PHP_FCGI_MAX_REQUESTS" => "10000", ), "bin-copy-environment" => ( "PATH", "SHELL", "USER" ), "broken-scriptfilename" => "enable", ) ) ) setenv.add-response-header = ( "X-Pi-hole" => "The Pi-hole Web interface is working!", "X-Frame-Options" => "DENY", "X-XSS-Protection" => "0", "X-Content-Type-Options" => "nosniff", "Content-Security-Policy" => "default-src 'self' 'unsafe-inline';", "X-Permitted-Cross-Domain-Policies" => "none", "Referrer-Policy" => "same-origin" ) $HTTP["url"] =~ "^/admin/\." { url.access-deny = ("") } $HTTP["url"] =~ "/(teleporter|api_token)\.php$" { $HTTP["referer"] =~ "/admin/settings\.php" { setenv.set-response-header = ( "X-Frame-Options" => "SAMEORIGIN" ) } } } else $HTTP["url"] == "/admin" { url.redirect = ("" => "/admin/") } $HTTP["host"] == "pi.hole" { $HTTP["url"] == "/" { url.redirect = ("" => "/admin/") } } server.modules += ( "mod_access", "mod_accesslog", "mod_redirect", "mod_fastcgi", "mod_setenv" ) *** [ DIAGNOSING ]: contents of /etc/cron.d -rw-r--r-- 1 root root 1.7K Mar 29 16:42 /etc/cron.d/pihole 14 3 * * 7 root PATH="$PATH:/usr/sbin:/usr/local/bin/" pihole updateGravity >/var/log/pihole/pihole_updateGravity.log || cat /var/log/pihole/pihole_updateGravity.log 00 00 * * * root PATH="$PATH:/usr/sbin:/usr/local/bin/" pihole flush once quiet @reboot root /usr/sbin/logrotate --state /var/lib/logrotate/pihole /etc/pihole/logrotate 2 18 * * * root PATH="$PATH:/usr/sbin:/usr/local/bin/" pihole updatechecker @reboot root PATH="$PATH:/usr/sbin:/usr/local/bin/" pihole updatechecker reboot *** [ DIAGNOSING ]: contents of /var/log/lighttpd -rw-r--r-- 1 www-data www-data 465 Mar 29 16:43 /var/log/lighttpd/error-pihole.log -----head of error-pihole.log------ 2024-03-29 15:50:56: server.c.1513) server started (lighttpd/1.4.59) 2024-03-29 16:09:14: server.c.1513) server started (lighttpd/1.4.59) 2024-03-29 16:09:14: gw_backend.c.475) unlink /run/lighttpd/pihole-php-fastcgi.socket-0 after connect failed: Connection refused 2024-03-29 16:42:59: server.c.1513) server started (lighttpd/1.4.59) 2024-03-29 16:42:59: gw_backend.c.475) unlink /run/lighttpd/pihole-php-fastcgi.socket-0 after connect failed: Connection refused -----tail of error-pihole.log------ 2024-03-29 15:50:56: server.c.1513) server started (lighttpd/1.4.59) 2024-03-29 16:09:14: server.c.1513) server started (lighttpd/1.4.59) 2024-03-29 16:09:14: gw_backend.c.475) unlink /run/lighttpd/pihole-php-fastcgi.socket-0 after connect failed: Connection refused 2024-03-29 16:42:59: server.c.1513) server started (lighttpd/1.4.59) 2024-03-29 16:42:59: gw_backend.c.475) unlink /run/lighttpd/pihole-php-fastcgi.socket-0 after connect failed: Connection refused *** [ DIAGNOSING ]: contents of /var/log/pihole -rw-r--r-- 1 pihole pihole 29K Mar 29 17:59 /var/log/pihole/FTL.log -----head of FTL.log------ [2024-03-29 15:50:56.917 267M] Using log file /var/log/pihole/FTL.log [2024-03-29 15:50:56.917 267M] ########## FTL started on pihole! ########## [2024-03-29 15:50:56.917 267M] FTL branch: master [2024-03-29 15:50:56.917 267M] FTL version: v5.25.1 [2024-03-29 15:50:56.917 267M] FTL commit: 1c2257be [2024-03-29 15:50:56.917 267M] FTL date: 2024-02-20 20:02:36 +0100 [2024-03-29 15:50:56.917 267M] FTL user: pihole [2024-03-29 15:50:56.917 267M] Compiled for x86_64 (compiled on CI) using gcc (Debian 8.3.0-6) 8.3.0 [2024-03-29 15:50:56.917 267M] Starting config file parsing (/etc/pihole/pihole-FTL.conf) [2024-03-29 15:50:56.917 267M] SOCKET_LISTENING: only local [2024-03-29 15:50:56.917 267M] AAAA_QUERY_ANALYSIS: Show AAAA queries [2024-03-29 15:50:56.918 267M] MAXDBDAYS: max age for stored queries is 365 days [2024-03-29 15:50:56.918 267M] RESOLVE_IPV6: Resolve IPv6 addresses [2024-03-29 15:50:56.918 267M] RESOLVE_IPV4: Resolve IPv4 addresses [2024-03-29 15:50:56.918 267M] DBINTERVAL: saving to DB file every minute [2024-03-29 15:50:56.918 267M] DBFILE: Using /etc/pihole/pihole-FTL.db [2024-03-29 15:50:56.918 267M] MAXLOGAGE: Importing up to 24.0 hours of log data [2024-03-29 15:50:56.918 267M] PRIVACYLEVEL: Set to 0 [2024-03-29 15:50:56.918 267M] IGNORE_LOCALHOST: Show queries from localhost [2024-03-29 15:50:56.918 267M] BLOCKINGMODE: Null IPs for blocked domains [2024-03-29 15:50:56.918 267M] ANALYZE_ONLY_A_AND_AAAA: Disabled. Analyzing all queries [2024-03-29 15:50:56.918 267M] DBIMPORT: Importing history from database [2024-03-29 15:50:56.918 267M] PIDFILE: Using /run/pihole-FTL.pid [2024-03-29 15:50:56.918 267M] SOCKETFILE: Using /run/pihole/FTL.sock [2024-03-29 15:50:56.918 267M] SETUPVARSFILE: Using /etc/pihole/setupVars.conf [2024-03-29 15:50:56.918 267M] MACVENDORDB: Using /macvendor.db [2024-03-29 15:50:56.918 267M] GRAVITYDB: Using /etc/pihole/gravity.db [2024-03-29 15:50:56.918 267M] PARSE_ARP_CACHE: Active [2024-03-29 15:50:56.918 267M] CNAME_DEEP_INSPECT: Active [2024-03-29 15:50:56.918 267M] DELAY_STARTUP: No delay requested. [2024-03-29 15:50:56.918 267M] BLOCK_ESNI: Enabled, blocking _esni.{blocked domain} [2024-03-29 15:50:56.918 267M] NICE: Cannot change niceness to -10 (permission denied) [2024-03-29 15:50:56.918 267M] MAXNETAGE: Removing IP addresses and host names from network table after 365 days [2024-03-29 15:50:56.918 267M] NAMES_FROM_NETDB: Enabled, trying to get names from network database [2024-03-29 15:50:56.918 267M] EDNS0_ECS: Overwrite client from ECS information -----tail of FTL.log------ [2024-03-29 16:43:01.980 226/T269] SQLite3 message: database is locked in "SELECT domain, CASE WHEN substr(domain, 1, 1) = '*' THEN '*' || substr(:input, - length(domain) + 1) ELSE :input END matcher FROM domain_audit WHERE matcher = domain;" (5) [2024-03-29 16:43:01.980 226/T269] gravityDB_open("SELECT EXISTS(... domain_audit ...)") - SQL error prepare: database is locked [2024-03-29 16:43:01.980 226/T269] SQLite3 message: database is locked in "SELECT domain, CASE WHEN substr(domain, 1, 1) = '*' THEN '*' || substr(:input, - length(domain) + 1) ELSE :input END matcher FROM domain_audit WHERE matcher = domain;" (5) [2024-03-29 16:43:01.980 226/T269] gravityDB_open("SELECT EXISTS(... domain_audit ...)") - SQL error prepare: database is locked [2024-03-29 16:43:01.980 226/T269] gravityDB_count(0): Gravity database not available [2024-03-29 16:43:01.981 226/T269] SQLite3 message: database is locked in "SELECT domain, CASE WHEN substr(domain, 1, 1) = '*' THEN '*' || substr(:input, - length(domain) + 1) ELSE :input END matcher FROM domain_audit WHERE matcher = domain;" (5) [2024-03-29 16:43:01.981 226/T269] gravityDB_open("SELECT EXISTS(... domain_audit ...)") - SQL error prepare: database is locked [2024-03-29 16:43:01.981 226/T269] gravityDB_count(3): Gravity database not available [2024-03-29 16:43:01.981 226/T269] WARN: Database query failed, assuming there are no blacklist regex entries [2024-03-29 16:43:01.981 226/T269] SQLite3 message: database is locked in "SELECT domain, CASE WHEN substr(domain, 1, 1) = '*' THEN '*' || substr(:input, - length(domain) + 1) ELSE :input END matcher FROM domain_audit WHERE matcher = domain;" (5) [2024-03-29 16:43:01.981 226/T269] gravityDB_open("SELECT EXISTS(... domain_audit ...)") - SQL error prepare: database is locked [2024-03-29 16:43:01.981 226/T269] gravityDB_count(4): Gravity database not available [2024-03-29 16:43:01.981 226/T269] WARN: Database query failed, assuming there are no whitelist regex entries [2024-03-29 16:43:01.981 226/T269] Compiled 0 whitelist and 0 blacklist regex filters for 6 clients in 0.8 msec [2024-03-29 16:43:01.981 226/T269] SQLite3 message: database is locked in "SELECT domain, CASE WHEN substr(domain, 1, 1) = '*' THEN '*' || substr(:input, - length(domain) + 1) ELSE :input END matcher FROM domain_audit WHERE matcher = domain;" (5) [2024-03-29 16:43:01.981 226/T269] gravityDB_open("SELECT EXISTS(... domain_audit ...)") - SQL error prepare: database is locked [2024-03-29 16:43:01.981 226/T269] check_inaccessible_adlists(): Gravity database not available [2024-03-29 16:43:01.982 226/T269] Blocking status is enabled [2024-03-29 16:44:23.023 226M] Reloading DNS cache [2024-03-29 16:44:23.038 226/T269] Compiled 0 whitelist and 0 blacklist regex filters for 6 clients in 0.2 msec [2024-03-29 16:44:23.038 226/T269] Blocking status is enabled [2024-03-29 17:00:47.877 226M] Resizing "FTL-dns-cache" from 4096 to (512 * 16) == 8192 (/dev/shm: 1.2MB used, 67.1MB total, FTL uses 1.2MB) [2024-03-29 17:59:53.481 226M] INFO: FTL replaced 1 invalid characters with ~ in the query "invalid~ip.2.0.0.192.in-addr.arpa" [2024-03-29 17:59:53.492 226M] INFO: FTL replaced 1 invalid characters with ~ in the query "invalid~ip.2.0.0.192.in-addr.arpa" [2024-03-29 17:59:53.492 226M] Resizing "FTL-dns-cache" from 8192 to (768 * 16) == 12288 (/dev/shm: 1.2MB used, 67.1MB total, FTL uses 1.2MB) [2024-03-29 17:59:53.521 226M] INFO: FTL replaced 1 invalid characters with ~ in the query "invalid~ip.0.1.168.192.in-addr.arpa" [2024-03-29 17:59:53.528 226M] INFO: FTL replaced 1 invalid characters with ~ in the query "invalid~ip.0.1.168.192.in-addr.arpa" [2024-03-29 17:59:53.545 226M] INFO: FTL replaced 1 invalid characters with ~ in the query "invalid~ip.22.5.65.100.in-addr.arpa" [2024-03-29 17:59:53.558 226M] INFO: FTL replaced 1 invalid characters with ~ in the query "invalid~ip.22.5.65.100.in-addr.arpa" [2024-03-29 17:59:53.591 226M] INFO: FTL replaced 1 invalid characters with ~ in the query "invalid~ip.taila8bd9.ts.net" [2024-03-29 17:59:53.593 226M] INFO: FTL replaced 1 invalid characters with ~ in the query "invalid~ip.taila8bd9.ts.net" [2024-03-29 17:59:53.629 226M] INFO: FTL replaced 1 invalid characters with ~ in the query "invalid~ip.hsd1.ma.comcast.net" [2024-03-29 17:59:53.630 226M] INFO: FTL replaced 1 invalid characters with ~ in the query "invalid~ip.hsd1.ma.comcast.net" [2024-03-29 17:59:53.684 226M] INFO: FTL replaced 1 invalid characters with ~ in the query "invalid~ip" [2024-03-29 17:59:53.751 226M] INFO: FTL replaced 1 invalid characters with ~ in the query "invalid~ip" *** [ DIAGNOSING ]: contents of /dev/shm total 1.2M -rw------- 1 pihole pihole 84K Mar 29 18:26 FTL-clients -rw------- 1 pihole pihole 248 Mar 29 16:42 FTL-counters -rw------- 1 pihole pihole 12K Mar 29 16:42 FTL-dns-cache -rw------- 1 pihole pihole 24K Mar 29 17:59 FTL-domains -rw------- 1 pihole pihole 88 Mar 29 16:42 FTL-lock -rw------- 1 pihole pihole 8.0K Mar 29 16:42 FTL-overTime -rw------- 1 pihole pihole 4.0K Mar 29 16:42 FTL-per-client-regex -rw------- 1 pihole pihole 672K Mar 29 18:24 FTL-queries -rw------- 1 pihole pihole 16 Mar 29 16:42 FTL-settings -rw------- 1 pihole pihole 80K Mar 29 16:43 FTL-strings -rw------- 1 pihole pihole 308K Mar 29 16:42 FTL-upstreams *** [ DIAGNOSING ]: contents of /etc -rw-r--r-- 1 root root 37 Mar 29 16:42 /etc/dnsmasq.conf conf-dir=/etc/dnsmasq.d user=pihole -rw-r--r-- 1 root root 62 Mar 29 16:42 /etc/resolv.conf search taila8bd9.ts.net nameserver 127.0.0.11 options ndots:0 *** [ DIAGNOSING ]: Pi-hole diagnosis messages *** [ DIAGNOSING ]: Locale LANG= *** [ DIAGNOSING ]: Pi-hole log -rw-r--r-- 1 pihole pihole 960K Mar 29 18:26 /var/log/pihole/pihole.log -----head of pihole.log------ Mar 29 15:50:57 dnsmasq[267]: started, version pi-hole-v2.90+1 cachesize 10000 Mar 29 15:50:57 dnsmasq[267]: compile time options: IPv6 GNU-getopt no-DBus no-UBus no-i18n IDN DHCP DHCPv6 Lua TFTP no-conntrack ipset no-nftset auth cryptohash DNSSEC loop-detect inotify dumpfile Mar 29 15:50:57 dnsmasq[267]: using nameserver 8.8.8.8#53 Mar 29 15:50:57 dnsmasq[267]: using nameserver 8.8.4.4#53 Mar 29 15:50:57 dnsmasq[267]: using only locally-known addresses for onion Mar 29 15:50:57 dnsmasq[267]: using only locally-known addresses for bind Mar 29 15:50:57 dnsmasq[267]: using only locally-known addresses for invalid Mar 29 15:50:57 dnsmasq[267]: using only locally-known addresses for localhost Mar 29 15:50:57 dnsmasq[267]: using only locally-known addresses for test Mar 29 15:50:57 dnsmasq[267]: read /etc/hosts - 9 names Mar 29 15:50:57 dnsmasq[267]: read /etc/pihole/custom.list - 2 names Mar 29 15:50:57 dnsmasq[267]: read /etc/pihole/local.list - 0 names Mar 29 15:50:57 dnsmasq[267]: query[A] raw.githubusercontent.com from 127.0.0.1 Mar 29 15:50:59 dnsmasq[267]: query[PTR] 105.1.168.192.in-addr.arpa from 127.0.0.1 Mar 29 15:51:01 dnsmasq[267]: query[A] raw.githubusercontent.com from 127.0.0.1 Mar 29 15:51:01 dnsmasq[267]: query[AAAA] raw.githubusercontent.com from 127.0.0.1 Mar 29 15:51:04 dnsmasq[267]: query[PTR] 105.1.168.192.in-addr.arpa from 127.0.0.1 Mar 29 15:51:06 dnsmasq[267]: query[A] adaway.org from 127.0.0.1 Mar 29 15:51:09 dnsmasq[267]: query[PTR] 105.1.168.192.in-addr.arpa from 127.0.0.1 Mar 29 15:51:10 dnsmasq[267]: query[AAAA] adaway.org from 127.0.0.1 -----tail of pihole.log------ Mar 29 18:26:05 dnsmasq[226]: reply update.googleapis.com is 142.250.80.35 Mar 29 18:26:05 dnsmasq[226]: reply update.googleapis.com is 2607:f8b0:4006:80e::2003 Mar 29 18:26:08 dnsmasq[226]: query[A] spclient.wg.spotify.com from 192.168.1.104 Mar 29 18:26:08 dnsmasq[226]: forwarded spclient.wg.spotify.com to 8.8.8.8 Mar 29 18:26:08 dnsmasq[226]: query[AAAA] spclient.wg.spotify.com from 192.168.1.104 Mar 29 18:26:08 dnsmasq[226]: forwarded spclient.wg.spotify.com to 8.8.8.8 Mar 29 18:26:08 dnsmasq[226]: reply spclient.wg.spotify.com is Mar 29 18:26:08 dnsmasq[226]: reply edge-web.dual-gslb.spotify.com is 35.186.224.25 Mar 29 18:26:08 dnsmasq[226]: reply spclient.wg.spotify.com is Mar 29 18:26:08 dnsmasq[226]: reply edge-web.dual-gslb.spotify.com is 2600:1901:1:c36:: Mar 29 18:26:17 dnsmasq[226]: query[A] ns1.pi-hole.net from 127.0.0.1 Mar 29 18:26:17 dnsmasq[226]: forwarded ns1.pi-hole.net to 8.8.8.8 Mar 29 18:26:17 dnsmasq[226]: reply ns1.pi-hole.net is 205.251.193.151 Mar 29 18:26:17 dnsmasq[226]: query[A] afront.io from 127.0.0.1 Mar 29 18:26:17 dnsmasq[226]: gravity blocked afront.io is 0.0.0.0 Mar 29 18:26:17 dnsmasq[226]: query[A] afront.io from 192.168.1.99 Mar 29 18:26:17 dnsmasq[226]: gravity blocked afront.io is 0.0.0.0 Mar 29 18:26:22 dnsmasq[226]: query[AAAA] star.fallback.c10r.facebook.com from 192.168.1.104 Mar 29 18:26:22 dnsmasq[226]: forwarded star.fallback.c10r.facebook.com to 8.8.8.8 Mar 29 18:26:22 dnsmasq[226]: reply star.fallback.c10r.facebook.com is 2a03:2880:f012:100:face:b00c:0:2 ******************************************** ******************************************** [✓] ** FINISHED DEBUGGING! ** * The debug log can be uploaded to tricorder.pi-hole.net for sharing with developers only. * A local copy of the debug log can be found at: /var/log/pihole/pihole_debug.log