FreeRADIUS SQl Ippool problem -

[Taz Manian]

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 at realm     Password   :=    1234567
mysql> select * from usergroup; 
+---------------+--------------------+----------+ 
|username      | GroupName          | priority |
+---------------+--------------------+----------+ 
username at 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 at fajar.net
> To: djtaz at iol.ie; freeradius-users at lists.freeradius.org
> 
> On Thu, Jun 28, 2012 at 8:22 PM, Taz Manian <djtazie at 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
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20120629/b20a696d/attachment.html>