Re: Freeradius 3.0.19 causes 'acctterminatecause' cannot be null

On Mar 17, 2020, at 6:45 PM, Houman <houmie@gmail.com> wrote:

I'm using Freeradius 3.0.19 on Ubuntu 19.10. The default schema in /etc/freeradius/3.0/mods-config/sql/main/mysql/schema.sql doesn't seem to work. I get the following error message, when connecting with my NAS.

(3) sql: ERROR: rlm_sql_mysql: ERROR 1048 (Column 'acctterminatecause' cannot be null): 23000

I have attached the detailed log.

The queries added in 3.0.18 had NULL for the 'acctterminatecause' field. That should just be ''. I've pushed a fix to GitHub. Alan DEKok.