Hello,
New to Pi-Hole and looking forward to some of the functionality it has to offer. I've installed fresh on a Ubuntu 20.04.02 server running in my ESXi environment and whenever I point my PC, Macbook, etc to this new server DNS resolution slows down dramatically. I previously ran Pi-Hole as a docker pod on my Synology and noticed it also to be slow and read that others experienced this on v5.0 so I just elected to spin up a VM and see how things work on here, but same experience.
-----tail of error.log------
2021-07-20 20:18:31: (server.c.1488) server started (lighttpd/1.4.55)
2021-07-20 20:18:35: (server.c.1970) server stopped by UID = 0 PID = 1
2021-07-20 20:18:35: (server.c.1488) server started (lighttpd/1.4.55)
2021-07-20 20:22:59: (mod_fastcgi.c.421) FastCGI-stderr: PHP Warning: SQLite3::exec(): no such table: blacklist in /var/www/html/admin/scripts/pi-hole/php/teleporter.php on line 90
2021-07-20 20:22:59: (mod_fastcgi.c.421) FastCGI-stderr: PHP Warning: SQLite3::exec(): no such table: regex_blacklist in /var/www/html/admin/scripts/pi-hole/php/teleporter.php on line 90
2021-07-20 20:22:59: (mod_fastcgi.c.421) FastCGI-stderr: PHP Warning: Executing sudo pihole -a addcustomdns 192.168.30.5 <REDACT> failed. in /var/www/html/admin/scripts/pi-hole/php/func.php on line 79
2021-07-20 20:22:59: (mod_fastcgi.c.421) FastCGI-stderr: PHP Warning: SQLite3::exec(): no such table: whitelist in /var/www/html/admin/scripts/pi-hole/php/teleporter.php on line 90
2021-07-20 20:22:59: (mod_fastcgi.c.421) FastCGI-stderr: PHP Warning: SQLite3::exec(): no such table: regex_whitelist in /var/www/html/admin/scripts/pi-hole/php/teleporter.php on line 90
2021-07-20 20:23:59: (server.c.1970) server stopped by UID = 0 PID = 1
2021-07-20 20:24:13: (server.c.1488) server started (lighttpd/1.4.55)
Can you provide some dig or nslookup results with what you are seeing?
It doesn't look like there is a DHCP server on the segment, how are you configuring your clients and what DNS servers do they show as being used?
Some basic dig pi.hole output or nslookup pi.hole would show some information for us to look at.
Apologies for the confusion. The dig and nslookup I posted before were from the Ubuntu server running Pi-Hole (192.168.30.50). Within Pi-hole i've selected Cloudflare are my DNS provider.
Below is a dig and nslookup from the a client device.
Appreciate your feedback and I see where in the dig it seems like the query time is normal. I can't explain it, when I update my DNS to either my router or external (1.1.1.1) page times improve significantly to all things (google.com, reddit.com, yahoo.com, etc.) over when i'm running pi-hole as my DNS server. I'll proceed with gathering more digs to other websites after work today.