On Wed, 2005-10-19 at 17:34 -0400, Kevin Bonner wrote:
Run in debug mode. Look at the queries that are being run and try to run them by hand to see what is returned by MySQL. Without more debug output, it is difficult to know what is happening.
Please see the debug output I've just posted. I've also run the queries using the mysql client and They return the calues stored in the tables. mysql> SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'user@otherrealm' ORDER BY id; +-----+-----------------+---------------+----------+----+ | id | UserName | Attribute | Value | op | +-----+-----------------+---------------+----------+----+ | 376 | user@otherrealm | User-Password | password | == | +-----+-----------------|---------------+----------+----+ 1 row in set (0.00 sec) mysql> SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'user@otherrealm' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id; +----+-----------+-------------------+------------+----+ | id | GroupName | Attribute | Value | op | +----+-----------+-------------------+------------+----+ | 4 | MY-GROUP | Called-Station-Id | 1234567890 | == | +----+-----------+-------------------+------------+----+ 1 row in set (0.00 sec) mysql> SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'user@otherrealm' ORDER BY id -> ; Empty set (0.00 sec) mysql> SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'user@otherrealm' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id; +----+-----------+-----------------+-----------------------+----+ | id | GroupName | Attribute | Value | op | +----+-----------+-----------------+-----------------------+----+ | 35 | MY-GROUP | Service-Type | Framed-User | = | | 36 | MY-GROUP | Framed-Protocol | PPP | = | | 38 | MY-GROUP | Cisco-AVPair | ip:addr-pool= my-pool | += | +----+-----------+-----------------+-----------------------+----+ 3 rows in set (0.00 sec) thanks -- Luca Corti PGP Key ID 1F38C091