pppd with radius-plugin seems to have troubles with traffic counter

pppd with radius-plugin seems to have troubles with traffic counter

[Philipp Kolmann]

Hi!

I seems to have found a bug in pppd 2.4.2. I am running a pptp-pppd VPN
server to authenticate Users coming in with laptops (at my university).

We authenticate the Users using the radius plugin and do also traffic
accounting with radius. Everything seems to be fine, but when a user
reaches over 4GB the traffic goes down to 0 again. I believe that this
could be a problem with an integer value running over.

Here is the relevant part of my mysql log file (I use a radiusd that
logs the acct-requests into a mysql db, interim accounting is done every
10 minutes):

040622 14:30:14   17953 Query       UPDATE calls SET
		acct_session_time\x16203,acct_input_octets’129211,
		acct_output_octetsB58766205,
		framed_ip_address='193.170.XX.XX',timestamp=NOW() 
		WHERE user_name='eXXXXXXX@student.tuwien.ac.at' AND 
		status= 1 AND acct_session_id='40D7E70949C7'
040622 14:40:14   17953 Query       UPDATE calls SET
		acct_session_time\x16803,acct_input_octets•118037,
		acct_output_octets\x110195513,
		framed_ip_address='193.170.XX.XX',timestamp=NOW() 
		WHERE user_name='eXXXXXXX@student.tuwien.ac.at' AND
		status= 1 AND acct_session_id='40D7E70949C7'

As you can see in theis session the acct_output_octets drops from over
4GB to around 100MB within 10 minutes (possible in our local lan).

I hope you can fix this,
thanks in advance
Philipp Kolmann
IT Dept.
Technical University of Vienna



-- 
Life is not fair,
but the root password helps!

Re: pppd with radius-plugin seems to have troubles with traffic counter

[Philipp Kolmann]

No reply at all.... 

Maybe someone could point out where to look at.
Or if more information is needed, please ask.

On Tue, Jun 22, 2004 at 05:46:45PM +0200, Philipp Kolmann wrote:
> Here is the relevant part of my mysql log file (I use a radiusd that
> logs the acct-requests into a mysql db, interim accounting is done every
> 10 minutes):
> 
> 040622 14:30:14   17953 Query       UPDATE calls SET
> 		acct_session_time\x16203,acct_input_octets’129211,
> 		acct_output_octetsB58766205,
> 		framed_ip_address='193.170.XX.XX',timestamp=NOW() 
> 		WHERE user_name='eXXXXXXX@student.tuwien.ac.at' AND 
> 		status= 1 AND acct_session_id='40D7E70949C7'
> 040622 14:40:14   17953 Query       UPDATE calls SET
> 		acct_session_time\x16803,acct_input_octets•118037,
> 		acct_output_octets\x110195513,
> 		framed_ip_address='193.170.XX.XX',timestamp=NOW() 
> 		WHERE user_name='eXXXXXXX@student.tuwien.ac.at' AND
> 		status= 1 AND acct_session_id='40D7E70949C7'
> 
> As you can see in theis session the acct_output_octets drops from over
> 4GB to around 100MB within 10 minutes (possible in our local lan).

Thanks
Philipp

-- 
Life is not fair,
but the root password helps!

Re: pppd with radius-plugin seems to have troubles with traffic

[Clive Nicolson]

This is no bug, the counter is unsigned 32 bit, so can only count upto
4294967295. You have to watch out for roll over your self and correct for 
the situation. There maybe useful tricks in doing that.

Clive