two database

Arran Cudbard-Bell A.Cudbard-Bell at sussex.ac.uk
Mon Apr 9 13:58:20 CEST 2007


Nirmal wrote:
> can i use two sql database in sql.conf for free radius version 0.9 ?
>  
> currently i m using freeradius 0.9 + MySQL 3.23 + PPPoE on linux (NAS)
>  
> authentication and accounting is happening in one database.
>  
> i have a very large user database and i want to assign roaming profile 
> to my users, in that case users will be authenticated from *database1* 
> which is having authentication information (radcheck, 
> radgroupcheck,radreply) of all users *and* accounting will be done in 
> *database2 *(radacct table).
>  
> how to specify two database in sql.conf ? as there is only one line 
> *radius_db. :(*
> **
You have two instances of the sql module config in sql.conf

so first default instance is
sql {
    directive = whatever
    .... config for database1
}
second for accounting
sql sql_accounting {
    directive = whatever
    .... config for database2
}

You then reference sql_accounting instead of just plain sql in the 
accounting sections .

> ** 
> i did not find more help in docs of freeradius-1.1.5 !!  Please help
>  
> Nirmal Patel
> +91-9323704733
>
>
> */Alan DeKok <aland at deployingradius.com>/* wrote:
>
>     Nirmal wrote:
>     > Hi i m using freeradius 0.9
>
>     Why?
>
>     > is it possible to select two sql databases in sql.conf ?
>
>     Yes.
>
>     > how ?
>
>     See the documentation in the recent versions.
>
>     Alan DeKok.
>     --
>     http://deployingradius.com - The web site of the book
>     http://deployingradius.com/blog/ - The blog
>     -
>     List info/subscribe/unsubscribe? See
>     http://www.freeradius.org/list/users.html
>
>
> ------------------------------------------------------------------------
> No need to miss a message. Get email on-the-go 
> <http://us.rd.yahoo.com/evt=43910/*http://mobile.yahoo.com/mail>
> with Yahoo! Mail for Mobile. Get started. 
> <http://us.rd.yahoo.com/evt=43910/*http://mobile.yahoo.com/mail>
> ------------------------------------------------------------------------
>
> - 
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html




More information about the Freeradius-Users mailing list