Gravity update failed

Help
1

Expected Behaviour:

_the gravity database should be upgraded and increase the blocked domain number, but it is still the default.
-Operating System - Dietpi
-hardware] RasberryPI

Actual Behaviour:

i had to re-install the pihole, so i did a backup and installed dietpi and then pihole but when i did retore to my adlist and update gravity it fail and give me error and its almost like
'two column was needed but found only one column in the database and inserted null '
i did repair but nothing happened after the repair it go throw updating gravity and the same error.

Debug Token:

_Would you like to upload the log? [y/N] y
    * Using curl for transmission.
    * curl failed, falling back to netcat for transmission.
tricorder.pi-hole.net: forward host lookup failed: Host name lookup failure : Resource temporarily unavailable
[✗]  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
2

There seems to be an issue with your servers name resolution. Do you use Pi-hole itself for that?

Could you paste the output of the following:

curl -IL tricorder.pi-hole.net
cat /etc/resolv.conf

And did you install Pi-hole via it's official installer or via dietpi-software?

3

i installed it via the Dietpi-software, is there a difference ?!

the out put was

root@DietPi:~# curl -IL tricorder.pi-hole.net
HTTP/1.1 301 Moved Permanently
Connection: close
Content-Type: text/html; charset=utf-8
Location: https://tricorder.pi-hole.net/
Server: Caddy
Date: Wed, 23 Sep 2020 08:23:30 GMT

HTTP/2 403
content-type: text/html; charset=utf-8
date: Wed, 23 Sep 2020 08:23:38 GMT
server: Caddy
strict-transport-security: max-age=15768000;
x-content-type-options: nosniff
x-frame-options: SAMEORIGIN
x-xss-protection: 1; mode=block

root@DietPi:~# cat /etc/resolv.conf
#nameserver 37.235.1.174
#nameserver 37.235.1.177

#nameserver 45.32.55.94
#nameserver 2001:19f0:7001:3259:5400:02ff:fe71:0bc9

nameserver 1.1.1.1

.------------------------------------------------------------------

4

do you think it will make a difference if i installed the Pi-Hole from the official installer.?

5

Okay resolving tricorder.pi-hole.net via curl works now. Could you retry sending the debug token?

Not with this kind of error. We use the official installer as well but the webserver stack is setup differently. But it might be relevant for the Pi-hole devs as they generally support curl -sSL https://install.pi-hole.net | bash installs only and this one might need to go to the Community Help subforum.

6

so i got my token
Your debug token is: https://tricorder.pi-hole.net/xci5sf9jj0

7

Your debug log is truncated, please upload a new one.

8

that the only one i have, pihole stopped working and had to change the OS and re-install pi-hole again, but thanks for the fast respond, i will delete the post

9

Looking at it, the log is truncated because there is a maximum file size that tricorder can accept, I think.

@pluto, I notice you have a metric shed load of .googlevideo.com domains in your exact black list. Two thoughts on this:

  • You are probably better off crafting (or searching for an existing) regex to replace all of these
  • Blocking ads on Youtube just doesn't work with Pi-hole, not with any meaningful results, anyway - you're really playing whack-a-mole with that!

You also have some invalid entries in your regex white/blacklists, e.g:

  • (\.|^)https://raw\.githubusercontent\.com/fademind/hosts\.extras/master/add\.2o7net/hosts$
  • (\.|^)https://raw\.githubusercontent\.com/anudeepnd/whitelist/master/domains/whitelist\.txt$

Anything added to the Pi-hole's lists needs to be domain only. URLs are not accepted, and in the case of these regex, they won't actually be providing any useful function to you, so you should remove them...

Edit: You might be better off going back to the default lists and starting your blocking strategy again from scratch. I don't want to accuse you of doing it, but one really shouldn't just paste in any old blocklist they come across on the internet to increase the numbers - this way is paved with pain!

1 Like
10

I guess the idea was to add the content of this file from a GitHub repo: hosts.extras/add.2o7Net/hosts at 18790380deb381ef062e6d91ce099d9b72565b57 · FadeMind/hosts.extras · GitHub
But that is a hosts file and not a Pi-hole white/blacklist file?

The other one would work: whitelist/domains/whitelist.txt at 7358a0446692635c9e83e205f3483d7c09588848 · anudeepND/whitelist · GitHub
But of course the content of this file, not its URL.

I guess that is the reason why we regularly get bug reports where raw.githubusercontent.com is blocked by Pi-hole which breaks DietPi updates, Pi-hole repair+updates and many other things, as users add the URL/domain to the blocklist instead of the file content when non-carefully following random guides :wink:? Just a guess :slightly_smiling_face:.

11

Hosts file is the correct format for a block list! Just needs to be added as an adlist on the groups page.

The other one is intended to be a whitelist. One would need to manually add each domain inside that list as Pi-hole does not have the ability to subscribe to whitelists. So one could add it as a blocklist, but it would have the opposite effect of what the user is (presumably) expecting.

1 Like
12

Ah okay, I though the override IP would not be allowed as it's set by Pi-hole based on blocking mode.

13

We just strip out the leading IP and take the domain only

14

Great to know, as ad blocklists are reasonably often provided in hosts file format :+1:.

15

ya i admit that i have alot in the list, my mistake got carried away but i already started cleaning all the clutter

thanks for the advice

16

Here's a quick command to get rid of those thousands of googlevideo blacklist entries:

sudo sqlite3 /etc/pihole/gravity.db "delete from domainlist where type=1 AND domain like '%googlevideo%' ;"

17

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.