Hi,
I have installed freeRadius 1.0.1 with postgresql to receive accounting from
a cisco 2600.
When freeradius receive accounting from the cisco router I have an error and
I see that this error have already be reported to this mailing list but I
don’t see the solution.
Thanks for help
Laurent
Module: Instantiated sql (pgsql-voip)
Initializing the thread pool...
Listening on authentication *:1812
Listening on accounting *:1813
Listening on proxy *:1814
Ready to process requests.
rad_recv: Accounting-Request packet from host 193.134.216.170:1646, id=11,
length=616
Acct-Session-Id = "0000005B"
Cisco-AVPair = "[EMAIL PROTECTED]"
Cisco-AVPair = "iphop=count:2"
Cisco-AVPair = "iphop=hop1:193.134.216.160"
Cisco-AVPair = "iphop=hop2:84.226.113.34"
h323-setup-time = "h323-setup-time=*15:29:55.082 GMT Tue Mar 2 1993"
h323-gw-id = "h323-gw-id=SIP-GW.tcom.eivd.ch"
h323-conf-id = "h323-conf-id=D7218093 162811CC 801BEB9D F55885DD"
h323-call-origin = "h323-call-origin=answer"
h323-call-type = "h323-call-type=VoIP"
Cisco-AVPair = "h323-incoming-conf-id=D7218093 162811CC 801BEB9D F55885DD"
Cisco-AVPair = "subscriber=Unknown"
Cisco-AVPair = "session-protocol=sipv2"
Cisco-AVPair = "gw-rxd-cdn=ton:0,npi:0,#:0787518551"
Acct-Authentic = 0
User-Name = "0244202373"
Acct-Status-Type = Start
Calling-Station-Id = "0244202373"
Called-Station-Id = "0787518551"
Service-Type = Login-User
NAS-IP-Address = 193.134.216.170
Acct-Delay-Time = 0
rlm_sql (pgsql-voip): Reserving sql socket id: 24
rlm_sql_postgresql: Status: PGRES_FATAL_ERROR
rlm_sql_postgresql: affected rows =
rlm_sql_postgresql: Postgresql check_error: PGRES_FATAL_ERROR, returning
SQL_DOWN
rlm_sql (pgsql-voip): Attempting to connect rlm_sql_postgresql #24
rlm_sql (pgsql-voip): Connected new DB handle, #24
rlm_sql_postgresql: Status: PGRES_FATAL_ERROR
rlm_sql_postgresql: affected rows =
rlm_sql_postgresql: Postgresql check_error: PGRES_FATAL_ERROR, returning
SQL_DOWN
rlm_sql (pgsql-voip): failed after re-connect
rlm_sql (pgsql-voip): Couldn't insert SQL accounting START record - ERROR:
invalid input syntax for type timestamp with time zone: "=2A15:29:55.082 GMT
Tue Mar 2 1993" CONTEXT: PL/pgSQL function "strip_dot" while casting return
value to function's return type
rlm_sql (pgsql-voip): Released sql socket id: 24
Sending Accounting-Response of id 11 to 193.134.216.170:1646
rad_recv: Accounting-Request packet from host 193.134.216.170:1646, id=12,
length=514
Acct-Session-Id = "0000005C"
h323-setup-time = "h323-setup-time=*15:29:55.504 GMT Tue Mar 2 1993"
h323-gw-id = "h323-gw-id=SIP-GW.tcom.eivd.ch"
h323-conf-id = "h323-conf-id=D7218093 162811CC 801BEB9D F55885DD"
h323-call-origin = "h323-call-origin=originate"
h323-call-type = "h323-call-type=Telephony"
Cisco-AVPair = "h323-incoming-conf-id=D7218093 162811CC 801BEB9D F55885DD"
Cisco-AVPair = "subscriber=Unknown"
Cisco-AVPair = "out-intrfc-desc=*** VIC 0 ***"
Cisco-AVPair = "gw-rxd-cdn=ton:0,npi:0,#:0787518551"
Acct-Authentic = 0
User-Name = "0244202373"
Acct-Status-Type = Start
NAS-Port-Type = Async
Cisco-NAS-Port = "BRI 1/0/0:1"
NAS-Port = 0
Calling-Station-Id = "0244202373"
Called-Station-Id = "0787518551"
Service-Type = Login-User
NAS-IP-Address = 193.134.216.170
Acct-Delay-Time = 0
rlm_sql (pgsql-voip): Reserving sql socket id: 23
rlm_sql_postgresql: Status: PGRES_FATAL_ERROR
rlm_sql_postgresql: affected rows =
rlm_sql_postgresql: Postgresql check_error: PGRES_FATAL_ERROR, returning
SQL_DOWN
rlm_sql (pgsql-voip): Attempting to connect rlm_sql_postgresql #23
rlm_sql (pgsql-voip): Connected new DB handle, #23
rlm_sql_postgresql: Status: PGRES_FATAL_ERROR
rlm_sql_postgresql: affected rows =
rlm_sql_postgresql: Postgresql check_error: PGRES_FATAL_ERROR, returning
SQL_DOWN
rlm_sql (pgsql-voip): failed after re-connect
rlm_sql (pgsql-voip): Couldn't insert SQL accounting START record - ERROR:
invalid input syntax for type timestamp with time zone: "=2A15:29:55.504 GMT
Tue Mar 2 1993" CONTEXT: PL/pgSQL function "strip_dot" while casting
return value to function's return type
rlm_sql (pgsql-voip): Released sql socket id: 23
Sending Accounting-Response of id 12 to 193.134.216.170:1646
rad_recv: Accounting-Request packet from host 193.134.216.170:1646, id=13,
length=1345
Acct-Session-Id = "0000005C"
h323-setup-time = "h323-setup-time=*15:29:55.504 GMT Tue Mar 2 1993"
h323-gw-id = "h323-gw-id=SIP-GW.tcom.eivd.ch"
h323-conf-id = "h323-conf-id=D7218093 162811CC 801BEB9D F55885DD"
h323-call-origin = "h323-call-origin=originate"
h323-call-type = "h323-call-type=Telephony"
Cisco-AVPair = "h323-incoming-conf-id=D7218093 162811CC 801BEB9D F55885DD"
Cisco-AVPair = "subscriber=Unknown"
Cisco-AVPair = "out-intrfc-desc=*** VIC 0 ***"
Cisco-AVPair = "gw-rxd-cdn=ton:0,npi:0,#:0787518551"
h323-connect-time = "h323-connect-time=*15:30:07.145 GMT Tue Mar 2 1993"
Acct-Input-Octets = 32960
Acct-Output-Octets = 5600
Acct-Input-Packets = 206
Acct-Output-Packets = 35
Acct-Session-Time = 4
h323-disconnect-time = "h323-disconnect-time=*15:30:10.842 GMT Tue Mar 2
1993"
h323-disconnect-cause = "h323-disconnect-cause=10"
Cisco-AVPair = "h323-ivr-out=Tariff:Unknown"
Cisco-AVPair = "release-source=3"
h323-voice-quality = "h323-voice-quality=0"
Cisco-AVPair = "alert-timepoint=*15:29:59.912 GMT Tue Mar 2 1993"
Cisco-AVPair = "gw-rxd-cgn=ton:0,npi:0,pi:0,si:1,#:0244202373"
Cisco-AVPair = "gw-final-xlated-cdn=ton:0,npi:0,#:0787518551"
Cisco-AVPair = "gw-final-xlated-cgn=ton:0,npi:0,pi:0,si:1,#:0244202373"
Cisco-AVPair = "charged-units=0"
Cisco-AVPair = "disconnect-text=normal call clearing (16)"
Cisco-AVPair = "peer-address=0787518551"
Cisco-AVPair = "info-type=speech"
Cisco-AVPair = "peer-id=400"
Cisco-AVPair = "peer-if-index=10"
Cisco-AVPair = "logical-if-index=3"
Cisco-AVPair = "acom-level=33"
Cisco-AVPair = "coder-type-rate=g711ulaw"
Cisco-AVPair = "noise-level=4294967212"
Cisco-AVPair = "voice-tx-duration=4120 ms"
Cisco-AVPair = "tx-duration=10210 ms"
Acct-Authentic = 0
User-Name = "0244202373"
Acct-Status-Type = Stop
NAS-Port-Type = Async
Cisco-NAS-Port = "BRI 1/0/0:1"
NAS-Port = 0
Calling-Station-Id = "0244202373"
Called-Station-Id = "0787518551"
Service-Type = Login-User
NAS-IP-Address = 193.134.216.170
Acct-Delay-Time = 0
rlm_sql (pgsql-voip): Reserving sql socket id: 22
rlm_sql_postgresql: Status: PGRES_FATAL_ERROR
rlm_sql_postgresql: affected rows =
rlm_sql_postgresql: Postgresql check_error: PGRES_FATAL_ERROR, returning
SQL_DOWN
rlm_sql (pgsql-voip): Attempting to connect rlm_sql_postgresql #22
rlm_sql (pgsql-voip): Connected new DB handle, #22
rlm_sql_postgresql: Status: PGRES_FATAL_ERROR
rlm_sql_postgresql: affected rows =
rlm_sql_postgresql: Postgresql check_error: PGRES_FATAL_ERROR, returning
SQL_DOWN
rlm_sql (pgsql-voip): failed after re-connect
rlm_sql (pgsql-voip): Couldn't update SQL accounting STOP record - ERROR:
invalid input syntax for type timestamp with time zone: "=2A15:29:55.504 GMT
Tue Mar 2 1993" CONTEXT: PL/pgSQL function "strip_dot" while casting return
value to function's return type
rlm_sql (pgsql-voip): Released sql socket id: 22
rad_recv: Accounting-Request packet from host 193.134.216.170:1646, id=14,
length=1697
Acct-Session-Id = "0000005B"
Cisco-AVPair = "[EMAIL PROTECTED]"
Cisco-AVPair = "iphop=count:2"
Cisco-AVPair = "iphop=hop1:193.134.216.160"
Cisco-AVPair = "iphop=hop2:84.226.113.34"
h323-setup-time = "h323-setup-time=*15:29:55.082 GMT Tue Mar 2 1993"
h323-gw-id = "h323-gw-id=SIP-GW.tcom.eivd.ch"
h323-conf-id = "h323-conf-id=D7218093 162811CC 801BEB9D F55885DD"
h323-call-origin = "h323-call-origin=answer"
h323-call-type = "h323-call-type=VoIP"
Cisco-AVPair = "h323-incoming-conf-id=D7218093 162811CC 801BEB9D F55885DD"
Cisco-AVPair = "subscriber=Unknown"
Cisco-AVPair = "session-protocol=sipv2"
Cisco-AVPair = "gw-rxd-cdn=ton:0,npi:0,#:0787518551"
h323-connect-time = "h323-connect-time=*15:30:07.157 GMT Tue Mar 2 1993"
Acct-Input-Octets = 5600
Acct-Output-Octets = 32960
Acct-Input-Packets = 35
Acct-Output-Packets = 206
Acct-Session-Time = 4
h323-disconnect-time = "h323-disconnect-time=*15:30:11.148 GMT Tue Mar 2
1993"
h323-disconnect-cause = "h323-disconnect-cause=10"
h323-remote-address = "h323-remote-address=193.134.216.160"
Cisco-AVPair = "release-source=3"
h323-voice-quality = "h323-voice-quality=0"
Cisco-AVPair = "remote-media-address=84.226.113.34"
Cisco-AVPair = "gw-rxd-cgn=ton:0,npi:0,pi:0,si:1,#:0244202373"
Cisco-AVPair = "charged-units=0"
Cisco-AVPair = "disconnect-text=normal call clearing (16)"
Cisco-AVPair = "peer-address=0244202373"
Cisco-AVPair = "info-type=speech"
Cisco-AVPair = "peer-id=800"
Cisco-AVPair = "peer-if-index=11"
Cisco-AVPair = "logical-if-index=0"
Cisco-AVPair = "codec-bytes=160"
Cisco-AVPair = "coder-type-rate=g711ulaw"
Cisco-AVPair = "ontime-rv-playout=540"
Cisco-AVPair = "remote-udp-port=5060"
Cisco-AVPair = "remote-media-udp-port=10646"
Cisco-AVPair = "vad-enable=enable"
Cisco-AVPair = "receive-delay=66 ms"
Cisco-AVPair = "round-trip-delay=0 ms"
Cisco-AVPair = "hiwater-playout-delay=66 ms"
Cisco-AVPair = "lowater-playout-delay=62 ms"
Cisco-AVPair = "gapfill-with-interpolation=0 ms"
Cisco-AVPair = "gapfill-with-prediction=1300 ms"
Cisco-AVPair = "gapfill-with-redundancy=0 ms"
Cisco-AVPair = "gapfill-with-silence=20 ms"
Cisco-AVPair = "early-packets=6"
Cisco-AVPair = "late-packets=4"
Cisco-AVPair = "lost-packets=91"
Acct-Authentic = 0
User-Name = "0244202373"
Acct-Status-Type = Stop
Calling-Station-Id = "0244202373"
Called-Station-Id = "0787518551"
Service-Type = Login-User
NAS-IP-Address = 193.134.216.170
Acct-Delay-Time = 0
rlm_sql (pgsql-voip): Reserving sql socket id: 21
rlm_sql_postgresql: Status: PGRES_FATAL_ERROR
rlm_sql_postgresql: affected rows =
rlm_sql_postgresql: Postgresql check_error: PGRES_FATAL_ERROR, returning
SQL_DOWN
rlm_sql (pgsql-voip): Attempting to connect rlm_sql_postgresql #21
rlm_sql (pgsql-voip): Connected new DB handle, #21
rlm_sql_postgresql: Status: PGRES_FATAL_ERROR
rlm_sql_postgresql: affected rows =
rlm_sql_postgresql: Postgresql check_error: PGRES_FATAL_ERROR, returning
SQL_DOWN
rlm_sql (pgsql-voip): failed after re-connect
rlm_sql (pgsql-voip): Couldn't update SQL accounting STOP record - ERROR:
invalid input syntax for type timestamp with time zone: "=2A15:29:55.082 GMT
Tue Mar 2 1993" CONTEXT: PL/pgSQL function "strip_dot" while casting return
value to function's return type
rlm_sql (pgsql-voip): Released sql socket id: 21
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
