Just need a little help w/sqlippool

[Dave]

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.!