NAS in sql and returning specific VSAs

[Vincent, Fabien]

Sorry, CTRL+Enter is not a good keyboard on Monday Morning ;)

 

So, I return to the NAS some VSAs depending LDAP Group like this :

 

if (Ldap-Group == "MyGroup") { 

update reply { 

# Rules for Cisco Routeurs 

Service-Type = NAS-Prompt-User

cisco-avpair = "shell:priv-lvl=15"

 

# Rule for 3Com Access

Service-Type += Login-User 

Login-Service += Telnet

Login-Service += 3com-50 

H3C-Exec_Privilege = 3 

3Com-User-Access-Level = 3Com-Manager 

 

#AV-Pair for F5 BigIP LTM Access (see /usr/share/freeradius/dictionnary.f5) 

F5-LTM-User-Role = Manager 

F5-LTM-User-Info-1 = myGroup

F5-LTM-User-Partition = Common 

F5-LTM-User-Shell = bpsh 

 

Etc 
.

 

Is there any to check a NAS attribute to split replies, with sort of VSAs
groups for each NAS type, in post-auth ? 

 

I have the following nas table :

 

mysql> describe nas;

+-------------+--------------+------+-----+---------------+----------------+

| Field       | Type         | Null | Key | Default       | Extra          |

+-------------+--------------+------+-----+---------------+----------------+

| id          | int(10)      | NO   | PRI | NULL          | auto_increment |


| nasname     | varchar(128) | NO   | MUL | NULL          |                |


| shortname   | varchar(32)  | YES  |     | NULL          |                |


| type        | varchar(30)  | YES  |     | other         |                |


| ports       | int(5)       | YES  |     | NULL          |                |


| secret      | varchar(60)  | NO   |     | secret        |                |


| server      | varchar(64)  | YES  |     | NULL          |                |


| community   | varchar(50)  | YES  |     | NULL          |                |


| description | varchar(200) | YES  |     | RADIUS Client |                |


+-------------+--------------+------+-----+---------------+----------------+

 

Thanks in advance for your help !

 

Fabien VINCENT

Ingénieur Réseaux & Sécurité / ASSR Produits

Niveau 3 - Infrastructure & Produits

 <mailto:fabien.vincent at coreye.fr> fabien.vincent at coreye.fr

 

coreye

Parc de la Haute Borne

22, rue Hergé

59650 Villeneuve d'Ascq

 <http://www.pictime.com/> www.pictime.com

 

 

De : Vincent, Fabien 
Envoyé : lundi 7 novembre 2011 10:31
À : 'freeradius-users at lists.freeradius.org'
Objet : NAS in sql and returning specific VSAs

 

Hi all,

 

I have one question about Free Radius and NAS in sql database.

 

I return to the NAS some VSAs depending LDAP User-Group like this : 

 

 

 

Fabien VINCENT

Ingénieur Réseaux & Sécurité / ASSR Produits

Niveau 3 - Infrastructure & Produits

 <mailto:fabien.vincent at coreye.fr> fabien.vincent at coreye.fr

 

coreye

Parc de la Haute Borne

22, rue Hergé

59650 Villeneuve d'Ascq

 <http://www.pictime.com/> www.pictime.com

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20111107/c3860257/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 2412 bytes
Desc: not available
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20111107/c3860257/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3746 bytes
Desc: not available
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20111107/c3860257/attachment.bin>