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_key
2;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@lists.freeradius.org
> Subject: Re: Freeradius/MySQL - Dynamic IP address, help pls?
> Date: Tue, 11 Nov 2008 19:39:50 +0100
> From: tnt@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

---

BigSnapSearch.com - 24 prizes a day, every day. Search now