Re: two database
http://wiki.freeradius.org/Rlm_sql - Original Message - From: Nirmal To: FreeRadius users mailing list Sent: Monday, April 09, 2007 1:53 PM Subject: Re: two database 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. :( i did not find more help in docs of freeradius-1.1.5 !! Please help Nirmal Patel +91-9323704733 Alan DeKok <[EMAIL PROTECTED]> 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 -- 8:00? 8:25? 8:40? Find a flick in no time with theYahoo! Search movie showtime shortcut. -- - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: two database
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 <[EMAIL PROTECTED]> 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.-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: two database
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 <[EMAIL PROTECTED]> 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
-
It's here! Your new message!
Get new email alerts with the free Yahoo! Toolbar.-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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 <[EMAIL PROTECTED]>/* 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
Re: two database
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. :( i did not find more help in docs of freeradius-1.1.5 !! Please help Nirmal Patel +91-9323704733 Alan DeKok <[EMAIL PROTECTED]> 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 - 8:00? 8:25? 8:40? Find a flick in no time with theYahoo! Search movie showtime shortcut.- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: two database
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. :( i did not find more help in docs of freeradius-1.1.5 !! Please help Nirmal Patel +91-9323704733 Alan DeKok <[EMAIL PROTECTED]> 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 - Get your own web address. Have a HUGE year through Yahoo! Small Business.- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: two database
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. :( i did not find more help in docs of freeradius-1.1.5 !! Please help Nirmal Patel +91-9323704733 Alan DeKok <[EMAIL PROTECTED]> 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 - Be a PS3 game guru. Get your game face on with the latest PS3 news and previews at Yahoo! Games.- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: two database
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. :( i did not find more help in docs of freeradius-1.1.5 !! Please help Nirmal Patel +91-9323704733 Alan DeKok <[EMAIL PROTECTED]> 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
Re: two database
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
