<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:'times new roman', 'new york', times, serif;font-size:12pt"><div><div>Seems there.</div><div><br></div><div><br></div><div>>select * from radcheck where username='bob';</div><div>+-----+----------+--------------------+----+-------------+</div><div>| id | username | attribute | op | value |</div><div>+-----+----------+--------------------+----+-------------+</div><div>| 386 | bob | Expiration | := | 25 Jun 2011 |</div><div>| 385 | bob | Simultaneous-Use | = | 1 |</div><div>| 384 | bob | Cleartext-Password | := | bob |</div></div><div><br></div><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><br></div><div
style="font-family:times new roman, new york, times, serif;font-size:12pt"><br></div><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><br><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><font size="2" face="Tahoma"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Tim Sylvester <tim.sylvester@networkradius.com><br><b><span style="font-weight: bold;">To:</span></b> FreeRadius users mailing list <freeradius-users@lists.freeradius.org><br><b><span style="font-weight: bold;">Sent:</span></b> Tue, May 24, 2011 10:42:35 AM<br><b><span style="font-weight: bold;">Subject:</span></b> RE: Authentication Problem<br></font><br>
<meta http-equiv="x-dns-prefetch-control" content="off"><style><!--
_filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
_filtered {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"serif";}
a:link, span.MsoHyperlink
{color:blue;text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{margin:0in;margin-bottom:.0001pt;font-size:8.0pt;font-family:"sans-serif";}
span.apple-tab-span
{}
span.BalloonTextChar
{font-family:"sans-serif";}
span.EmailStyle20
{font-family:"sans-serif";color:#1F497D;}
.MsoChpDefault
{font-size:10.0pt;}
_filtered {margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{}
--></style><div class="WordSection1"><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"sans-serif";color:#1F497D;"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"sans-serif";color:#1F497D;"> </span></p><div><div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in;"><p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"sans-serif";">From:</span></b><span style="font-size:10.0pt;font-family:"sans-serif";"> freeradius-users-bounces+tim.sylvester=networkradius.com@lists.freeradius.org [mailto:freeradius-users-bounces+tim.sylvester=networkradius.com@lists.freeradius.org] <b>On Behalf Of </b>john decot<br><b>Sent:</b> Monday, May 23, 2011 9:36 PM<br><b>To:</b> FreeRadius users mailing list<br><b>Subject:</b> Re: Authentication Problem</span></p></div></div><p class="MsoNormal"> </p><div><div><p class="MsoNormal"><span
style="color:black;">I have backup from working server but still not working </span></p></div><div><p class="MsoNormal"><span style="color:black;"> </span></p></div><div><p class="MsoNormal"><span style="color:black;">Please find the log:</span></p></div><div><p class="MsoNormal"><span style="color:black;"> </span></p></div><div><p class="MsoNormal"><span style="color:black;">success Log:</span></p></div><div><p class="MsoNormal"><span style="color:black;"> </span></p></div><div><div><p class="MsoNormal"> [sql] <span class="apple-tab-span"> </span>expand: %{User-Name} -> rajnish</p></div><div><p class="MsoNormal">[sql] sql_set_user escaped user --> 'rajnish'</p></div><div><p class="MsoNormal">rlm_sql (sql): Reserving sql socket id: 3</p></div><div><p class="MsoNormal">[sql] <span class="apple-tab-span"> </span>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</p></div><div><p class="MsoNormal">[sql] User found in radcheck table</p></div><div><p class="MsoNormal"><span style="color:#1F497D;"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"sans-serif";color:#1F497D;"><tim> The user “rajnish” was found in the radcheck table …</span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"sans-serif";color:#1F497D;"> </span></p><p class="MsoNormal">[sql] <span class="apple-tab-span"> </span>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</p></div><div><p class="MsoNormal">[sql] <span class="apple-tab-span"> </span>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</p></div><div><p class="MsoNormal">[sql] <span class="apple-tab-span"> </span>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</p></div><div><p class="MsoNormal">[sql] User found in group 128kbps_Unlimited</p></div><div><p class="MsoNormal">[sql] <span class="apple-tab-span"> </span>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</p></div><div><p class="MsoNormal">rlm_sql (sql): Released sql socket id: 3</p></div><div><p class="MsoNormal">++[sql] returns ok</p></div></div><div><p class="MsoNormal"><span style="color:black;"> </span></p></div><div><p class="MsoNormal"><span style="color:black;">Failure Log:</span></p></div><div><p class="MsoNormal"><span style="color:black;"> </span></p></div><div><div><p class="MsoNormal">[sql] <span class="apple-tab-span"> </span>expand: %{User-Name} -> bob</p></div><div><p class="MsoNormal">[sql] sql_set_user escaped user --> 'bob'</p></div><div><p class="MsoNormal">rlm_sql (sql): Reserving sql socket id: 3</p></div><div><p class="MsoNormal">[sql] <span
class="apple-tab-span"> </span>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</p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"sans-serif";color:#1F497D;"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"sans-serif";color:#1F497D;"><tim> The user “bob” was not found in the radcheck table …</span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"sans-serif";color:#1F497D;"> </span></p></div><div><p class="MsoNormal">[sql] <span
class="apple-tab-span"> </span>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</p></div><div><p class="MsoNormal">[sql] <span class="apple-tab-span"> </span>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</p></div><div><p class="MsoNormal">[sql] User found in group 256kbps_Unlimited</p></div><div><p class="MsoNormal"><span style="color:#1F497D;"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"sans-serif";color:#1F497D;"><tim> The user “bob” was found in the radgroup table …</span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"sans-serif";color:#1F497D;"> </span></p><p class="MsoNormal">[sql] <span class="apple-tab-span"> </span>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</p></div><div><p class="MsoNormal">rlm_sql (sql): Released sql socket id: 3</p></div><div><p class="MsoNormal">++[sql] returns ok</p></div><div><p class="MsoNormal">rlm_checkval: Could not find item named Calling-Station-Id in request</p></div><div><p class="MsoNormal">rlm_checkval: Could not find attribute named Calling-Station-Id in check pairs</p></div><div><p class="MsoNormal">++[station-check] returns notfound</p></div><div><p class="MsoNormal">rlm_checkval: Could not find item named NAS-Identifier in request</p></div><div><p class="MsoNormal">rlm_checkval: Could not find attribute named NAS-Identifier in check pairs</p></div><div><p class="MsoNormal">++[NAS-check] returns notfound</p></div><div><p class="MsoNormal">++[expiration] returns noop</p></div><div><p
class="MsoNormal">rlm_logintime: Checking Login-Time: 'Su-Sa0000-2400'</p></div><div><p class="MsoNormal">rlm_logintime: timestr returned unlimited</p></div><div><p class="MsoNormal">++[logintime] returns ok</p></div><div><p class="MsoNormal">[pap] WARNING! No "known good" password found for the user. Authentication may fail because of this.</p></div><div><p class="MsoNormal">++[pap] returns noop</p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"sans-serif";color:#1F497D;"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"sans-serif";color:#1F497D;"><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. </span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"sans-serif";color:#1F497D;"> </span></p><p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"sans-serif";color:#1F497D;">Tim</span></p></div></div></div></div><meta http-equiv="x-dns-prefetch-control" content="on"></div></div><div style="position:fixed"></div>
</div></body></html>