Hello, I have unixodbc configured as the SQL back end for my RADIUS server and the back end database is an MS SQL Server. Does anyone have a schema available for MS SQL Server? This would need to include a unix_timestamp stored procedure. Please help -Daniel
It seems to me like (reading back in the archives) there used to be a schmea file for MS SQL servers but that was removed from the archive once FreeTDS support was dropped. Can anyone lend me a hand here? On 10/12/05, Daniel Corbe <daniel.junkmail@gmail.com> wrote:
Hello,
I have unixodbc configured as the SQL back end for my RADIUS server and the back end database is an MS SQL Server.
Does anyone have a schema available for MS SQL Server? This would need to include a unix_timestamp stored procedure.
Please help
-Daniel
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 On 10/13/05, Daniel Corbe <daniel.junkmail@gmail.com> wrote:
It seems to me like (reading back in the archives) there used to be a schmea file for MS SQL servers but that was removed from the archive once FreeTDS support was dropped.
Can anyone lend me a hand here?
On 10/12/05, Daniel Corbe <daniel.junkmail@gmail.com> wrote:
Hello,
I have unixodbc configured as the SQL back end for my RADIUS server and the back end database is an MS SQL Server.
Does anyone have a schema available for MS SQL Server? This would need to include a unix_timestamp stored procedure.
Please help
-Daniel
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/dri... Grab the 1.3 revision (last one before the file was removed). --Craig
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@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/dri...
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
Don't know anything about submitting things for a software update, but im always willing to work on modification projects :-) -----Original Message----- From: freeradius-users-bounces@lists.freeradius.org [mailto:freeradius-users-bounces@lists.freeradius.org] On Behalf Of Daniel Corbe Sent: Monday, October 24, 2005 5:18 PM To: FreeRadius users mailing list Subject: Re: MS SQL Schema File 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@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/dri vers/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
Daniel Corbe <daniel.junkmail@gmail.com> 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?
bugs.freeradius.org. Submit an enhancement request. Alan DeKok.
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@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/dri...
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
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@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
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@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/dri...
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
Daniel Corbe wrote: - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
That was supposed to be a reply directly to him, not to the list. Sorry! -Daniel On 10/26/05, Daniel Corbe <daniel.junkmail@gmail.com> wrote:
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@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
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@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/dri...
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
Daniel Corbe wrote: - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (5)
-
Alan DeKok -
Alex M -
Craig Huckabee -
Daniel Corbe -
Troy Settle