Reg: Different databases with single frerradius
Fajar A. Nugraha
list at fajar.net
Fri Jun 29 10:13:45 CEST 2012
On Fri, Jun 29, 2012 at 3:04 PM, Malla reddy Sama
<mallareddy.sama at yahoo.com> wrote:
> Dear all,
> Can any possible to manage two database(MySQL) with single radius server.
You mean USE more than one database? Sure. Just create different sql
module instances: http://wiki.freeradius.org/Rlm_sql#wiki-Instances
Each instance can connect to a different database or schema.
> Here, One database manage by one operator and another database manage by
> another operator. This two operators database data will not see each other.
You need to realize the consequences though. For example:
- where will you store accounting? is it on db1 or db2? or both?
- both database might have different information for the same user
(e.g. different password), thus making the result unpredictable
The usual case for different instances is if you use them for
different purposes (e.g. one to store user info, the other to store
accounting) or for different realms (e.g. all user @domain1 will read
data from db1, while all user @domain1 will read data from db2).
More information about the Freeradius-Users