<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
a:link, span.MsoHyperlink
{color:#0563C1;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:#954F72;
text-decoration:underline}
span.EmailStyle17
{font-family:"Calibri",sans-serif;
color:windowtext}
.MsoChpDefault
{font-family:"Calibri",sans-serif}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
div.WordSection1
{}
-->
</style>
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Hi,</p>
<p class="MsoNormal"> Followed the diff forum threads and have managed to link the Freeradius to look for users from a Mysql DB but am still not able to successfully authenticate users in this setup.I get the following error on receiving a user request</p>
<p class="MsoNormal">Received Access-Request Id 24 from 10.127.6.21:59169 to 10.127.6.244:1645 length 76</p>
<p class="MsoNormal"> User-Name = 'test'</p>
<p class="MsoNormal"> User-Password = 'test'</p>
<p class="MsoNormal"> NAS-IP-Address = 10.127.6.21</p>
<p class="MsoNormal"> Service-Type = Administrative-User</p>
<p class="MsoNormal"> Calling-Station-Id = '10.120.92.40'</p>
<p class="MsoNormal"> NAS-Port-Type = Virtual</p>
<p class="MsoNormal">(1) # Executing section authorize from file /etc/raddb/sites-enabled/default</p>
<p class="MsoNormal">(1) authorize {</p>
<p class="MsoNormal">(1) [preprocess] = ok</p>
<p class="MsoNormal">(1) [chap] = noop</p>
<p class="MsoNormal">(1) [mschap] = noop</p>
<p class="MsoNormal">(1) [digest] = noop</p>
<p class="MsoNormal">(1) suffix : No '@' in User-Name = "test", looking up realm NULL</p>
<p class="MsoNormal">(1) suffix : No such realm "NULL"</p>
<p class="MsoNormal">(1) [suffix] = noop</p>
<p class="MsoNormal">(1) eap : No EAP-Message, not doing EAP</p>
<p class="MsoNormal">(1) [eap] = noop</p>
<p class="MsoNormal">(1) sql : EXPAND %{User-Name}</p>
<p class="MsoNormal">(1) sql : --> test</p>
<p class="MsoNormal">(1) sql : SQL-User-Name set to 'test'</p>
<p class="MsoNormal">rlm_sql (sql): Reserved connection (4)</p>
<p class="MsoNormal">(1) sql : EXPAND SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id desc</p>
<p class="MsoNormal">(1) sql : --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'test' ORDER BY id desc</p>
<p class="MsoNormal">rlm_sql (sql): Executing query: 'SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'test' ORDER BY id desc'</p>
<p class="MsoNormal"><b><span style="color:red">rlm_sql: Failed to create the pair: Invalid vendor name in attribute name "Password"</span></b></p>
<p class="MsoNormal"><b><span style="color:red">rlm_sql (sql): Error parsing user data from database result</span></b></p>
<p class="MsoNormal">(1) ERROR: sql : SQL query error</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">But the user exists in the DB as we can see from the following output :</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'test' ORDER BY id desc;</p>
<p class="MsoNormal">+----+----------+-----------+-------+----+</p>
<p class="MsoNormal">| id | username | attribute | value | op |</p>
<p class="MsoNormal">+----+----------+-----------+-------+----+</p>
<p class="MsoNormal">| 2 | test | Password | test | := |</p>
<p class="MsoNormal">| 1 | test | Auth-Type | Local | := |</p>
<p class="MsoNormal">+----+----------+-----------+-------+----+</p>
<p class="MsoNormal">2 rows in set (0.00 sec)</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">I have attached the configuration files along with this mail. Any help in this would be very much appreciated.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><br>
Senthil KSK</p>
<p class="MsoNormal"> </p>
</div>
<br>
<hr>
<font face="Arial" color="Gray" size="2"><br>
DISCLAIMER:<br>
This e-mail and any attachments to it may contain confidential and proprietary material and is solely for the use of the intended recipient. Any review, use, disclosure, distribution or copying of this transmittal is prohibited except by or on behalf of the
intended recipient. If you have received this transmittal in error, please notify the sender and destroy this e-mail and any attachments and all copies, whether electronic or printed.<br>
</font>
</body>
</html>