multiple NAS's and Mysql
Hello List I'm in the process of setting up a freeradius server to replace the old icradius box we have. I can get the server running just fine with Mysql and it's all work really well but I'm stumped on how to do the following. I have checked the lists and google for pointers but frankly I'm lost What I need to be able to do is send back different info based on the incoming request from a set of NAS's. We have L2TP interconnects from multiple providers, most of them are very simple but one is different in that they only require a certain response. They need the following info Standard Framed-Protocol PPP Standard User-Service Framed-User Standard Tunnel-Server-Endpoirt "82.*.*.*" Cisco Cisco-AVPair "vpdn:tunnel-id=provider.net" Standard Tunnel-Type L2TP Standard Tunnel-Medium-Type IP How do I send back just this info for this provider? my SQL foo is rubbish. all other providers send the request direct to my NAS which then grabs the relevant info from my radius ok. I could not get this to work in icradius so we had 2 radius server setup, one for this provider and one for all others Current versions are (running on Debian sarge at the mo) freeradius = 1.0.2-4sarge3 freeradius-mysql = 1.0.2-4sarge3 mysql-server = 4.0.24-10sarge Thanks for your time. Wayne
hi, a single FreeRADIUS server can do this. simply put each range of NASs into different groups and then use the group and groupreply tables in the SQL to do your return code work. if you cant google for "SQL howto freeradius" then http://wiki.freeradius.org/SQL_HOWTO#Configuring_FreeRadius_to_use_SQL if that document does help you enough, then please post to the list with its weaknesses so that it may be strenghtened that HOWTO link is posted each week on this list. how can we make it more obvious? (open question to others who struggle with the SQL and FReeRADIUS) alan
Perhaps you mis-read my post, I have read the SQL howto (and the FAQ and Wiki) before posting to the list and the server it is currently working fine using SQL , I just did not understand how to reply to different NAS's with different info.like I said my SQl foo is rubbish. I guess what I'm really after is some pointers on what the SQL queries would look like or do I not need to edit the queries in sql.conf? I'll upgrade to the latest version and therefore included updated docs. Wayne On Feb 12, 2008 7:19 PM, <A.L.M.Buxey@lboro.ac.uk> wrote:
hi,
a single FreeRADIUS server can do this. simply put each range of NASs into different groups and then use the group and groupreply tables in the SQL to do your return code work.
if you cant google for "SQL howto freeradius" then
http://wiki.freeradius.org/SQL_HOWTO#Configuring_FreeRadius_to_use_SQL
if that document does help you enough, then please post to the list with its weaknesses so that it may be strenghtened
that HOWTO link is posted each week on this list. how can we make it more obvious? (open question to others who struggle with the SQL and FReeRADIUS)
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Wayne Lee wrote:
What I need to be able to do is send back different info based on the incoming request from a set of NAS's.
In 2.0, just write the policy. See "man unlang". Or, use virtual servers. client foo { ipaddr = 1.2.3.4 ... virtual_server = one # or two } See raddb/sites-available/README for more examples.
Current versions are (running on Debian sarge at the mo) freeradius = 1.0.2-4sarge3
Ouch. Please upgrade. Alan DeKok.
participants (3)
-
A.L.M.Buxey＠lboro.ac.uk -
Alan DeKok -
Wayne Lee