Centralized data accounting

Installing and Using OpenWrt
1

First i would like to say hello to all you here.

I am a noob in OpenWRT. I use it for few months and i am a little overwhelmed by the options.

I will try to explain and also attach a picture of what i am trying to achieve.

I am currently onboard a vessel and sharing a Starlink Mini connection among about 10 users. We use the 500GB plan and split the price of the subscription and trying to have an fair usage for all.

I have at hand 3 routers with OpenWRT installed:

Cudy AP3000 v1
Xiaomi AX3000T
Unifi AP AC Lite

I currently run a Ethernet cable from the Starlink Mini antenna to the first router Cudy AP3000 which is located somewhere close to the bridge.
I use relayd on the other 2 routers (Xiaomi and UAP) to extend the wifi signal to the other levels of the accommodation.
I currently monitor the data consumption on each router by mac using brvphoenix / luci-app-wrtbwmon.
I am also using mac filtering on the wifi in order to disconnect users when reaching their quota. But it is a little pain in the .... to check all 3 routers and calculate consumed GB for each user every 2-3 days.

I would like to build a setup where there is a centralized data accounting on the main router Cudy AP3000.
What would be my best option to achieve this?
Attached is the picture of what i am trying to build.

Untitled2
Untitled2700×591 48.2 KB

Thanks in advance for your tips on this.

2

Check if opennds does accounting.

Keep in mind your accounting goes to sh-t if the device keeping track is rebooted, since data's usually stored in /tmp.

3

Seems you want to control bandwidth actually? Try OpenNDS?

4

My goal is to make the Cudy AP3000 router to act as a central hub to collect usage data for all users connected to any other routers.

brvphoenix / luci-app-wrtbwmon does a very good job to record usage data and has a very nice interface in luci. The only thing is that it records usage separately on each router.
Is there any way that i can collect all usage on Cudy router?

Or, I'm thinking of something else.
Is there any way that i can set the dhcp on secondary routers to have all connected users show on Cudy router?

5

Make vlans like guest AP-s per "customer", then you can account per user.

6

Radius authentication/accounting might be some kind of a solution for you

7

I get the impression just to tell neighbour upstairs to tune down usage....

8

If you don't mind using an external device like a Raspberry Pi zero I made an external bandwidth monitor. Instead of probing one router you probe all three routers and get the total. You need to modify router.php file and add three requests and add the final total to the variable. The best part is that you can reboot your routers any time and still get pretty accurate data.

Link to the project for more information - Made an external bandwidth monitor for OpenWrt