SQL and different accounting records by NAS

tnt at kalik.co.yu tnt at kalik.co.yu
Thu Jul 26 14:31:37 CEST 2007


Have a look at 2.0. It can do if/than/else in .conf files so you should
be able to define different sql statements for different cases.

Ivan Kalik
Kalik Informatika ISP


Dana 26/7/2007, "Nicolas Velazquez" <nicolas.velazquez at uam.es> piše:

>Hi,
>
>We are using freeradius 1.1.6, now, to provide 
>access for our wireless network only.
>The accounting is very detailed and 
>comprehensive: IP addresses, usernames,  packets, roles,  APs, SSIDs, etc.
>
>Now, we are starting to use the same radius to 
>give 802.1x access to our wired network.
>
>The key is that the accounting records for a wired switch are VERY different.
>Now, AP and SSID, are nonsense items, for example.
>But we need another records.
>
>Can freeradius use different accounting sql inserts depending on NAS?
>
>Is there any document showing something like this?
>I have read many documents but I can not find a clear answer.
>
>This was the main question.
>
>A related tiny question is as follows.
>The most comfortable configuration will be to use 
>different accounting inserts depending on huntgroups.
>Then we could select sql inserts for one 
>huntgroup (all our wired NASes) and different sql 
>insert for another huntgroup (all our wireless NASes).
>The addition, remove or change of the different 
>NASes could be made modifying only the lists contained in the huntgroups file.
>It could be very clean and useful.
>But, when I read the huntgroups documentation I 
>have  the strong suspect I can´t do this.
>
>Thank you very much in advance,
>
>    Nicolas Velazquez
>
>
>- 
>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
>




More information about the Freeradius-Users mailing list