I have a very detailed breakdown of what we did to solve the UBB problem on my Wireless Cowboys blog. You can read it here:

http://www.wirelesscowboys.com/?p=88

We went the NetFlow method and correlate customer IP addresses to their Freeside accounts to see who gets billed. Right now, the list of violators is pretty small so we do the overage billing manually. We have the option of building a batch transaction that gets imported into our billing system on the first of each month. We also built a portal for users to check their own bandwidth utilization, and our system sends emails to users when they go over and a summary email to our techs with a list of all the people that are over.

Hope that helps.

Matt Larsen
vistabeam.com
www.wirelesscowboys.com


On 5/3/2011 12:00 PM, Cameron Crum wrote:
What happens if/when you reboot the MT? Don't you lose your counts? I would think a better idea would be to use traffic flow and an external NetFlow analyzer. We are working on this for Wispmon as another way (other than radius accounting) to do usage based billing with the product. The downside to this is that the "Traffic Flow" stream as they call it, does not output the mac field (even though one is available according to the NetFlow spec). So if you are using DHCP, it becomes harder to track with this method as you would have to constantly poll the routers to find out what mac they are attached to. RADIUS is fairly cumbersome too as you have to sum all the accounting sessions for a given user over a given time period.

On Tue, May 3, 2011 at 12:25 PM, Josh Luthman <j...@imaginenetworksllc.com <mailto:j...@imaginenetworksllc.com>> wrote:

    Joe - http://www.mikrotik-routeros.com/?p=24


    Josh Luthman
    Office: 937-552-2340
    Direct: 937-552-2343

    1100 Wayne St
    Suite 1337
    Troy, OH 45373


    On Tue, May 3, 2011 at 12:08 PM, Joe Miller
    <joe.mil...@dslbyair.com <mailto:joe.mil...@dslbyair.com>> wrote:

        Can this script be made available for everyone?

        Joe Miller
        DSLbyAir, LLC
        228-831-8881 <tel:228-831-8881>
        www.dslbyair.com <http://www.dslbyair.com>
        ----- Original Message -----
        From: "Stuart Pierce" <spie...@avolve.net
        <mailto:spie...@avolve.net>>
        To: "WISPA General List" <wireless@wispa.org
        <mailto:wireless@wispa.org>>
        Sent: Tuesday, May 03, 2011 8:05 AM
        Subject: Re: [WISPA] My day is now dedicated to UBB research.
        You should
        too.


        > I've been saying for a while now that you have to have
        bandwidth caps and
        > costs stated on your website somewhere, even if you are not
        charging for
        > them at this point. You also have to have some method of
        giving feedback
        > to them on their bandwidth consumption.
        >
        > Right now thanks to Josh for the heads up about Andrew Cox's
        script for a
        > Mikrotik box, I've done that and so far so good. It will
        email the client
        > when they reach percentages of usage with whatever you want
        the content of
        > the email to say.
        >
        > What did your letter say ?
        >
        > ---------- Original Message ----------------------------------
        > From: Mark Nash <markl...@uwol.net <mailto:markl...@uwol.net>>
        > Reply-To: WISPA General List <wireless@wispa.org
        <mailto:wireless@wispa.org>>
        > Date:  Mon, 02 May 2011 10:34:01 -0700
        >
        >>I think it's important for people to (after gaining an
        understanding of
        >>the impact they have on "shared" bandwidth) choose one of
        these...
        >>
        >>1. pay more (either by overages or a different service plan
        that allows
        >>for more & costs more), or
        >>2. change their behavior to not use so much
        >>3. leave
        >>
        >>I am implementing this now.  The letter went out on Friday
        to most
        >>customers...
        >>
        >>On 5/2/2011 10:25 AM, Chuck Hogg wrote:
        >>> Not saying what I'm doing is right...I don't have enough
        spectrum to
        >>> continue to deliver the service...haven't figured anything
        else out yet.
        >>>
        >>> Regards,
        >>>
        >>> Chuck
        >>>
        >>>
        >>> On Mon, May 2, 2011 at 1:21 PM, Josh Luthman
        >>> <j...@imaginenetworksllc.com
        <mailto:j...@imaginenetworksllc.com>
        <mailto:j...@imaginenetworksllc.com
        <mailto:j...@imaginenetworksllc.com>>>
        >>> wrote:
        >>>
        >>>     Why not collect more revenue instead of limiting them?
         I suppose
        >>>     if the customer wants to simply be throttled back
        instead of pay
        >>>     more, that's one thing, but I imagine it makes more
        sense to
        >>>     capitalize on something.
        >>>
        >>>     Thinking along the lines of the on demand movies and
        stuff from
        >>>     cable companies, for example.
        >>>
        >>>
        >>>     Josh Luthman
        >>>     Office: 937-552-2340 <tel:937-552-2340>
        <tel:937-552-2340 <tel:937-552-2340>>
        >>>     Direct: 937-552-2343 <tel:937-552-2343>
        <tel:937-552-2343 <tel:937-552-2343>>
        >>>     1100 Wayne St
        >>>     Suite 1337
        >>>     Troy, OH 45373
        >>>
        >>>
        >>>     On Mon, May 2, 2011 at 1:17 PM, Chuck Hogg
        <ch...@shelbybb.com <mailto:ch...@shelbybb.com>
        >>> <mailto:ch...@shelbybb.com <mailto:ch...@shelbybb.com>>>
        wrote:
        >>>
        >>>         25GB per month. 128k/s after exceeding their limit.
        >>>
        >>>         Regards,
        >>>
        >>>         Chuck
        >>>
        >>>
        >>>
        >>>         On Mon, May 2, 2011 at 1:02 PM, Matt
        <lm7...@gmail.com <mailto:lm7...@gmail.com>
        >>> <mailto:lm7...@gmail.com <mailto:lm7...@gmail.com>>> wrote:
        >>>
        >>> > Robert
        >>> > up/down/aggregate
        >>> > 103972 MB   469598 MB   573570 MB
        >>> >
        >>> > The guy downloaded 470 gigs in April.  Paying $53.32 for
        >>>             4 megabits down.
        >>> >
        >>> > I got no responses at all about monthly caps on my
        >>>             previous email, but if
        >>> > anyone could offer what bandwidth rates and monthly caps
        >>>             you are using I
        >>> > would greatly appreciate it.
        >>>
        >>>             What is cost per megabit from your upstream?
        >>>
        >>>
>>> --------------------------------------------------------------------------------
        >>>             WISPA Wants You! Join today!
        >>> http://signup.wispa.org/
>>> --------------------------------------------------------------------------------
        >>>
        >>>             WISPA Wireless List: wireless@wispa.org
        <mailto:wireless@wispa.org>
        >>> <mailto:wireless@wispa.org <mailto:wireless@wispa.org>>
        >>>
        >>>             Subscribe/Unsubscribe:
        >>> http://lists.wispa.org/mailman/listinfo/wireless
        >>>
        >>>             Archives:
        http://lists.wispa.org/pipermail/wireless/
        >>>
        >>>
        >>>
        >>>
        >>>
>>> --------------------------------------------------------------------------------
        >>>         WISPA Wants You! Join today!
        >>> http://signup.wispa.org/
>>> --------------------------------------------------------------------------------
        >>>
        >>>         WISPA Wireless List: wireless@wispa.org
        <mailto:wireless@wispa.org>
        >>> <mailto:wireless@wispa.org <mailto:wireless@wispa.org>>
        >>>
        >>>         Subscribe/Unsubscribe:
        >>> http://lists.wispa.org/mailman/listinfo/wireless
        >>>
        >>>         Archives: http://lists.wispa.org/pipermail/wireless/
        >>>
        >>>
        >>>
        >>>
        >>>
>>> --------------------------------------------------------------------------------
        >>>     WISPA Wants You! Join today!
        >>> http://signup.wispa.org/
>>> --------------------------------------------------------------------------------
        >>>
        >>>     WISPA Wireless List: wireless@wispa.org
        <mailto:wireless@wispa.org> <mailto:wireless@wispa.org
        <mailto:wireless@wispa.org>>
        >>>
        >>>     Subscribe/Unsubscribe:
        >>> http://lists.wispa.org/mailman/listinfo/wireless
        >>>
        >>>     Archives: http://lists.wispa.org/pipermail/wireless/
        >>>
        >>>
        >>>
        >>>
        >>>
        >>>
        
--------------------------------------------------------------------------------
        >>> WISPA Wants You! Join today!
        >>> http://signup.wispa.org/
        >>>
        
--------------------------------------------------------------------------------
        >>>
        >>> WISPA Wireless List: wireless@wispa.org
        <mailto:wireless@wispa.org>
        >>>
        >>> Subscribe/Unsubscribe:
        >>> http://lists.wispa.org/mailman/listinfo/wireless
        >>>
        >>> Archives: http://lists.wispa.org/pipermail/wireless/
        >>
        >>
        >>
        >>
        >
        >
        >
        >
        >
        > ________________________________________________________________
        > Sent via the WebMail system at avolve.net <http://avolve.net>
        >
        >
        >
        >
        >
        >
        >
        
--------------------------------------------------------------------------------
        > WISPA Wants You! Join today!
        > http://signup.wispa.org/
        >
        
--------------------------------------------------------------------------------
        >
        > WISPA Wireless List: wireless@wispa.org
        <mailto:wireless@wispa.org>
        >
        > Subscribe/Unsubscribe:
        > http://lists.wispa.org/mailman/listinfo/wireless
        >
        > Archives: http://lists.wispa.org/pipermail/wireless/



        
--------------------------------------------------------------------------------
        WISPA Wants You! Join today!
        http://signup.wispa.org/
        
--------------------------------------------------------------------------------

        WISPA Wireless List: wireless@wispa.org
        <mailto:wireless@wispa.org>

        Subscribe/Unsubscribe:
        http://lists.wispa.org/mailman/listinfo/wireless

        Archives: http://lists.wispa.org/pipermail/wireless/





    
--------------------------------------------------------------------------------
    WISPA Wants You! Join today!
    http://signup.wispa.org/
    
--------------------------------------------------------------------------------

    WISPA Wireless List: wireless@wispa.org <mailto:wireless@wispa.org>

    Subscribe/Unsubscribe:
    http://lists.wispa.org/mailman/listinfo/wireless

    Archives: http://lists.wispa.org/pipermail/wireless/





--------------------------------------------------------------------------------
WISPA Wants You! Join today!
http://signup.wispa.org/
--------------------------------------------------------------------------------

WISPA Wireless List: wireless@wispa.org

Subscribe/Unsubscribe:
http://lists.wispa.org/mailman/listinfo/wireless

Archives: http://lists.wispa.org/pipermail/wireless/


--------------------------------------------------------------------------------
WISPA Wants You! Join today!
http://signup.wispa.org/
--------------------------------------------------------------------------------
 
WISPA Wireless List: wireless@wispa.org

Subscribe/Unsubscribe:
http://lists.wispa.org/mailman/listinfo/wireless

Archives: http://lists.wispa.org/pipermail/wireless/

Reply via email to