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