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@networkradius.com>
To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org>
Sent: Tue, May 24, 2011 10:42:35 AM
Subject: RE: Authentication Problem

 

 

From: freeradius-users-bounces+tim.sylvester=networkradius.com@lists.freeradius.org [mailto:freeradius-users-bounces+tim.sylvester=networkradius.com@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