SQL and different accounting records by NAS

Nicolas Velazquez nicolas.velazquez at uam.es
Thu Jul 26 12:42:13 CEST 2007


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





More information about the Freeradius-Users mailing list