move /etc/raddb/users file to mysql

Alan DeKok aland at
Mon Jan 28 15:05:02 CET 2013

Stefan König wrote:
> I inherited an old freeradius 1.1.8 system which is configured to use a
> mysql DB.


> So far so good, but now I discovered, that someone also created a
> /etc/raddb/users file with some DEFAULT information in it.
> The funny thing is, that I have also some DEFAULT information in my DB
> in radgroupreply, which is where I think the data from the "users" file
> belongs.
> As far as I see in our config, the flat files have precedence over SQL.

  If "files" is listed before "sql", then yes.

> I am not very deep into freeradius, so I have some questions which I
> hope someone can answer:
> 1) Does the data from the "users" file go into radgroupreply table?

  You can do that.  See the rlm_sql documentation.

> 2) I have a DEFAULT groupname in the DB and in the flat file, will I
> have to rename the flat file DEFAULT groupname to something else to
> avoid problems?


> 3) "op" needs to be "=~" and ":=" for the first to settings and "==" for
> all the following?

  Read the documentation.  Please.  I'm not going to cut & paste it here.

  Alan DeKok.

More information about the Freeradius-Users mailing list