Re: Accounting responce question.

2009-05-28 Thread Borislav Dimitrov
 = 129.11.17.230
   3GPP2-BSID = "2A2100021102"
   3GPP2-User-Id = 0
   3GPP2-Forward-FCH-Mux-Option = 0
   3GPP2-Reverse-FCH-Mux-Option = 0
   3GPP2-Service-Option = 59
   3GPP2-Forward-Traffic-Type = 0
   3GPP2-Reverse-Traffic-Type = 0
   3GPP2-FCH-Frame-Size = 0
   3GPP2-Forward-FCH-RC = 0
   3GPP2-Reverse-FCH-RC = 0
   3GPP2-IP-Technology = 1
   3GPP2-Compulsory-Tunnel-Indicator = 0
   3GPP2-Release-Indicator = 7
   3GPP2-DCCH-Frame-Size = 0
   3GPP2-Attr-78 = 0x
   3GPP2-Forward-PDCH-RC = 0
   3GPP2-Forward-DCCH-Mux-Option = 0
   3GPP2-Reverse-DCCH-Mux-Option = 0
   3GPP2-Forward-DCCH-RC = 0
   3GPP2-Reverse-DHHC-RC = 0
   3GPP2-Attr-114 = 0x
   3GPP2-Bad-PPP-Frame-Count = 0
   3GPP2-Active-Time = 33
   3GPP2-Number-Active-Transitions = 0
   3GPP2-Received-HDLC-Octets = 0
   3GPP2-Inbound-Mobile-IP-Sig-Octets = 0
   3GPP2-Outbound-Mobile-IP-Sig-Octets = 0
   3GPP2-Last-User-Activity-Time = 1216337292
   3GPP2-IP-QoS = 10
   3GPP2-Airlink-Priority = 0
+- entering group preacct
   rlm_realm: Looking up realm "triatel.lv" for User-Name =
"tria...@triatel.lv"
   rlm_realm: No such realm "triatel.lv"
++[suffix] returns noop
+- entering group accounting
rlm_acct_unique: Hashing '3GPP2-Correlation-Id = "17934924",Acct- 
Session-Id

= "000\000",Calling-Station-Id = "247033715823092"'
rlm_acct_unique: Acct-Unique-Session-ID = "33187f91caa26b34".
++[acct_unique] returns ok
   expand: %{User-Name} -> tria...@triatel.lv
rlm_sql (sql): sql_set_user escaped user --> 'tria...@triatel.lv'
   expand: UPDATE radacct SET AcctStopTime = '%{Event-Timestamp}',
AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets =
'%{Acct-Input-Octets}', OutputPacket = '%{Acct-Output-Packets}',  
InputPacket

= '%{Acct-Input-Packets}', AcctOutputOctets = '%{Acct-Output-Octets}',
ReleaseIndicator = '%{Acct-Terminate-Cause}', CDMABadPPPFrameCount =
'%{3GPP2-Bad-PPP-Frame-Count}', CDMACorrelationId =
'%{3GPP2-Correlation-Id}', CDMAActiveTime = '%{3GPP2-Active-Time}'  
WHERE

AcctUniqueId = '%{Acct-Unique-Session-Id}' -> UPDATE radacct SET
AcctStopTime = 'Jul 18 2008 02:43:01 EEST', AcctSessionTime = '922',
AcctInputOctets = '0', OutputPacket = '0', InputPacket = '0',
AcctOutputOctets = '0', ReleaseIndicator = 'Idle-Timeout',
CDMABadPPPFrameCount = '0', CDMACorrelationId = '17934924',  
CDMAActiveTime =

'33' WHERE AcctUniqueId = '33187f91caa26b34'
rlm_sql (sql): Reserving sql socket id: 25
rlm_sql_postgresql: Status: PGRES_COMMAND_OK
rlm_sql_postgresql: query affected rows = 1
rlm_sql (sql): Released sql socket id: 25
++[sql] returns ok
Finished request 22102.



--
View this message in context: 
http://www.nabble.com/Accounting-responce-question.-tp23756895p23756895.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.


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



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


Re: Accounting responce question.

2009-05-28 Thread Alan DeKok
lamersons wrote:
> Im using FreeRADIUS Version 2.0.4(slackware+postgre) on powerfull x86 server
> with alot of RAM, connected with gigabit to NAS. Load is about
> 5-15record/sec

  That machine is overkill, but it should work.

> Once in a while we get double accounting records. I started to take traces
> at NAS side and saw that sometimes AAA doesnt responce to accounting record,

  Are you sure that the AAA is *sending* responses?  Maybe the packets
are being lost elsewhere in the network.

> NAS thinks that AAA didnt get it and sends it one more time. But AAA gets
> the first one even if it doesnt responce to request, therefore we get double
> record.(debug info is below) 

  Duplicate accounting records are *always* possible, even if everything
is working perfectly.  Your solution needs to be able to handle these.

> I have made debug trace at AAA side. Is it somehow possible to see from that
> trace that AAA did respond  and that is NASes(or network) problem that it
> did not recieve responce ?(debug info is below) 

  Hmm... the debug output does *not* show the server sending a response.
 That's odd.  When using "radiusd -X", it *should* print out something
like "sending response ..."

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


Accounting responce question.

2009-05-28 Thread lamersons
roup preacct
rlm_realm: Looking up realm "triatel.lv" for User-Name =
"tria...@triatel.lv"
rlm_realm: No such realm "triatel.lv"
++[suffix] returns noop
+- entering group accounting
rlm_acct_unique: Hashing '3GPP2-Correlation-Id = "17934924",Acct-Session-Id
= "000\000",Calling-Station-Id = "247033715823092"'
rlm_acct_unique: Acct-Unique-Session-ID = "33187f91caa26b34".
++[acct_unique] returns ok
expand: %{User-Name} -> tria...@triatel.lv
rlm_sql (sql): sql_set_user escaped user --> 'tria...@triatel.lv'
expand: UPDATE radacct SET AcctStopTime = '%{Event-Timestamp}',
AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets =
'%{Acct-Input-Octets}', OutputPacket = '%{Acct-Output-Packets}', InputPacket
= '%{Acct-Input-Packets}', AcctOutputOctets = '%{Acct-Output-Octets}',
ReleaseIndicator = '%{Acct-Terminate-Cause}', CDMABadPPPFrameCount =
'%{3GPP2-Bad-PPP-Frame-Count}', CDMACorrelationId =
'%{3GPP2-Correlation-Id}', CDMAActiveTime = '%{3GPP2-Active-Time}' WHERE
AcctUniqueId = '%{Acct-Unique-Session-Id}' -> UPDATE radacct SET
AcctStopTime = 'Jul 18 2008 02:43:01 EEST', AcctSessionTime = '922',
AcctInputOctets = '0', OutputPacket = '0', InputPacket = '0',
AcctOutputOctets = '0', ReleaseIndicator = 'Idle-Timeout',
CDMABadPPPFrameCount = '0', CDMACorrelationId = '17934924', CDMAActiveTime =
'33' WHERE AcctUniqueId = '33187f91caa26b34'
rlm_sql (sql): Reserving sql socket id: 25
rlm_sql_postgresql: Status: PGRES_COMMAND_OK
rlm_sql_postgresql: query affected rows = 1
rlm_sql (sql): Released sql socket id: 25
++[sql] returns ok
Finished request 22102.



-- 
View this message in context: 
http://www.nabble.com/Accounting-responce-question.-tp23756895p23756895.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.


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