[prev in list] [next in list] [prev in thread] [next in thread]
List: freeradius-users
Subject: Re: use realms to access different mysql tables
From: Alexander Papenburg <freeradius () papenb ! org>
Date: 2007-03-28 19:43:06
Message-ID: 460AC54A.90400 () papenb ! org
[Download RAW message or body]
Hi Kevin,
this works very well (still some probs with accounting, but hey i'll get
it tomorrow), thanks for your advice.
Cheers!
Alexander
Kevin Bonner schrieb:
> On Tuesday 27 March 2007 18:13:09 Alexander Papenburg wrote:
>> Hi Freeradius-Mailing-List,
>>
>> does anyone of you differentiate sql database table with realms?
>> E.g.:
>>
>> Auth-Requests for user1@realm1 will be checked against table db_radius1
>> Auth-Requests for user1@realm2 will be checked against table db_radius2
>> .....and so on.
>>
>> I already found out that it is possible to use multiple sql instances,
>> but for what i understand is that they would be asked/checked one after
>> another. That would be nice for failover scenarios but if there are
>> about 20-30 realms to check it would be result in a very slow
>> performance (depending on mysql host speed).
>> So is there a better way to solve this Problem? All users in one
>> database is at the time unfortunately no option...
>>
>>
>> Thanks in advance
>>
>> Alex
>
> An example of this is below. In each sql definition you can define the
> different queries necessary to handle a particular realm. realm3 shows how
> to allow multiple realms to use the same db/SQL queries, so you can easily
> merge the databases over time and update the users file to reflect the db
> changes.
>
> Kevin Bonner
>
> == sql.conf ==
> sql db1 { ... }
> sql db2 { ... }
> ...
> == sql.conf ==
>
> == radiusd.conf ==
> authorize {
> ...
> Autz-Type SQL1 {
> db1
> }
> Autz-Type SQL2 {
> db2
> }
> }
> == radiusd.conf ==
>
> == users ==
> DEFAULT Realm == "realm1", Autz-Type := SQL1
> DEFAULT Realm == "realm2", Autz-Type := SQL2
> DEFAULT Realm == "realm3", Autz-Type := SQL2
> ... OR
> DEFAULT User-Name =~ "@realm1$", Autz-Type := SQL1
> DEFAULT User-Name =~ "@realm2$", Autz-Type := SQL2
> DEFAULT User-Name =~ "@realm3$", Autz-Type := SQL2
> == users ==
>
>
> ------------------------------------------------------------------------
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic