Authentication Problem

john decot johndecot at yahoo.com
Tue May 24 10:20:39 CEST 2011


> SELECT id, username, attribute, value, op          FROM radcheck          WHERE 
>username = BINARY 'bob'          ORDER BY id;
+-----+----------+--------------------+-------------+----+
| id  | username | attribute          | value       | op |
+-----+----------+--------------------+-------------+----+
| 384 | bob    | Cleartext-Password | bob       | := |
| 385 | bob    | Simultaneous-Use   | 1           | =  |
| 386 | bob    | Expiration         | 25 Jun 2011 | := |
+-----+----------+--------------------+-------------+----+
3 rows in set (0.00 sec)






________________________________
From: Tim Sylvester <tim.sylvester at networkradius.com>
To: john decot <johndecot at yahoo.com>; FreeRadius users mailing list 
<freeradius-users at lists.freeradius.org>
Sent: Tue, May 24, 2011 1:08:55 PM
Subject: RE: Authentication Problem


What do you get when you run this query?
 
SELECT id, username, attribute, value, op          FROM radcheck          WHERE 
username = BINARY 'bob'          ORDER BY id
 
From:john decot [mailto:johndecot at yahoo.com] 
Sent: Monday, May 23, 2011 11:24 PM
To: tim.sylvester at networkradius.com; FreeRadius users mailing list
Subject: Re: Authentication Problem
 
Seems there.
 
 
>select * from radcheck where username='bob';
+-----+----------+--------------------+----+-------------+
| id  | username | attribute          | op | value       |
+-----+----------+--------------------+----+-------------+
| 386 | bob    | Expiration         | := | 25 Jun 2011 |
| 385 | bob    | Simultaneous-Use   | =  | 1           |
| 384 | bob    | Cleartext-Password | := | bob       |
 
 
 
 

________________________________

From:Tim Sylvester <tim.sylvester at networkradius.com>
To: FreeRadius users mailing list <freeradius-users at lists.freeradius.org>
Sent: Tue, May 24, 2011 10:42:35 AM
Subject: RE: Authentication Problem



 
 
From:freeradius-users-bounces+tim.sylvester=networkradius.com at lists.freeradius.org
[mailto:freeradius-users-bounces+tim.sylvester=networkradius.com at lists.freeradius.org]
] On Behalf Of john decot
Sent: Monday, May 23, 2011 9:36 PM
To: FreeRadius users mailing list
Subject: Re: Authentication Problem
 
I have backup from working server but still not working 
 
Please find the log:
 
success Log:
 
[sql]    expand: %{User-Name} -> rajnish
[sql] sql_set_user escaped user --> 'rajnish'
rlm_sql (sql): Reserving sql socket id: 3
[sql]     expand: SELECT id, username, attribute, value, op          FROM 
radcheck          WHERE username = BINARY '%{SQL-User-Name}'          ORDER BY 
id -> SELECT id, username, attribute, value, op          FROM radcheck         
 WHERE username = BINARY 'rajnish'          ORDER BY id
[sql] User found in radcheck table
 
<tim> The user “rajnish” was found in the radcheck table …
 
[sql]     expand: SELECT id, username, attribute, value, op          FROM 
radreply          WHERE username = BINARY '%{SQL-User-Name}'          ORDER BY 
id -> SELECT id, username, attribute, value, op          FROM radreply         
 WHERE username = BINARY 'rajnish'          ORDER BY id
[sql]     expand: SELECT groupname          FROM usergroup          WHERE 
username = BINARY '%{SQL-User-Name}'          ORDER BY priority -> SELECT 
groupname          FROM usergroup          WHERE username = BINARY 'rajnish'     
     ORDER BY priority
[sql]     expand: SELECT id, groupname, attribute,           Value, op           
FROM radgroupcheck           WHERE groupname = '%{Sql-Group}'           ORDER BY 
id -> SELECT id, groupname, attribute,           Value, op           FROM 
radgroupcheck           WHERE groupname = '128kbps_Unlimited'           ORDER BY 
id
[sql] User found in group 128kbps_Unlimited
[sql]     expand: SELECT id, groupname, attribute,           value, op           
FROM radgroupreply           WHERE groupname = '%{Sql-Group}'           ORDER BY 
id -> SELECT id, groupname, attribute,           value, op           FROM 
radgroupreply           WHERE groupname = '128kbps_Unlimited'           ORDER BY 
id
rlm_sql (sql): Released sql socket id: 3
++[sql] returns ok
 
Failure Log:
 
[sql]     expand: %{User-Name} -> bob
[sql] sql_set_user escaped user --> 'bob'
rlm_sql (sql): Reserving sql socket id: 3
[sql]     expand: SELECT id, username, attribute, value, op          FROM 
radcheck          WHERE username = BINARY '%{SQL-User-Name}'          ORDER BY 
id -> SELECT id, username, attribute, value, op          FROM radcheck         
 WHERE username = BINARY 'bob'          ORDER BY id
 
<tim> The user “bob” was not found in the radcheck table …
 
[sql]     expand: SELECT groupname          FROM usergroup          WHERE 
username = BINARY '%{SQL-User-Name}'          ORDER BY priority -> SELECT 
groupname          FROM usergroup          WHERE username = BINARY 'bob'         
 ORDER BY priority
[sql]     expand: SELECT id, groupname, attribute,           Value, op           
FROM radgroupcheck           WHERE groupname = '%{Sql-Group}'           ORDER BY 
id -> SELECT id, groupname, attribute,           Value, op           FROM 
radgroupcheck           WHERE groupname = '256kbps_Unlimited'           ORDER BY 
id
[sql] User found in group 256kbps_Unlimited
 
<tim> The user “bob” was found in the radgroup table …
 
[sql]     expand: SELECT id, groupname, attribute,           value, op           
FROM radgroupreply           WHERE groupname = '%{Sql-Group}'           ORDER BY 
id -> SELECT id, groupname, attribute,           value, op           FROM 
radgroupreply           WHERE groupname = '256kbps_Unlimited'           ORDER BY 
id
rlm_sql (sql): Released sql socket id: 3
++[sql] returns ok
rlm_checkval: Could not find item named Calling-Station-Id in request
rlm_checkval: Could not find attribute named Calling-Station-Id in check pairs
++[station-check] returns notfound
rlm_checkval: Could not find item named NAS-Identifier in request
rlm_checkval: Could not find attribute named NAS-Identifier in check pairs
++[NAS-check] returns notfound
++[expiration] returns noop
rlm_logintime: Checking Login-Time: 'Su-Sa0000-2400'
rlm_logintime: timestr returned unlimited
++[logintime] returns ok
[pap] WARNING! No "known good" password found for the user.  Authentication may 
fail because of this.
++[pap] returns noop
 
<tim> Make sure that bob is in the radcheck table in the MySQL database. 
FreeRADIUS did not find the user “bob” in the radcheck table, and just 
continued. 

 
Tim
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20110524/5f026638/attachment.html>


More information about the Freeradius-Users mailing list