Max length of SQl return string?

Phil Mayers p.mayers at imperial.ac.uk
Thu Nov 28 15:54:56 CET 2013


On 28/11/13 14:41, Alexander Silveröhrt wrote:
> Hello,
>
> We are doing a query which are supposed to comeback with a bunch of
> subscriber accounts.
>
>   update request {
>                  Subscriber-Accounts := "%{sql-cisco-bng:SELECT
> GROUP_CONCAT(username SEPARATOR ';') FROM radcheck WHERE username LIKE
> '%{User-Name}%%'}"
>   }
>
> But it seems that there is a limit on how long the return string can be?

Well, it's a radius attribute, so it's probably 253 bytes.

Not sure if this limit is changed/removed in later versions of the 
server (e.g. for attributes which are internal, since they never go on 
the wire there's no protocol reason to limit their length)


More information about the Freeradius-Users mailing list