Pi-Hole Upgrade

 When you see in your Pi-Hole admin web:

is time to update your Pi-Hole software.

Protocol:

# pihole -up

  [i] Checking for updates...
  [i] Pi-hole Core:    update available
  [i] Web Interface:    update available
  [i] FTL:        update available

  [i] Pi-hole core files out of date, updating local repo.
  [✓] Check for existing repository in /etc/.pihole
  [i] Update repo in /etc/.pihole...HEAD is now at cbc3fbdf Merge pull request #3989 from pi-hole/release/v5.2.3
  [✓] Update repo in /etc/.pihole

  [i] If you had made any changes in '/etc/.pihole/', they have been stashed using 'git stash'

  [i] Pi-hole Web Admin files out of date, updating local repo.
  [✓] Check for existing repository in /var/www/html/admin
  [i] Update repo in /var/www/html/admin...HEAD is now at 3ff33a3d Merge pull request #1704 from pi-hole/release/v5.3
  [✓] Update repo in /var/www/html/admin

  [i] If you had made any changes in '/var/www/html/admin/', they have been stashed using 'git stash'

  [i] FTL out of date, it will be updated by the installer.

  [✓] Root user check

        .;;,.
        .ccccc:,.
         :cccclll:.      ..,,
          :ccccclll.   ;ooodc
           'ccll:;ll .oooodc
             .;cll.;;looo:.
                 .. ','.
                .',,,,,,'.
              .',,,,,,,,,,.
            .',,,,,,,,,,,,....
          ....''',,,,,,,'.......
        .........  ....  .........
        ..........      ..........
        ..........      ..........
        .........  ....  .........
          ........,,,,,,,'......
            ....',,,,,,,,,,,,.
               .',,,,,,,,,'.
                .',,,,,,'.
                  ..'''.

  [i] Update local cache of available packages...

...
...
...

  [i] The install log is located at: /etc/pihole/install.log
Update Complete!

  Current Pi-hole version is v5.2.3.
  Current AdminLTE version is v5.3.
  Current FTL version is v5.4.

... only have to wait, Pi-Hole makes everithing fo you.

And finally think about contribute PiHole, a really amaizing tool.

Ref.:

https://discourse.pi-hole.net/t/how-do-i-update-pi-hole/249

PiHole databases and SQLite

The PiHole data databases are make and
managed by SQLite.

PiHole databases files are located in /etc/pihole:

$ ls -f /etc/pihole
.
..
list.5.s3.amazonaws.com.domains
black.list
list.2.mirror1.malwaredomains.com.domains
GitHubVersions
local.list
migration_backup
gravity.db
list.1.raw.githubusercontent.com.domains
custom.list
logrotate
dns-servers.conf
list.3.sysctl.org.domains
list.4.zeustracker.abuse.ch.domains
setupVars.conf.update.bak
install.log
gravity.list
macvendor.db
setupVars.conf
pihole-FTL.conf
list.6.s3.amazonaws.com.domains
localbranches
localversions
adlists.list
pihole-FTL.db
dhcp.leases

Databases are available from SQLite3 commands in bash console or SQLliteBrowser.

SQL code to get the know MACs order by recent DNS queries in PiHole from /etc/pihole/pihole-FTL.db:

SELECT hwaddr , strftime('%Y-%m-%d %H:%M:%S', lastQuery, 'unixepoch') AS date FROM `network` ORDER BY lastQuery DESC;

"hwaddr" "date"
"xx:xx:xx:xx:xx:xx"    "2021-01-16 18:26:58"
"xx:xx:xx:xx:xx:xx"    "2021-01-16 18:26:28"
"xx:xx:xx:xx:xx:xx"    "2021-01-16 18:23:35"
"xx:xx:xx:xx:xx:xx"    "2021-01-16 18:26:58"
"xx:xx:xx:xx:xx:xx"    "2021-01-16 18:26:28"
"xx:xx:xx:xx:xx:xx"    "2021-01-16 18:23:35"
 ...

 It is good source of data for monitoring the net.

 

Search queries by domain name:

sqlite> .open pihole-FTL.db

sqlite> select * from queries where domain like "%KeyWord%" limit 50;

 .