Pi-hole Core v5.2.3, Web v5.3 and FTL v5.4 released!

Adam Warner 2021-01-15 Updates 17

A new year, a new release!

Before running pihole -up to update, make sure you’ve read over the release notes below to ensure there’s nothing that would stop you from upgrading. ~~Pi-hole docker containers will be updated in due course… (before anyone asks “Where’s the Docker update??”)~~

Update: Docker containers now tagged at :v5.4

Core:

Only use ‘Location:’ header for FTL update check on Github API #3987 (@dschaper)
Allow @ in adlist URLs #3912 (@mdujava)
Change wording in whiptail for adlist selection #3943 (@yubiuser)
Further failsafe check for available APT packages #3537 (@MichaIng)
Remove deprecated malwaredomains list #3937 (@yubiuser)
Fix connection mechanism between Chronometer and FTL #3954 (@DL6ER )
Fix release check for centos stream #3958 (@bcambl)

Web:

Implement dark theme on the modal dialogs #1674 (@kevlg)
Add more query type names to title of Query Log instead of “type ” #1671 (@Daxtorim)
Fix sorting by reply in Query Log #1669 (@Daxtorim)
Change radius to 10px for a more modern look. #1691 (@Gontier-Julien)
Remove unnecessary backround-color for the interface. #1692 (@Gontier-Julien)
Fix gray space on the left side for cleaner look. #1693 (@Gontier-Julien)
Fix charts overflowing. #1694 (@Gontier-Julien)

FTL:

New

Implement support for displaying exact type instead of just OTHER #1013
Add new query types SVCB and HTTPS #1010 (@DL6ER)
These queries where shown as OTHER before. Now they can be distinguished on the query log pages and are included as separate items in the daily statistics.
Detect and handle interface changes of clients with the same IP #999 (@DL6ER)
Update SQLite3 to 3.34.0 #1006 (@DL6ER)
We also expose a full-fledged SQLite3 shell interface through pihole-FTL sqlite3

Fixes

Fix for errno not being set by posix_fallocate() #1023 (@DL6ER)
Check for validity of iface pointer before dereferencing it #1018 (@DL6ER)
Don’t show retried queries when filtering for blocked queries #1022 (@Daxtorim)
Do not record NXDOMAIN from DNS cache as “regex blocked” #1014 (@DL6ER)
Added missing NS query type to getQueryTypes() #1007 (@Daxtorim)
Do not return regex idx if privacy level > 0 #1016 (@DL6ER)

Notable Replies

DanSchaper says:

2021-01-16

anon55913113:

it is contained in pihole-FTL just as DNSmasq is.

That.

Edlt:

You can actually symlink pihole-FTL to sqlite3 and run sqlite3 normally on the command line.

Yes.

github.com

pi-hole/FTL/blob/6bd0988663aec98ba1bb579be506473e2665caac/src/database/sqlite3.h#L126


** within its configuration management system.  ^The SQLITE_SOURCE_ID
** string contains the date and time of the check-in (UTC) and a SHA1
** or SHA3-256 hash of the entire source tree.  If the source code has
** been edited in any way since it was last checked in, then the last
** four hexadecimal digits of the hash may be modified.
**
** See also: [sqlite3_libversion()],
** [sqlite3_libversion_number()], [sqlite3_sourceid()],
** [sqlite_version()] and [sqlite_source_id()].
*/
#define SQLITE_VERSION        "3.34.0"
#define SQLITE_VERSION_NUMBER 3034000
#define SQLITE_SOURCE_ID      "2020-12-01 16:14:00 a26b6597e3ae272231b96f9982c3bcc17ddec2f2b6eb4df06a224b91089fed5b"
/*
** CAPI3REF: Run-Time Library Version Numbers
** KEYWORDS: sqlite3_version sqlite3_sourceid
**
** These interfaces provide the same information as the [SQLITE_VERSION],
** [SQLITE_VERSION_NUMBER], and [SQLITE_SOURCE_ID] C preprocessor macros
** but are associated with the library instead of the header file.  ^(Cautious

PromoFaux says:

2021-01-16

Seems like everyone is saying it, and I feel left out.

Yes.
MichaIng says:

2021-01-17

Ah interesting, does it mean that the sqlite(3) package installed as dependency is actually obsolete, especially now that pihole-FTL sqlite3/sql CLI is available?
deHakkelaar says:

2021-01-17
DanSchaper:

You can actually symlink pihole-FTL to sqlite3 and run sqlite3 normally on the command line.

Nice.
For the ones that dont have the sqlite3 package installed:
```
pi@ph5:~ $ apt policy sqlite3
sqlite3:
  Installed: none
  Candidate: 3.27.2-3+deb10u1
[..]
```
```
pi@ph5:~ $ stat /usr/bin/sqlite3
stat: cannot stat '/usr/bin/sqlite3': No such file or directory
```
But still want sqlite3 available on the prompt, you can symlink with below:
```
pi@ph5:~ $ sudo ln -s /usr/bin/pihole-FTL /usr/bin/sqlite3
pi@ph5:~ $
```
And test:
```
pi@ph5:~ $ sqlite3 --version
3.34.0 2020-12-01 16:14:00 a26b6597e3ae272231b96f9982c3bcc17ddec2f2b6eb4df06a224b91089fed5b
```
```
pi@ph5:~ $ sqlite3 /etc/pihole/pihole-FTL.db ".stats"
Memory Used:                         0 (max 0) bytes
Number of Outstanding Allocations:   0 (max 0)
Number of Pcache Overflow Bytes:     4104 (max 4104) bytes
[..]
```

Continue the discussion discourse.pi-hole.net

12 more replies

Pi-hole Core v5.2.3, Web v5.3 and FTL v5.4 released!

Pi-hole Core v5.2.3, Web v5.3 and FTL v5.4 released!

Core:

Web:

FTL:

New

Fixes

Notable Replies

Continue the discussion discourse.pi-hole.net

Participants

Search

Archives

Subscribe to Blog via Email