Hi i m using freeradius 0.9 is it possible to select two sql databases in sql.conf ? how ? Thanks In Advance Regards Nirmal Patel 9323704733 --------------------------------- TV dinner still cooling? Check out "Tonight's Picks" on Yahoo! TV.
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
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 <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 with Yahoo! Mail for Mobile. Get started.
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
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@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 --------------------------------- It's here! Your new message! Get new email alerts with the free Yahoo! Toolbar.
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@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.
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 <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 --------------------------------- Be a PS3 game guru. Get your game face on with the latest PS3 news and previews at Yahoo! Games.
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 <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 --------------------------------- Get your own web address. Have a HUGE year through Yahoo! Small Business.
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 <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 --------------------------------- 8:00? 8:25? 8:40? Find a flick in no time with theYahoo! Search movie showtime shortcut.
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 <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 ------------------------------------------------------------------------------ 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
participants (4)
-
Alan DeKok -
Arran Cudbard-Bell -
Nirmal -
Thor Spruyt