On 08/20/2011 09:07 PM, Faisal Imtiaz wrote: Hello Faisal,
> I am currently using Raditor configured with mysql for authenticating > DSL Subscribers. So far we have been allocating fixed IP addresses & > framed routes as needed for the subscribers. > > We have bunch of subscribers who need to be on dynamic IP's. There is > a RADPOOL table, that I can add addresses to either manually or via > AddressPool... > > What I am having trouble with is on What do I need to 'define' for the > user so that Radiator will get an IP address from the RADPOOL Table ? > and What code if any I need to put in radius.cfg for this to happen. Please see goodies/addressallocator.cfg in Radiator distribution package for an example. The idea is to run the normal authentication first followed by AuthBy DYNADDRESS. The AuthByPolicy should be set so that DYNADDRESS is only used if the normal authentication first succeeds. You should probably keep your existing Handler and AuthBy as they are and add a new Handler to match the dynaddress users. This new Handler would have two AuthBys where the first does normal authentication followed by the second AuthBy that does address allocation from AddressPool. You can also have more AuthBys if needed, but the above is a simple extension of your current setup shown below. Best regards, Heikki > Many Thanks in advance. > =========================== > here is what my AuthBy looks like > > <AuthBy SQL> > # MySQL DB, DB radius, host localhost > DBSource dbi:mysql:xxxxxxx > DBUsername xxxxxxxxx > DBAuth xxxxxxxxxxx > > # Define Table and Columns for Authentication > AuthSelect select PASSWORD, SERVICETYPE, > FRAMEDPROTOCOL, TRAFFICSHAPE, ACL, PORTLIMIT, TIMELEFT, IPPOOL, FRAMEDI$ > from SUBSCRIBERS where USERNAME = %0 > AuthColumnDef 0, Password, check > AuthColumnDef 1, GENERIC, check > AuthColumnDef 2, GENERIC, reply > AuthColumnDef 3, GENERIC, reply > AuthColumnDef 4, GENERIC, reply > AuthColumnDef 5, GENERIC, reply > AuthColumnDef 6, GENERIC, reply > AuthColumnDef 7, GENERIC, reply > AuthColumnDef 8, GENERIC, reply > AuthColumnDef 9, GENERIC, reply > AuthColumnDef 10, GENERIC, reply > AuthColumnDef 11, GENERIC, reply > AuthColumnDef 12, GENERIC, reply > > # Define Table and Columns for Accounting > AccountingTable ACCOUNTING > AcctColumnDef USERNAME,User-Name > AcctColumnDef TIME_STAMP,Timestamp,formatted-date,\ > '%Y/%m/%e %H:%M:%S' > AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type > AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer > AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer > AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer > AcctColumnDef ACCTSESSIONID,Acct-Session-Id > AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer > AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause > AcctColumnDef NASIDENTIFIER,NAS-Identifier > AcctColumnDef NASIPADDRESS,NAS-IP-Address > AcctColumnDef NASPORT,NAS-Port,integer > AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address > </AuthBy> > ================================================================================================= > -- Heikki Vatiainen <[email protected]> Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP, DIAMETER etc. Full source on Unix, Windows, MacOSX, Solaris, VMS, NetWare etc. _______________________________________________ radiator mailing list [email protected] http://www.open.com.au/mailman/listinfo/radiator
