Re: two database

--===============0723840595==
Content-Type: multipart/alternative; boundary="0-1572700831-1176119632=:76159"
Content-Transfer-Encoding: 8bit

--0-1572700831-1176119632=:76159
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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.
--0-1572700831-1176119632=:76159
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<DIV>can i use two sql database in sql.conf for free radius version 0.9 ?</DIV> <DIV>&nbsp;</DIV> <DIV>currently i m using freeradius 0.9 + MySQL 3.23 + PPPoE on linux (NAS)</DIV> <DIV>&nbsp;</DIV> <DIV>authentication and accounting is happening in one database. </DIV> <DIV>&nbsp;</DIV> <DIV>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 <STRONG>database1</STRONG> which is having authentication information (radcheck, radgroupcheck,radreply) of all users&nbsp;<STRONG>and</STRONG> accounting will be done in <STRONG>database2 </STRONG>(radacct table).<BR></DIV> <DIV>&nbsp;</DIV> <DIV>how to specify two database in sql.conf ? as there is only one line <STRONG>radius_db. :(</STRONG></DIV> <DIV><STRONG></STRONG>&nbsp;</DIV> <DIV><STRONG></STRONG>&nbsp;</DIV> <DIV>i did not find more help in docs of freeradius-1.1.5 !!&nbsp; Please help</DIV> <DIV>&nbsp;</DIV> <DIV>Nirmal Patel</DIV>
<DIV>+91-9323704733</DIV> <DIV><BR><BR><B><I>Alan DeKok &lt;aland@deployingradius.com&gt;</I></B> wrote:</DIV> <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Nirmal wrote:<BR>&gt; Hi i m using freeradius 0.9<BR><BR>Why?<BR><BR>&gt; is it possible to select two sql databases in sql.conf ?<BR><BR>Yes.<BR><BR>&gt; how ?<BR><BR>See the documentation in the recent versions.<BR><BR>Alan DeKok.<BR>--<BR>http://deployingradius.com - The web site of the book<BR>http://deployingradius.com/blog/ - The blog<BR>- <BR>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html<BR></BLOCKQUOTE><BR><p>

<hr size=1>
<a href="http://us.rd.yahoo.com/evt=49678/*http://smallbusiness.yahoo.com/domains/?p=BESTDEAL"> Get your own web address.</a><br> Have a HUGE year through <a href="
http://us.rd.yahoo.com/evt=49678/*http://smallbusiness.yahoo.com/domains/?p=BESTDEAL">Yahoo! Small Business.</a>
--0-1572700831-1176119632=:76159--

--===============0723840595==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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