<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>> SELECT id, username, attribute, value, op FROM radcheck WHERE username = BINARY 'bob' ORDER BY id;</div><div>+-----+----------+--------------------+-------------+----+</div><div>| id | username | attribute | value | op |</div><div>+-----+----------+--------------------+-------------+----+</div><div>| 384 | bob | Cleartext-Password | bob | := |</div><div>| 385 | bob | Simultaneous-Use | 1 | = |</div><div>| 386 | bob | Expiration | 25 Jun 2011 | :=
|</div><div>+-----+----------+--------------------+-------------+----+</div><div>3 rows in set (0.00 sec)</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> john decot <johndecot@yahoo.com>; FreeRadius users mailing list <freeradius-users@lists.freeradius.org><br><b><span style="font-weight: bold;">Sent:</span></b> Tue, May 24, 2011 1:08:55 PM<br><b><span style="font-weight: bold;">Subject:</span></b> RE: Authentication
Problem<br></font><br>
<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.BalloonTextChar
{font-family:"sans-serif";}
p.msochpdefault, li.msochpdefault, div.msochpdefault
{margin-right:0in;margin-left:0in;font-size:10.0pt;font-family:"serif";}
span.balloontextchar0
{font-family:"sans-serif";}
span.emailstyle20
{font-family:"sans-serif";color:#1F497D;}
span.apple-tab-span
{}
span.EmailStyle23
{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;">What do you get when you run this query?</span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"sans-serif";color:#1F497D;"> </span></p><p class="MsoNormal">SELECT id, username, attribute, value, op FROM radcheck WHERE username = BINARY 'bob' ORDER BY id<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";"> john decot [mailto:johndecot@yahoo.com] <br><b>Sent:</b> Monday, May 23, 2011 11:24 PM<br><b>To:</b> tim.sylvester@networkradius.com; FreeRadius users mailing list<br><b>Subject:</b> Re: Authentication Problem</span></p></div></div><p class="MsoNormal"> </p><div><div><div><p class="MsoNormal">Seems there.</p></div><div><p class="MsoNormal"> </p></div><div><p class="MsoNormal"> </p></div><div><p class="MsoNormal">>select * from radcheck where username='bob';</p></div><div><p class="MsoNormal">+-----+----------+--------------------+----+-------------+</p></div><div><p class="MsoNormal">| id | username | attribute | op | value |</p></div><div><p class="MsoNormal">+-----+----------+--------------------+----+-------------+</p></div><div><p class="MsoNormal">| 386 | bob | Expiration
| := | 25 Jun 2011 |</p></div><div><p class="MsoNormal">| 385 | bob | Simultaneous-Use | = | 1 |</p></div><div><p class="MsoNormal">| 384 | bob | Cleartext-Password | := | bob |</p></div></div><div><p class="MsoNormal"> </p></div><div><p class="MsoNormal"> </p></div><div><p class="MsoNormal"> </p></div><div><p class="MsoNormal"> </p><div><div class="MsoNormal" align="center" style="text-align:center;"><span style="font-size:10.0pt;font-family:"sans-serif";"><hr size="1" width="100%" align="center"></span></div><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";"> Tim Sylvester <tim.sylvester@networkradius.com><br><b>To:</b> FreeRadius users mailing list
<freeradius-users@lists.freeradius.org><br><b>Sent:</b> Tue, May 24, 2011 10:42:35 AM<br><b>Subject:</b> RE: Authentication Problem<br></span><br><br></p><div><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></div></div></div></div></div></div><div style="position:fixed"></div>
</div></body></html>