If you are looking for Radius using SQL
Free Radius support multiple database formats - I have been using MySQL for over 6 years with over
3000 customers. much easier to work with and very solid
take a look in the docs folders of freeradius tar ball
From: Randy Newby [mailto:randy at newbydev dot com]
Sent: Wed 24/05/2006 11:10 PM
To: alex at nkpanama dot com
Cc: m0n0wall at lists dot m0n0 dot ch
Subject: RE: [m0n0wall] captive portal with scripting
I've designed a similar system for our hotspots. This system uses SQL
Server, ASP.NET, and a Free Radius server. Here is a simple layout of
how I did it:
The login in page that is uploaded to the m0n0wall has the standard
username and password fields as required. I've added a link to that
page that allows the users to go off to a whitelisted IP address to
register if they do not already have a username.
Once on the registration web site, the are able to choose which time
limit they want, fill in their contact information, and then be directed
to PayPal to handle the payment. PayPal then confirms back to the IPN
page that the order has been completed. After the order is completed a
script that runs on 5 minute intervals downloads all of the active/paid
customers' usernames and passwords to the radius server (having a radius
server that uses a database would be a little less cumbersome, still
looking for one cheap.).
Now that the radius server has been updated, the customer is now free to
use the plain html login page on the m0n0wall and m0n0wall handles the
I have six properties using this same application with 40-70 users each.
Multiple properties can be added and each can have it's own pricing or
terms. Additionally, if the property would like to collect their own
funds and not use PayPal, then they can manually add the users through
an administrative interface.
Hope this gives you some ideas.
From: Alex Neuman van der Hans [mailto:alex at nkpanama dot com]
Sent: Tuesday, May 23, 2006 6:48 PM
To: m0n0wall at lists dot m0n0 dot ch
Subject: Re: [m0n0wall] captive portal with scripting
David Rando wrote:
> If you get to make it using scripting please share with the list, i'm
> sure it'll be useful for the others users of m0n0.
I'm sure it could be done using a combination of PHP-mysql-radiusd,
although I believe I'd have to raise the money for someone to write it
If there are any interested parties let me know and I'll ask how much it
To unsubscribe, e-mail: m0n0wall dash unsubscribe at lists dot m0n0 dot ch
For additional commands, e-mail: m0n0wall dash help at lists dot m0n0 dot ch