<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>
Got it sorted!<BR>
<BR>
I had two files on the "sites-enabled" directory, one was the default and another one called defaul.bak, which i had created and tested with some configs.<BR>
<BR>
By starting the radius server with -X option and piping the output to a file:<BR>
<BR>
radiusd -X > file<BR>
<BR>
i was able to verify that radiusd was reading both files and giving preference to the .bak file, so i deleted the .bak file and it worked at first time.<BR>
<BR>
<BR>
Thanks a lot for your help.<BR>
<BR>
Lucio<BR>
<BR><BR>> To: freeradius-users@lists.freeradius.org<BR>> Subject: RE: Freeradius/MySQL - Dynamic IP address, help pls?<BR>> Date: Wed, 12 Nov 2008 12:36:59 +0100<BR>> From: tnt@kalik.net<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>> >authorize { sql}<BR>> >authenticate { sql}<BR>> >preacct { acct_unique}<BR>> >accounting { sqlippool}<BR>> >session { sql}<BR>> >post-auth {<BR>> > sqlippool}<BR>> ><BR>> <BR>> In accountung and post-auth you add pool name (main_pool) not sqlippool.<BR>> There should be entries for main_pool already there (commented out).<BR>> <BR>> > <BR>> >then populate the table "radippool" with:<BR>> > <BR>> >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;;<BR>> <BR>> You just need to add the pool name and the IP address.<BR>> <BR>> >Then the table "radgroupcheck" with:<BR>> > <BR>> >GroupName: dynamic <BR>> >Attribute: Pool-Name <BR>> >op: :=<BR>> >Value: main_pool<BR>> > <BR>> <BR>> OK.<BR>> <BR>> > <BR>> >Then the table "radusergroup"<BR>> > <BR>> >UserName: macaco<BR>> >GroupName: dynamic<BR>> >priority: 0<BR>> >Nothing on the table "radgroupreply" or "radreply"<BR>> > <BR>> >Is this right?<BR>> ><BR>> <BR>> Yes.<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 />Click here for FREE customisable desktop wallpapers. <a href='http://wallpapers.msn.com/?ocid=[B001MSN42A0716B]' target='_new'>Get them Now!</a></body>
</html>