In 1.1.6 you can make several sql.conf modules with different accounting queries. Then sort out which NAS uses which in acct_users file. Read about multiple sql instances : http://wiki.freeradius.org/Rlm_sql Ivan Kalik Kalik Informatika ISP Dana 26/7/2007, "Nicolas Velazquez" <nicolas.velazquez@uam.es> piše:
Thank you very much Ivan. It´s very useful to know that 2.0 could include this features.
But, also, it's very useful to know if 1.1.6 includes or not any of these. And this is an important question. In the past I wasted so much time reading, searching and testing features that finally were impossible for a certain version of software .....
Another key is the stability. 2.0 is a pre-release and the service must not support outages or bugs. Of course, we shall update to 2.0 as soon as the software can be reasonably stable. But now, the only programmed update in the next future is 1.1.7.
Thanks again for such useful information
Nicolas
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