Build-time error: sqlite3 >= 3.20.0 must be compiled with --enable-fts5

[Reiner Steffens]

Dear gnome at FreeBSD.org <mailto:gnome at FreeBSD.org>,

With a fresh ports tree as of this morning (2020-06-20 PDT), while compiling Samba 4.11, the following could be observed:

checking for sqlite3.h... (cached) yes
checking whether SQLite3 has required FTS features... no
configure: error: sqlite3 >= 3.20.0 must be compiled with --enable-fts5
===>  Script "configure" failed unexpectedly.
Please report the problem to gnome at FreeBSD.org [maintainer] and attach the
"/usr/ports/sysutils/tracker/work/tracker-2.0.4/config.log" including the
output of the failure of your make command. Also, it might be a good idea to
provide an overview of all packages installed on your system (e.g. a
/usr/local/sbin/pkg-static info -g -Ea).
*** Error code 1

Hence this mail.

Triage:
The default sqlite3 configuration on FreeBSD, when sqlite3 was originally installed as a 
dependency of some other port, long time ago, allegedly did not include --enable-fts5 (as
default). The default has changes since, after a:


/usr/ports/databases/sqlite3 # make rmconfig
/usr/ports/databases/sqlite3 # make config

--enable-fts5

Presumably, fresh installs should not be affected.

Checked:
/usr/ports/UPDATING
but to no avail.

Mitigation:
/usr/ports/databases/sqlite3 # make config
and check: 

--enable-fts5


Next step:
/usr/ports/databases/sqlite3 # make deinstall
/usr/ports/databases/sqlite3 # make reinstall clean

Result:
tracker now builds w/o errors, Samba 4.11 now builds 


Speculation and thoughts:
For the fresh Samba 4.11 build, I enabled

SPOTLIGHT

This appears to have triggered quite some dependencies… including Gnome (?)
Guess I’ll rollback and test w/o SPOTLIGHT
Right, an explicit:

# echo WITHOUT_X11=YES >> /etc/make.conf
may a good idea for a headless NAS, too (J/K)

Pardon my longwinded report, will you?

As requested, attached the files for your reference. Hoping this helps.
Please do not hesitate to ask for more information, happy to help.

Stay Safe,
Reiner