Spire 1.6.4 and 1.7.0 releases for Linux/arm64 fail down with sqlite3 settings in config

[bellycat77]

• Version: 1.6.4 and 1.7.0
• Platform: Linux bab2ff3aacde 5.15.49-linuxkit-pr CLI authentication #1 SMP PREEMPT Thu May 25 07:27:39 UTC 2023 aarch64 GNU/Linux
• Subsystem: server
  The Spire server got from release archives https://github.com/spiffe/spire/releases/download/v1.7.0/spire-1.7.0-linux-arm64-glibc.tar.gz and https://github.com/spiffe/spire/releases/download/v1.6.4/spire-1.6.4-linux-arm64-glibc.tar.gz fails down when ran in VM with error like:

# ./spire-1.6.4/bin/spire-server run -config spire-1.6.4/conf/server/server.conf
WARN[0000] default_x509_svid_ttl is too high for the configured ca_ttl value. SVIDs with shorter lifetimes may be issued. Please set default_x509_svid_ttl to 28h or less, or the ca_ttl to 288h or more, to guarantee the full default_x509_svid_ttl lifetime when CA rotations are scheduled. 
WARN[0000] Current umask 0022 is too permissive; setting umask 0027 
INFO[0000] Configured                  admin_ids="[]" data_dir=./data/server
INFO[0000] Opening SQL database             db_type=sqlite3 subsystem_name=sql
ERRO[0000] Fatal run error                error="sqlite3 is not a supported dialect when CGO is not enabled"
ERRO[0000] Server crashed                error="sqlite3 is not a supported dialect when CGO is not enabled"

Environment details
OS: macOS Ventura 13.4/ CPU M1
Docker Desktop: v4.21.1
Docker Engine: 24.0.2
Used docker images: golang:1.20.5-buster and arm64v8/ubuntu:22.04

N.B.: The server built inside the container from sources works well

[bellycat77]

The steps for reproducing in MacOS:

% docker pull golang:1.20.5-buster
% docker run -it golang:1.20.5-buster
root@bb2e1925286c:/go# cd /
root@bb2e1925286c:/# wget https://github.com/spiffe/spire/releases/download/v1.7.0/spire-1.7.0-linux-arm64-glibc.tar.gz
root@bb2e1925286c:/# tar zxf spire-1.7.0-linux-arm64-glibc.tar.gz
root@bb2e1925286c:/# spire-1.7.0/bin/spire-server run -config spire-1.7.0/conf/server/server.conf 
WARN[0000] default_x509_svid_ttl is too high for the configured ca_ttl value. SVIDs with shorter lifetimes may be issued. Please set default_x509_svid_ttl to 28h or less, or the ca_ttl to 288h or more, to guarantee the full default_x509_svid_ttl lifetime when CA rotations are scheduled. 
WARN[0000] Current umask 0022 is too permissive; setting umask 0027 
INFO[0000] Configured                                    admin_ids="[]" data_dir=./data/server
INFO[0000] Opening SQL database                          db_type=sqlite3 subsystem_name=sql
ERRO[0000] Fatal run error                               error="sqlite3 is not a supported dialect when CGO is not enabled"
ERRO[0000] Server crashed                                error="sqlite3 is not a supported dialect when CGO is not enabled"
root@bb2e1925286c:/# 

[bellycat77]

It looks like release 1.7.2 didn't solve the issue

% docker pull golang:1.20.5-buster
% docker run -it golang:1.20.5-buster
root@7d3831308416:/go# wget https://github.com/spiffe/spire/releases/download/v1.7.2/spire-1.7.2-linux-arm64-glibc.tar.gz
root@7d3831308416:/go# tar zxf spire-1.7.2-linux-arm64-glibc.tar.gz 
root@7d3831308416:/go# spire-1.7.2/bin/spire-server run -config spire-1.7.2/conf/server/server.conf 
WARN[0000] default_x509_svid_ttl is too high for the configured ca_ttl value. SVIDs with shorter lifetimes may be issued. Please set default_x509_svid_ttl to 28h or less, or the ca_ttl to 288h or more, to guarantee the full default_x509_svid_ttl lifetime when CA rotations are scheduled. 
WARN[0000] Current umask 0022 is too permissive; setting umask 0027 
INFO[0000] Configured                                    admin_ids="[]" data_dir=./data/server
INFO[0000] Opening SQL database                          db_type=sqlite3 subsystem_name=sql
ERRO[0000] Fatal run error                               error="sqlite3 is not a supported dialect when CGO is not enabled"
ERRO[0000] Server crashed                                error="sqlite3 is not a supported dialect when CGO is not enabled"