Re: move /etc/raddb/users file to mysql

2013-01-28 Thread Alan DeKok 
Stefan König wrote:
> I inherited an old freeradius 1.1.8 system which is configured to use a
> mysql DB.

  Upgrade

> 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?

  No.

> 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.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

move /etc/raddb/users file to mysql

2013-01-28 Thread Stefan König 
Hello List,

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.

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?
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?

For your reference here is the anonymized content of my users file:

DEFAULT User-Name =~"@example\.net$",
Auth-Type := "Accept"
Context-Name == local,
Tunnel-Domain == 1,
Tunnel-Type == L2TP,
Tunnel-Medium-Type == IP,
Tunnel-Client-Endpoint == xxx.xxx.xxx.xxx,
Tunnel-Server-Endpoint == yyy.xxx.xxx.xxx,
Tunnel-Password == password,
Tunnel-Assignment-Id == zzz.xxx.xxx.xxx,
Tunnel-Function == 1,
Tunnel-Local-Name == EXAMPLE.NET


Thanks for any help or hints!


regards
Stefan
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html