I have the same setup as Randy but use Freeradius as Ben does and when
the payment verification comes back my script simply does a remote
SQL statement to the radius DB and inserts the new user data on the fly.
Then every 15 mins or so I have another script to clean out the
expired accounts in the Mysql DB. The new captive portal time limit feature stops
them at the proper time this is just so the DB does not have a lot
of expired account information in it. BTW we use authorize.net not
paypal but it would work either way I guess.
Wednesday, May 24, 2006, 9:27:57 AM, you wrote:
> 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
> Ben Morrisson
> 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.
> -----Original Message-----
> 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
> for me.
> If there are any interested parties let me know and I'll ask how much it
> would cost.
> 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