HI ALL,
i'm new to free radius.. i'm using freeradius 0.8/ mysql / cisco as5400
(client) / (no authentication) only accounting)
can anyone help me to find out why so many repetetions of the same CDR in
different account session id.. and some error messages also... and i need
only one call start and stop CDR.. i'm getting a VOIP CDR also, which is
logging into mysql database...
Thanks in advance
sunil
IP: 195*54*247*108
E: [EMAIL PROTECTED]
Listening on IP address *, ports 1812/udp and 1813/udp, with proxy on
1814/udp.
Ready to process requests.
rad_recv: Accounting-Request packet from host (my ip address):21716, id=77,
length=427
Acct-Session-Id = "00001870"
h323-setup-time = "h323-setup-time=*09:57:17.863 UTC Mon Jan 31 2000"
h323-gw-id = "h323-gw-id=imass-GW02."
h323-conf-id = "h323-conf-id=A2B2B082 D6FB11D3 9841B371 6DC5E167"
h323-call-origin = "h323-call-origin=answer"
h323-call-type = "h323-call-type=Telephony"
Cisco-AVPair = "h323-incoming-conf-id=A2B2B082 D6FB11D3 9841B371
6DC5E167"
Cisco-AVPair = "subscriber=RegularLine"
User-Name = "2074014200"
Acct-Status-Type = Start
NAS-Port-Type = Async
Cisco-NAS-Port = "ISDN 6/0:D:1"
NAS-Port = 0
Calling-Station-Id = "2074014200"
Called-Station-Id = "00447952122550"
Service-Type = Login-User
NAS-IP-Address = (IP ADDRESS)
Acct-Delay-Time = 0
rad_recv: Accounting-Request packet from host (IP ADDRESS):21716, id=78,
length=455
Acct-Session-Id = "00001871"
h323-setup-time = "h323-setup-time=*09:57:17.871 UTC Mon Jan 31 2000"
h323-gw-id = "h323-gw-id=imass-GW02."
h323-conf-id = "h323-conf-id=A2B2B082 D6FB11D3 9841B371 6DC5E167"
h323-call-origin = "h323-call-origin=originate"
h323-call-type = "h323-call-type=Telephony"
Cisco-AVPair = "h323-incoming-conf-id=A2B2B082 D6FB11D3 9841B371
6DC5E167"
Cisco-AVPair = "subscriber=RegularLine"
Cisco-AVPair = "out-intrfc-desc="
User-Name = "2074014200"
Acct-Status-Type = Start
NAS-Port-Type = Async
Cisco-NAS-Port = "ISDN 0/-1:D:0"
NAS-Port = 0
Calling-Station-Id = "2074014200"
Called-Station-Id = "00447952122550"
Service-Type = Login-User
NAS-IP-Address = (IP ADDRESS)
Acct-Delay-Time = 0
rad_recv: Accounting-Request packet from host (IP ADDRESS):21716, id=79,
length=865
Acct-Session-Id = "00001871"
h323-setup-time = "h323-setup-time=*09:57:17.871 UTC Mon Jan 31 2000"
h323-gw-id = "h323-gw-id=imass-GW02."
h323-conf-id = "h323-conf-id=A2B2B082 D6FB11D3 9841B371 6DC5E167"
h323-call-origin = "h323-call-origin=originate"
h323-call-type = "h323-call-type=Telephony"
Cisco-AVPair = "h323-incoming-conf-id=A2B2B082 D6FB11D3 9841B371
6DC5E167"
Cisco-AVPair = "subscriber=RegularLine"
Cisco-AVPair = "out-intrfc-desc="
Acct-Input-Octets = 0
Acct-Output-Octets = 0
Acct-Input-Packets = 0
Acct-Output-Packets = 0
Acct-Session-Time = 0
h323-connect-time = "h323-connect-time=*09:57:17.871 UTC Mon Jan 31
2000"
h323-disconnect-time = "h323-disconnect-time=*09:57:17.871 UTC Mon
Jan 31 2000"
h323-disconnect-cause = "h323-disconnect-cause=22"
Cisco-AVPair = "h323-ivr-out=Tariff:Unknown"
Cisco-AVPair = "release-source=3"
h323-voice-quality = "h323-voice-quality=0"
Cisco-AVPair = "gw-rxd-cdn=00447952122550"
Cisco-AVPair = "gw-rxd-cgn=2074014200"
Cisco-AVPair = "gw-final-xlated-cdn=447952122550"
Cisco-AVPair = "gw-final-xlated-cgn=2074014200"
User-Name = "2074014200"
Acct-Status-Type = Stop
NAS-Port-Type = Async
Cisco-NAS-Port = "ISDN 0/-1:D:0"
NAS-Port = 0
Calling-Station-Id = "2074014200"
Called-Station-Id = "00447952122550"
Service-Type = Login-User
NAS-IP-Address = (IP ADDRESS)
Acct-Delay-Time = 0
rad_recv: Accounting-Request packet from host (IP ADDRESS):21716, id=80,
length=423
Acct-Session-Id = "00001873"
h323-setup-time = "h323-setup-time=*09:57:17.875 UTC Mon Jan 31 2000"
h323-gw-id = "h323-gw-id=imass-GW02."
h323-conf-id = "h323-conf-id=A2B2B082 D6FB11D3 9841B371 6DC5E167"
h323-call-origin = "h323-call-origin=originate"
h323-call-type = "h323-call-type=VoIP"
Cisco-AVPair = "h323-incoming-conf-id=A2B2B082 D6FB11D3 9841B371
6DC5E167"
Cisco-AVPair = "subscriber=RegularLine"
Cisco-AVPair = "session-protocol=cisco"
User-Name = "2074014200"
Acct-Status-Type = Start
Calling-Station-Id = "2074014200"
Called-Station-Id = "00447952122550"
Service-Type = Login-User
NAS-IP-Address = (IP ADDRESS)
Acct-Delay-Time = 0
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql_mysql: MYSQL check_error: 1065 received
rlm_sql (sql): Couldn't update SQL accounting for START packet - Query was
empty
rlm_sql (sql): Released sql socket id: 4
Sending Accounting-Response of id 80 to (IP ADDRESS):21716
rlm_sql (sql): Reserving sql socket id: 3
rlm_sql (sql): Reserving sql socket id: 2
rlm_sql (sql): Reserving sql socket id: 1
rlm_sql_mysql: MYSQL check_error: 1065 received
rlm_sql (sql): Couldn't update SQL accounting for START packet - Query was
empty
rlm_sql_mysql: MYSQL check_error: 1065 received
rlm_sql (sql): Couldn't update SQL accounting for START packet - Query was
empty
rlm_sql: Stop packet with zero session length. (user '2074014200', nas
'(IP ADDRESS)')
rlm_sql (sql): Released sql socket id: 1
Sending Accounting-Response of id 79 to (IP ADDRESS):21716
rlm_sql (sql): Released sql socket id: 3
Sending Accounting-Response of id 77 to (IP ADDRESS):21716
rlm_sql (sql): Released sql socket id: 2
Sending Accounting-Response of id 78 to (IP ADDRESS):21716
rad_recv: Accounting-Request packet from host (IP ADDRESS):21716, id=81,
length=886
Acct-Session-Id = "00001873"
h323-setup-time = "h323-setup-time=*09:57:17.875 UTC Mon Jan 31 2000"
h323-gw-id = "h323-gw-id=imass-GW02."
h323-conf-id = "h323-conf-id=A2B2B082 D6FB11D3 9841B371 6DC5E167"
h323-call-origin = "h323-call-origin=originate"
h323-call-type = "h323-call-type=VoIP"
Cisco-AVPair = "h323-incoming-conf-id=A2B2B082 D6FB11D3 9841B371
6DC5E167"
Cisco-AVPair = "subscriber=RegularLine"
Cisco-AVPair = "session-protocol=cisco"
h323-connect-time = "h323-connect-time=*09:57:29.299 UTC Mon Jan 31
2000"
Acct-Input-Octets = 9183
Acct-Output-Octets = 0
Acct-Input-Packets = 463
Acct-Output-Packets = 0
Acct-Session-Time = 11
h323-disconnect-time = "h323-disconnect-time=*09:57:40.571 UTC Mon
Jan 31 2000"
h323-disconnect-cause = "h323-disconnect-cause=10"
h323-remote-address = "h323-remote-address=(IP ADDRESS REMOTE)"
Cisco-AVPair = "release-source=4"
h323-voice-quality = "h323-voice-quality=10"
Cisco-AVPair = "remote-media-address=(IP ADDRESS)"
Cisco-AVPair = "gw-rxd-cdn=00447952122550"
Cisco-AVPair = "gw-rxd-cgn=2074014200"
Cisco-AVPair = "gw-final-xlated-cdn=00447952122550"
Cisco-AVPair = "gw-final-xlated-cgn=2074014200"
User-Name = "2074014200"
Acct-Status-Type = Stop
Calling-Station-Id = "2074014200"
Called-Station-Id = "00447952122550"
Service-Type = Login-User
NAS-IP-Address = (IP ADDRESS)
Acct-Delay-Time = 0
rlm_sql (sql): Reserving sql socket id: 0
rad_recv: Accounting-Request packet from host (IP ADDRESS):21716, id=82,
length=747
Acct-Session-Id = "00001870"
h323-setup-time = "h323-setup-time=*09:57:17.863 UTC Mon Jan 31 2000"
h323-gw-id = "h323-gw-id=imass-GW02."
h323-conf-id = "h323-conf-id=A2B2B082 D6FB11D3 9841B371 6DC5E167"
h323-call-origin = "h323-call-origin=answer"
h323-call-type = "h323-call-type=Telephony"
Cisco-AVPair = "h323-incoming-conf-id=A2B2B082 D6FB11D3 9841B371
6DC5E167"
Cisco-AVPair = "subscriber=RegularLine"
h323-connect-time = "h323-connect-time=*09:57:29.299 UTC Mon Jan 31
2000"
Acct-Input-Octets = 81
Acct-Output-Octets = 9183
Acct-Input-Packets = 5
Acct-Output-Packets = 463
Acct-Session-Time = 11
h323-disconnect-time = "h323-disconnect-time=*09:57:40.583 UTC Mon
Jan 31 2000"
h323-disconnect-cause = "h323-disconnect-cause=10"
Cisco-AVPair = "h323-ivr-out=Tariff:Unknown"
Cisco-AVPair = "release-source=4"
h323-voice-quality = "h323-voice-quality=0"
Cisco-AVPair = "gw-rxd-cdn=00447952122550"
Cisco-AVPair = "gw-rxd-cgn=2074014200"
Acct-Status-Type = Stop
NAS-Port-Type = Async
Cisco-NAS-Port = "ISDN 6/0:D:1"
NAS-Port = 0
Calling-Station-Id = "2074014200"
Called-Station-Id = "00447952122550"
Service-Type = Login-User
NAS-IP-Address = (IP ADDRESS)
Acct-Delay-Time = 0
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql (sql): Released sql socket id: 0
Sending Accounting-Response of id 81 to (IP ADDRESS):21716
rlm_sql (sql): Released sql socket id: 4
Sending Accounting-Response of id 82 to (IP ADDRESS):21716
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
