<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16414" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2><A
href="http://wiki.freeradius.org/Rlm_sql">http://wiki.freeradius.org/Rlm_sql</A></FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=nirmal_909@yahoo.com href="mailto:nirmal_909@yahoo.com">Nirmal</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=freeradius-users@lists.freeradius.org
href="mailto:freeradius-users@lists.freeradius.org">FreeRadius users mailing
list</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, April 09, 2007 1:53
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: two database</DIV>
<DIV><BR></DIV>
<DIV>can i use two sql database in sql.conf for free radius version 0.9
?</DIV>
<DIV> </DIV>
<DIV>currently i m using freeradius 0.9 + MySQL 3.23 + PPPoE on linux
(NAS)</DIV>
<DIV> </DIV>
<DIV>authentication and accounting is happening in one database. </DIV>
<DIV> </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 <STRONG>and</STRONG>
accounting will be done in <STRONG>database2 </STRONG>(radacct
table).<BR></DIV>
<DIV> </DIV>
<DIV>how to specify two database in sql.conf ? as there is only one line
<STRONG>radius_db. :(</STRONG></DIV>
<DIV><STRONG></STRONG> </DIV>
<DIV><STRONG></STRONG> </DIV>
<DIV>i did not find more help in docs of freeradius-1.1.5 !! Please
help</DIV>
<DIV> </DIV>
<DIV>Nirmal Patel</DIV>
<DIV>+91-9323704733</DIV>
<DIV><BR><BR><B><I>Alan DeKok <aland@deployingradius.com></I></B>
wrote:</DIV>
<BLOCKQUOTE class=replbq
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Nirmal
wrote:<BR>> Hi i m using freeradius 0.9<BR><BR>Why?<BR><BR>> is it
possible to select two sql databases in sql.conf ?<BR><BR>Yes.<BR><BR>>
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>
8:00? 8:25? 8:40? <A
href="http://tools.search.yahoo.com/shortcuts/?fr=oni_on_mail&#news">Find
a flick</A> in no time<BR>with the<A
href="http://tools.search.yahoo.com/shortcuts/?fr=oni_on_mail&#news">Yahoo!
Search movie showtime shortcut.</A>
<P>
<HR>
<P></P>- <BR>List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html</BLOCKQUOTE></BODY></HTML>