> Yes I've made sure the dictionary (radattributes) is set right with #4, #32
> and I've tried the field name NASIdentifier and NAS-Identifier and still
> radius doesn't see it.
RadiusNT loads column information for just the first 40 columns. This
limit will go away in the next patch.
I'd suggest deleting the old columns or rebuilding a smaller Calls
table. Having so many columns is going to eat lots of disk/performance.
Have Fun!
Peter
> I see from the Testing Datasources below that CallDate3 is found below but
> CallDate. When I converted the CallDate from text to date/time type I renamed
> CallDate to CallDate3 and made a new CallDate. So now I don't see CallDate,
> NASIdentifier and OuputOctets in the Testing Datasources below.
>
> Here is a capture of Testing Datasources...
>
> Testing Datasources...
> LiveAccounting = OK
> InterPC-Calls2 = OK
> Unlimited MBR License
> SQL Statement: Select Name, RadAttributeID, Type, RadVendorID, RadVendorType,
> AliasAttributeID, AliasVendorID
> FROM RadAttributes Order By RadVendorID ASC, RadAttributeID DESC,
> RadVendorType DESC
> SQL Statement: Select Name, RadAttributeID, Type, RadVendorID, RadVendorType
> From
> RadAttributes Order By RadVe
> ndorID ASC, RadAttributeID DESC, RadVendorType DESC
> SQL Statement: Select Name, RadAttributeID, Type, RadVendorID, RadVendorType
> From
> RadAttributes Order By RadVe
> ndorID ASC, RadAttributeID DESC, RadVendorType DESC
> SQL Statement: SELECT ra.Name, rv.Name, rv.Value, rv.RadVendorID,
> rv.RadVendorType FROM
> RadValues rv, RadAttri
> butes ra WHERE rv.RadAttributeID = ra.RadAttributeID AND rv.RadVendorType =
> ra.RadVendorType AND rv.RadVendorI
> D = ra.RadVendorID
> 137 Dictionary Attributes Loaded...
> SQL Statement: Select ServerID, Server, IPAddress, Secret From Servers
> 6 Clients Loaded
> Calls Column 0 (10): 'ModemLinkECC'
> Calls Column 1 (10): 'ModemTransmitSpeed'
> Calls Column 2 (10): 'ModemLinkMod'
> Calls Column 3 (10): 'AscendFirstDes'
> Calls Column 4 (10): 'AscendConnectProgress'
> Calls Column 5 (10): 'AscendMultilinkID'
> Calls Column 6 (50): 'ModemCardPort'
> Calls Column 7 (10): 'AcctOutputPackets'
> Calls Column 8 (10): 'ModemTerminationCause'
> Calls Column 9 (15): 'CallerID'
> Calls Column 10 (10): 'ClientPortDNIS'
> Calls Column 11 (10): 'AscendNumberSessions'
> Calls Column 12 (10): 'InputOctets'
> Calls Column 13 (32): 'ConnectInfo'
> Calls Column 14 (10): 'ISDNTerminationCause'
> Calls Column 15 (10): 'AcctTerminateCause'
> Calls Column 16 (10): 'ModemLinkComp'
> Calls Column 17 (10): 'AscendPreSessionTim'
> Calls Column 18 (5): 'AcctStatusType'
> Calls Column 19 (10): 'AcctInputPackets'
> Calls Column 20 (10): 'AscendNumInMultilink'
> Calls Column 21 (10): 'AscendPreInputPackets'
> Calls Column 22 (5): 'UserService'
> Calls Column 23 (25): 'CallDate3'
> Calls Column 24 (12): 'UserName'
> Calls Column 25 (10): 'AcctSessionTime'
> Calls Column 26 (10): 'AcctSessionId'
> Calls Column 27 (10): 'AcctDataRate'
> Calls Column 28 (10): 'AscendPreOutputPackets'
> Calls Column 29 (10): 'NASPort'
> Calls Column 30 (10): 'ServerID'
> Calls Column 31 (15): 'NASPortDNIS'
> Calls Column 32 (10): 'AccountID'
> Calls Column 33 (50): 'GandalfASID'
> Calls Column 34 (10): 'ModemReceiveSpeed'
> Calls Column 35 (10): 'ModemSlotNo'
> Calls Column 36 (10): 'AscendPreInputOctets'
> Calls Column 37 (16): 'FramedAddress'
> Calls Column 38 (10): 'ModemPortNo'
> Calls Column 39 (10): 'AcctDelayTime'
> 40 Calls Columns Loaded
> RadLogs Column 0 (15): 'CallerID'
> RadLogs Column 1 (10): 'RadLogMsgID'
> RadLogs Column 2 (16): 'Username'
> RadLogs Column 3 (19): 'LogDate'
> RadLogs Column 4 (64): 'Data'
> 5 RadLogs Columns Loaded
> ServerPorts Column 0 (10): 'Port'
> ServerPorts Column 1 (10): 'CostPerMinute'
> ServerPorts Column 2 (64): 'SNMPUser'
> ServerPorts Column 3 (5): 'AcctStatusType'
> ServerPorts Column 4 (25): 'UserName'
> ServerPorts Column 5 (10): 'ServerID'
> ServerPorts Column 6 (16): 'IPAddress'
> ServerPorts Column 7 (16): 'FramedAddress'
> ServerPorts Column 8 (10): 'MaxSessionTime'
> ServerPorts Column 9 (19): 'CallDate'
> 10 ServerPorts Columns Loaded
> RadiusNT 3.0.168
> Standard Initialized...
>
> SQL Statement: SELECT Now() FROM Licenses
> SQL Statement: SELECT Now() FROM Licenses
> SQL Statement: Select Domain AS Label, Server, IPAddress, Secret, AuthPort,
> AcctPort,
> Priority, Timeout, Retri
> es, StripDomain, TreatAsLocal, AccountType From RadRoamDomains rrd,
> RadRoamServers rrs
> Where rrd.RadRoamServe
> rID = rrs.RadRoamServerID UNION Select rrd2.Domain AS Label, Server,
> IPAddress, Secret,
> AuthPort, AcctPort, r
> rd.Priority, Timeout, Retries, StripDomain, TreatAsLocal, rrd.AccountType From
>
> RadRoamDomains rrd, RadRoamServ
> ers rrs, RadRoamDomains rrd2 Where rrd.RadRoamServerID =
> rrs.RadRoamServerID AND
> rrd.Domain = 'DEFAULT' UNI
> ON Select FORMAT(RadRoamServerID,' ') AS Label, Server, IPAddress, Secret,
> AuthPort,
> AcctPort, 0, Timeout, Re
> tries, StripDomain, TreatAsLocal, NULL From RadRoamServers Order By
> Label,Priority ASC
> SQL Statement: Select rc.AccountType, ra.RadAttributeID, Name, Data, Value,
> Type,
> rc.RadVendorID, rc.RadVendo
> rType, rc.RadCheck From RadATConfigs rc, RadAttributes ra Where
> ra.RadAttributeID=rc.RadAttributeID AND (r
> a.RadVendorID = rc.RadVendorID OR rc.RadVendorID IS NULL) AND
> (ra.RadVendorType =
> rc.RadVendorType OR rc
> .RadVendorType IS NULL) ORDER BY AccountTyperadrecv: Request from host
> d85fa782
> (MAXWarp2) code=4, id=122, le
> ngth=223
>
> --
> Mike Kovacich
> System Administrator
> sysadmin@inter-pc.com
>
> Inter-PC Internet Services
> WarpLink Communications
> http://www.inter-pc.com
>
>
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
>
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart