Long SQL queries in attributes

[Mike Jenkins]

Perhaps try the latest version of mysql and stored procedures and / or 
triggers.


Regards

Mike


----- Original Message ----- 
From: "Pedro Ribeiro" <pribeiro-bulk at net.ipl.pt>
To: <freeradius-users at lists.freeradius.org>
Sent: Tuesday, November 29, 2005 2:12 PM
Subject: Long SQL queries in attributes


> Hello freeradius-users,
>
>  I'm having trouble using long (>253 chars) SQL queries in the
>  "users" file.
>
>  It seems the limitations of attribute size are being applied to
>  SQL queries even before expanding %{...} variables.
>
>  Example:
>
>>DEFAULT NAS-Port-Type == 'Wireless-802.11', Service-Type == 'Login-User', 
>>Client-IP-Address != 127.0.0.1
>>        IPLNet-VLAN = `%{sql:SELECT DISTINCT VLAN FROM alunos.RadiusVLAN 
>> AS v,alunos.Bindings AS b WHERE (Realm = '%{Realm}' OR Realm IS NULL) AND 
>> (HuntgroupName = '%{HuntgroupName}' OR HuntgroupName IS NULL) AND (User = 
>> SUBSTRING_INDEX('%{reply:User-Name}','@',1) AND Domain = '%{Realm}' AND 
>> v.CodigoCurso = b.CodigoCurso OR v.CodigoCurso IS NULL) ORDER BY 
>> v.CodigoCurso DESC,Realm DESC,HuntgroupName DESC LIMIT 1:-1003}`,
>>        Fall-Through = Yes
>
>  Is there any way to overcome this limitation ??
>
>  TIA.
>
> -- 
> Best regards,
> Pedro                          mailto:pribeiro-bulk at net.ipl.pt
>
> -
> List info/subscribe/unsubscribe? See 
> http://www.freeradius.org/list/users.html
>