FreeRADIUS SQl Ippool problem -

[Taz Manian]

Thanks Alan, But the username isnt the problem, that authenticates properly and if i put in        mysql> select * from radreply;
 
      +----+-------------------------+------------------------+---------------+------+
      | id | UserName                | Attribute                | Value          | Op   |
      +----+-------------------------+------------------------+---------------+------+
      |  1 | username at realm      | Framed-IP-Address | 1.2.3.4        | :=   |
Then i get the framed IP address back no problems, the problem is that the pool isnt working at all, and i know its something stupid im doing but i cant see to see it.Ive built 3 radius boxes - one proxy , one for  l2pt tunnels that gets a hand off from the proxy if thats the correct realm and one sql based one (also passed from the proxy) which works fine for userthat have the framed IP's but not for users that have pools. I also have hand offs from a Cisco ACS devices and all of that works perfectly.Im just stumped on the ip pools and its the last thing i want to get working so its frustrating. I get no info back for the pools at all when i do a radiusd -X  Taz   > Date: Fri, 29 Jun 2012 07:46:36 -0400
> From: aland at deployingradius.com
> To: djtaz at iol.ie; freeradius-users at lists.freeradius.org
> Subject: Re: FreeRADIUS SQl Ippool problem -
> 
> Taz Manian wrote:
> > 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.
> 
>   It's not.
> 
> > mysql> select * from radcheck;
> > +----+--------------------+--------------------+----+------------+
> > | id | username        | attribute          | op | value      |
> > +----+--------------------+--------------------+----+------------+
> >   1  username at realm <mailto:username at realm>     Password   :=    1234567
> 
>   Fix that.  Honestly, it's been wrong for 6 years.  Why do people still
> do this?
> 
>   See the FAQ for a *correct* example.
> 
> > If theres anything im missing it would help
> 
>   a) did you follow the directions?
> 
>   b) does it work?
> 
>   Alan DeKok.
> -
> 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/70e760e4/attachment-0001.html>