PPPoE can accouting only Internet traffic !!!

routerOS 2.9.38

make mangle for LAN traffic with address list.
make static simplequeue rules with packetmark LAN traffic.

when user connect , MT make dinamic simplequeue for this user,
because, static simplequeue rules capture LAN traffic,
dinamic traffic capture all other, and this is Internet !

now I need assistance …

I need to capture with SNMP : “name” , “bytes-in”, “bytes-out”, from dinamic simplequeue, and write this in MySql.

Problem are … script (PERL) must capture with command (Get SubTree), all from simplequeue, on every 10 sec, and write in mysql.

I think about capture when user connect, but pppoe connection can be unstable. :frowning:

any one, … who known perl or other way, to capture and write this in mysql ?

thanks

Although is a quite old posting it sounds interesting. I´m wondering how this did work?
In mangle I mark packets from a spefic IP with a packet mark “test”. This works as counter increases.
I added a static simplequeue with criteria packet-mark “test”. But this does not work, counter stays at 0 after connect of the pppoe session.
Is there a known schema of the selection of the queue? Do dynamic queues have always precedence over static queues? I don´t think so.

Edit: Solved, I missed to specify a rate limit. But at all this is not the right way, I supposed that this would affect the Acct-In/Output-Octets. But of course it does not. So I have to look for another solution.