Freeradius 3.0.19 causes 'acctterminatecause' cannot be null

[Alan DeKok]

> On Oct 13, 2020, at 2:51 AM, Volodymyr Litovka <doka.ua at gmx.com> wrote
> Please, be aware, that queries.conf still contains an error (at least on
> Ubuntu 20.04, freeradius 3.0.20+dfsg-3build1), which appears when adding
> sql_session_start in post_auth section -
> queries.conf/accounting/type/post-auth explicitly inserts NULL for
> 'acctterminatecause' column.
> 
> The patch below fixes this (only for MySQL), but I guess same can be
> done for other dialects:
> 
> --- mods-config/sql/main/mysql/queries.conf.orig 2020-10-13
> 08:49:35.841485192 +0300 +++ mods-config/sql/main/mysql/queries.conf
> 2020-10-13 08:49:58.877127891 +0300 @@ -273,7 +273,7 @@ 0, \
> '%{Called-Station-Id}', \ '%{Calling-Station-Id}', \ - NULL, \ + '', \
> '%{Service-Type}', \ NULL, \ '', \

  That's already fixed in the v3.0.x branch, thanks.

  Alan DeKok.