Freeradius/MySQL - Dynamic IP address, help pls?

[tnt at kalik.net]

>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}
>

In accountung and post-auth you add pool name (main_pool) not sqlippool.
There should be entries for main_pool already there (commented out).

> 
>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;;

You just need to add the pool name and the IP address.

>Then the table "radgroupcheck" with:
> 
>GroupName: dynamic 
>Attribute: Pool-Name 
>op:   :=
>Value: main_pool
> 

OK.

> 
>Then the table "radusergroup"
> 
>UserName: macaco
>GroupName: dynamic
>priority: 0
>Nothing on the table "radgroupreply" or "radreply"
> 
>Is this right?
>

Yes.

Ivan Kalik
Kalik Informatika ISP