Pihole gravity corrupted itself
After running pihole -g and pihole -g -r
This has been happening since May 2021
Error: no such table: domainlist
Error: no such table: domainlist
Error: no such table: gravity
[i] No results found for www.google.com within the block lists
Please upload a debug log and post just the token that is generated after the log is uploaded by running the following command from the Pi-hole host terminal:
pihole -d
or do it through the Web interface:
Tools > Generate Debug Log
The token is https://tricorder.pi-hole.net/KV7H2hDE/.
I've tried this yubiuser Moderator solution but to no avil. I'm going to try it one last time just to be sure. But I have my doubt.
You're running an open resolver - your Pi-hole is accessible from the internet. Pi-hole does not acknowledge and provide support for open resolvers. This is a threat to the global DNS infrastructure. Close your open port 53!
No Luck. Just this as a result
[✓] Storing downloaded domains in new gravity database
[i] Building tree...
[✗] Unable to build gravity tree in /etc/pihole/gravity.db_temp
Error: no such column: domain
[i] Number of gravity domains: 0 (0 unique domains)
[i] Number of exact blacklisted domains: 21
[i] Number of regex blacklist filters: 14
[i] Number of exact whitelisted domains: 26
[i] Number of regex whitelist filters: 4
[✓] Flushing DNS cache
[✓] Cleaning up stray matter
[✓] DNS service is listening
[✓] UDP (IPv4)
[✓] TCP (IPv4)
[✓] UDP (IPv6)
[✓] TCP (IPv6)
[✓] Pi-hole blocking is enabled
I am aware of the fact that it is an open resolvers. It is a personal server with fail2ban if that helps. Do you mind elaborating on how on how this is true This is a threat to the global DNS infrastructure. I'm confused because aren't Google and Cloudflare are open resolvers?
https://www.ncsc.gov.ie/emailsfrom/DDoS/DNS/
They are, but they also have sophisticated rate limiting and DDOS protection, which your open Pi-hole does not have.
It is still an open resolver, publicly accessible by others on the internet. Many scanners are in use, and they will quickly find your open resolver and put it to no good use.
I do have rate limiters on the server on other ports and using fail2ban. I've also got log scanners than ban any non allowed IP's and notorious hacking countries are ban. I now know Pi Hole doesn't support open resolvers. Will you still help me? Also thank you for opening my eyes to this problem. I was not aware of the problem at all
No.
What do I have to do to get help? Disable external access? Or can I add a rate limiter via other software?
You need to close port 53. If you need remote access to your Pi-hole, I suggest using a VPN like WireGuard. It runs fine aside of Pi-hole and the clients can be easily configured to use the tunnel for DNS only while bypassing it for everything else.
How do I prove that? Via Debug token?
No, we'll take your word for it.
What is the output from sudo ls -lac /etc/pihole, do you have that directory mounted anywhere special or on a remote filesystem?
I've disabled external access. Again a big thanks to all of you for opening my eyes to this. I was not aware of this issue
sudo ls -lac /etc/pihole
total 3632108
drwxrwxr-x 7 pihole pihole 442368 Aug 13 21:25 .
drwxr-xr-x 181 root root 20480 Aug 13 21:18 ..
drwxr-xr-x 8 root root 4096 Aug 13 21:00 .git
-rw-r--r-- 1 root root 647516160 Aug 12 17:15 03-08-2021-203015-gravity.db
-rw-r--r-- 1 root root 647290880 Aug 11 16:54 2021-06-17-gravity.db
-rw-r--r-- 1 root root 20507 Aug 13 20:30 Ad-block-raw_whitelist.txt
-rw-r--r-- 1 root root 20177 Aug 13 20:30 DNSlock-PiHole-whitelist-whitelist.list
-rw-r--r-- 1 root root 20 Aug 13 14:43 GitHubVersions
-rw-r--r-- 1 root root 24302 Aug 12 18:20 Pi-Hosts.lists
drwxr-xr-x 2 root root 4096 Aug 13 20:30 PyPhDB
drwxr-xr-x 2 root root 4096 Aug 13 09:42 PyPhTP
-rw-r--r-- 1 root root 576 Aug 13 20:30 WHITE_LIST_ALL_IN_ONE.txt
-rw-r--r-- 1 root root 80 Aug 13 20:30 YTTV_whitelist.txt
-rw-r--r-- 1 root root 62 Aug 12 17:00 acestream.com-blacklist.txt
-rw-r--r-- 1 root root 0 Aug 12 17:00 acestream.info-blacklist.txt
-rw-r--r-- 1 root root 190 Aug 12 17:00 acestream.me-blacklist.txt
-rw-r--r-- 1 root root 537 Aug 12 17:00 acestream.net-blacklist.txt
-rw-r--r-- 1 root root 265 Aug 12 17:00 acestream.org-blacklist.txt
-rw-r--r-- 1 root root 8149 Aug 12 16:59 adlists.list.1
-rw-r--r-- 1 root root 8149 Aug 12 16:59 adlists.list.2
-rw-r--r-- 1 root root 40 Aug 12 16:59 adlists.list.bk.REMOVED.git-id
-rw-r--r-- 1 root root 65 Aug 12 16:59 adlists.list.old
-rw-r--r-- 1 root root 0 Aug 12 23:00 adlists.txt
-rw-r--r-- 1 root root 19 Aug 12 17:00 ads.google.com-blacklist.txt
-rw-r--r-- 1 root root 0 Aug 12 17:00 ads.google.com-whitelist.txt
-rw-r--r-- 1 root root 40 Aug 12 16:59 black.list.REMOVED.git-id
-rw-r--r-- 1 root root 5040 Aug 12 17:00 blacklist_regex.txt
-rw-r--r-- 1 root root 6209 Aug 13 20:30 blacklist_regex_CyberAndi-Pi-Hole-5.txt
-rw-r--r-- 1 root root 615 Aug 13 20:30 blacklist_regex_Perfly.txt
-rw-r--r-- 1 root root 2133 Aug 13 20:30 blacklist_regex_filtered.txt
-rw-r--r-- 1 root root 5117 Aug 13 20:30 blacklist_regex_incentkenny01_spotblock__wildcard.txt
-rw-r--r-- 1 root root 21475 Aug 13 20:30 custom-blacklist.txt
-rw-r--r-- 1 root root 21475 Aug 13 20:30 custom-blacklist.txt.bk
-rw-r--r-- 1 root root 21475 Aug 13 20:30 custom-blacklist.txt.bk.unsorted
-rw-r--r-- 1 root root 5992 Aug 13 20:25 custom-dns-server.conf
-rw-r--r-- 1 root root 5970 Aug 9 09:30 custom-dns-server.conf-
................
-rw-r--r-- 1 root root 475 Aug 13 20:30 custom-facebook-blacklist.txt.bk
-rw-r--r-- 1 root root 475 Aug 13 20:30 custom-facebook-blacklist.txt.bk.unsorted
-rw-r--r-- 1 root root 435 Aug 13 20:30 custom-facebook-whitelist.txt
-rw-r--r-- 1 root root 435 Aug 13 20:30 custom-facebook-whitelist.txt.bk
-rw-r--r-- 1 root root 435 Aug 13 20:30 custom-facebook-whitelist.txt.bk.unsorted
-rw-r--r-- 1 root root 1605 Aug 13 20:30 custom-google-blacklist.txt
-rw-r--r-- 1 root root 1605 Aug 13 20:30 custom-google-blacklist.txt.bk
-rw-r--r-- 1 root root 1605 Aug 13 20:30 custom-google-blacklist.txt.bk.unsorted
-rw-r--r-- 1 root root 126 Aug 13 20:30 custom-hubspot-whitelist.txt
-rw-r--r-- 1 root root 126 Aug 13 20:30 custom-hubspot-whitelist.txt.bk
-rw-r--r-- 1 root root 126 Aug 13 20:30 custom-hubspot-whitelist.txt.bk.unsorted
-rw-r--r-- 1 root root 192 Aug 12 17:00 custom-instagram-regex-whitelist.txt
-rw-r--r-- 1 root root 0 Aug 13 20:30 custom-mobile-trackers-blacklist.txt
-rw-r--r-- 1 root root 0 Aug 13 20:30 custom-mobile-trackers-blacklist.txt.bk
-rw-r--r-- 1 root root 0 Aug 13 20:30 custom-mobile-trackers-blacklist.txt.bk.unsorted
-rw-r--r-- 1 root root 1133 Aug 12 17:00 custom-mobile-trackers-blacklist_regex.txt
-rw-r--r-- 1 root root 338 Aug 13 20:30 custom-onedrive-whitelist.txt
-rw-r--r-- 1 root root 338 Aug 13 20:30 custom-onedrive-whitelist.txt.bk
-rw-r--r-- 1 root root 338 Aug 13 20:30 custom-onedrive-whitelist.txt.bk.unsorted
-rw-r--r-- 1 root root 491 Aug 13 20:30 custom-snap-ads-blacklist.txt
-rw-r--r-- 1 root root 491 Aug 13 20:30 custom-snap-ads-blacklist.txt.bk
-rw-r--r-- 1 root root 491 Aug 13 20:30 custom-snap-ads-blacklist.txt.bk.unsorted
-rw-r--r-- 1 root root 131 Aug 12 17:00 custom-snap-ads_regex_blacklist.txt
-rw-r--r-- 1 root root 292 Aug 12 17:00 custom-snap-ads_regex_whitelist.txt
-rw-r--r-- 1 root root 97 Aug 12 17:00 custom-snap-regex-whitelist.txt
-rw-r--r-- 1 root root 213 Aug 13 20:30 custom-snap-whitelist.txt
-rw-r--r-- 1 root root 213 Aug 13 20:30 custom-snap-whitelist.txt.bk
-rw-r--r-- 1 root root 213 Aug 13 20:30 custom-snap-whitelist.txt.bk.unsorted
-rw-r--r-- 1 root root 15308 Aug 13 20:30 custom-whitelist.txt
-rw-r--r-- 1 root root 15308 Aug 13 20:30 custom-whitelist.txt.bk
-rw-r--r-- 1 root root 15308 Aug 13 20:30 custom-whitelist.txt.bk.unsorted
-rw-r--r-- 1 root root 0 Aug 13 21:18 custom.list
-rw-r--r-- 1 root root 0 Aug 12 16:59 custom.list.bk.unsorted
-rw-r--r-- 1 root root 0 Aug 12 16:59 custom.list.bk.unsorted.bk.unsorted
-rw-r--r-- 1 root root 103 Aug 13 20:30 custom_instgram_whitelist.txt
-rw-r--r-- 1 root root 103 Aug 13 20:30 custom_instgram_whitelist.txt.bk
-rw-r--r-- 1 root root 103 Aug 13 20:30 custom_instgram_whitelist.txt.bk.unsorted
-rw-r--r-- 1 root root 67 Aug 13 20:30 custom_no-tracking-rm-list.txt
-rw-r--r-- 1 root root 67 Aug 13 20:30 custom_no-tracking-rm-list.txt.bk
-rw-r--r-- 1 root root 67 Aug 13 20:30 custom_no-tracking-rm-list.txt.bk.unsorted
-rw-r--r-- 1 root root 6249 Aug 12 17:00 custom_regex_blacklist.txt
-rw-r--r-- 1 pihole pihole 0 Aug 13 21:18 dhcp.leases
-rw-r--r-- 1 root root 1269 Aug 13 21:15 dns-servers.conf
-rw-r--r-- 1 root root 1269 Aug 12 17:13 dns-servers.conf.bk
drwxr-xr-x 3 root root 4096 Aug 12 18:04 etc
-rw-r--r-- 1 root root 3214 Aug 12 17:00 facebook.com-blacklist.txt
-rw-r--r-- 1 root root 22571 Aug 12 17:00 facebook.com-whitelist.txt
-rw-r--r-- 1 root root 29 Aug 12 17:00 github.com-blacklist.txt
-rw-r--r-- 1 root root 19718 Aug 12 17:00 github.com-whitelist.txt
-rw-r--r-- 1 root root 137 Aug 12 17:00 google-analytics.com-blacklist.txt
-rw------- 1 root root 2282 Aug 12 17:03 google-blacklist.list
-rw------- 1 root root 896 Aug 12 17:06 google-blacklist.regex
-rw------- 1 root root 5124 Aug 12 17:03 google-whitelist.list
-rw------- 1 root root 544 Aug 12 17:06 google-whitelist.regex
-rw-r--r-- 1 root root 0 Aug 12 17:00 googleadservices.com-blacklist.txt
-rw-r--r-- 1 root root 1047 Aug 12 17:00 googlesyndication.com-blacklist.txt
-rw-r--r-- 1 root root 27075 Aug 12 17:00 googlesyndication.com-whitelist.txt
-rw-r--r-- 1 root root 0 Aug 12 17:00 googletagservices.com-blacklist.txt
-rw-r--r-- 1 root root 2886 Aug 12 17:03 goverment-whitelist.list
-rw-r--r-- 1 pihole pihole 651264 Aug 13 21:18 gravity.db
-rw-r--r-- 1 pihole pihole 32768 Aug 13 21:25 gravity.db-shm
-rw-r--r-- 1 pihole pihole 552112 Aug 13 21:25 gravity.db-wal
-rw-r--r-- 1 root root 95 Aug 12 17:16 list.1.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 198540 Aug 13 15:21 list.10.gitlab.com.domains
-rw-r--r-- 1 root root 81 Aug 13 12:20 list.10.gitlab.com.domains.sha1
-rw-r--r-- 1 root root 96 Aug 12 17:19 list.10.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 83 Aug 12 21:28 list.1000.gitlab.com.domains.sha1
-rw-r--r-- 1 root root 4859 Aug 13 15:04 list.1000.raw.githubusercontent.com.domains
-rw-r--r-- 1 root root 98 Aug 13 12:40 list.1000.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 83 Aug 12 21:28 list.1001.gitlab.com.domains.sha1
-rw-r--r-- 1 root root 92 Aug 12 18:33 list.1001.hblock.molinero.dev.domains.sha1
-rw-r--r-- 1 root root 290031 Aug 13 15:04 list.1001.raw.githubusercontent.com.domains
-rw-r--r-- 1 root root 98 Aug 13 12:40 list.1001.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 93 Aug 12 18:33 list.1002.hostfiles.frogeye.fr.domains.sha1
-rw-r--r-- 1 root root 93 Aug 12 18:34 list.1003.hostfiles.frogeye.fr.domains.sha1
-rw-r--r-- 1 root root 5233 Aug 13 15:04 list.1003.raw.githubusercontent.com.domains
-rw-r--r-- 1 root root 98 Aug 13 12:40 list.1003.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 121772 Aug 13 15:04 list.1004.raw.githubusercontent.com.domains
-rw-r--r-- 1 root root 98 Aug 13 12:40 list.1004.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 11045 Aug 13 15:04 list.1005.raw.githubusercontent.com.domains
-rw-r--r-- 1 root root 98 Aug 13 12:40 list.1005.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 1590 Aug 13 15:04 list.1006.raw.githubusercontent.com.domains
-rw-r--r-- 1 root root 98 Aug 13 12:40 list.1006.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 2301 Aug 13 15:04 list.1007.raw.githubusercontent.com.domains
-rw-r--r-- 1 root root 98 Aug 13 12:40 list.1007.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 313333 Aug 13 15:04 list.1008.raw.githubusercontent.com.domains
-rw-r--r-- 1 root root 98 Aug 13 12:57 list.1008.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 1350 Aug 13 15:04 list.1009.raw.githubusercontent.com.domains
-rw-r--r-- 1 root root 98 Aug 13 12:57 list.1009.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 721996 Aug 13 15:04 list.1011.raw.githubusercontent.com.domains
-rw-r--r-- 1 root root 98 Aug 13 12:57 list.1011.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 6490 Aug 13 15:04 list.1012.raw.githubusercontent.com.domains
-rw-r--r-- 1 root root 98 Aug 13 12:57 list.1012.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 86 Aug 13 10:16 list.1013.phishing.army.domains.sha1
-rw-r--r-- 1 root root 1168313 Aug 13 15:04 list.1013.raw.githubusercontent.com.domains
-rw-r--r-- 1 root root 98 Aug 13 12:57 list.1013.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 99 Aug 12 21:29 list.1014.ransomwaretracker.abuse.ch.domains.sha1
-rw-r--r-- 1 root root 40537 Aug 13 15:04 list.1014.raw.githubusercontent.com.domains
-rw-r--r-- 1 root root 98 Aug 13 12:57 list.1014.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 99 Aug 12 21:29 list.1015.ransomwaretracker.abuse.ch.domains.sha1
-rw-r--r-- 1 root root 99 Aug 12 21:29 list.1016.ransomwaretracker.abuse.ch.domains.sha1
-rw-r--r-- 1 root root 99 Aug 12 21:30 list.1017.ransomwaretracker.abuse.ch.domains.sha1
-rw-r--r-- 1 root root 146905 Aug 13 15:04 list.1017.raw.githubusercontent.com.domains
-rw-r--r-- 1 root root 98 Aug 13 12:57 list.1017.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 99 Aug 12 21:30 list.1018.ransomwaretracker.abuse.ch.domains.sha1
-rw-r--r-- 1 root root 94 Aug 12 18:34 list.1020.hosts.ubuntu101.co.za.domains.sha1
-rw-r--r-- 1 root root 90 Aug 12 18:34 list.1021.hostsfile.mine.nu.domains.sha1
-rw-r--r-- 1 root root 86 Aug 12 18:34 list.1022.hostsfile.org.domains.sha1
-rw-r--r-- 1 root root 32796004 Aug 13 11:26 list.1022.raw.githubusercontent.com.domains
-rw-r--r-- 1 root root 98 Aug 12 21:31 list.1022.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 92 Aug 12 18:34 list.1023.hostsmobile.oisd.nl.domains.sha1
-rw-r--r-- 1 root root 131925 Aug 13 11:26 list.1023.raw.githubusercontent.com.domains
-rw-r--r-- 1 root root 98 Aug 12 21:31 list.1023.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 91 Aug 12 18:34 list.1025.infosec.cert-pa.it.domains.sha1
-rw-r--r-- 1 root root 16824255 Aug 13 11:26 list.1025.raw.githubusercontent.com.domains
-rw-r--r-- 1 root root 98 Aug 12 21:32 list.1025.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 85 Aug 12 18:34 list.1026.isc.sans.edu.domains.sha1
-rw-r--r-- 1 root root 5624 Aug 13 11:26 list.1026.raw.githubusercontent.com.domains
-rw-r--r-- 1 root root 98 Aug 12 21:32 list.1026.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 1581 Aug 13 11:26 list.1027.raw.githubusercontent.com.domains
-rw-r--r-- 1 root root 98 Aug 12 21:32 list.1027.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 84 Aug 12 18:34 list.1028.joewein.net.domains.sha1
-rw-r--r-- 1 root root 578023 Aug 13 11:26 list.1028.raw.githubusercontent.com.domains
-rw-r--r-- 1 root root 98 Aug 12 21:32 list.1028.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 84 Aug 12 18:34 list.1029.joewein.net.domains.sha1
-rw-r--r-- 1 root root 204 Aug 13 11:26 list.1029.raw.githubusercontent.com.domains
-rw-r--r-- 1 root root 98 Aug 12 21:33 list.1029.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 94 Aug 12 18:34 list.1030.justdomains.github.io.domains.sha1
-rw-r--r-- 1 root root 31661 Aug 13 11:26
..........
-rw-r--r-- 1 root root 98 Aug 12 19:36 list.1880.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 7136 Aug 13 13:50 list.1880.void.gr.domains
-rw-r--r-- 1 root root 80 Aug 13 13:50 list.1880.void.gr.domains.sha1
-rw-r--r-- 1 root root 98 Aug 12 19:36 list.1881.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 1565612 Aug 13 13:50 list.1881.warui.intaa.net.domains
-rw-r--r-- 1 root root 88 Aug 13 13:50 list.1881.warui.intaa.net.domains.sha1
.........
-rw-r--r-- 1 root root 100 Aug 13 13:51 list.1891.www.github.developerdan.com.domains.sha1
-rw-r--r-- 1 root root 98 Aug 12 19:37 list.1892.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 1580467 Aug 13 13:51 list.1892.www.github.developerdan.com.domains
-rw-r--r-- 1 root root 100 Aug 13 13:51 list.1892.www.github.developerdan.com.domains.sha1
-rw-r--r-- 1 root root 98 Aug 12 19:37 list.1893.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 8385 Aug 13 15:51 list.1893.www.jabcreations.com.domains
-rw-r--r-- 1 root root 93 Aug 13 13:51 list.1893.www.jabcreations.com.domains.sha1
-rw-r--r-- 1 root root 1288489 Aug 13 13:51 list.1894.www.joewein.net.domains
-rw-r--r-- 1 root root 88 Aug 13 13:51 list.1894.www.joewein.net.domains.sha1
-rw-r--r-- 1 root root 98 Aug 12 19:37 list.1895.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 141256 Aug 13 15:51 list.1895.www.kiboke-studio.hr.domains
-rw-r--r-- 1 root root 93 Aug 13 13:51 list.1895.www.kiboke-studio.hr.domains.sha1
-rw-r--r-- 1 root root 98 Aug 12 19:38 list.1896.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 98 Aug 12 19:38 list.1897.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 0 Aug 13 13:51 list.1897.www.openphish.com.domains
-rw-r--r-- 1 root root 90 Aug 13 13:51 list.1897.www.openphish.com.domains.sha1
-rw-r--r-- 1 root root 98 Aug 12 19:38 list.1898.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 98 Aug 12 19:38 list.1899.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 82 Aug 12 17:21 list.190.github.com.domains.sha1
-rw-r--r-- 1 root root 98 Aug 12 19:38 list.1900.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 98 Aug 12 19:38 list.1901.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 98 Aug 12 19:38 list.1902.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 510120 Aug 13 15:53 list.1902.www.stopforumspam.com.domains
-rw-r--r-- 1 root root 94 Aug 13 13:53 list.1902.www.stopforumspam.com.domains.sha1
-rw-r--r-- 1 root root 98 Aug 12 19:38 list.1903.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 55357 Aug 13 13:53 list.1903.www.threatcrowd.org.domains
-rw-r--r-- 1 root root 92 Aug 13 13:53 list.1903.www.threatcrowd.org.domains.sha1
-rw-r--r-- 1 root root 98 Aug 12 19:38 list.1904.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 4574873 Aug 13 15:53 list.1904.zerodot1.gitlab.io.domains
-rw-r--r-- 1 root root 91 Aug 13 13:53 list.1904.zerodot1.gitlab.io.domains.sha1
-rw-r--r-- 1 root root 98 Aug 12 19:38 list.1905.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 68842 Aug 13 15:53 list.1905.zerodot1.gitlab.io.domains
-rw-r--r-- 1 root root 91 Aug 13 13:53 list.1905.zerodot1.gitlab.io.domains.sha1
-rw-r--r-- 1 root root 98 Aug 12 19:38 list.1906.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 4574874 Aug 13 15:53 list.1906.zerodot1.gitlab.io.domains
-rw-r--r-- 1 root root 91 Aug 13 13:53 list.1906.zerodot1.gitlab.io.domains.sha1
-rw-r--r-- 1 root root 98 Aug 12 19:38 list.1907.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 68842 Aug 13 15:54 list.1907.zerodot1.gitlab.io.domains
-rw-r--r-- 1 root root 91 Aug 13 13:53 list.1907.zerodot1.gitlab.io.domains.sha1
-rw-r--r-- 1 root root 98 Aug 12 19:38 list.1908.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 35171 Aug 13 15:54 list.1908.zerodot1.gitlab.io.domains
-rw-r--r-- 1 root root 91 Aug 13 13:53 list.1908.zerodot1.gitlab.io.domains.sha1
-rw-r--r-- 1 root root 98 Aug 12 19:38 list.1909.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 82 Aug 12 17:21 list.191.github.com.domains.sha1
-rw-r--r-- 1 root root 98 Aug 12 19:38 list.1910.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 0 Aug 13 15:54 list.1910.zonefiles.io.domains
-rw-r--r-- 1 root root 85 Aug 13 13:55 list.1910.zonefiles.io.domains.sha1
-rw-r--r-- 1 root root 98 Aug 12 19:38 list.1911.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 90 Aug 13 10:33
-rw-r--r-- 1 root root 4574874 Aug 13 14:55 list.624.gitlab.com.domains
-rw-r--r-- 1 root root 82 Aug 13 12:29 ...................
list.783.raw.githubusercontent.com.domains
-rw-r--r-- 1 root root 97 Aug 12 20:07 list.783.raw.githubusercontent.com.domains.sha1
-rw-r--r-- 1 root root 83 Aug 12 22:07 list.784.easylist.to.domains.sha1
-rw-r--r-- 1 root root 2865 Aug 13 11:13 list.784.raw.githubusercontent.com.domains
-rw-r--r-- 1 root root 97 Aug 12 20:07
-rw-r--r-- 1 root root 68 Aug 13 21:18 local.list
-rw-r--r-- 1 root root 20 Aug 13 21:20 localbranches
-rw-r--r-- 1 root root 43 Aug 13 21:20 localversions
-rw-r--r-- 1 root root 238 Aug 12 17:48 logrotate
drwxr-xr-x 2 root root 4096 Aug 13 14:49 migration_backup
-rw-r--r-- 1 root root 41050 Aug 12 17:03 openphish.com.list
-rw-r--r-- 1 root root 1443091 Aug 12 23:34 pi-hole-ctp-vpn-teleporter_2021-08-12_23-34-41.tar.gz
-rw-r--r-- 1 root root 882 Aug 11 17:59 pihole-FTL.conf
-rw-r--r-- 1 pihole pihole 66805760 Aug 13 21:24 pihole-FTL.db
-rw-r--r-- 1 root root 1766 Aug 13 20:30 pihole-blocklist_whitelist.txt
-rw-r--r-- 1 root root 1170 Aug 13 20:30 pihole-regex_blacklist_regex_blacklist.txt
-rw-r--r-- 1 root root 545 Aug 12 17:03 quick-blacklist.list
-rw-r--r-- 1 root root 373 Aug 12 17:03 quick-whitelist.list
-rw-r--r-- 1 root root 1226 Aug 12 17:00 regex-list.txt
-rw-r--r-- 1 root root 1426 Aug 12 17:48 setupVars.conf
-rw-r--r-- 1 root root 736 Aug 12 18:20 shallalist.lists
-rw-r--r-- 1 root root 0 Aug 12 17:00 stevejenkins_my-pihole-list.txt
-rw-r--r-- 1 root root 194 Aug 12 17:00 stripe-whitelist.txt
-rw-r--r-- 1 root root 12149 Aug 12 17:00 top-1000-domains-whitelist.txt
-rw-r--r-- 1 root root 0 Aug 12 17:00 tv.youtube.com-blacklist.txt
-rw-r--r-- 1 root root 711 Aug 12 17:00 twitter.com-blacklist.txt
-rw-r--r-- 1 root root 21760 Aug 12 17:00 twitter.com-whitelist.txt
-rw-r--r-- 1 root root 1696 Aug 13 21:25 vulnerability-blacklist.regex
-rw-r--r-- 1 root root 1056 Aug 12 17:00 whitelist-regex.txt
-rw-r--r-- 1 root root 0 Aug 13 20:30 whitelist222.txt
-rw-r--r-- 1 root root 0 Aug 12 17:00 www.acestream.org-blacklist.txt
-rw-r--r-- 1 root root 518 Aug 12 17:00 youtube.com-blacklist.txt
-rw---xr-- 1 root everyone 230 Aug 13 21:00 youtube_regex_urls.txt
that us the output to sudo ls -lac /etc/pihole
I the char count so the .... is deleted lines
You have a lot of extra items and things that look like they are trying to modify the database directly. A lof of python scripts.
See if you can replicate the problem with just a fresh install and no extra items that are not part of Pi-hole.
I can try that.
I get this error
[✓] Enabling lighttpd service to start on reboot...
[✓] Checking for user 'pihole'
[i] FTL Checks...
[✓] Detected x86_64 processor
[i] Checking for existing FTL binary...
[✓] Downloading and Installing FTL
[✓] Installing scripts from /etc/.pihole
[i] Installing configs from /etc/.pihole...
[i] Existing dnsmasq.conf found... it is not a Pi-hole file, leaving alone!
[✓] Copying 01-pihole.conf to /etc/dnsmasq.d/01-pihole.conf
[i] Installing blocking page...
[✓] Creating directory for blocking page, and copying files
[i] Backing up index.lighttpd.html
No default index.lighttpd.html file found... not backing up
[✓] Installing sudoer file
[✓] Installing latest Cron script
[✓] Installing latest logrotate script
[i] Backing up /etc/dnsmasq.conf to /etc/dnsmasq.conf.old
[✓] man pages installed and database updated
[i] Testing if systemd-resolved is enabled
[✓] Disabling systemd-resolved DNSStubListener and restarting systemd-resolved
[✓] Restarting lighttpd service...
[✓] Enabling lighttpd service to start on reboot...
[i] Restarting services...
[✓] Enabling pihole-FTL service to start on reboot...
[✓] Restarting pihole-FTL service...
Error: no such table: info
[✓] Deleting existing list cache
[i] Neutrino emissions detected...
[✗] Pulling blocklist source list into range
[i] No source list found, or it is empty
[i] Building tree...
[✗] Unable to build gravity tree in /etc/pihole/gravity.db_temp
Error: no such table: main.gravity
[✗] Unable to update gravity timestamp in database /etc/pihole/gravity.db
Error: near line 2: no such table: info
Error: no such table: vw_gravity
Error: no such table: vw_gravity
[i] Number of gravity domains: ( unique domains)
Error: near ")": syntax error
Error: no such table: vw_blacklist
[i] Number of exact blacklisted domains:
Error: no such table: vw_regex_blacklist
[i] Number of regex blacklist filters:
Error: no such table: vw_whitelist
[i] Number of exact whitelisted domains:
Error: no such table: vw_regex_whitelist
[i] Number of regex whitelist filters:
[✓] Flushing DNS cache
[✓] Cleaning up stray matter
[✓] DNS service is listening
[✓] UDP (IPv4)
[✓] TCP (IPv4)
[✓] UDP (IPv6)
[✓] TCP (IPv6)
[i] Pi-hole blocking will be enabled
[i] Enabling blocking
[✓] Flushing DNS cache
[✓] Pi-hole Enabled
That's on a brand new install with only the files the installer added to /etc/pihole?
Yes, sir. I ran pihole uninstall before