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.

Reply via email to