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@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 user

that 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@deployingradius.com
> To: djtaz@iol.ie; freeradius-users@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@realm <mailto:username@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