CDR

2002-12-28 Thread sunil . kumar 
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 = 1870
  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 = 1871
  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 = 1871
  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 = 1873
  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

cisco as5400 dialing digits

2002-12-20 Thread sunil . kumar 
hi all,

i'm new to free radius... i've RH Linux, Freeradius 0.8, mysql for
accounting/cdr (no authentication)... and cisco as5400 as radius client.

while making calls, we can see all the attributes are displaying properly
in screen (running radius in debug mode). but in the calldetails table
(radacct) the digits of calling station and called station are truncated to
10 digits... instead of getting the whole digits. i've checked the field
names, there enough space is there (32)

can anyone help in this issue

TIA

regards
sunil


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: cisco as5400 dialing digits

2002-12-20 Thread sunil . kumar 
hi gerald,

thanks

that's worked!!!

regards
sunil





i have noticed the same (using a AS5300) and found a limitation
in the create statement of the radacct table in
[freeradius-home]/src/modules/rlm_sql/drivers/rlm_sql_mysql/db_mysql.sql:

...
  CalledStationId varchar(10) NOT NULL default '',
  CallingStationId varchar(10) NOT NULL default '',
...

changing this to a bigger value then 10 works good for me. are you really
using varchar(32) here?

[EMAIL PROTECTED] wrote:

hi all,

i'm new to free radius... i've RH Linux, Freeradius 0.8, mysql for
accounting/cdr (no authentication)... and cisco as5400 as radius client.

while making calls, we can see all the attributes are displaying properly
in screen (running radius in debug mode). but in the calldetails table
(radacct) the digits of calling station and called station are truncated
to
10 digits... instead of getting the whole digits. i've checked the field
names, there enough space is there (32)

can anyone help in this issue

TIA

regards
sunil


-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html



gerald



- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html