Prepaid solution.
-
Howdy,
Hopefully the last question from me - i really appreciate all your help so far.
Im trying to work out the best solution for allowing pre-paid card usage (scratch card purchased from hotspot ). I was thinking along these lines:
1. I populate a SQL table with the card numbers and codes that i have had printed.
2. User purchases card
3. Captive portal directs to a PHP page which asks for the code, validates it against the mySQL table and if valid, inserts the MAC address and Code into the Free Radius MYSQL table.
4. I then call the authorise form from the PHP page which passes the radius request for the captive portal to the Radius server. MAC and Code should exist, so login is granted.does that look about right - or can you see any downfalls in that method?
regards
-
Take a look at a billing package called freeside.
It supports this and is opensourced, and also has commercial support.
We have used it for several years and are using it with pfsense / radius for the last month.
http://www.sisd.com/freeside/for a quick start using a vmware image:
http://www.sisd.com/freeside/developers.html-Mark