HELP!!!!!! does the RouterOS reset queue's after checkpoint

RouterOS General
1

We are using PPPoE for client connections and use a MySQL backend
to collect the accounting packets sent to a RADIUS server.

We set the AAA interim update to 30 min.
Does the router reset the queue totals e.g. uploads/downloads when it sends
the checkpoint to the radius server or does it keep adding up?

We assume that while they are still connected and when the byte count is sent in a checkpoint packet that it resets the totals, cause what we are doing is taking these values and inserting them into a client account in MySQL under downloaded and every half hour when the checkpoint is sent again or when a disconnect packet arrives we take the totals from the clients account and add them up with what was sent to the radius accounting from the mikrotik

Make a long story short is this what happens?

Cause it seems that the clients downloads are accumulating quickly or maybe they really are just downloading allot.

2

as far as i know it is accumulating.

3

Ok Mag thanks

Then how about this.

Do you know how to write a script along with a scheduler to check if INTERIM-UPDATE has been sent?

If so then reset-counters on clients queue?

I’m running ver 2.8.13 and i have clients on PPP connections the accounting packets are sent to the radius which it enters the data into a MySQL database.
I have a script (PHP) that runs every half hour and calculates the data, but I’m getting improper values due to accumulation of the checkpoint interim-update.

So what i was thinking was if i can get a script that monitors the interim-update have it reset-counters afterwards so next interim-update to my radius it will send new NON-ACCUMULATED values.

I would really appreciate the help thanks.