SQL Counter query buffer limit freeradius 3.0.10

Herwin Weststrate herwin at quarantainenet.nl
Thu Sep 24 15:10:50 CEST 2015


On 23-09-15 22:59, Michal Tomaszewski wrote:
> Hi,
> 
> SQL Counter has a hardcoded limit for the length of SQL query to probably 1024 bytes.
> When query string is longer freeradius debug shows: "sql: Insufficient query buffer space"
> 
> It seems to be not sufficient in the case of longer, more sophisticated queries, e.g. when the timezone conversions must be applied few times in the single query string or query logic shall contain other data subsets.
> Some our queries reach almost 1500 bytes...
> 
> Is there any other way to define 'long query' SQL statement to be correctly processed by sqlcounter module?

Another workaround that doesn't required custom builds of FreeRADIUS: if
your database-server supports stored procedures you could move all the
logic there and keep the queries in the FR-config short.

-- 
Herwin Weststrate


More information about the Freeradius-Users mailing list