Message-ID: <C08766F49249D411AC9D00508BD9216905008941@GRUADMD> From: email@example.com Subject: RE: [RadiusNT] Redirecting Inactive Customers Date: Wed, 9 Jul 2003 15:32:58 -0400
I'm guessing that you are handing out IP's from the NAS
device since you asked how to do it from SQL. If that is
the case, in my opinion it's much easier to add another
pool of addresses that are something like 192.168.1.x and
provide a different DNS server for those addresses.
This is all easily accomplished in RadiusNT. I personally
made another RadATConfig and when a deadbeat user doesn't
pay, move their account type to that.
Then when they log in, they get a bogus IP, and the only
thing the DNS server resolves is the same IP for any query.
That IP, is a web server directing them to pay their bill.
15 ways to skin the cat, just depends on what works for you.
-- David A. Niblett | email: firstname.lastname@example.org Network Administrator | Phone: (352) 334-3400 Gainesville Regional Utilities | Web: http://www.gru.net/
-----Original Message----- From: Dale E. Reed Jr. [mailto:email@example.com] Sent: Wednesday, July 09, 2003 3:01 PM To: firstname.lastname@example.org Subject: RE: [RadiusNT] Redirecting Inactive Customers
> Can anyone offer any assistance on how to use radiusnt/sql7 to hand > off ip's. The radius docs are quite limited in the discussion of ip > pools.
There are three tables you have to add entries to:
ServerGroups - Create A ServerGroup and one or more Servers with that ServerGroupID
RadIPGroups - Create a RadIPGroup and one or more RadIPAddresses with that RadIPGroupID
RadIPAccountTypes - This table ties ServerGroups, RadIPGroups and AccountTypes together. You need any entry in for atleast each ServerGroup. You can least AccountTypeID and RadIPGroupID NULL to cover all AccountTypes/IPGroups or any combination.
If you are not familar with SQL Server, I'd recommend looking at Emerald Express. It has a full web front for managing all the User and RADIUS database information and we offer upgraded from RADIUS to Emerald Express. Please contact our sales group for more information on Emerald Express.
This is a user supported list. If you require assistance from IEA Software's Support Engineers, please check out our Support resources at http://www.iea-software.com/support.
For more information about this list (including removal) go to: http://www.iea-software.com/support/maillists/liststart