FreeRadius & MySql

[disciplefk]

Hi There,

I have a FreeRadius server that connects to a mysql database populated with users. I having trouble finding out how to authenticate users from information saved in the database. All goes well (I think) until the authentication:

rlm_sql (sql): Released sql socket id: 3
modcall[authorize]: module "sql" returns ok for request 0
modcall: leaving group authorize (returns ok) for request 0
rad_check_password: Found Auth-Type System
auth: type "System"
Processing the authenticate section of radiusd.conf
modcall: entering group authenticate for request 0
rlm_unix: [disciplefk]: invalid password
modcall[authenticate]: module "unix" returns reject for request 0
modcall: leaving group authenticate (returns reject) for request 0
auth: Failed to validate the user.
Delaying request 0 for 1 seconds
Finished request 0

Any ideas on what I need to do?

[janjust]

err, how about posting this message to a freeradius/mysql forum? if the authentication via freeradius fails there's nothing that openvpn can do about it.

[disciplefk]

Yeah i know, I could not find a dedicated freeradius forum. And it would make as much sense to post it in mysql as here.

[disciplefk]

Nevermind, I figured it out. I knew the problem was Auth-Type needed to be defined, but I did not know as what and where. Turns out is is in the users files and needs to be set as Local. Just in case anyone else needs this info =) Thanks anyway!

[Douglas]

Locked...