RE: Freeradius/MySQL - Dynamic IP address, help pls? - FIXED
Hi Ivan;
Got it sorted!
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.
By starting the radius server with -X option and piping the output to a file:
radiusd -X > file
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.
Thanks a lot for your help.
Lucio
> To: freeradius-users@lists.freeradius.org> Subject: RE: Freeradius/MySQL -
> Dynamic IP address, help pls?> Date: Wed, 12 Nov 2008 12:36:59 +0100> From:
> [EMAIL PROTECTED]> > >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.40/0/;;3;main_pool;192.168.6.50/0/;;4;main_pool;192.168.6.60/0/;;5;main_pool;192.168.6.70/0/;;>
> > 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> > -> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
_
BigSnapSearch.com - 24 prizes a day, every day - Search Now!
http://clk.atdmt.com/UKM/go/117442309/direct/01/-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Freeradius/MySQL - Dynamic IP address, help pls?
>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.40/0/;;3;main_pool;192.168.6.50/0/;;4;main_pool;192.168.6.60/0/;;5;main_pool;192.168.6.70/0/;;
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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Freeradius/MySQL - Dynamic IP address, help pls?
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.40/0/;;3;main_pool;192.168.6.50/0/;;4;main_pool;192.168.6.60/0/;;5;main_pool;192.168.6.70/0/;;
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:
> [EMAIL PROTECTED]> > >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/-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius/MySQL - Dynamic IP address, help pls?
>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
