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!
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