> 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