<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 for the input so far everyone.<p>Can you guys confirm that this is the correct format for the SQl side of things please ?<p>Im still having problems and just want to confirm that this is correct.<p> <p> <p>mysql> select * from radcheck; <br>+----+--------------------+--------------------+----+------------+ <br>| id | username | attribute | op | value | <br>+----+--------------------+--------------------+----+------------+ <br> 1 <a href="mailto:username@realm">username@realm</a> Password := 1234567<p><br>mysql> select * from usergroup; <br>+---------------+--------------------+----------+ <br>|username | GroupName | priority |<br>+---------------+--------------------+----------+ <br><a href="mailto:username@realm">username@realm</a> MyGroup 1<p> <p>mysql> select * from radgroupcheck; <br>+----+---------------------+-----------+----+---------------+ <br>| id | groupname | attribute | op | value | <br>+----+---------------------+-----------+----+---------------+ <br> 1 MyGroup Pool-Name := EZ_POOL_NAME<p><br>mysql> select * from radippool; <br>+----+---------------+-----------------+--------------+-----------------+------------------+-------------+----------+----------+<br>| id | pool_name | framedipaddress | nasipaddress | calledstationid | callingstationid | expiry_time | username | pool_key |<br>+----+---------------+-----------------+--------------+-----------------+------------------+-------------+----------+----------+ <br> 1 EZ_POOL_NAME 192.168.1.2 0000-00-00 00:00:00 <br> 2 EZ_POOL_NAME 192.168.1.3 0000-00-00 00:00:00 <br> <br> <br>mysql> select * from radgroupreply; <br>+----+-----------------+---------------+-------+-------------+ <br>| id | GroupName | Attribute | Op | Value | <br>+----+-----------------+---------------+-------+-------------+ <br> 1 EZ_POOL_NAME Framed-MTU := 1500<br> 2 EZ_POOL_NAME Service-Type := Framed-User<br> 3 EZ_POOL_NAME Framed-Protocol := PPP<br><p> <p>If theres anything im missing it would help<p> <p>Thanks<p> <p> <p> <p><br> <div><div id="SkyDrivePlaceholder"></div>> Date: Thu, 28 Jun 2012 20:38:52 +0700<br>> Subject: Re: FreeRADIUS SQl Ippool problem -<br>> From: list@fajar.net<br>> To: djtaz@iol.ie; freeradius-users@lists.freeradius.org<br>> <br>> On Thu, Jun 28, 2012 at 8:22 PM, Taz Manian <djtazie@hotmail.com> wrote:<br>> > I did check the wiki , i have been on it for the last 3 days trying to<br>> > figure this out<br>> ><br>> > I did a search for Pool-Name and i got 4 different results as below<br>> ><br>> > http://wiki.freeradius.org/search?q=Pool-Name<br>> ><br>> > http://wiki.freeradius.org/Rlm_sqlippool<br>> <br>> Did you notice I specifically mentioned that page?<br>> <br>> > http://wiki.freeradius.org/Rlm_ippool<br>> > http://wiki.freeradius.org/Users<br>> > http://wiki.freeradius.org/Ippool%20and%20radius%20clients<br>> ><br>> > I checked each one of them and not one said anything about radcheck or<br>> > radreply.<br>> <br>> Did you read this paragraph?<br>> <br>> "<br>> To assign a user an IP from a pool you simply need to have a Pool-Name<br>> Attribute (Keep in mind that it is a CONTROL attribute, not a reply<br>> attribute) in the required configuration file, which is either in<br>> files(users), sql or any other type of configuration schema.<br>> "<br>> <br>> It should be clear enough that Pool-Name should not be in<br>> rad(group)reply (since that table holds reply attributes).<br>> <br>> If you don't know where to put CONTROL attribute (which is in<br>> rad(group)check, btw), then we might need to add an entry for that.<br>> <br>> > I checked on Google and found some pages that said TO USE Framed-Pool , and<br>> > i could see that when i ran radiusd -X<br>> <br>> Your primary source of information should be the included<br>> documentation (comments on the config file, man pages, etc).<br>> <br>> After that, the wiki.<br>> <br>> After that, this list.<br>> <br>> If you decide to follow some random page, then no wonder you get random result.<br>> <br>> -- <br>> Fajar<br>> -<br>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html<br></div> </div></body>
</html>