Temporary failure resolving ... still

Help
1

I run Pi-hole in a docker container on a rapsberry pi with a dedicated ip address through macvlan.
The ip address of the Pi-hole is the primary DNS server in my router (FRITZ!Box).

I already found this thread:
https://discourse.pi-hole.net/t/apt-get-update-is-not-working-temporary-failure-resolving-raspbian-raspberrypi-org/70849

I followed the instructions and successfully added two custom dns servers.

my NetworkManager.conf looks like this:
[main]
plugins=ifupdown,keyfile
#Below are added DNS items
dns=1.1.1.1
dns=8.8.8.8

[ifupdown]
managed=false

[device]
wifi.scan-rand-mac-address=no

my resolv.conf looks like this:
search fritz.box
nameserver ip of the Pi-hole

However, I still receive the Temporary failure resolving when running sudo apt update on the pi.

Is there any option for me to further debug my setup?

2

Let's check if your Raspberry Pi is able to use Pi-hole and if it is correctly resolving domains.

From your Raspberry Pi terminal, what is the full output of the 2 commands below?

nslookup google.com
nslookup google.com <ip_of_Pi-hole_container>
3

First & foremost, thanks for the your support - much appreciated.:clap:

dammit ... there seems to be sth. wrong.

both commands lead to no servers reached:

;; communications error to ip address of Pi-hole#53: timed out

Do you have an idea on how to further investigate?

4

Please upload a debug log and post just the token URL that is generated after the log is uploaded by running the following command inside the container:

pihole -d

or do it through the Web interface: Tools > Generate Debug Log

Note:

If your Pi-hole is using a private IP address (and probably this is the case), like 192.168.x.y or 172.x.y.z, you don't need to hide the IP.
IPs in these ranges are local and can't be accessed by someone outside your network.

5

Thanks, I generated the log via the web interface:

https://tricorder.pi-hole.net/COKkp0IC/

There is an error showing up:
[2024-11-27 02:01:00.011 224/T263] SQLite3 message: database corruption at line 71062 of [831d0fb283] (11)
[2024-11-27 02:01:00.011 224/T263] SQLite3 message: statement aborts at 3: [SELECT MAX(ID) FROM queries] database disk image is malformed (11)
[2024-11-27 02:01:00.011 224/T263] Encountered step error in get_max_query_ID(): database disk image is malformed
[2024-11-27 02:01:00.011 224/T263] WARN: Database /etc/pihole/pihole-FTL.db is damaged and cannot be used.

@rdwebdesign Do you have a suggestion on how to fix this?