Debian 12 and Azure SQL setup issues (trying unixodb/ FreeTDS / iODBC) .

[Olaf]

Dear users,

After 6 years running Freeradius on CentOS 7 successfully it's time to
migrate to Debian12.
CentOS7 setup: Freeradius 3, FreeTDS and unixodbc. No setup issues.

On my new Debian 12.2 server things seem not that easy.
By default, Freeradius is not compiled with unixdbc.
Ok, I'm not an advanced user on compile from source but ending up with
things like:

configure: WARNING: silently not building rlm_sql_unixodbc. configure:
WARNING: FAILURE: rlm_sql_unixodbc requires: libodbc sql.h.

https://serverfault.com/questions/448365/debian-build-the-freeradius-package-with-unixodbc-support
.
No solution for Debian 12.unixodbc-(dev) is installed but still...

##############################################################
Next try is to use iODBC.
Also not working. iodbc modules on debian12 are 12+ years old.
Ok compiling from source and issues again;

configure.ac:320: error: possibly undefined macro: AM_PATH_GTK
      If this token and others are legitimate, please use m4_pattern_allow.
      See the Autoconf documentation.
make: *** [/usr/share/cdbs/1/class/autotools-files.mk:71:
debian/stamp-autotools-files] Error 1
dpkg-buildpackage: error: debian/rules build subprocess returned exit
status 2

Got stuck again.
##############################################################

Next try is to use FreeTDS module with
/usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so
odbc.ini, odbcinst.ini and FreeTDS.conf configured as it should be.

no luck still,
freeradius -X always show:

rlm_sql (sql): Opening additional connection (0), 1 of 32 pending slots used
rlm_sql_freetds: unable to establish db to symbolic servername mydatabasedsn
rlm_sql_freetds: client error: severity(0), number(34), origin(0),
layer(0): Adaptive Server connection failed
rlm_sql_freetds: socket destructor called, closing socket
rlm_sql (sql): Opening connection failed (0)
rlm_sql (sql): Removing connection pool
/etc/freeradius/mods-enabled/sql[27]: Instantiation failed for module "sql"

Got stuck again.
With isql and tsql i can connect manually, so the server>azure sql link
works.
No issues with that.

Summary of my request:
If anyone could provide me some help how to get a working sql connection
from Freeradius to azure sql on debian12 would be great, regardless of the
connection method.
Or it's a missing (for me unknown param in mods-enabled\sql)

Thanks,
Olaf