FreeRadius overview

[David Covert]

Ok, I almost get it...  question:
 
The mssql.conf file has an entry like this:
 
#Database table configutation
radius_db = "radius"
 
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).
 
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?
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?
 
Thank you for your time,
Dave Covert 
 
I am serious... and don't call me Shirley!
 


  _____  

From:
freeradius-users-bounces+dcovert=erfwireless.com at lists.freeradius.org
[mailto:freeradius-users-bounces+dcovert=erfwireless.com at lists.freeradiu
s.org] On Behalf Of Hernan Antolini
Sent: Thursday, December 28, 2006 11:29 AM
To: FreeRadius users mailing list
Subject: Re: FreeRadius overview




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). 

I hope it helps....if you're about using ms-sql check also "mssql" at
source_directory/doc. 

Regards 
freeradius-users-bounces+antolini=ar.ibm.com at lists.freeradius.org wrote
on 12/28/2006 01:37:51 PM:

>  
> I have gotten freeRadius working with a mikrotik NAS using the users
> flat file (hooray for me! <g>). Now I need to have the freeRadius
server
> reference a MS-SQL db server rather than the users file on the
> freeRadius server. I am quite fuzzy about the process tho. I am hoping
> for some basic edukashun.
> 
> How do you tell freeRadius to reference an external MS-SQL db rather
> than the local users flat file?
> How do you issue the query to the db? (what file contains the
connection
> string and query)
> How do the returning fields get mapped into RADIUS attributes? (what
do
> you do when the db calls the field "uname" and RADIUS calls it
> "user-name")
> 
> Thank you for your time,
> Dave Covert 
> 
> - 
> List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20061228/9f1c9d56/attachment.html>