freeradius 1.0.4 + mysql cannot authincate

[Dennis Skinner]

Jonathan Carpenter wrote:
> Config:   including file: /etc/raddb/sql.conf

That's good.

> rad_recv: Access-Request packet from host 127.0.0.1:32784
> <http://127.0.0.1:32784>, id=125, length=58
>         User-Name = "scooby"
>         User-Password = "scooby"
>         NAS-IP-Address = 255.255.255.255 <http://255.255.255.255>
>         NAS-Port = 10
> rad_lowerpair:  User-Name now 'scooby'
> rad_rmspace_pair:  User-Name now 'scooby'
> rad_rmspace_pair:  User-Password now 'scooby'
> auth: No authenticate method (Auth-Type) configuration found for the
> request: Rejecting the user
> auth: Failed to validate the user.
> Login incorrect: [scooby/scooby] (from client localhost port 10)

So, looks like it has all that info about how to login to your MySQL
server and what queries to use, but you never told it to actually use it.

Hint: look at the authorize section towards the bottom of your
radius.conf.  There should be a line like:

# sql

Uncomment it.

-- 
Dennis Skinner
Systems Administrator
BlueFrog Internet
http://www.bluefrog.com