(?) How to get PPPoE user total traffic used on a session?

RouterOS General
1

I want to get total traffic used by every PPPoE session (active user) before their PPPoE session will disconnect (by their side). Is there some event for scripts or something that will help?
This is needed for our billing system to count users traffic.

We’re using RADIUS for users authentication which integrated with billing. Maybe there is some RADIUS property, supported by RouterOS, that will work for me?

NetFlow will not help - it generates traffic with very small packets (headers of all ip packets) and will slow down our network and billing server.
Accounting will not work with many users and connections active.

All I need is simply get PPPoE session (by username) RX total and TX total, before session disconnection (while data is still present).
Question is HOW?

2

If I understand what you wish to do, all that information is available in userman>users.

You can go to settings and select what you wish to see.

Once you set this, it will stay in the userman system until you delete it.

See the attached screen shots.
Settings.jpg
Users.jpg

3

I have no idea, what software you’re using.

Even if I know how to get total tx/rx of an user in RouterOS, I don’t know how to trigger this script on PPPoE user disconnection.

4

Open your browser, type in the IP address of your router/userman (15.16.9.1/userman).

This will open a program in your router that will allow you to see and print things.

This is also where you set the amount of money a customer pays for hotspot pay as you go.

google mikrotik-userman for the manual.

5

Thanks! Somehow you hinted me to the right direction. (no sarcasm)
I’ve found that the RADIUS-server accounting provides exact functional I want.
Acct-Input-Octets and Acct-Output-Octets is TX/RX bytes which gets only on session stop and stores into DB. Now I can use script to collect traffic data from DB and pass it to an external billing.

6

hi hel, can u help me with your script to collect total TX/RX trafics??

thank u in advance.

7

Sorry, I’ve dropped this idea because I can’t pass collected traffic to the Traffic Inspector billing system due to API limitation and bad support for the product. So thats why script isn’t ready and I can’t help you.