Authentication Problem

[Tim Sylvester]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20110523/b461f8f6/attachment.html>