Thanks for the input so far everyone.

Can you guys confirm that this is the correct format for the SQl side of things please ?

Im still having problems and just want to confirm that this is correct.

 

 

mysql> select * from radcheck;
+----+--------------------+--------------------+----+------------+
| id | username        | attribute          | op | value      |
+----+--------------------+--------------------+----+------------+
  1  username@realm     Password   :=    1234567


mysql> select * from usergroup;
+---------------+--------------------+----------+
|username      | GroupName          | priority |
+---------------+--------------------+----------+
username@realm      MyGroup          1

 

mysql> select * from radgroupcheck;
+----+---------------------+-----------+----+---------------+
| id | groupname           | attribute | op | value         |
+----+---------------------+-----------+----+---------------+
  1  MyGroup       Pool-Name  :=    EZ_POOL_NAME


mysql> select * from radippool;    
+----+---------------+-----------------+--------------+-----------------+------------------+-------------+----------+----------+
| id | pool_name     | framedipaddress | nasipaddress | calledstationid | callingstationid | expiry_time | username | pool_key |
+----+---------------+-----------------+--------------+-----------------+------------------+-------------+----------+----------+
   1  EZ_POOL_NAME  192.168.1.2         0000-00-00 00:00:00    
   2  EZ_POOL_NAME  192.168.1.3         0000-00-00 00:00:00    
  
  
mysql> select * from radgroupreply;
+----+-----------------+---------------+-------+-------------+
| id | GroupName       | Attribute     | Op    | Value       |
+----+-----------------+---------------+-------+-------------+
  1  EZ_POOL_NAME  Framed-MTU  :=    1500
  2  EZ_POOL_NAME  Service-Type  :=    Framed-User
  3  EZ_POOL_NAME  Framed-Protocol :=    PPP

 

If theres anything im missing it would help

 

Thanks

 

 

 


 

> Date: Thu, 28 Jun 2012 20:38:52 +0700
> Subject: Re: FreeRADIUS SQl Ippool problem -
> From: list@fajar.net
> To: djtaz@iol.ie; freeradius-users@lists.freeradius.org
>
> On Thu, Jun 28, 2012 at 8:22 PM, Taz Manian <djtazie@hotmail.com> wrote:
> > I did check the wiki , i have been on it for the last 3 days trying to
> > figure this out
> >
> > I did a search for Pool-Name and i got 4 different results as below
> >
> > http://wiki.freeradius.org/search?q=Pool-Name
> >
> > http://wiki.freeradius.org/Rlm_sqlippool
>
> Did you notice I specifically mentioned that page?
>
> > http://wiki.freeradius.org/Rlm_ippool
> > http://wiki.freeradius.org/Users
> > http://wiki.freeradius.org/Ippool%20and%20radius%20clients
> >
> > I checked each one of them and not one said anything about radcheck or
> > radreply.
>
> Did you read this paragraph?
>
> "
> To assign a user an IP from a pool you simply need to have a Pool-Name
> Attribute (Keep in mind that it is a CONTROL attribute, not a reply
> attribute) in the required configuration file, which is either in
> files(users), sql or any other type of configuration schema.
> "
>
> It should be clear enough that Pool-Name should not be in
> rad(group)reply (since that table holds reply attributes).
>
> If you don't know where to put CONTROL attribute (which is in
> rad(group)check, btw), then we might need to add an entry for that.
>
> > I checked on Google and found some pages that said TO USE Framed-Pool , and
> > i could see that when i ran radiusd -X
>
> Your primary source of information should be the included
> documentation (comments on the config file, man pages, etc).
>
> After that, the wiki.
>
> After that, this list.
>
> If you decide to follow some random page, then no wonder you get random result.
>
> --
> Fajar
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html