<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Ok, I found the problem.<br>
<br>
The problem was the operator in radcheck I put '==' instead of
':='...<br>
<br>
Sorry for the inconvenience.<br>
<br>
<pre class="moz-signature" cols="72">Bastien Semene
Administrateur Réseau & Système
Cyanide Studio - FRANCE
</pre>
<br>
Le 06/07/2011 15:26, Bastien Semene a écrit :
<blockquote cite="mid:4E1462A2.8070702@cyanide-studio.com"
type="cite">
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<div class="moz-text-flowed" style="font-family: -moz-fixed;
font-size: 13px;" lang="x-western">Hi list, <br>
<br>
I have problem authenticating users against (My)SQL. <br>
Freeradius is running on a FreeBSD 8.0-STABLE and is on version
2.1.10. <br>
<br>
It is a fresh install that I made work with the default file
authentication. <br>
When I connect the SQL backend, it doesn't work. <br>
I followed the instructions on the FreeRADIUS wiki : <a
moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://wiki.freeradius.org/SQl_HOWTO">http://wiki.freeradius.org/SQl_HOWTO</a>
<br>
<br>
The SQL module is correctly loaded and it returns an OK during
authentication. <br>
The queries are well formed and the results should be ok <br>
<br>
What I don't understand is why sql module returns OK, and the
authentication is rejected. In my mind, an OK from the SQL
module at this step means it has authenticated the user. <br>
Am I misunderstanding ? <br>
<br>
The debug output and relevant configuration directives are
below. <br>
<br>
P.S. : 10.1.8.4 is the IP of the server, I'm running radtest
commands from this host (I can't use 127.0.0.1 because of how
network currently works in jails on FreeBSD). <br>
<br>
<br>
Here is the output of the radtest command : <br>
<br>
# radtest bsemene test 10.1.8.4 0 "password for jail client" <br>
Sending Access-Request of id 214 to 10.1.8.4 port 1812 <br>
User-Name = "bsemene" <br>
User-Password = "test" <br>
NAS-IP-Address = 10.1.8.4 <br>
NAS-Port = 0 <br>
rad_recv: Access-Reject packet from host 10.1.8.4 port 1812,
id=214, length=20 <br>
<br>
<br>
<br>
<br>
H<br>
<pre class="moz-signature" cols="72">--
If you think experts are expensive,
wait to see what amateurs will cost you
--
Bastien Semene
Administrateur Réseau & Système
Cyanide Studio - FRANCE
</pre>
</div>
</blockquote>
</body>
</html>