Control: tags -1 + confirmed patch upstream
Hi,
> 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.
Ack, this has already been fixed upstream at
https://github.com/FreeRADIUS/freeradius-server/commit/eef366956e2e4a689ab33a0d1f265eb15f749d8d
I will try to make a bullseye-pu upgrade before the next stable update.
Bernhard
