Update Gravity - Issue

[ilirdaka]

Hello! Just installed a new Pi-Hole Server in CentOS 7.
The issue I am facing:
Gravity List Cannot be updated
Details about my system:
When run pihole -g get error as below:

--------------------
  [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_temp.db
  Error: no such table: main.gravity
-------------------------

when try pihole -g -r

--------------------------------
[✗] Unable to fill table adlist in database /etc/pihole/gravity.db
  Error: /tmp/tmp.VMr0BjNnzB.gravity line 1: expected 7 columns of data but found 6
----------------------------------

Tried to delete gravity.db and gravity_temp.db and situation is the same!

What I have changed since installing Pi-hole:
Nothing, since installation I got this error!
Error: /tmp/tmp.[tablename].gravity line 1: expected 7 columns of data but found 6

[jfb]

@ilirdaka

When run pihole -g get error as below:

Please post the complete output of the following command from the Pi terminal:

pihole -g -f

[ilirdaka]

[root@pihole ~]# pihole -g -f
[✓] 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_temp.db
Error: no such table: main.gravity
[i] Number of gravity domains: 0 (0 unique domains)
[i] Number of exact blacklisted domains: 0
[i] Number of regex blacklist filters: 0
[i] Number of exact whitelisted domains: 0
[i] Number of regex whitelist filters: 0
[✓] Flushing DNS cache
[✓] Cleaning up stray matter

[jfb]

Please upload a debug log and post just the token generated by

pihole -d

allowing to upload when prompted, or do it through the Web interface:

Tools > Generate Debug Log

[ilirdaka]

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

[jfb]

You have no adlists shown. Use this FAQ to restore the default lists and rebuild gravity. If this produces errors please reply with the output and a new debug token.

Restoring default Pi-hole adlist(s)

Pi-hole ships with optional adlist(s) (publicly maintained block lists), which you can enable if you choose. If you find that you need to restore the default list(s), they are as follows - current as of the V5.2 release and a pending change to remove a discontinued list. https://raw.githubusercontent.com/StevenBlack/hosts/master/hosts To restore these lists to your Pi-hole, you have several options: Pi-hole V4: From the web Admin GUI > Settings > Blocklists you can paste any of the URL's …

Edit: also check your firewalld settings against our documentation:

Prerequisites - Pi-hole documentation

Your debug log shows the following:

*** [ DIAGNOSING ]: FirewallD
[i] Firewalld service active
[✗]   Allow Service: http (https://docs.pi-hole.net/main/prerequisites/#firewalld)
[✗]   Allow Service: dns (https://docs.pi-hole.net/main/prerequisites/#firewalld)
[✓]   Allow Service: dhcp
[✓]   Allow Service: dhcpv6
[✗] FTL Custom Zone Not Detected (https://docs.pi-hole.net/main/prerequisites/#firewalld)

[ilirdaka]

The same situation!
https://tricorder.pi-hole.net/57c36txert

[DaftSpartan104]

Same error I am receiving, @ilirdaka. Even on fresh installs. I have not found a workaround yet.

[ilirdaka]

I tried another fresh install on CentOS and is the same isue. Tried on Debian 10 minimal last version and everything is working great.