I’d like to use RADIUS accounting for local login and PPPoE server sessions, and some DHCP server IP assingments on multiple CCR1036s (RouterOS 6.x on all of them) to FreeRADIUS 3.0 server using MySQL backend for accounting and LDAP server for authentication.
I set up everything as per documentation and forums, and I can successfully authenticate with test users defined on RADIUS server (authentication come from LDAP), but I have very limited amount of accounting info in the SQL database (which stores accounting), far less than expected.
I get accounting for PPPoE and login sessions only if the RADIUS server authenticates the user. Locally (by router) authenticated PPPoE or login sessions never accounted on RADIUS server. Even no RADIUS interaction from router after local auth.
I get some DHCP assingment accounting (I set some DHCP servers to “use-radius=accounting”) which get addresses from local pool (not from RADIUS server), but far less assingments accounted than addresses assigned by the router. I even can’t figure out, how it’s decided to send to RADIUS accounting a lease or not…
I see no errors on neither router or RADIUS server side.
Is this the expected behavior, or is this a bug or maybe I missed some configuration?
Hi,
I don’t know if my NAS configuration bellow can help you or not, because me too, I’ve same issue with my PPPoE accounting, VALUE OF Upload/Download accounted in RADIUS exceed the packet send.
1/ Configuration on mikrotik PPPoE server + Radius server:
