SQL Accounting and Null Attribute Values

trs therightsock at gmail.com
Thu Mar 2 07:39:06 CET 2006


Accounting queries fail if an attribute is null when supplied as a
value for certain column types.
Partial line from debug output:

radius_xlat: 'UPDATE radacct SET AcctStartTime = '2006-03-02
01:18:04', AcctStartDelay = '',

It fails with:

rlm_sql (sql): Couldn't update SQL accounting START record - ERROR: 
invalid input syntax for type bigint: ""

Can freeradius substitute a zero if an integer attribute is missing
from an accounting packet, instead of just a null value?




More information about the Freeradius-Users mailing list