Radius & MySQL Question

RouterOS General
1

Just wondering if anybody has done something similar to the following, and could either offer me suggestions on a product to use, or some chargeable scripting time to do it.

I need to be able to do the following for a hotspot type service:

  • Provide user with webpage to setup a password from an existing userID, this password must update an existing record in a MySQL database used for Radius authentication by Freeradius.

  • Run a script to update user database details (remaining login time, remaining RX and TX data, etc, in a MySQL database regularly (ie. every 5 minutes) from the accounting data sent back from Mikotik Hotspot server.

For some this might not sound hard, but I have no SQL experience and may need this setup quickly for this client. I’m happy to buy some off the shelf product as long as it’s not clunky and is able to import user details in batches, and is of course resonably priced. I also need to run this stuff with Freeradius on windows. I have looked at Radius Manager but it seems a bit clunky, and I don’t need to bill from it, just use it for authentication and to cut people off when they reach their limit.

Thanks in advance
Paul

2

Alepo and Rodopi do the job!

3

Thanks. I believe Alepo is quite expensive, any idea on the price of Rodopi ?

Paul

4

Have a look at Freeside - http://www.sisd.com/freeside/ works well
with Mysql and others, and FreeRadius/Radiator etc.

5

Thanks Ken, but I think you need linux/Unix for Freeside, is that correct ?
I’m starting to teach myself how to talk to a MySQL DB with Perl and see where I get with that. If I can read in the info from the accounting logs, then rewrite the user records in mysql that Radius looks at, I should be right, but whether I can do it or not is the question :slight_smile:

Thanks

6

by the way guys,

freeside looks v. complicated to configure!

am I Right? any tutorials or how-to’s?

Regards,