Realm users authentication failure

[Luca Corti]

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 at otherrealm' ORDER BY id;
+-----+-----------------+---------------+----------+----+
| id  | UserName        | Attribute     | Value    | op |
+-----+-----------------+---------------+----------+----+
| 376 | user at 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 at 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 at 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 at 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20051020/ecdc7990/attachment.pgp>