Ive been fighting with upgrading my working 1.7 freeradius to 2.1.3 . Ive been using the sqlippool module all this time, and while I think I'm close I just cant figure this out. The database is the original database I used with 1.7 but the configs are all new from the ground up for 2.1.3. I think maybe it changed in the way it works.
With 1.7 I was inserting a username and password into radcheck table; I was inserting the username into usergroup table with the groupname value of "wisp-dynamic-pool2" among one other group for my NAS; my radgroupcheck table: +----+--------------------+-----------+----+---------+ | id | GroupName | Attribute | op | Value | +----+--------------------+-----------+----+---------+ | 2 | wisp-dynamic-pool2 | Pool-Name | := | IP-Pool | +----+--------------------+-----------+----+---------+ part of my radippool table; +-----+-----------+-----------------+--------------+-----------------+------------------+---------------------+----------+----------+ | id | pool_name | framedipaddress | nasipaddress | calledstationid | callingstationid | expiry_time | username | pool_key | +-----+-----------+-----------------+--------------+-----------------+------------------+---------------------+----------+----------+ | 304 | IP-Pool | 75.119.xxx.xxx | | | | 0000-00-00 00:00:00 | | | | 305 | IP-Pool | 75.119.xxx.xxx | | | | 0000-00-00 00:00:00 | | | Part of my radcheck table; | 217 | preichenbach | Cleartext-Password | := | preichenbach | | 218 | dfast | Cleartext-Password | := | dfast | | 219 | jhoffman | Cleartext-Password | := | jhoffman | my radgroupreply table; +----+-----------+---------------------+----+-------------------------------------+------+ | id | GroupName | Attribute | op | Value | prio | +----+-----------+---------------------+----+-------------------------------------+------+ | 1 | wisp-1500 | Mikrotik-Rate-Limit | = | 384k/1500k 600k/4000k 128k/128k 8/8 | 0 | | 2 | wisp-1500 | Port-Limit | = | 1 | 0 | | 3 | wisp-2500 | Mikrotik-Rate-Limit | = | 384k/2500k 600k/4000k 128k/128k 8/8 | 0 | | 4 | wisp-2500 | Port-Limit | = | 1 | 0 | | 9 | wisp-256 | Port-Limit | = | 1 | 0 | | 8 | wisp-256 | Mikrotik-Rate-Limit | = | 64k/256k | 0 | +----+-----------+---------------------+----+-------------------------------------+------+ My usergroup table with a user for example: +----------+--------------------+----------+ | UserName | GroupName | priority | +----------+--------------------+----------+ | kcase | wisp-1500 | 0 | | kcase | wisp-dynamic-pool2 | 0 | +----------+--------------------+----------+ The above worked with 1.7 BUT this isnt working for 2.1.3; Do I have to insert into the radcheck table the username as well as the pool name into radcheck? +-----+----------+--------------------+----+---------+ | id | UserName | Attribute | op | Value | +-----+----------+--------------------+----+---------+ | 78 | kcase | Cleartext-Password | := | kcase | | 230 | kcase | Pool-Name | := | IP-Pool | +-----+----------+--------------------+----+---------+ The above seems to work, if I don't put the pool-name in radcheck; and I leave the user into the usergroup table, and put the user into group wisp-dynamic-pool2 where radgroupcheck has wisp-dynamic-pool2 setting Pool-Name := IP-Pool. I get no pool name defined error. The rest works as expected though using the usergroup table as it did before, (put my user into wisp-1500 group for example and radtest returns the correct attributes) Any suggestions would be great.! - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
