Hi Everyone,
I need to Setup Billing which must Work with Mikrotik,
I need to Setup AAA For PPTP, Wireless Using Radius Server,
Who can Help me what Radius Server or Billing System to choose ??
I Am NOT A PROGRAMMER
Please Help me To Solve that Great Question
I’m using FreeRadius running on a Linux Fedora box, sitting in my office in one town, handling Authentication and Accounting for tree networks in three other towns.
http://www.freeradius.org
The documentation tells you just about everything you need to know about it,
but I’ll be happy to consult if you need more help with that one.
RADIUS can be set up to query a SQL database for user info and group parameters,
including bandwidth-limitations and some-such, throughput monitoring…
And you can manage/view the SQL database with some simple PHP scripts.
You can use this to add, remove, disable users, monitor their throughput,
change their bandwidth-limits…
I’m not a programmer either, but http://www.howtoforge.com came to the rescue.
Then, Mikrotik can be set up to query your Radius for Auths, and dump all it’s accounting info on it too. Radius will neatly place it in the SQL database, ready for you to view or process.
I can tell you that RADIUS with SQL works great, but building PHP front-end stuff to administrate it can be very tricky. I’ve managed with spitballs and sticky-tape.
I’m not, however, discrediting User Manager as an option, which I quite frankly know nothing about. But yell if you need help on RADIUS.
Good luck!
-Krige
User Manager is very good tool, as with installed User Manager package makes your router as advanced management server for HotSpot, PPP, wireless and DHCP clients. Just one command required to enable WEB interface of the User Manager, that is very user-friendly and intuitive, you do need to set a “bunch” of console commands to get it work.
More information about User Manager,
http://wiki.mikrotik.com/wiki/User_Manager
if he is a hotspot provider than userman is good but if he is a WISP then useless in my opinion. FreeRadius is the way to go if you are a WISP…
It is not very arguable response, you may post here and at the "Feature Request’ topic for the features, that are required, but they are not present at User-Manager.
in my opinion freeradius with radiusmanager is the best solution ATM. Usermanager just doesn’t have the features to support a in my situation a wisp or hotspot with having the account provisoned at the signup process as in different prices for diff speeds and have it auto populate to the customer. Most ISPs and hotspots utilize this feature to control per user bandwidth. I and others have requested this feature and told there was no plan to add the feature. On the plus if you don’t need persignup bandwith management like you don’t care if all users auto get like 1.5/1.5 and then you change it after signup then usermanager word great. Can’t go wrong with a all in one point and click solution
In case your post is about total amount of traffic downloaded/+uploaded at signup stage (sell specific amount of bandwidth to the customer), such feature is planned at the future.
well, i havent find a way to differentiate the user queue for local or oversea in usermanager.
It’s just one queue for the user.
It is not possible to build multiple queue with User-Manager now.
yes what we are lookin for is to add packages at signup that are not for total allowed download , but differnet speeed packages like building ques into the packages , id want the user to be able to choose what what speed they want upon signup instead of putting it on my page and then having to change it once i get the email, this is currently not possible with usermanger but is possible with radiusmanager. I was told this wasnt going to be added in the future either, which is really going to limit the use or usermanager forcing all customers to have the same speed and default que, hope you guys change your mind on this , until then radiusmanager fits my needs better than the usermanager. Im sure alot of others would like this feature as well
if mikrotik were suppose to design and manufacture a car from version 1.0, they would add tires in version 11.2 or higher…
there are some very serious limitations in RouterOS that don’t allow us to make all that is needed for a complete billing system. We will try to overcome those limitations and then a lot of new features will be possible.
Hello frens,
as far as i used routerOS just made bw management and routing system only since 2 years ago, and about billing i made by myself for communication user to my central server:
and this screen shot my billing system. this's nice for myself and for dynamic user i used userman [Centralized AAA] to make control hotspot, pptp, and pppoe user
So far, Scripting has allowed me to solve any shortcomings that User Manager / Router OS’ billing has. I’ll be publishing my scripts on Wiki soon.
Has anyone been able to implement this? As natedogg said this is needed for a WISP situation, but i was just checking to see if this is possible?
Is there a script I could use? Thanks -Jordan
Hello krigevr,
can you please send me your script onowojemma@yahoo.com i will appreciate if you can share them with me
Thanks
Hey onowojemma, Krige’s automated billing script can be found in the wikie under “scripts” take a look. -Jordan
Hello balimore this your billing system is it some thing you want to share ? if u want to please i will appreciate if you could mail it to me at onowojemma@yahoo.com
thanks
I’ve used Free Radius but with the need of dynamic packages for the customers; I started using 24Online as AAA with Mikrotik as Access Gateway. That worked out to be much better as Billing & Bandwidth Mgmt Paltform. Ease of manageability and handling.
S Krishnan
Has anyone looked at http://daloradius.com , its pretty awesome imo. Its free but the documentation will cost you some minimal amount.