Re: radlogin

Dale E. Reed Jr. ( (no email) )
Tue, 18 Aug 1998 11:10:25 -0700

Lanham Rattan wrote:
>
> I am trying to use radlogin from the same machine that I have RadiusNT 2.5
> running.
>
> radlogin test test
>
> Results...
>
> Decrypted Password:j+S
> Database Password: test
> Sending Reject of id 199 to cc857882 (Local Test)
>
> SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, Username, Data)
> VALUE
> S (11, GetDate(), 'test', j+S')
>
> ODBC Error:S0022:207:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Data'.

Make sure you have an entry in your servers table matching the same IP
and secret in your server file for Radlogin. The secrets are not
matching,
which is causing the password problem. This is covered in the "testing"
section of the RadiusNT 2.5 manual.

> ...why is the password failing. I have no secret set for the server.

Thats exactly why.

> I would like to add the Data field (SQL) but when I tried it corrupted the
> database. Are there any specific directions to do so.

It shouldn't corrupt it. I use a command like this is isql_w:

ALTER TABLE RadLogs
ADD Data varchar (50) NULL DEFAULT NULL
GO

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com