Community discussions

MikroTik App
 
David1234
Forum Guru
Forum Guru
Topic Author
Posts: 1282
Joined: Sun Sep 18, 2011 7:00 pm

export data to database?

Wed Mar 18, 2020 10:39 am

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 ,
 
afuchs
just joined
Posts: 3
Joined: Wed Jul 03, 2019 11:10 am

Re: export data to database?

Wed Mar 18, 2020 1:18 pm

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.
 
David1234
Forum Guru
Forum Guru
Topic Author
Posts: 1282
Joined: Sun Sep 18, 2011 7:00 pm

Re: export data to database?

Thu Mar 26, 2020 7:08 pm

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 :-)

Who is online

Users browsing this forum: arm920t and 185 guests