MS SQL Schema File

[Daniel Corbe]

I can give you the schema file and show you what to change in the
FreeRADIUS config to get it to work.

The rest is an excersise left to the reader.

There's plenty of documentation available on getting FreeTDS and
UnixODBC to peacfully coexist on a unix system and setting up Data
Sources and Driver Templates to connect to your MS SQL also isn't
hardto do.

This document may help you:
http://www.unixodbc.org/doc/FreeTDS.html

as it is the guide I used to get my configuration working

As always though, YMMV

I'd be willing to help you more in depth on a contractual basis.  My
background is quite extensive and there isn't much I cannot accomplish
if given the proper amount of time.  If you're interested, please call
me at 321-422-9083 so we can work out the details.

Regards,
Daniel Corbe

On 10/26/05, Troy Settle <troy at psknet.com> wrote:
>
> Daniel,
>
> I'd be most interested in seeing your work, from the MSSQL schema to
> your Freeradius, ODBC, and FreeTDS configurations.
>
> --
>    Troy Settle
>    Pulaski Networks
>    http://www.psknet.com
>    866.477.5638
>
>
> Daniel Corbe wrote:
> > I have a working schema file that I have loaded on my MS SQL server
> > right now that works with minor changes to the configuration file, if
> > anyone is interested in it.  How would I go about submiting it back
> > for review and inclusion into CVS as well as my cosemtic changes to
> > mssql.conf?
> >
> > -Daniel
> >
> > On 10/13/05, Craig Huckabee <huck at spawar.navy.mil> wrote:
> >
> >>
> >>Daniel Corbe wrote:
> >>
> >>
> >>>The mssql.conf file is still there and says:
> >>>
> >>>#  The database schema is available at:
> >>>#
> >>>#   src/radiusd/src/modules/rlm_sql/drivers/rlm_sql_freetds/db_mssql.sql
> >>>
> >>>:(
> >>>
> >>>-Daniel
> >>
> >>Get it from the CVS Attic:
> >>
> >>http://www.freeradius.org/cgi-bin/cvsweb.cgi/radiusd/src/modules/rlm_sql/drivers/rlm_sql_freetds/Attic/db_mssql.sql
> >>
> >>Grab the 1.3 revision (last one before the file was removed).
> >>
> >>--Craig
> >>
> >>
> >>-
> >>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
> >>
> >
> >
> > -
> > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>