<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
</style>
</head>
<body class='hmmessage'>
Hi Ivan;<BR>
<BR>
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:<BR><BR>
authorize {<BR> sql<BR>}<BR>
authenticate {<BR> sql<BR>}<BR>
preacct {<BR> acct_unique<BR>}<BR>
accounting {<BR> sqlippool<BR>}<BR>
session {<BR> sql<BR>}<BR>
post-auth {<BR>
sqlippool<BR>}<BR>
<BR>
<BR>
then populate the table "radippool" with:<BR>
<BR>
id;pool_name;FramedIPAddress;NASIPAddress;CalledStationId;CallingStationID;expiry_time;username;pool_key<BR>2;main_pool;192.168.6.4;;;;0/0/0000;;<BR>3;main_pool;192.168.6.5;;;;0/0/0000;;<BR>4;main_pool;192.168.6.6;;;;0/0/0000;;<BR>5;main_pool;192.168.6.7;;;;0/0/0000;;<BR><BR>
Then the table "radgroupcheck" with:<BR>
<BR>
GroupName: dynamic <BR>
Attribute: Pool-Name <BR>
op: :=<BR>
Value: main_pool<BR>
<BR>
<BR>
Then the table "radusergroup"<BR>
<BR>
UserName: macaco<BR>
GroupName: dynamic<BR>
priority: 0<BR><BR>
Nothing on the table "radgroupreply" or "radreply"<BR>
<BR>
Is this right?<BR>
<BR>
thanks<BR>
<BR>
Lucio<BR>
<BR>
<BR>
<BR> <BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>> To: freeradius-users@lists.freeradius.org<BR>> Subject: Re: Freeradius/MySQL - Dynamic IP address, help pls?<BR>> Date: Tue, 11 Nov 2008 19:39:50 +0100<BR>> From: tnt@kalik.net<BR>> <BR>> >I have read all about: Pool-Name := main_pool, Fall-Through = Yes, the Freeradius WIKI, etc, etc; but can't get anything to work.<BR>> > <BR>> >Could any body help me to add the right entries on the sql tables for<BR>> > <BR>> >user: TEST<BR>> >Group called: DYNAMIC<BR>> >ip pool called: MAIN_POOL<BR>> >IP range of 192.168.2.1 till 192.168.2.10<BR>> <BR>> 1. Configure your pool in raddb/modules/ippool. Read (and follow)<BR>> instructions about Pool-Name and db files.<BR>> <BR>> 2. Add user (test) to the group (dynamic) in radusergroup table.<BR>> <BR>> 3. Add attribute (Pool-Name), value (main_pool) and operator (:=) to the<BR>> group (dynamic) checking in radgroupcheck table.<BR>> <BR>> Ivan Kalik<BR>> Kalik Informatika ISP<BR>> <BR>> -<BR>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html<BR><BR><br /><hr />BigSnapSearch.com - 24 prizes a day, every day. <a href='http://clk.atdmt.com/UKM/go/117442309/direct/01/' target='_new'>Search now</a></body>
</html>