Freeradius/MySQL - Dynamic IP address, help pls?

[Lucio Godoy]

Hi Ivan;
 
Thank you for the quick response. I though on Freeradius version 2.x i needed to work only on the SQL tables, and that i needed to specify on the file "raddb/sites-enabled/default" as:
authorize {        sql}
authenticate {        sql}
preacct {        acct_unique}
accounting {        sqlippool}
session {        sql}
post-auth {
        sqlippool}
 
 
then populate the table "radippool" with:
 
id;pool_name;FramedIPAddress;NASIPAddress;CalledStationId;CallingStationID;expiry_time;username;pool_key2;main_pool;192.168.6.4;;;;0/0/0000;;3;main_pool;192.168.6.5;;;;0/0/0000;;4;main_pool;192.168.6.6;;;;0/0/0000;;5;main_pool;192.168.6.7;;;;0/0/0000;;
Then the table "radgroupcheck" with:
 
GroupName: dynamic 
Attribute: Pool-Name 
op:   :=
Value: main_pool
 
 
Then the table "radusergroup"
 
UserName: macaco
GroupName: dynamic
priority: 0
Nothing on the table "radgroupreply" or "radreply"
 
Is this right?
 
thanks
 
Lucio
 
 
 
 
 
 
 
 
 
 
 
 
 
 
> To: freeradius-users at lists.freeradius.org> Subject: Re: Freeradius/MySQL - Dynamic IP address, help pls?> Date: Tue, 11 Nov 2008 19:39:50 +0100> From: tnt at kalik.net> > >I have read all about: Pool-Name := main_pool, Fall-Through = Yes, the Freeradius WIKI, etc, etc; but can't get anything to work.> > > >Could any body help me to add the right entries on the sql tables for> > > >user: TEST> >Group called: DYNAMIC> >ip pool called: MAIN_POOL> >IP range of 192.168.2.1 till 192.168.2.10> > 1. Configure your pool in raddb/modules/ippool. Read (and follow)> instructions about Pool-Name and db files.> > 2. Add user (test) to the group (dynamic) in radusergroup table.> > 3. Add attribute (Pool-Name), value (main_pool) and operator (:=) to the> group (dynamic) checking in radgroupcheck table.> > Ivan Kalik> Kalik Informatika ISP> > -> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
_________________________________________________________________
See the most popular videos on the web 
http://clk.atdmt.com/GBL/go/115454061/direct/01/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20081111/989fed08/attachment.html>