<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3020" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=815492019-28122006><FONT face=Arial
color=#0000ff size=2>Ok, I almost get it... question:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=815492019-28122006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=815492019-28122006><FONT face=Arial
color=#0000ff size=2>The mssql.conf file has an entry like
this:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=815492019-28122006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=815492019-28122006><FONT face=Arial
color=#0000ff size=2>#Database table configutation</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=815492019-28122006><FONT face=Arial
color=#0000ff size=2>radius_db = "radius"</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=815492019-28122006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=815492019-28122006><FONT face=Arial
color=#0000ff size=2>I assume that "radius" refers to a pre-determined schema
that freeRadius assumes the auth db is going to use. Thing is, I want to
reference a different schema, one that is used by my current customer care
system (Platypus).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=815492019-28122006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=815492019-28122006><FONT face=Arial
color=#0000ff size=2>Can I refer to a different schema? If so, where do I go to
define it? Does anyone happen to know if a Platypus schema already
exists?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=815492019-28122006><FONT face=Arial
color=#0000ff size=2>Or would I be better off to write triggers
in my current Platypus db to copy data from various tables to the radius tables
every time a customer record is updated?</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV align=left><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">Thank you for your time,<BR>Dave
Covert</SPAN></FONT> </DIV>
<DIV align=left><FONT face=Tahoma size=2></FONT> </DIV>
<DIV align=right><FONT face=Papyrus>I am serious... and don't call me
Shirley!</FONT></DIV>
<DIV> </DIV><FONT face=Papyrus></FONT><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
freeradius-users-bounces+dcovert=erfwireless.com@lists.freeradius.org
[mailto:freeradius-users-bounces+dcovert=erfwireless.com@lists.freeradius.org]
<B>On Behalf Of </B>Hernan Antolini<BR><B>Sent:</B> Thursday, December 28, 2006
11:29 AM<BR><B>To:</B> FreeRadius users mailing list<BR><B>Subject:</B> Re:
FreeRadius overview<BR></FONT><BR></DIV>
<DIV></DIV><BR><FONT face=sans-serif size=2><BR>David, start with "rlm_sql" at
source_directory/doc, check also your sql.conf in your installation etc/raddb
directory....it help me also this one to start
http://www.frontios.com/freeradius.html (for mysql).</FONT> <BR><BR><FONT
face=sans-serif size=2>I hope it helps....if you're about using ms-sql check
also "mssql" at source_directory/doc.</FONT> <BR><BR><FONT face=sans-serif
size=2>Regards</FONT> <BR><TT><FONT
size=2>freeradius-users-bounces+antolini=ar.ibm.com@lists.freeradius.org wrote
on 12/28/2006 01:37:51 PM:<BR><BR>> <BR>> I have gotten freeRadius
working with a mikrotik NAS using the users<BR>> flat file (hooray for me!
<g>). Now I need to have the freeRadius server<BR>> reference a MS-SQL
db server rather than the users file on the<BR>> freeRadius server. I am
quite fuzzy about the process tho. I am hoping<BR>> for some basic
edukashun.<BR>> <BR>> How do you tell freeRadius to reference an external
MS-SQL db rather<BR>> than the local users flat file?<BR>> How do you
issue the query to the db? (what file contains the connection<BR>> string and
query)<BR>> How do the returning fields get mapped into RADIUS attributes?
(what do<BR>> you do when the db calls the field "uname" and RADIUS calls
it<BR>> "user-name")<BR>> <BR>> Thank you for your time,<BR>> Dave
Covert <BR>> <BR>> - <BR>> List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html<BR></FONT></TT></BODY></HTML>