Hi list,
I have problem authenticating users against (My)SQL.
Freeradius is running on a FreeBSD 8.0-STABLE and is on version
2.1.10.
It is a fresh install that I made work with the default file
authentication.
When I connect the SQL backend, it doesn't work.
I followed the instructions on the FreeRADIUS wiki :
http://wiki.freeradius.org/SQl_HOWTO
The SQL module is correctly loaded and it returns an OK during
authentication.
The queries are well formed and the results should be ok
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.
Am I misunderstanding ?
The debug output and relevant configuration directives are
below.
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).
Here is the output of the radtest command :
# radtest bsemene test 10.1.8.4 0 "password for jail client"
Sending Access-Request of id 214 to 10.1.8.4 port 1812
User-Name = "bsemene"
User-Password = "test"
NAS-IP-Address = 10.1.8.4
NAS-Port = 0
rad_recv: Access-Reject packet from host 10.1.8.4 port 1812,
id=214, length=20
H
--
If you think experts are expensive,
wait to see what amateurs will cost you
--
Bastien Semene
Administrateur Réseau & Système
Cyanide Studio - FRANCE