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@realm Password := 1234567 mysql> select * from usergroup; +---------------+--------------------+----------+ |username | GroupName | priority | +---------------+--------------------+----------+ username@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@fajar.net To: djtaz@iol.ie; freeradius-users@lists.freeradius.org
On Thu, Jun 28, 2012 at 8:22 PM, Taz Manian <djtazie@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
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