SQL and different accounting records by NAS

tnt at kalik.co.yu tnt at kalik.co.yu
Thu Jul 26 18:21:43 CEST 2007


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 at 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
>
>




More information about the Freeradius-Users mailing list