Hey yubi,
vielen Dank für den Hinweis.
Nach dem ich recreate ausgeführt habe, sah es zunächst ganz gut aus. Der Fehler war im *.log größtenteils behoben. Nach einem Neustart des System wurde mir nun aber der DNS als "not running" angezeigt. Im Reiter settings erfolgt die Anzeige:
There was a problem applying your settings.
Debugging information:
PHP error (2): fsockopen(): unable to connect to 127.0.0.1:4711 (Connection refused) in /var/www/html/admin/scripts/pi-hole/php/FTL.php:43
Ich konnte auch nicht mehr online mit meinen IPv4 Geräten und musste in der fritte wieder den dns auf xxx.xxx.xxx.1 umstellen. IPv6 konnte ich lassen. Mit dem Handy gings.
Das neue *.log kann ich nicht hochladen.. fehler: "Error message: curl: (6) Could not resolve host: tricorder.pi-hole.net"
Deswegen hier:
This process collects information from your Pi-hole, and optionally uploads it to a unique and random directory on tricorder.pi-hole.net.
The intent of this script is to allow users to self-diagnose their installations. This is accomplished by running tests against our software and providing the user with links to FAQ articles when a problem is detected. Since we are a small team and Pi-hole has been growing steadily, it is our hope that this will help us spend more time on development.
NOTE: All log files auto-delete after 48 hours and ONLY the Pi-hole developers can access your data via the given token. We have taken these extra steps to secure your data and will work to further reduce any personal information gathered.
*** [ INITIALIZING ]
[i] 2022-05-26:22:07:58 debug log has been initialized.
[i] System has been running for 0 days, 2 hours, 55 minutes
*** [ INITIALIZING ] Sourcing setup variables
[i] Sourcing /etc/pihole/setupVars.conf...
*** [ DIAGNOSING ]: Core version
[i] Core: v5.10 (https://discourse.pi-hole.net/t/how-do-i-update-pi-hole/249)
[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.10-0-g853f6b7
*** [ DIAGNOSING ]: Web version
[i] Web: v5.12 (https://discourse.pi-hole.net/t/how-do-i-update-pi-hole/249)
[i] Remotes: origin https://github.com/pi-hole/AdminLTE.git (fetch)
origin https://github.com/pi-hole/AdminLTE.git (push)
[i] Branch: master
[i] Commit: v5.12-0-g6c320a4
*** [ DIAGNOSING ]: FTL version
[✓] FTL: v5.15 (https://discourse.pi-hole.net/t/how-do-i-update-pi-hole/249)
*** [ DIAGNOSING ]: lighttpd version
[i] 1.4.35
*** [ DIAGNOSING ]: php version
[i] 7.0.33
*** [ DIAGNOSING ]: Operating system
[i] dig return code: 10
[i] dig response: dig: couldn't get address for 'ns1.pi-hole.net': failure
[✗] Distro: Ubuntu
[✗] Error: Ubuntu is not a supported distro (https://docs.pi-hole.net/main/prerequisites/)
*** [ DIAGNOSING ]: SELinux
[i] SELinux not detected
*** [ DIAGNOSING ]: FirewallD
[i] Firewalld service inactive
*** [ DIAGNOSING ]: Processor
[✓] armv7l
*** [ DIAGNOSING ]: Disk usage
Filesystem Size Used Avail Use% Mounted on
udev 369M 0 369M 0% /dev
tmpfs 100M 5.0M 95M 5% /run
/dev/mmcblk0p2 6.7G 5.1G 1.3G 81% /
tmpfs 500M 304K 500M 1% /dev/shm
tmpfs 5.0M 4.0K 5.0M 1% /run/lock
tmpfs 500M 0 500M 0% /sys/fs/cgroup
tmpfs 100M 28K 100M 1% /run/user/1000
/dev/mmcblk0p1 253M 41M 212M 17% /media/pi/BPI-BOOT
*** [ DIAGNOSING ]: Network interfaces and addresses
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default
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
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: dummy0: <BROADCAST,NOARP> mtu 1500 qdisc noop state DOWN group default
link/ether 8a:09:4b:20:c8:ec brd ff:ff:ff:ff:ff:ff
3: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
link/ether 4e:6a:f4:a8:4f:fb brd ff:ff:ff:ff:ff:ff
inet 192.168.178.28/24 brd 192.168.178.255 scope global dynamic eth0
valid_lft 853457sec preferred_lft 853457sec
inet6 fe80::4c6a:f4ff:fea8:4ffb/64 scope link
valid_lft forever preferred_lft forever
4: tunl0: <NOARP> mtu 0 qdisc noop state DOWN group default
link/ipip 0.0.0.0 brd 0.0.0.0
5: sit0: <NOARP> mtu 1480 qdisc noop state DOWN group default
link/sit 0.0.0.0 brd 0.0.0.0
*** [ DIAGNOSING ]: Network routing table
default via 192.168.178.1 dev eth0 proto static metric 100
169.254.0.0/16 dev eth0 scope link metric 1000
192.168.178.0/24 dev eth0 proto kernel scope link src 192.168.178.28 metric 100
*** [ DIAGNOSING ]: Networking
[✓] IPv4 address(es) bound to the eth0 interface:
192.168.178.28/24
[✓] IPv6 address(es) bound to the eth0 interface:
fe80::4c6a:f4ff:fea8:4ffb/64
[i] Default IPv4 gateway: 192.168.178.1
* Pinging 192.168.178.1...
[✓] Gateway responded.
[i] Default IPv6 gateway: fe80::3631:c4ff:fe81:890f
* Pinging fe80::3631:c4ff:fe81:890f...
[✓] Gateway responded.
*** [ DIAGNOSING ]: Ports in use
*** [ DIAGNOSING ]: Name resolution (IPv4) using a random blocked domain and a known ad-serving domain
[✗] Failed to resolve cueohf.forumieren.de on lo (127.0.0.1)
[✗] Failed to resolve cueohf.forumieren.de on eth0 (192.168.178.28)
[✓] doubleclick.com is 142.250.181.206 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
[✗] Failed to resolve hv.adingo.jp on lo (::1)
[✗] Failed to resolve hv.adingo.jp on eth0 (fe80::4c6a:f4ff:fea8:4ffb)
[✗] 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
WARN: Could not sendto() in send_dhcp_discover() (/__w/FTL/FTL/src/dhcp-discover.c:233): Network is unreachable
WARN: Could not sendto() in send_dhcp_discover() (/__w/FTL/FTL/src/dhcp-discover.c:233): Network is unreachable
WARN: Could not sendto() in send_dhcp_discover() (/__w/FTL/FTL/src/dhcp-discover.c:233): Network is unreachable
* Received 548 bytes from eth0:192.168.178.1
Offered IP address: 192.168.178.28
Server IP address: 192.168.178.1
Relay-agent IP address: N/A
BOOTP server: (empty)
BOOTP file: (empty)
DHCP options:
Message type: DHCPOFFER (2)
server-identifier: 192.168.178.1
lease-time: 864000 ( 10d )
renewal-time: 432000 ( 5d )
rebinding-time: 756000 ( 8d 18h )
netmask: 255.255.255.0
router: 192.168.178.1
dns-server: 192.168.178.1
domain-name: "fritz.box"
broadcast: 192.168.178.255
ntp-server: 192.168.178.1
Port Control Protocol (PCP) server: 192.168.178.1
DHCP packets received on interface dummy0: 0
DHCP packets received on interface sit0: 0
DHCP packets received on interface eth0: 1
DHCP packets received on interface tunl0: 0
DHCP packets received on interface lo: 0
*** [ DIAGNOSING ]: Pi-hole processes
[✓] lighttpd daemon is active
[✗] pihole-FTL daemon is inactive
*** [ DIAGNOSING ]: Pi-hole-FTL full status
● pihole-FTL.service - LSB: pihole-FTL daemon
Loaded: loaded (/etc/init.d/pihole-FTL; bad; vendor preset: enabled)
Active: inactive (dead)
Docs: man:systemd-sysv-generator(8)
*** [ DIAGNOSING ]: Setup variables
PIHOLE_INTERFACE=eth0
IPV4_ADDRESS=192.168.178.28/24
IPV6_ADDRESS=
QUERY_LOGGING=true
INSTALL_WEB_SERVER=true
INSTALL_WEB_INTERFACE=true
LIGHTTPD_ENABLED=true
CACHE_SIZE=10000
DNS_FQDN_REQUIRED=true
DNS_BOGUS_PRIV=true
DNSMASQ_LISTENING=local
DNSSEC=false
REV_SERVER=false
BLOCKING_ENABLED=true
PIHOLE_DNS_1=1.1.1.1
PIHOLE_DNS_2=1.0.0.1
PIHOLE_DNS_3=2606:4700:4700::1111
PIHOLE_DNS_4=2606:4700:4700::1001
*** [ DIAGNOSING ]: Dashboard and block page
[✗] Block page X-Header: X-Header does not match or could not be retrieved.
HTTP/1.1 200 OK
Expires: Thu, 26 May 2022 14:08:43 GMT
Cache-Control: max-age=0, max-age=0
Content-type: text/html; charset=UTF-8
Date: Thu, 26 May 2022 14:08:43 GMT
Server: lighttpd/1.4.35
[✓] Web interface X-Header: X-Pi-hole: The Pi-hole Web interface is working!
*** [ DIAGNOSING ]: Gravity Database
-rw-rw-r-- 1 pihole pihole 9.5M May 26 16:34 /etc/pihole/gravity.db
*** [ DIAGNOSING ]: Info table
property value
-------------------- ----------------------------------------
version 15
updated 1653554069
gravity_count 143018
Last gravity run finished at: Thu May 26 16:34:29 CST 2022
----- First 10 Gravity Domains -----
localhost.localdomain
wizhumpgyros.com
coccyxwickimp.com
webmail-who-int.000webhostapp.com
010sec.com
01mspmd5yalky8.com
0byv9mgbn0.com
ns6.0pendns.org
dns.0pengl.com
12724.xyz
*** [ DIAGNOSING ]: Groups
id enabled name date_added date_modified description
---- ------- -------------------------------------------------- ------------------- ------------------- --------------------------------------------------
0 1 Default 2022-05-26 16:34:15 2022-05-26 16:34:15 The default group
*** [ DIAGNOSING ]: Domainlist (0/1 = exact white-/blacklist, 2/3 = regex white-/blacklist)
*** [ 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 2022-05-26 16:34:15 2022-05-26 16:34:15 Migrated from /etc/pihole/adlists.list
*** [ DIAGNOSING ]: contents of /etc/pihole
-rw-r--r-- 1 root root 0 May 22 18:14 /etc/pihole/custom.list
-rw-r--r-- 1 root root 65 May 26 16:34 /etc/pihole/local.list
-rw-r--r-- 1 root root 238 May 22 18:14 /etc/pihole/logrotate
/var/log/pihole.log {
su root syslog
daily
copytruncate
rotate 5
compress
delaycompress
notifempty
nomail
}
/var/log/pihole-FTL.log {
su root syslog
weekly
copytruncate
rotate 3
compress
delaycompress
notifempty
nomail
}
-rw-rw-r-- 1 pihole root 146 May 22 19:36 /etc/pihole/pihole-FTL.conf
PRIVACYLEVEL=0
RATE_LIMIT=1000/60
*** [ DIAGNOSING ]: contents of /etc/dnsmasq.d
-rw-r--r-- 1 root root 1.4K May 22 19:36 /etc/dnsmasq.d/01-pihole.conf
addn-hosts=/etc/pihole/local.list
addn-hosts=/etc/pihole/custom.list
localise-queries
no-resolv
cache-size=10000
log-queries
log-facility=/var/log/pihole.log
log-async
server=1.1.1.1
server=1.0.0.1
server=2606:4700:4700::1111
server=2606:4700:4700::1001
domain-needed
expand-hosts
bogus-priv
local-service
-rw-r--r-- 1 root root 2.2K May 22 18:14 /etc/dnsmasq.d/06-rfc6761.conf
server=/test/
server=/localhost/
server=/invalid/
server=/bind/
server=/onion/
-rw-r--r-- 1 root root 202 Apr 16 2016 /etc/dnsmasq.d/network-manager
bind-interfaces
*** [ DIAGNOSING ]: contents of /etc/lighttpd
-rw-r--r-- 1 root root 0 May 22 18:14 /etc/lighttpd/external.conf
-rw-r--r-- 1 root root 3.9K May 22 18:14 /etc/lighttpd/lighttpd.conf
server.modules = (
"mod_access",
"mod_accesslog",
"mod_auth",
"mod_expire",
"mod_redirect",
"mod_setenv",
"mod_rewrite"
)
server.document-root = "/var/www/html"
server.error-handler-404 = "/pihole/index.php"
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
accesslog.filename = "/var/log/lighttpd/access.log"
accesslog.format = "%{%s}t|%V|%r|%s|%b"
server.stream-response-body = 1
index-file.names = ( "index.php", "index.html", "index.lighttpd.html" )
url.access-deny = ( "~", ".inc", ".md", ".yml", ".ini" )
static-file.exclude-extensions = ( ".php", ".pl", ".fcgi" )
mimetype.assign = (
".ico" => "image/x-icon",
".jpeg" => "image/jpeg",
".jpg" => "image/jpeg",
".png" => "image/png",
".svg" => "image/svg+xml",
".css" => "text/css; charset=utf-8",
".html" => "text/html; charset=utf-8",
".js" => "text/javascript; charset=utf-8",
".json" => "application/json; charset=utf-8",
".map" => "application/json; charset=utf-8",
".txt" => "text/plain; charset=utf-8",
".eot" => "application/vnd.ms-fontobject",
".otf" => "font/otf",
".ttc" => "font/collection",
".ttf" => "font/ttf",
".woff" => "font/woff",
".woff2" => "font/woff2"
)
include_shell "cat external.conf 2>/dev/null"
include_shell "/usr/share/lighttpd/use-ipv6.pl " + server.port
include_shell "find /etc/lighttpd/conf-enabled -name '*.conf' -a ! -name 'letsencrypt.conf' -printf 'include \"%p\"
' 2>/dev/null"
$HTTP["url"] =~ "^/admin/" {
setenv.add-response-header = (
"X-Pi-hole" => "The Pi-hole Web interface is working!",
"X-Frame-Options" => "DENY"
)
}
$HTTP["url"] =~ "^/admin/\.(.*)" {
url.access-deny = ("")
}
$HTTP["url"] =~ "/(teleporter|api_token)\.php$" {
$HTTP["referer"] =~ "/admin/settings\.php" {
setenv.add-response-header = ( "X-Frame-Options" => "SAMEORIGIN" )
}
}
expire.url = ( "" => "access plus 0 seconds" )
*** [ DIAGNOSING ]: contents of /etc/cron.d
-rw-r--r-- 1 root root 1.8K May 22 18:14 /etc/cron.d/pihole
24 4 * * 7 root PATH="$PATH:/usr/sbin:/usr/local/bin/" pihole updateGravity >/var/log/pihole_updateGravity.log || cat /var/log/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
*/10 * * * * root PATH="$PATH:/usr/sbin:/usr/local/bin/" pihole updatechecker local
51 19 * * * root PATH="$PATH:/usr/sbin:/usr/local/bin/" pihole updatechecker remote
@reboot root PATH="$PATH:/usr/sbin:/usr/local/bin/" pihole updatechecker remote reboot
*** [ DIAGNOSING ]: contents of /var/log/lighttpd
-rw-r--r-- 1 www-data www-data 526K May 26 19:12 /var/log/lighttpd/error.log
-----head of error.log------
2022-05-22 18:32:29: (log.c.164) server started
2022-05-22 18:32:29: (server.c.1045) WARNING: unknown config-key: server.stream-response-body (ignored)
2022-05-22 19:09:50: (server.c.1558) server stopped by UID = 0 PID = 1
2022-05-22 19:09:59: (log.c.164) server started
2022-05-22 19:09:59: (server.c.1045) WARNING: unknown config-key: server.stream-response-body (ignored)
2022-05-22 20:22:33: (server.c.1558) server stopped by UID = 0 PID = 1
2022-05-22 20:22:42: (log.c.164) server started
2022-05-22 20:22:42: (server.c.1045) WARNING: unknown config-key: server.stream-response-body (ignored)
2022-05-22 20:33:06: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Warning: SQLite3::querySingle(): Unable to prepare statement: 1, no such table: info in /var/www/html/admin/scripts/pi-hole/php/gravity.php on line 14
2022-05-22 20:33:06: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Warning: SQLite3::querySingle(): Unable to prepare statement: 1, no such table: info in /var/www/html/admin/scripts/pi-hole/php/gravity.php on line 14
2022-05-22 20:45:33: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Warning: SQLite3::querySingle(): Unable to prepare statement: 1, no such table: info in /var/www/html/admin/scripts/pi-hole/php/gravity.php on line 14
2022-05-22 20:45:41: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Warning: SQLite3::querySingle(): Unable to prepare statement: 1, no such table: info in /var/www/html/admin/scripts/pi-hole/php/gravity.php on line 14
2022-05-22 20:45:55: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Warning: SQLite3::querySingle(): Unable to prepare statement: 1, no such table: info in /var/www/html/admin/scripts/pi-hole/php/gravity.php on line 14
2022-05-22 21:16:04: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Warning: SQLite3::querySingle(): Unable to prepare statement: 1, no such table: info in /var/www/html/admin/scripts/pi-hole/php/gravity.php on line 14
2022-05-22 21:16:04: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Warning: SQLite3::querySingle(): Unable to prepare statement: 1, no such table: info in /var/www/html/admin/scripts/pi-hole/php/gravity.php on line 14
2022-05-22 21:16:04: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Warning: SQLite3::querySingle(): Unable to prepare statement: 1, no such table: info in /var/www/html/admin/scripts/pi-hole/php/gravity.php on line 14
2022-05-22 21:16:04: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Warning: SQLite3::querySingle(): Unable to prepare statement: 1, no such table: info in /var/www/html/admin/scripts/pi-hole/php/gravity.php on line 14
2022-05-22 21:16:06: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Warning: SQLite3::querySingle(): Unable to prepare statement: 1, no such table: info in /var/www/html/admin/scripts/pi-hole/php/gravity.php on line 14
2022-05-22 21:16:07: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Warning: SQLite3::querySingle(): Unable to prepare statement: 1, no such table: info in /var/www/html/admin/scripts/pi-hole/php/gravity.php on line 14
2022-05-22 21:16:08: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Warning: SQLite3::querySingle(): Unable to prepare statement: 1, no such table: info in /var/www/html/admin/scripts/pi-hole/php/gravity.php on line 14
2022-05-22 21:16:09: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Warning: SQLite3::querySingle(): Unable to prepare statement: 1, no such table: info in /var/www/html/admin/scripts/pi-hole/php/gravity.php on line 14
2022-05-22 21:16:10: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Warning: SQLite3::querySingle(): Unable to prepare statement: 1, no such table: info in /var/www/html/admin/scripts/pi-hole/php/gravity.php on line 14
2022-05-22 21:16:11: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Warning: SQLite3::querySingle(): Unable to prepare statement: 1, no such table: info in /var/www/html/admin/scripts/pi-hole/php/gravity.php on line 14
2022-05-22 21:16:12: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Warning: SQLite3::querySingle(): Unable to prepare statement: 1, no such table: info in /var/www/html/admin/scripts/pi-hole/php/gravity.php on line 14
2022-05-22 21:16:13: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Warning: SQLite3::querySingle(): Unable to prepare statement: 1, no such table: info in /var/www/html/admin/scripts/pi-hole/php/gravity.php on line 14
-----tail of error.log------
2022-05-26 14:24:09: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Warning: SQLite3::querySingle(): Unable to prepare statement: 1, no such table: info in /var/www/html/admin/scripts/pi-hole/php/gravity.php on line 14
2022-05-26 14:24:09: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Warning: SQLite3::querySingle(): Unable to prepare statement: 1, no such table: info in /var/www/html/admin/scripts/pi-hole/php/gravity.php on line 14
2022-05-26 14:24:47: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Warning: SQLite3::querySingle(): Unable to prepare statement: 1, no such table: info in /var/www/html/admin/scripts/pi-hole/php/gravity.php on line 14
2022-05-26 14:24:47: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Warning: SQLite3::querySingle(): Unable to prepare statement: 1, no such table: info in /var/www/html/admin/scripts/pi-hole/php/gravity.php on line 14
2022-05-26 14:25:20: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Warning: SQLite3::querySingle(): Unable to prepare statement: 1, no such table: info in /var/www/html/admin/scripts/pi-hole/php/gravity.php on line 14
2022-05-26 14:25:20: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Warning: SQLite3::querySingle(): Unable to prepare statement: 1, no such table: info in /var/www/html/admin/scripts/pi-hole/php/gravity.php on line 14
2022-05-26 14:25:41: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Warning: SQLite3::querySingle(): Unable to prepare statement: 1, no such table: info in /var/www/html/admin/scripts/pi-hole/php/gravity.php on line 14
2022-05-26 14:25:41: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Warning: SQLite3::querySingle(): Unable to prepare statement: 1, no such table: info in /var/www/html/admin/scripts/pi-hole/php/gravity.php on line 14
2022-05-26 14:27:09: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Warning: SQLite3::querySingle(): Unable to prepare statement: 1, no such table: info in /var/www/html/admin/scripts/pi-hole/php/gravity.php on line 14
2022-05-26 14:27:09: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Warning: SQLite3::querySingle(): Unable to prepare statement: 1, no such table: info in /var/www/html/admin/scripts/pi-hole/php/gravity.php on line 14
2022-05-26 16:39:11: (server.c.1558) server stopped by UID = 0 PID = 1
2022-05-26 16:39:19: (log.c.164) server started
2022-05-26 16:39:19: (server.c.1045) WARNING: unknown config-key: server.stream-response-body (ignored)
2022-05-26 16:40:10: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Notice: Undefined offset: 1 in /var/www/html/admin/scripts/pi-hole/php/update_checker.php on line 57
2022-05-26 16:40:10: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Notice: Undefined offset: 2 in /var/www/html/admin/scripts/pi-hole/php/update_checker.php on line 58
2022-05-26 18:44:21: (server.c.1558) server stopped by UID = 0 PID = 1
2022-05-26 18:44:30: (log.c.164) server started
2022-05-26 18:44:30: (server.c.1045) WARNING: unknown config-key: server.stream-response-body (ignored)
2022-05-26 18:45:30: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Notice: Undefined offset: 1 in /var/www/html/admin/scripts/pi-hole/php/update_checker.php on line 57
2022-05-26 18:45:30: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Notice: Undefined offset: 2 in /var/www/html/admin/scripts/pi-hole/php/update_checker.php on line 58
2022-05-26 18:45:51: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Notice: Undefined offset: 2 in /var/www/html/admin/scripts/pi-hole/php/update_checker.php on line 58
2022-05-26 18:45:54: (mod_fastcgi.c.2702) FastCGI-stderr: PHP Notice: Undefined offset: 2 in /var/www/html/admin/scripts/pi-hole/php/update_checker.php on line 58
2022-05-26 19:12:20: (server.c.1558) server stopped by UID = 0 PID = 1
2022-05-26 19:12:28: (log.c.164) server started
2022-05-26 19:12:28: (server.c.1045) WARNING: unknown config-key: server.stream-response-body (ignored)
*** [ DIAGNOSING ]: contents of /var/log
-rw-r--r-- 1 pihole pihole 14K May 26 18:44 /var/log/pihole-FTL.log
-----head of pihole-FTL.log------
[2022-05-26 00:17:52.997 13222M] Resizing "FTL-dns-cache" from 172032 to (11008 * 16) == 176128 (/dev/shm: 2.6MB used, 523.6MB total, FTL uses 2.4MB)
[2022-05-26 00:36:38.557 11592/F13222] SQLite3 message: no such table: domain_audit in "SELECT EXISTS(SELECT domain, CASE WHEN substr(domain, 1, 1) = '*' THEN '*' || substr(:input, - length(domain) + 1) ELSE :input END matcher FROM domain_audit WHERE matcher = doma (1)
[2022-05-26 00:36:38.558 11592/F13222] gravityDB_open("SELECT EXISTS(... domain_audit ...)") - SQL error prepare: SQL logic error
[2022-05-26 00:37:43.711 11967/F13222] SQLite3 message: no such table: domain_audit in "SELECT EXISTS(SELECT domain, CASE WHEN substr(domain, 1, 1) = '*' THEN '*' || substr(:input, - length(domain) + 1) ELSE :input END matcher FROM domain_audit WHERE matcher = doma (1)
[2022-05-26 00:37:43.712 11967/F13222] gravityDB_open("SELECT EXISTS(... domain_audit ...)") - SQL error prepare: SQL logic error
[2022-05-26 00:44:57.716 14702/F13222] SQLite3 message: no such table: domain_audit in "SELECT EXISTS(SELECT domain, CASE WHEN substr(domain, 1, 1) = '*' THEN '*' || substr(:input, - length(domain) + 1) ELSE :input END matcher FROM domain_audit WHERE matcher = doma (1)
[2022-05-26 00:44:57.717 14702/F13222] gravityDB_open("SELECT EXISTS(... domain_audit ...)") - SQL error prepare: SQL logic error
[2022-05-26 04:25:47.791 28764/F13222] SQLite3 message: no such table: domain_audit in "SELECT EXISTS(SELECT domain, CASE WHEN substr(domain, 1, 1) = '*' THEN '*' || substr(:input, - length(domain) + 1) ELSE :input END matcher FROM domain_audit WHERE matcher = doma (1)
[2022-05-26 04:25:47.792 28764/F13222] gravityDB_open("SELECT EXISTS(... domain_audit ...)") - SQL error prepare: SQL logic error
[2022-05-26 04:40:05.046 1598/F13222] SQLite3 message: no such table: domain_audit in "SELECT EXISTS(SELECT domain, CASE WHEN substr(domain, 1, 1) = '*' THEN '*' || substr(:input, - length(domain) + 1) ELSE :input END matcher FROM domain_audit WHERE matcher = doma (1)
[2022-05-26 04:40:05.047 1598/F13222] gravityDB_open("SELECT EXISTS(... domain_audit ...)") - SQL error prepare: SQL logic error
[2022-05-26 04:58:57.559 13222M] Resizing "FTL-dns-cache" from 176128 to (11264 * 16) == 180224 (/dev/shm: 2.6MB used, 523.6MB total, FTL uses 2.4MB)
[2022-05-26 06:05:57.018 337/F13222] SQLite3 message: no such table: domain_audit in "SELECT EXISTS(SELECT domain, CASE WHEN substr(domain, 1, 1) = '*' THEN '*' || substr(:input, - length(domain) + 1) ELSE :input END matcher FROM domain_audit WHERE matcher = doma (1)
[2022-05-26 06:05:57.019 337/F13222] gravityDB_open("SELECT EXISTS(... domain_audit ...)") - SQL error prepare: SQL logic error
[2022-05-26 08:03:35.424 10294/F13222] SQLite3 message: no such table: domain_audit in "SELECT EXISTS(SELECT domain, CASE WHEN substr(domain, 1, 1) = '*' THEN '*' || substr(:input, - length(domain) + 1) ELSE :input END matcher FROM domain_audit WHERE matcher = doma (1)
[2022-05-26 08:03:35.424 10294/F13222] gravityDB_open("SELECT EXISTS(... domain_audit ...)") - SQL error prepare: SQL logic error
[2022-05-26 09:05:00.370 31938/F13222] SQLite3 message: no such table: domain_audit in "SELECT EXISTS(SELECT domain, CASE WHEN substr(domain, 1, 1) = '*' THEN '*' || substr(:input, - length(domain) + 1) ELSE :input END matcher FROM domain_audit WHERE matcher = doma (1)
[2022-05-26 09:05:00.371 31938/F13222] gravityDB_open("SELECT EXISTS(... domain_audit ...)") - SQL error prepare: SQL logic error
[2022-05-26 10:33:17.794 30792/F13222] SQLite3 message: no such table: domain_audit in "SELECT EXISTS(SELECT domain, CASE WHEN substr(domain, 1, 1) = '*' THEN '*' || substr(:input, - length(domain) + 1) ELSE :input END matcher FROM domain_audit WHERE matcher = doma (1)
[2022-05-26 10:33:17.795 30792/F13222] gravityDB_open("SELECT EXISTS(... domain_audit ...)") - SQL error prepare: SQL logic error
[2022-05-26 10:59:06.375 7714/F13222] SQLite3 message: no such table: domain_audit in "SELECT EXISTS(SELECT domain, CASE WHEN substr(domain, 1, 1) = '*' THEN '*' || substr(:input, - length(domain) + 1) ELSE :input END matcher FROM domain_audit WHERE matcher = doma (1)
[2022-05-26 10:59:06.376 7714/F13222] gravityDB_open("SELECT EXISTS(... domain_audit ...)") - SQL error prepare: SQL logic error
[2022-05-26 16:33:37.121 13222M] Resizing "FTL-dns-cache" from 180224 to (11520 * 16) == 184320 (/dev/shm: 2.6MB used, 523.6MB total, FTL uses 2.4MB)
[2022-05-26 16:34:32.122 13222M] Reloading DNS cache
[2022-05-26 16:34:32.207 13222/T13226] Compiled 0 whitelist and 0 blacklist regex filters for 29 clients in 1.1 msec
[2022-05-26 16:34:32.209 13222/T13226] Blocking status is enabled
[2022-05-26 16:39:10.760 13222M] Shutting down...
[2022-05-26 16:39:11.045 13222M] Finished final database update (stored 11 queries)
[2022-05-26 16:39:11.045 13222M] Waiting for threads to join
[2022-05-26 16:39:11.045 13222M] Thread telnet-IPv4 (0) is idle, terminating it.
[2022-05-26 16:39:11.046 13222M] Thread telnet-IPv6 (1) is idle, terminating it.
[2022-05-26 16:39:11.046 13222M] Thread telnet-socket (2) is idle, terminating it.
[2022-05-26 16:39:11.046 13222M] Thread database (3) is idle, terminating it.
[2022-05-26 16:39:11.047 13222M] Thread housekeeper (4) is idle, terminating it.
[2022-05-26 16:39:11.047 13222M] Thread DNS client (5) is idle, terminating it.
-----tail of pihole-FTL.log------
[2022-05-26 18:43:36.733 17147M] -> Unique domains: 786
[2022-05-26 18:43:36.733 17147M] -> Unique clients: 25
[2022-05-26 18:43:36.733 17147M] -> Known forward destinations: 2
[2022-05-26 18:43:36.734 17147M] Successfully accessed setupVars.conf
[2022-05-26 18:43:36.736 17147M] listening on 192.168.178.28 port 53
[2022-05-26 18:43:36.736 17147M] listening on eth0(#3): 192.168.178.28 port 53
[2022-05-26 18:43:36.737 17147M] listening on 127.0.0.1 port 53
[2022-05-26 18:43:36.737 17147M] listening on lo(#1): 127.0.0.1 port 53
[2022-05-26 18:43:36.737 17147M] listening on fe80::4c6a:f4ff:fea8:4ffb%eth0 port 53
[2022-05-26 18:43:36.738 17147M] listening on eth0(#3): fe80::4c6a:f4ff:fea8:4ffb%eth0 port 53
[2022-05-26 18:43:36.738 17147M] listening on ::1 port 53
[2022-05-26 18:43:36.738 17147M] listening on lo(#1): ::1 port 53
[2022-05-26 18:43:36.743 17149M] PID of FTL process: 17149
[2022-05-26 18:43:36.744 17149/T17150] Listening on port 4711 for incoming IPv4 telnet connections
[2022-05-26 18:43:36.746 17149/T17151] Listening on port 4711 for incoming IPv6 telnet connections
[2022-05-26 18:43:36.746 17149/T17152] Listening on Unix socket
[2022-05-26 18:43:36.747 17149M] INFO: FTL is running as user pihole (UID 999)
[2022-05-26 18:43:36.748 17149M] Reloading DNS cache
[2022-05-26 18:43:36.853 17149/T17153] Compiled 0 whitelist and 0 blacklist regex filters for 25 clients in 1.4 msec
[2022-05-26 18:43:36.853 17149/T17153] Blocking status is enabled
[2022-05-26 18:43:37.650 17149M] New upstream server: 2606:4700:4700::1111:53 (2/256)
[2022-05-26 18:43:37.651 17149M] New upstream server: 2606:4700:4700::1001:53 (3/256)
[2022-05-26 18:44:21.799 17149M] Shutting down...
[2022-05-26 18:44:22.088 17149M] Finished final database update (stored 8 queries)
[2022-05-26 18:44:22.089 17149M] Waiting for threads to join
[2022-05-26 18:44:22.089 17149M] Thread telnet-IPv4 (0) is idle, terminating it.
[2022-05-26 18:44:22.094 17149M] Thread telnet-IPv6 (1) is idle, terminating it.
[2022-05-26 18:44:22.094 17149M] Thread telnet-socket (2) is idle, terminating it.
[2022-05-26 18:44:22.095 17149M] Thread database (3) is idle, terminating it.
[2022-05-26 18:44:22.095 17149M] Thread housekeeper (4) is idle, terminating it.
[2022-05-26 18:44:22.096 17149M] Thread DNS client (5) is idle, terminating it.
[2022-05-26 18:44:22.097 17149M] All threads joined
[2022-05-26 18:44:22.098 17149M] WARNING: Unable to write used port to file
[2022-05-26 18:44:22.098 17149M] (API might not find the port)
[2022-05-26 18:44:22.100 17149M] ########## FTL terminated after 46s (code 0)! ##########
*** [ DIAGNOSING ]: contents of /dev/shm
-rwx------ 1 pi pi 65M May 26 19:12 /dev/shm/pulse-shm-1479378048
-rwx------ 1 pi pi 65M May 26 19:13 /dev/shm/pulse-shm-3252689837
-rwx------ 1 pi pi 65M May 26 19:12 /dev/shm/pulse-shm-3276010683
-rwx------ 1 pi pi 65M May 26 19:12 /dev/shm/pulse-shm-403178259
-rwx------ 1 pi pi 65M May 26 19:12 /dev/shm/pulse-shm-519944599
-rwx------ 1 pi pi 65M May 26 19:13 /dev/shm/pulse-shm-815209216
*** [ DIAGNOSING ]: contents of /etc
-rw-r--r-- 1 root root 24 May 22 18:14 /etc/dnsmasq.conf
conf-dir=/etc/dnsmasq.d
lrwxrwxrwx 1 root root 29 Apr 21 2016 /etc/resolv.conf -> ../run/resolvconf/resolv.conf
nameserver 127.0.1.1
search fritz.box
*** [ DIAGNOSING ]: Pi-hole diagnosis messages
*** [ DIAGNOSING ]: Locale
LANG=en_US.UTF-8
*** [ DIAGNOSING ]: Pi-hole log
-rw-r--r-- 1 pihole pihole 4.9M May 26 18:44 /var/log/pihole.log
-----head of pihole.log------
May 26 00:00:06 dnsmasq[13222]: query[HTTPS] iphonesubmissions.apple.com from fe80::1407:3e3c:7c3:404
May 26 00:00:06 dnsmasq[13222]: forwarded iphonesubmissions.apple.com to 1.1.1.1
May 26 00:00:06 dnsmasq[13222]: query[AAAA] iphonesubmissions.apple.com from fe80::1407:3e3c:7c3:404
May 26 00:00:06 dnsmasq[13222]: forwarded iphonesubmissions.apple.com to 1.1.1.1
May 26 00:00:06 dnsmasq[13222]: query[A] iphonesubmissions.apple.com from fe80::1407:3e3c:7c3:404
May 26 00:00:06 dnsmasq[13222]: forwarded iphonesubmissions.apple.com to 1.1.1.1
May 26 00:00:06 dnsmasq[13222]: reply iphonesubmissions.apple.com is <CNAME>
May 26 00:00:06 dnsmasq[13222]: reply iphonesubmissions.v.aaplimg.com is NODATA
May 26 00:00:06 dnsmasq[13222]: query[HTTPS] iphonesubmissions.v.aaplimg.com from fe80::1407:3e3c:7c3:404
May 26 00:00:06 dnsmasq[13222]: forwarded iphonesubmissions.v.aaplimg.com to 1.1.1.1
May 26 00:00:06 dnsmasq[13222]: reply iphonesubmissions.apple.com is <CNAME>
May 26 00:00:06 dnsmasq[13222]: reply iphonesubmissions.v.aaplimg.com is NODATA-IPv6
May 26 00:00:06 dnsmasq[13222]: reply iphonesubmissions.apple.com is <CNAME>
May 26 00:00:06 dnsmasq[13222]: reply iphonesubmissions.v.aaplimg.com is 17.137.170.1
May 26 00:00:06 dnsmasq[13222]: query[A] daisy.ubuntu.com from fe80::4c6a:f4ff:fea8:4ffb
May 26 00:00:06 dnsmasq[13222]: cached daisy.ubuntu.com is 185.125.188.136
May 26 00:00:06 dnsmasq[13222]: cached daisy.ubuntu.com is 185.125.188.137
May 26 00:00:06 dnsmasq[13222]: query[AAAA] daisy.ubuntu.com from fe80::4c6a:f4ff:fea8:4ffb
May 26 00:00:06 dnsmasq[13222]: cached daisy.ubuntu.com is NODATA-IPv6
May 26 00:00:06 dnsmasq[13222]: query[AAAA] iphonesubmissions.v.aaplimg.com from fe80::1407:3e3c:7c3:404
-----tail of pihole.log------
May 26 18:44:11 dnsmasq[17149]: reply eu.t100.prod.ter.amazonvideo.com is <CNAME>
May 26 18:44:11 dnsmasq[17149]: reply fra.t100.prod.ter.amazonvideo.com is 3.121.138.154
May 26 18:44:11 dnsmasq[17149]: reply fra.t100.prod.ter.amazonvideo.com is 3.124.127.185
May 26 18:44:11 dnsmasq[17149]: reply fra.t100.prod.ter.amazonvideo.com is 3.124.238.28
May 26 18:44:11 dnsmasq[17149]: query[A] umwatson.events.data.microsoft.com from fe80::e425:58:bc98:5083
May 26 18:44:11 dnsmasq[17149]: cached umwatson.events.data.microsoft.com is <CNAME>
May 26 18:44:11 dnsmasq[17149]: cached blobcollector.events.data.trafficmanager.net is <CNAME>
May 26 18:44:11 dnsmasq[17149]: forwarded umwatson.events.data.microsoft.com to 1.0.0.1
May 26 18:44:11 dnsmasq[17149]: query[AAAA] umwatson.events.data.microsoft.com from fe80::e425:58:bc98:5083
May 26 18:44:11 dnsmasq[17149]: cached umwatson.events.data.microsoft.com is <CNAME>
May 26 18:44:11 dnsmasq[17149]: forwarded umwatson.events.data.microsoft.com to 1.0.0.1
May 26 18:44:11 dnsmasq[17149]: reply umwatson.events.data.microsoft.com is <CNAME>
May 26 18:44:11 dnsmasq[17149]: reply blobcollector.events.data.trafficmanager.net is <CNAME>
May 26 18:44:11 dnsmasq[17149]: reply onedsblobprdcus17.centralus.cloudapp.azure.com is 13.89.179.12
May 26 18:44:11 dnsmasq[17149]: reply umwatson.events.data.microsoft.com is <CNAME>
May 26 18:44:11 dnsmasq[17149]: reply blobcollector.events.data.trafficmanager.net is <CNAME>
May 26 18:44:11 dnsmasq[17149]: reply onedsblobprdeus17.eastus.cloudapp.azure.com is NODATA-IPv6
May 26 18:44:20 dnsmasq[17149]: query[PTR] 46.178.168.192.in-addr.arpa from 192.168.178.46
May 26 18:44:20 dnsmasq[17149]: config 192.168.178.46 is NXDOMAIN
May 26 18:44:21 dnsmasq[17149]: exiting on receipt of SIGTERM
********************************************
********************************************
[✓] ** FINISHED DEBUGGING! **
* The debug log can be uploaded to tricorder.pi-hole.net for sharing with developers only.
[i] Debug script running in automated mode
* Using curl for transmission.
* curl failed, contact Pi-hole support for assistance.
* Error message: curl: (6) Could not resolve host: tricorder.pi-hole.net
[✗] There was an error uploading your debug log.
* Please try again or contact the Pi-hole team for assistance.
* A local copy of the debug log can be found at: /var/log/pihole_debug.log
Danke und schönen Vatertag 
JR
ps. bei mir werden keine ports in use angezeigt ...
[✓] Gateway responded.
*** [ DIAGNOSING ]: Ports in use
*** [ DIAGNOSING ]: Name resolution (IPv4) using a random blocked domain and a known ad-serving domain
Mein 4ér Pi liegt als TVHeaendserver hinter der Fritte