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 = '[EMAIL PROTECTED]' ORDER BY id;
+-----+-----------------+---------------+----------+----+
| id | UserName | Attribute | Value | op |
+-----+-----------------+---------------+----------+----+
| 376 | [EMAIL PROTECTED] | 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 = '[EMAIL PROTECTED]'
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 = '[EMAIL PROTECTED]' 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 = '[EMAIL PROTECTED]'
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
signature.asc
Description: This is a digitally signed message part
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
