[Pkg-freeradius-maintainers] Bug#992207: Freeradius postgresql mod broken in Bullseye

Nick Smith nick at aoeu.uk
Sun Aug 15 20:40:24 BST 2021


Package: freeradius
Version: 3.0.21+dfsg-2.2 amd64

I just built a new Bullseye VM to replace my Buster freeradius VM.  Upon trying to configure it for a postgres backend, 'freeradius -X' fails out with the following:

...
including configuration file /etc/freeradius/3.0/mods-enabled/mschap
including configuration file /etc/freeradius/3.0/mods-enabled/sql
including configuration file /etc/freeradius/3.0/mods-config/sql/main/postgresql/queries.conf
/etc/freeradius/3.0/mods-config/sql/main/postgresql/queries.conf[505]: Parse error: Unterminated string
Errors reading or parsing /etc/freeradius/3.0/radiusd.conf

Looking at line 505 of /etc/freeradius/3.0/mods-config/sql/main/postgresql/queries.conf, it does seem to be missing a line-extending terminator '\' that is present on surrounding lines (the context is that this is in the middle of a ~15-line SQL query):

...
504:                                        AcctUpdateTime = ${....event_timestamp}, \
505:                                        AcctSessionTime = COALESCE(%{%{Acct-Session-Time}:-NULL},
506:                                                (${....event_timestamp_epoch} - EXTRACT(EPOCH FROM(AcctStartTime)))), \
...

Adding the '\' in at the end of the line seems to fix it.

This is a fully stable Bullseye installation, built from the official ISOs released yesterday.



More information about the Pkg-freeradius-maintainers mailing list