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" <[email protected]> > An: [email protected] > 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. > -- > Psssst! 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
