Page 1 of 1

FreeRadius & MySql

Posted: Tue Mar 01, 2011 3:48 pm
by 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?

Re: FreeRadius & MySql

Posted: Tue Mar 01, 2011 3:50 pm
by 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.

Re: FreeRadius & MySql

Posted: Tue Mar 01, 2011 4:15 pm
by 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.

Re: FreeRadius & MySql

Posted: Tue Mar 01, 2011 4:22 pm
by 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!

Re: FreeRadius & MySql

Posted: Wed Mar 02, 2011 1:08 am
by Douglas
Locked...