Hi,
I recently installed iPass on our network and I noticed that some Stop
records are not being inserted in the accounting table. In the logs, it
has the error:
---------------------------------------------------------------------------
[OpenLink][ODBC][SQL Server]Arithmetic overflow error converting numeric
to data type int
---------------------------------------------------------------------------
I've looked at my radius.cfg and I compared all the integer fields to
the data that's trying to be inserted into those fields. The only
integer field that has no data being inserted is the Acct-Delay-Time.
I don't know why these Stop records are not being recorded. Anybody
have a clue?
cfg file
--------------------------------------------------------------------
AccountingTable ACCOUNTING
AcctColumnDef IDENTIFIER,User-Name
AcctColumnDef TIME_STAMP,Timestamp,formatted-date,'%m-%d-%Y
%H:%M:%S'
-> AcctColumnDef DURATION,Acct-Session-Time,integer
AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
-> AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer
-> AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer
-> AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
AcctColumnDef ACCTSESSIONID,Acct-Session-Id
AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause
AcctColumnDef NASIDENTIFIER,NAS-IP-Address
-> AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
AcctColumnDef CONNECTSPEED,Connect-Info
AcctColumnDef CONNECTSPEED,USR-Connect-Speed
AcctColumnDef CALLERID,Calling-Station-Id
AcctColumnDef POPID,Called-Station-Id
logfile
--------------------------------------------------------------------
Wed Jan 24 20:19:09 2001: ERR: do failed for 'insert into ACCOUNTING
(IDENTIFIER, TIME_STAMP, DURATION, ACCTSTATUSTYPE,
ACCTINPUTOCTETS, ACCTOUTPUTOCTETS, ACCTSESSIONID, NASIDENTIFIER,
NASPORT, FRAMEDIPADDRESS, POPID)
values
('lcf', '01-24-2001 20:19:08', 153, 'Stop', 471793664,
2636644608, '327172759', '210.253.96.17', 21606, '210.253.98.190', '')':
[OpenLink][ODBC][SQL Server]Arithmetic overflow error converting numeric
to data type int. (SQL-S1000)(DBD: st_execute/SQLExecute err=-1)
I'd appreciate any help or hints!!!
Thank you,
Janet
_____________________________________________________
Janet del Mundo
Internet Administrator, Startec Global Communications
135 Chalan Santo Papa Agana, Guam 96910
Email: [EMAIL PROTECTED]
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.