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@net.ipl.pt
Perhaps try the latest version of mysql and stored procedures and / or triggers. Regards Mike ----- Original Message ----- From: "Pedro Ribeiro" <pribeiro-bulk@net.ipl.pt> To: <freeradius-users@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@net.ipl.pt
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (2)
-
Mike Jenkins -
Pedro Ribeiro