Re: [RADIATOR] Question about IP Pool.

2011-08-21 Thread Heikki Vatiainen
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
> 
> 
>  # MySQL DB, DB radius, host localhost
>  DBSource dbi:mysql:xxx
>  DBUsername x
>  DBAuth xxx
> 
>  # 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
> 
> =
> 


-- 
Heikki Vatiainen 

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
radiator@open.com.au
http://www.open.com.au/mailman/listinfo/radiator


[RADIATOR] Question about IP Pool.

2011-08-20 Thread Faisal Imtiaz
Hello,
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.

Many Thanks in advance.
===
here is what my AuthBy looks like


 # MySQL DB, DB radius, host localhost
 DBSource dbi:mysql:xxx
 DBUsername x
 DBAuth xxx

 # 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

=

-- 
Faisal Imtiaz
Snappy Internet&  Telecom
7266 SW 48 Street
Miami, Fl 33155
Tel: 305 663 5518 x 232
Helpdesk: 305 663 5518 option 2 Email: supp...@snappydsl.net


___
radiator mailing list
radiator@open.com.au
http://www.open.com.au/mailman/listinfo/radiator