Re: [RadiusNT] Authentication Problem with Oracle

Dale E. Reed Jr. ( (no email) )
Sat, 30 Oct 1999 10:31:47 -0700

Salman Karim wrote:
>
> Plzzz see my previous email or see this attachment of debug.
> Dale I am still waiting yr ans.

> Checking for duplicate logins.
>
> SQL Statement: Select Count(Username) From ServerPorts Where Username='test' and AcctStatusType=1
>
> ODBC Error:22007:0:
> [Oracle][ODBC]Invalid datetime format.

This one is kind of wierd. I'm not sure why it it complaining about a
date
format, when there is no date columns involved in this query?

> SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type, rc.RadVendorID, rc.RadVendorType, rc.RadCheck From RadConfigs rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.A
> ccountID=1
>
> SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type, rc.RadVendorID, rc.RadVendorType, rc.RadCheck From RadATConfigs rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc
> .AccountType='PPP'
>
> Sending Reject of id 8 to c0a80120 (192.168.1.32)
> test: PPP has no RADIUS default attributes.
>
> test: PPP has no RADIUS default attributes.

I summarized this earlier. You need to put some records in the
RadATConfigs table like:

RadATConfigID int IDENTITY(1,1) CONSTRAINT pk_RadATConfigID PRIMARY KEY
,
AccountType varchar (15) NOT NULL REFERENCES AccountTypes(AccountType),

RadAttributeID int NOT NULL,
RadVendorID int NOT NULL DEFAULT 0 REFERENCES RadVendors(RadVendorID),
RadVendorType int NOT NULL DEFAULT 0, CONSTRAINT
fk_RadATConfigs_RadAttributes
FOREIGN KEY (RadAttributeID, RadVendorID, RadVendorType)
REFERENCES RadAttributes (RadAttributeID, RadVendorID, RadVendorType),
Data varchar (100) NOT NULL,
Value int NULL ,
RadCheck tinyint NULL DEFAULT 0

INSERT RadATConfigs(AccountType, RadAttributeID, RadVendorID,
RadVendorType, Data, Value, RadCheck) VALUES('PPP', 6, 0, 0, '2', 2, 0)
INSERT RadATConfigs(AccountType, RadAttributeID, RadVendorID,
RadVendorType, Data, Value, RadCheck) VALUES('PPP', 7, 0, 0, '1', 1, 0)

-- 

Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com

For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart