<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
Thanks Alan,<p> <p>But the username isnt the problem, that authenticates properly and if i put in <p> mysql> select * from radreply;<br> <br> +----+-------------------------+------------------------+---------------+------+<br> | id | UserName | Attribute | Value | Op |<br> +----+-------------------------+------------------------+---------------+------+<br> | 1 | <a href="mailto:username@realm">username@realm</a> | Framed-IP-Address | 1.2.3.4 | := |<br><p>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.<p>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<p>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.<p>Im just stumped on the ip pools and its the last thing i want to get working so its frustrating.<p> <p>I get no info back for the pools at all when i do a radiusd -X <p> <p>Taz<p> <p> <p> <div><div id="SkyDrivePlaceholder"></div>> Date: Fri, 29 Jun 2012 07:46:36 -0400<br>> From: aland@deployingradius.com<br>> To: djtaz@iol.ie; freeradius-users@lists.freeradius.org<br>> Subject: Re: FreeRADIUS SQl Ippool problem -<br>> <br>> Taz Manian wrote:<br>> > Can you guys confirm that this is the correct format for the SQl side of<br>> > things please ?<br>> ><br>> > Im still having problems and just want to confirm that this is correct.<br>> <br>> It's not.<br>> <br>> > mysql> select * from radcheck;<br>> > +----+--------------------+--------------------+----+------------+<br>> > | id | username | attribute | op | value |<br>> > +----+--------------------+--------------------+----+------------+<br>> > 1 username@realm <mailto:username@realm> Password := 1234567<br>> <br>> Fix that. Honestly, it's been wrong for 6 years. Why do people still<br>> do this?<br>> <br>> See the FAQ for a *correct* example.<br>> <br>> > If theres anything im missing it would help<br>> <br>> a) did you follow the directions?<br>> <br>> b) does it work?<br>> <br>> Alan DeKok.<br>> -<br>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html<br></div> </div></body>
</html>