Re: radius+mysql weird problem

---- Original Message -----
From: "Alan DeKok" <aland@deployingradius.com>
To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org>
Sent: Friday, December 22, 2006 10:23 PM
Subject: Re: radius+mysql weird problem


> Jorge Minassian - Comintec wrote:
>> Hello all !,
>>
>> After upgrading Fedora from FC2 to FC4, I got what is described below
>> from log (radiusd -X)
>> If I query database manually, I get all info about users (all users are
>> correctly on DB), but radius still says "No matching entry in the
>> database ...".
>
> What is returned when you query the DB manually? The contents of the
> fields (operators, etc.) matter.
>
> Alan DeKok.

Alan,

----
mysql> SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username =
'000' ORDER BY id;
+------+----------+-----------+-------+----+
| id | UserName | Attribute | Value | op |
+------+----------+-----------+-------+----+
| 1590 | 000 | Password | 1234 | == |
+------+----------+-----------+-------+----+

op tried as "==" and ":=", same results.
Value as "Password" or "User-Password", same resutls.

----
mysql> SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupc heck.Attribute,radgroupcheck.Value,radgroupcheck.o p
-> FROM radgroupcheck,usergroup WHERE usergroup.Username = '000' AND
-> usergroup.GroupName = radgroupcheck.GroupName ORDER BY
radgroupcheck.id;
+----+-----------+------------------+--------+------+
| id | GroupName | Attribute | Value | op |
+----+-----------+------------------+--------+------+
| 1 | normal | Simultaneous-Use | 1 | == |
| 5 | normal | Huntgroup-Name | normal | == |
+----+-----------+------------------+--------+------+


----
mysql> SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username =
'000' ORDER BY id;
Empty set (0.02 sec)


----
mysql> SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupr eply.Attribute,radgroupreply.Value,radgroupreply.o p
FROM radgroupreply,usergroup WHERE usergroup.Username = '000' AND
usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id
-> ;
+----+-----------+--------------------+---------------------+------+
| id | GroupName | Attribute | Value | op |
+----+-----------+--------------------+---------------------+------+
| 3 | normal | Framed-Protocol | PPP | == |
| 4 | normal | Framed-Compression | Van-Jacobson-TCP-IP | == |
| 5 | normal | Framed-IP-Address | 255.255.255.254 | == |
| 6 | normal | Service-Type | Framed-User | == |
+----+-----------+--------------------+---------------------+------+
4 rows in set (0.01 sec)


Remember please, before upgrading same tables was working fine ...

Thank you,
Jorge.








> --
> http://deployingradius.com - The web site of the book
> http://deployingradius.com/blog/ - The blog
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html