Re: two database

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

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