Usage Accounting

Hey all :slight_smile:

Up until recently we have offered unlimited data plans and charged more for more speed.

This has worked fine until recently when the network has expanded and data usage abuse has become more of an issue. I now wish to have data and speed options for customers.

My plan was to have each MT router at the Client Premises to log back into our central PPTP/RADIUS server and authenticate and provide accounting data back through the RADIUS server to a SQL database. In theory this idea works fine, I have designed a front end where users can log in and check their data usage and it works great if I start a PPTP/PPPoE session from outside the network (through the internet).

The issue is though I use WDS bridging on my network, if I create a PPTP session on a clients router it will not route the data through the PPTP tunnel but instead over the WDS bridge (makes sense really!!) So this defeats the purpose of the tunnel and therefore does not pass on the accounting figures i need.

I am wondering if there is a different/better way of doing this, with so many broadband networks setup out there someone must have a system that works great.

I would like to stick with using RADIUS and Linux software as it is relatively simple and extremely reliable.
There must be a way of doing it with RADIUS, MYSQL and PPTP.

Cheers :smiley:

PPTP still use authentication, that PPP Authentication, can still be handled by Radius…

I don’t see the issue?

Right,
The PPTP connection is over a current wireless bridge. The data travels over the wireless bridge rather than through the tunnel.

That is the issue, if I could get all data to flow over the PPTP connection problem would be solved.

Thanks :slight_smile: