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@yahoo.com] Sent: Monday, May 23, 2011 11:24 PM To: tim.sylvester@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@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