Prepaid billing using freeradius and rlm_counter/rlm_sqlcounter
Hey guys, I'd like to try and implement a solution for pre-paid accounts. The idea is that I'd be providing pairs of username/passwords to customers and these accounts will be set to N hours, after those N hours are used by the customer (the user has ran out of his N-hour time) the account will be disabled, i.e: freeradius would return an access-reject. I'm currently using FreeRADIUS 1.1.0 with mysql as the back-end on debian and I've read the manpage about rlm_counter and rlm_sqlcounter though the manpage is a bit low of information and examples. Could someone please provide me with an example of how to get freeradius configured to this solution? Thanks, Sincerly, Liran Tal.
I have not tried it myself yet (due to back-ordered equipment and time constraints) but I have been looking at phpmyprepaid for just this type of solution. Its free and it is designed to work with freeradius and mysql and their are a lot of how-to's floating around the internet (google for phpmyprepaid). Maybe someone else on the list has some more experience with it. Let me know how it works for you if you decide to give it a try. Thanks, Craig Russell AirDigitalNetwork.com liran tal wrote:
Hey guys,
I'd like to try and implement a solution for pre-paid accounts. The idea is that I'd be providing pairs of username/passwords to customers and these accounts will be set to N hours, after those N hours are used by the customer (the user has ran out of his N-hour time) the account will be disabled, i.e: freeradius would return an access-reject.
I'm currently using FreeRADIUS 1.1.0 with mysql as the back-end on debian and I've read the manpage about rlm_counter and rlm_sqlcounter though the manpage is a bit low of information and examples.
Could someone please provide me with an example of how to get freeradius configured to this solution?
Thanks, Sincerly, Liran Tal.
------------------------------------------------------------------------
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Thanks for the reply Craig. I know about phpMyPrepaid although it's an all-around solution which uses chillispot as well, and I was just wondering about the configuration of rlm_counter/sql_counter. On 6/9/06, Craig Russell <craig@airdigitalnetwork.com> wrote:
I have not tried it myself yet (due to back-ordered equipment and time constraints) but I have been looking at phpmyprepaid for just this type of solution. Its free and it is designed to work with freeradius and mysql and their are a lot of how-to's floating around the internet (google for phpmyprepaid).
Maybe someone else on the list has some more experience with it.
Let me know how it works for you if you decide to give it a try.
Thanks,
Craig Russell AirDigitalNetwork.com
liran tal wrote:
Hey guys,
I'd like to try and implement a solution for pre-paid accounts. The idea is that I'd be providing pairs of username/passwords to customers and these accounts will be set to N hours, after those N hours are used by the customer (the user has ran out of his N-hour time) the account will be disabled, i.e: freeradius would return an access-reject.
I'm currently using FreeRADIUS 1.1.0 with mysql as the back-end on debian and I've read the manpage about rlm_counter and rlm_sqlcounter though the manpage is a bit low of information and examples.
Could someone please provide me with an example of how to get freeradius configured to this solution?
Thanks, Sincerly, Liran Tal.
------------------------------------------------------------------------
- List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Assuming you had a way to populate the radius database with your username/password pairs, you could configure each one with a Max-All-Session-Time value. FreeRADIUS will make sure they get disconnected when their time is used up. liran tal <liransgarage@gmail.com> wrote: Hey guys, I'd like to try and implement a solution for pre-paid accounts. The idea is that I'd be providing pairs of username/passwords to customers and these accounts will be set to N hours, after those N hours are used by the customer (the user has ran out of his N-hour time) the account will be disabled, i.e: freeradius would return an access-reject. I'm currently using FreeRADIUS 1.1.0 with mysql as the back-end on debian and I've read the manpage about rlm_counter and rlm_sqlcounter though the manpage is a bit low of information and examples. Could someone please provide me with an example of how to get freeradius configured to this solution? Thanks, Sincerly, Liran Tal. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
participants (3)
-
Craig Russell -
Julius Igugu -
liran tal