Community discussions

MikroTik App
 
MikroManagement
Frequent Visitor
Frequent Visitor
Topic Author
Posts: 64
Joined: Thu Feb 09, 2006 2:41 pm
Location: Pretoria

Simple PPP logging - SQL based

Thu Feb 09, 2006 4:58 pm

I have developed a simple SQL-based application to track PPP usage.

SysLog on MikroTik send all PPP & Info messages to server. Retrieve, imports, update automatically according to User, month etc. Automated emailing to users with summary, last few sessions and quota.

There are different methods by using RADIUS / Hotspot etc, but these simple scripts are more than sufficient to keep track off all PPPOE / PPTP connections made to your network.
 
cibernet
Long time Member
Long time Member
Posts: 610
Joined: Fri Jan 28, 2005 7:22 pm
Location: Marcos Juárez, Córdoba, Argentina
Contact:

Re: Simple PPP logging - SQL based

Thu Feb 09, 2006 5:40 pm

I have developed a simple SQL-based application to track PPP usage.

SysLog on MikroTik send all PPP & Info messages to server. Retrieve, imports, update automatically according to User, month etc. Automated emailing to users with summary, last few sessions and quota.

There are different methods by using RADIUS / Hotspot etc, but these simple scripts are more than sufficient to keep track off all PPPOE / PPTP connections made to your network.
Well done, you can post them on the MT WIKI ;)

Regards
 
User avatar
maroon
Member Candidate
Member Candidate
Posts: 230
Joined: Thu Oct 07, 2004 11:15 am
Location: Lebanon
Contact:

Fri Mar 10, 2006 5:37 pm

we all are still waiting your post if you please

best regards,
 
User avatar
maximan
Trainer
Trainer
Posts: 543
Joined: Sat May 29, 2004 12:10 am
Location: Rio Cuarto, Argentina
Contact:

Fri Mar 10, 2006 10:04 pm

I would like to test it!

Good work!!! :D

Maximiliano Dobladez
Intercity SRL
Rio Cuarto- Argentina
http://www.intercity.net.ar

Who is online

Users browsing this forum: Google [Bot] and 30 guests