(RADIATOR) Negative bytes_out number on adsl users!!

[Hugh Irvine]

Hello Nikos -

This is more likely a problem with your database which is not set up to 
handle large numbers correctly.

As you can see from the trace, Radiator reports the number correctly.

>         Acct-Output-Octets = 3657597853

regards

Hugh


On Thursday, Sep 25, 2003, at 23:50 Australia/Melbourne, Nikos 
Aslanakis wrote:

> Hello all,
>
> We're trying to setup a billing system with radiator interim updates 
> for our
> adsl users. We're getting negative values for bytes_out witch 
> translated
> into wrong values. This affects our billling system as you may imagine.
> Is there any workaround for this ?
>
> Thanks a lot for your support,
>
>
>
> Here is an example accounting record:
>
>
> ###############################################
> CISCO ROUTER (show accounting command - IOS ver 12.2-17 3660 router)
>
> Active Accounted actions on Interface Virtual-Access3, User XXX at xxx 
> Priv 1
>  Task ID 8949, Network Accounting record, 14:11:17 Elapsed
>  task_id=8949 start_time=1064437345 timezone=GMT service=ppp
> ip-addresses=195.66.100.9 source-ip=195.66.100.10 tunnel-type=2
> tunnel-id=spark-the-dsl gw-name=standard tunnel-connection-id=9863899
> protocol=ip addr=195.66.98.140 pre-session-time=1674397 
> pre-bytes-in=104
> pre-bytes-out=35 pre-paks-in=4 pre-paks-out=3 bytes_in=333783
> bytes_out=-637369443 paks_in=10155 paks_out=6244 elapsed_time=48771
> ###############################################
> RADIATOR LOGFILE  (debug 4)
>
>
> Attributes:
>         NAS-IP-Address = 195.66.100.148
>         NAS-Port = 3
>         Cisco-NAS-Port = "Virtual-Access3"
>         NAS-Port-Type = ISDN
>         User-Name = XXX at xxx
>         Acct-Status-Type = Alive
>         Acct-Authentic = RADIUS
>         Service-Type = Framed-User
>         Acct-Session-Id = "0C0022F5"
>         Framed-Protocol = PPP
>         Tunnel-Server-Endpoint = 195.66.100.9
>         Tunnel-Client-Endpoint = 195.66.100.10
>         Tunnel-Type = 0:L2TP
>         Tunnel-Client-Auth-ID = spark-the-dsl
>         Tunnel-Server-Auth-ID = standard
>         Tunnel-ID = 9863899
>         Framed-IP-Address = 195.66.98.140
>         Acct-Input-Octets = 333783
>         Acct-Output-Octets = 3657597853
>         Acct-Input-Packets = 10155
>         Acct-Output-Packets = 6244
>         Acct-Session-Time = 48771
>         cisco-avpair = "tunnel-id=spark-the-dsl"
>         cisco-avpair = "gw-name=standard"
>         cisco-avpair = "pre-session-time=1674397"
>         cisco-avpair = "pre-bytes-in=104"
>         cisco-avpair = "pre-bytes-out=35"
>         cisco-avpair = "pre-paks-in=4"
>         cisco-avpair = "pre-paks-out=3"
>         Acct-Delay-Time = 0
>
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
>
>

NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.