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@lists.freeradius.org [mailto:freeradius-users-bounces+dcovert=erfwireless.com@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@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