Hello ,
it there any to export my ppp-secrets to mysql database?
My router have about 1000 ppp-secrets (clients)
and sometime I need to get data from all of them , for example:
last connected in 1 month ,
information about clients with subnet 10.0.0.0/24
etc…
I didn’t find a smart and easy way to it using command line
so I thought maybe there is a way to export it as cvs - then uplaod it to mysql (or any other data base)
Thanks ,
With 1000 ppp clients, I would consider using an external RADIUS server. In some settings we use the freeware TekRADIUS (Microsoft SQL Server (Expresse) or SQLLite) for hotspot authentication, but it can also be used for ppp dial-in.
OK ,
if I’m using mysql can it work with this ?
also - do you have a simple guide to show me how to do it?
we start to work with 25 users , and time past now we have ~1000 
On the Mikrtotik, the Configuration is easy.
In a simple setting you only need to go to RADIUS add a New one, (IP-Adress and pre shared key) and bind it to the service (ppp).
in PPP you must open the Tab secrets and set teh checkbox “Use Radius” under “PPP Authentication&Accounting” (the button).
Thats all (beside to allow the RADIUS-communication in the firewall)
You can Find mort to thr Mikrotik-RAIUDS-Clint under https://wiki.mikrotik.com/wiki/Manual:RADIUS_Client.
The RADIUS side depends on the used RADIUS-Server and your setting. Unfortunately TekRadius dosn’t support MySQL but FreeRadius dose.
use freeradius, it will work with mysql.