two database

[Nirmal]

Thanks Mr. Alan Dekok and Mr. Arran Cudbard-Bell  for your help. i tried the same and its working gr8.
   
   
  Thanks, i appreciate your help.
   
   
  Nirmal Patel
  +91-9323704733

  Arran Cudbard-Bell <A.Cudbard-Bell at sussex.ac.uk> wrote:
  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 /* 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 
> 
> with Yahoo! Mail for Mobile. Get started. 
> 
> ------------------------------------------------------------------------
>
> - 
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

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


 
---------------------------------
Never miss an email again!
Yahoo! Toolbar alerts you the instant new Mail arrives. Check it out.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20070409/71b7627b/attachment.html>