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