Yes, we got Acct-Terminate-Cause all wrong in emerald.cfg.
The line should read
AcctColumnDef AcctTerminateCause,Acct-Terminate-Cause,integer
That should fix your problem.
we apologise for the inconvenience, it is fixed in the next release.
Cheers
----------------------------------------------------------------------------
---------------
Mike McCauley [EMAIL PROTECTED]
Open System Consultants +61 3 9598 0985
Mike is travelling right now, and there may be delays
in our correspondence.
-----Original Message-----
From: michael <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Monday, March 01, 1999 9:40 PM
Subject: (RADIATOR) ODBC Error
>Hi all,
>
>I am getting an ODBC error and need some help.
>
>I noticed I wasn't getting any Terminate causes recording in the database,
I
>found the cause
>pretty quick:
>
>AcctColumnDef AcctTerminateCause,Acct_Terminate-Cause
> ^should be -
>
>That was from the emerald.cfg in the goodies box, anyway I got that sorted
>and getting
>the cause and I then got an ODBC error, I've added the log for you. Being
>new to all this I'm not sure whats going wrong, the "AcctTerminateCause"
>column does exist in the database.(Platypus)
>
>Mon Mar 1 19:38:58 1999: DEBUG: Packet dump:
>*** Received from 203.39.10.194 port 1645 ....
>Code: Accounting-Request
>Identifier: 45
>Authentic: <17><19><189><209><156>a<148><17><183>ML<171><213>s0=
>Attributes:
>Acct-Session-Id = "00101248"
>User-Name = "michael"
>NAS-IP-Address = 203.39.10.194
>NAS-Port = 17
>Acct-Status-Type = Stop
>Acct-Session-Time = 6
>Acct-Terminate-Cause = Lost-Carrier
>Acct-Authentic = RADIUS
>Called-Station-Id = "89620100"
>USR-Connect-Speed = 50666_BPS
>USR-Modulation-Type = v90Analogue
>USR-Simplified-MNP-Levels = mnpLevel4
>USR-Simplified-V42bis-Usage = NONE
>USR-Chassis-Call-Slot = 0
>USR-Chassis-Call-Span = 0
>USR-Chassis-Call-Channel = 19
>USR-Unauthenticated-Time = 21
>NAS-Identifier = "switch2"
>Acct-Input-Octets = 697
>Acct-Output-Octets = 456
>Acct-Input-Packets = 8
>Acct-Output-Packets = 6
>NAS-Port-Type = Async
>Service-Type = Framed-User
>Framed-Protocol = PPP
>Framed-IP-Address = 203.39.10.224
>Acct-Delay-Time = 0
>
>Mon Mar 1 19:38:58 1999: DEBUG: Handling request with Handler
>'Realm=DEFAULT'
>Mon Mar 1 19:38:58 1999: DEBUG: Handling with Radius::AuthEMERALD
>Mon Mar 1 19:38:58 1999: DEBUG: Handling accounting with
>Radius::AuthEMERALD
>Mon Mar 1 19:38:58 1999: DEBUG: do query is: insert into Calls
> (UserName, AcctStatusType, FramedAddress, NASIdentifier,
>AcctTerminateCause, NASPort, AcctDelayTime, CallDate, AcctSessionId,
>AcctInputOctets, AcctOutputOctets, AcctSessionTime)
> values
> ('michael', 2, '203.39.10.224', '203.39.10.194', 'Lost-Carrier', 17, 0,
>'Mar 1, 1999 19:38', '00101248', 697, 456, 6)
>
>Mon Mar 1 19:38:58 1999: ERR: do failed for 'insert into Calls
> (UserName, AcctStatusType, FramedAddress, NASIdentifier,
>AcctTerminateCause, NASPort, AcctDelayTime, CallDate, AcctSessionId,
>AcctInputOctets, AcctOutputOctets, AcctSessionTime)
> values
>
>>>>>>>
>('michael', 2, '203.39.10.224', '203.39.10.194', 'Lost-Carrier', 17, 0,
>'Mar 1, 1999 19:38', '00101248', 697, 456, 6)': [Microsoft][ODBC SQL Server
>Driver][SQL Server]Syntax error converting the varchar value 'Lost-Carrier'
>to a column of data type tinyint. (SQL-22005)(DBD: st_execute/SQLExecute
>err=-1)
>Mon Mar 1 19:38:58 1999: DEBUG: Deleting session for michael,
>203.39.10.194, 17
>Mon Mar 1 19:38:58 1999: DEBUG: Accounting accepted
>Mon Mar 1 19:38:58 1999: DEBUG: Packet dump:
>*** Sending to 203.39.10.194 port 1645 ....
>Code: Accounting-Response
>Identifier: 45
>Authentic: <17><19><189><209><156>a<148><17><183>ML<171><213>s0=
>Attributes:
>
>
>===
>To unsubscribe, email '[EMAIL PROTECTED]' with
>'unsubscribe radiator' in the body of the message.
>
===
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
