multiple NAS's and Mysql

[Wayne Lee]

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