<div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="gmail_quote"><div class="im">Alan DeKok wrote:<span dir="ltr"></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div>>Quentin Smith wrote:<br>
>> However, when I run freeradius -X, it appears that for some reason<br>
>> that setting is erased. The following is the pertinent output:<br>
<br>
</div> > Read the rest of the debug output. Which files is it reading? Which<br>
> one contains the SQL configuration? Which one did you edit?<br>
<div><br></div></blockquote></div><div> I edited the sql.conf file, which was the file being read.<br> </div><div class="im"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
>> I'm guessing the SQL query error is related to the fact that<br>
>> authorize_check_query is now an empty string, but I'm not sure why<br>
>> that's the case.<br>
<br>
</div> > You edited it locally. The default configuration doesn't have this issue.<br>
<br>
> Find out which file was edited, and fix it.<br></blockquote><div> <br> > Alan DeKok.<br></div></div></div></blockquote><div><br> After some closer inspection, I discovered the problem. In order to have<br>
the default configuration available for reference purposes, I had simply <br> commented out the following line:<br> <br> authorize_check_query = "SELECT id, UserName, Attribute, Value, op \<br>
<br> and replaced it with the following line:<br><br> authorize_check_query = "SELECT id, name as UserName, 'NT-Password' as Attribute, nthashpass as Value, ':=' as op \<br><br> However, I didn't realize that commenting the line didn't prevent the <br>
escaping of the return character at the end of the line, effectively <br> commenting out the following lines as well. Deleting the backslash<br> fixed the problem, and it now works as I intended.<br>
<br> Thanks for the reply.<br><br><br></div></div><br><br clear="all"><br>-- <br>Quentin Smith<br>