MSSQL, bugs and a patch

[Sebastian Heil]

Hello everybody,

i try to work with a mssql-database. The connection to the database works fine, 
but there are some things missing and wrong in the schema and the dialup.conf.

I added the following part to the schema.sql to make sure, that there is a 
radpostauth-table in the mssql-database:

-
CREATE TABLE radpostauth (
[id] [int] IDENTITY (1, 1) NOT NULL,
[UserName] [varchar] (64) NOT NULL,
[pass] [varchar] (64) NOT NULL,
[reply] [varchar] (32) NOT NULL,
[authdate] [datetime] NOT NULL,
) on [PRIMARY]
GO


ALTER TABLE [radpostauth] WITH NOCHECK ADD
CONSTRAINT [DF_radpostauth_UserName] DEFAULT ('') FOR [UserName],
CONSTRAINT [DF_radpostauth_pass] DEFAULT ('') FOR [pass],
CONSTRAINT [DF_radpostauth_reply] DEFAULT ('') FOR [reply],
CONSTRAINT [DF_radpostauth_authdate] DEFAULT ('1900-01-01 00:00:00') 
FOR [authdate],
CONSTRAINT [PK_radpostauth] PRIMARY KEY  NONCLUSTERED
(
[id]
)  ON [PRIMARY];
GO
-

Maybe someone can verify this, if it is correct and maybe it is even worth to 
be supplied as a patch to the current version of the server.

In the next days, i will try to correct some other issues about the 
mssql-configuration and i will try to convert the missing dialup.conf from 
mysql to mssql. 
-- 
Pt! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: 
http://www.gmx.net/de/go/multimessenger01
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: MSSQL, bugs and a patch

[Sebastian Heil]

Hello,

forget this mail. I worked with an old version of the schema. In the new 
version, the radpostauth-table is already there...

 Original-Nachricht 
 Datum: Tue, 10 Feb 2009 11:58:20 +0100
 Von: Sebastian Heil s...@gmx.de
 An: freeradius-users@lists.freeradius.org
 Betreff: MSSQL, bugs and a patch

 Hello everybody,
 
 i try to work with a mssql-database. The connection to the database works
 fine, but there are some things missing and wrong in the schema and the
 dialup.conf.
 
 I added the following part to the schema.sql to make sure, that there is a
 radpostauth-table in the mssql-database:
 
 -
 CREATE TABLE radpostauth (
 [id] [int] IDENTITY (1, 1) NOT NULL,
 [UserName] [varchar] (64) NOT NULL,
 [pass] [varchar] (64) NOT NULL,
 [reply] [varchar] (32) NOT NULL,
 [authdate] [datetime] NOT NULL,
 ) on [PRIMARY]
 GO
 
 
 ALTER TABLE [radpostauth] WITH NOCHECK ADD
 CONSTRAINT [DF_radpostauth_UserName] DEFAULT ('') FOR [UserName],
 CONSTRAINT [DF_radpostauth_pass] DEFAULT ('') FOR [pass],
 CONSTRAINT [DF_radpostauth_reply] DEFAULT ('') FOR [reply],
   CONSTRAINT [DF_radpostauth_authdate] DEFAULT ('1900-01-01 00:00:00') FOR
 [authdate],
 CONSTRAINT [PK_radpostauth] PRIMARY KEY  NONCLUSTERED
 (
 [id]
 )  ON [PRIMARY];
 GO
 -
 
 Maybe someone can verify this, if it is correct and maybe it is even worth
 to be supplied as a patch to the current version of the server.
 
 In the next days, i will try to correct some other issues about the
 mssql-configuration and i will try to convert the missing dialup.conf from 
 mysql
 to mssql. 
 -- 
 Pt! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen:
 http://www.gmx.net/de/go/multimessenger01
 

-- 
Jetzt 1 Monat kostenlos! GMX FreeDSL - Telefonanschluss + DSL 
für nur 17,95 Euro/mtl.!* http://dsl.gmx.de/?ac=OM.AD.PD003K11308T4569a
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html