Configuring freeradius with mysql

michalsanda[cz] · 03-01-2012, 12:26 PM

Hi, I am configuring freeradius with mysql ... I've found this tutorial http://www.ban-solms.de/t/debian-radius.html but i am confused because when I add

test1 User-Password == "password1"
DEFAULT Auth-Type := sql
Fall-Through := 1

I didnt found

#DEFAULT Auth-Type = System
# Fall-Through = 1

and freeradius -x returns:

/etc/freeradius/users[207]: Parse error (check) for entry DEFAULT: Unknown value sql for attribute Auth-Type
Errors reading /etc/freeradius/users
/etc/freeradius/modules/files[7]: Instantiation failed for module "files"
/etc/freeradius/sites-enabled/inner-tunnel[124]: Failed to load module "files".
/etc/freeradius/sites-enabled/inner-tunnel[47]: Errors parsing authorize section.

Could you help me please?

acid_kewpie · 03-02-2012, 04:53 AM

AFAIK the sql authentication type is defined in /etc/raddb/sql.conf, so if that config file is not included, that reference you are sticking on there will not work.

http://wiki.freeradius.org/SQL-HOWTO...ius+to+use+SQL

michalsanda[cz] · 11-06-2012, 07:17 AM

Hmm I solved it. But now I am setting the other one..I've installed the latest radius from debian repository and I set up it by this tutorial Authentication, Authorization & Accounting with FreeRadius & MySQL backend & web based Management with Daloradius | HowtoForge - Linux Howtos and Tutorials. I changed name of db to my own. But when I tried to start radius - I used "freeradius -X" (debug mode) - Radius seems to like running fine, but when I tried to connect ( with this - "radtest sqltest testpwd localhost 1812 testing123"), I've got this errors

Code:

# Executing section authorize from file /etc/freeradius/sites-enabled/default
+- entering group authorize {...}
Segmentation fault

What is wrong? I didn't found any answer