Authentication Problem

[Tim Sylvester]

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/c32c3cbe/attachment.html>