[Solved] Various Issues after re-install

Help
1

Please follow the below template, it will help us to help you!

Expected Behaviour:

Show network in the Network overview, filter traffic

Actual Behaviour:

Nothing in Network Overview, on loading a page from within the network, i.e. Chrome immediately shows Connection Timed Out" then it instantly refreshes and loads the page, happens on any page every time.

More Info

Had a Rasbian update go wrong, had to reformat, reinstall rasbian and PiHole (had a backup of the settings folder). This was working before, not so much now, any ideas?

Debug Token:

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

2

You do not have a clean install of Pi-hole core.

** [ DIAGNOSING ]: Core version
[i] Core: v4.4 (https://discourse.pi-hole.net/t/how-do-i-update-pi-hole/249)
[i] Branch: master
[i] Commit: v4.4-0-g9e49077-dirty
[i] Status:  M advanced/Scripts/chronometer.sh
             M advanced/Scripts/list.sh
             M advanced/Scripts/piholeDebug.sh
             M advanced/Scripts/piholeLogFlush.sh
             M advanced/Scripts/setupLCD.sh
             M advanced/Scripts/update.sh
             M advanced/Scripts/updatecheck.sh
             M advanced/Scripts/version.sh
             M advanced/Scripts/webpage.sh
             M "automated install/basic-install.sh"
             M "automated install/uninstall.sh"
             M autotest
             M gravity.sh
             M pihole
[i] Diff: diff --git a/advanced/Scripts/chronometer.sh b/advanced/Scripts/chronometer.sh
          old mode 100755
          new mode 100644
          diff --git a/advanced/Scripts/list.sh b/advanced/Scripts/list.sh
          old mode 100755
          new mode 100644

Run these commands:

cd /etc/.pihole
sudo git checkout master
pihole -r and select repair

3

Thanks, hmm getting Permission denied when trying to run the pihole -r command..

pi@pihole:~ $ cd /etc/.pihole
pi@pihole:/etc/.pihole $ sudo git checkout master
M	advanced/Scripts/chronometer.sh
M	advanced/Scripts/list.sh
M	advanced/Scripts/piholeDebug.sh
M	advanced/Scripts/piholeLogFlush.sh
M	advanced/Scripts/setupLCD.sh
M	advanced/Scripts/update.sh
M	advanced/Scripts/updatecheck.sh
M	advanced/Scripts/version.sh
M	advanced/Scripts/webpage.sh
M	automated install/basic-install.sh
M	automated install/uninstall.sh
M	autotest
M	gravity.sh
M	pihole
Already on 'master'
Your branch is up to date with 'origin/master'.
pi@pihole:/etc/.pihole $ pihole -r
/usr/local/bin/pihole: line 67: /etc/.pihole/automated install/basic-install.sh: Permission denied

Owner of basic-install.sh is pi:pi and permissions are 644

4

Let's try this, more of a brute force approach:

cd /
sudo rm -rf /etc/.pihole
sudo git clone https://github.com/pi-hole/pi-hole /etc/.pihole
pihole -r

5

That seems to resolved the permission issue, nothing still in Network Overview..

6

Please generate a new debug log, upload it and post the token here.

7

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

8

Your long term database is corrupted. Let's move it and start up without one, and let Pi-hole make a new one.

  [2020-04-28 19:41:02.410 9554] SQLite3 message: database corruption at line 66193 of [0eca3dd3d3] (11)
   [2020-04-28 19:41:02.410 9554] SQLite3 message: database disk image is malformed in "SELECT VALUE FROM ftl WHERE id = 0;" (11)
   [2020-04-28 19:41:02.410 9554] db_query_int(SELECT VALUE FROM ftl WHERE id = 0;) - SQL error prepare (11): database disk image is malformed
   [2020-04-28 19:41:02.410 9554] check_database(11): Disabling database connection due to error

sudo service pihole-FTL stop

sudo mv /etc/pihole/pihole-FTL.db /etc/pihole/pihole-FTL-old.db

sudo service pihole-FTL start

9

Done, here's the new debug log

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

I see IP's in the Network Overview now.. I also see SQLite3 query Unable to prepare statement database disk image is malformed in the log still..

10

These log entries are from prior to restarting FTL. Is everything in the Pi-hole working properly now?

11

Ah ok, seems everything within PiHole is working except I still get the Connection timed out issue issue I described under Default Behaviour in my initial post.

12

Sounds like your client isn't using Pi-hole as the DNS server. What OS is it?

13

I'm running Win 10, PiHole is running on Rasbian, Router has the DNS set to PiHole's static IP.

14

From the command prompt on the WIN10 clients, what is the output of the following commands:

nslookup pi.hole

nslookup pi.hole 192.168.1.51

15 
pi@pihole:/ $ nslookup pi.hole
Server:		127.0.0.1
Address:	127.0.0.1#53

Name:	pi.hole
Address: 192.168.1.51

pi@pihole:/ $ nslookup pi.hole 192.168.1.51
Server:		192.168.1.51
Address:	192.168.1.51#53

Name:	pi.hole
Address: 192.168.1.51
16

That doesn't look like a Windows 10 CMD or PS prompt?

17

Whoops, my bad for not reading that.

C:\WINDOWS\System32>nslookup pi.hole
DNS request timed out.
    timeout was 2 seconds.
Server:  UnKnown
Address:  192.168.1.51

DNS request timed out.
    timeout was 2 seconds.
DNS request timed out.
    timeout was 2 seconds.
DNS request timed out.
    timeout was 2 seconds.
DNS request timed out.
    timeout was 2 seconds.
*** Request to UnKnown timed-out

C:\WINDOWS\System32>nslookup pi.hole 192.168.1.51
DNS request timed out.
    timeout was 2 seconds.
Server:  UnKnown
Address:  192.168.1.51

DNS request timed out.
    timeout was 2 seconds.
DNS request timed out.
    timeout was 2 seconds.
DNS request timed out.
    timeout was 2 seconds.
DNS request timed out.
    timeout was 2 seconds.
*** Request to UnKnown timed-out

I can however access the PiHole admin panel from Windows via pi.hole/admin as well as the IP above.

18

What kind of router are you using, and does it have rebind protection enabled?

19

Asus RT-AC87U . I don't know if it does, I don't believe so?

20

Okay, can you run ipconfig on the Windows box and list the DNS servers that Windows is trying to use?

ipconfig /all will do that.