Just updated to OPNsense 26.7, went fairly well, no issues on my side. The dotnet package was nuked however. Thanks to @piepre for mentioning that repository. With https://github.com/sec/dotnet-core-freebsd-source-build, it is possible to upgrade to Technitium DNS Server 15.x due to requiring .NET 10 (which seems to not be available in the official FreeBSD repositories) on FreeBSD 15.
Regarding SQLite - There just seems to be a missing symlink. Beware, potentially dangerous assumptions following - I found https://forums.truenas.com/t/please-please-freebsd-gurus-i-need-your-help/14926/23 which suggested /usr/local/lib/libsqlite3.so (probably coming via the sqlite3 package) is the same as lib3_sqlite that Technitium DNS complains about. So I just symlinked it:
I suppose this symlink might go stale in the future, but it works (for now).
Regarding SQLite - There just seems to be a missing symlink. Beware, potentially dangerous assumptions following - I found https://forums.truenas.com/t/please-please-freebsd-gurus-i-need-your-help/14926/23 which suggested /usr/local/lib/libsqlite3.so (probably coming via the sqlite3 package) is the same as lib3_sqlite that Technitium DNS complains about. So I just symlinked it:
Code Select
# show the libsqlite3.so
$ file /usr/local/lib/libsqlite3.so
/usr/local/lib/libsqlite3.so: ELF 64-bit LSB shared object, x86-64, version 1 (FreeBSD), dynamically linked, for FreeBSD 15.1, stripped
# install dotnet 10 and create symlinks; wget omitted
$ mkdir /opt/dotnet/dotnet-sdk-10.0.110-freebsd.15
$ tar zxf dotnet-sdk-10.0.110-freebsd.15-x64.tar.gz -C /opt/dotnet/dotnet-sdk-10.0.110-freebsd.15
$ ln -s /opt/dotnet/dotnet-sdk-10.0.110-freebsd.15/dotnet /usr/local/bin/dotnet
$ ln -s /usr/local/lib/libsqlite3.so /opt/dotnet/dotnet-sdk-10.0.110-freebsd.15/shared/Microsoft.NETCore.App/10.0.10/libe_sqlite3
$ file /opt/dotnet/dotnet-sdk-10.0.110-freebsd.15/shared/Microsoft.NETCore.App/10.0.10/libe_sqlite3
/opt/dotnet/dotnet-sdk-10.0.110-freebsd.15/shared/Microsoft.NETCore.App/10.0.10/libe_sqlite3: symbolic link to /usr/local/lib/libsqlite3.so
I suppose this symlink might go stale in the future, but it works (for now).
"