Re: Bandwith limit/per user from mysql

2009-12-09 Thread Ray Morris
Did anyone tried mod_bw or mod_cband , or maybe other mods like these? i still don't know how the hell those could solve my problem , at least partialy.. none of those connect with a SQL db.. they make the decisions upon a conf file , for the whole vhost.. We tried those with several cli

Re: Bandwith limit/per user from mysql

2009-12-09 Thread Ray Morris
Yeah, there aren't a lot of options, and what else there is other than Throttlebox is far more simplistic. We wrote Throttlebox because we found that the existing solutions were a tad TOO simplistic - they caused just enough problems to not be worth it for the benefits. It took a few years of e

Re: Bandwith limit/per user from mysql

2009-12-08 Thread Ray Morris
> This kind of functionality, in my opinion, is better > implemented at transport level and not at application level. Yes, well that was the main problem , doing it per user, of course i have on the DB the ips of the users when they login, i even update that, but you know how ips are, co

Re: Bandwith limit/per user from mysql

2009-12-08 Thread partysoft
Did anyone tried mod_bw or mod_cband , or maybe other mods like these? i still don't know how the hell those could solve my problem , at least partialy.. none of those connect with a SQL db.. they make the decisions upon a conf file , for the whole vhost.. i can identify the users from the URL

Re: Bandwith limit/per user from mysql

2009-12-08 Thread partysoft
Yes, well that was the main problem , doing it per user, of course i have on the DB the ips of the users when they login, i even update that, but you know how ips are, constantly changing, even more, they can be under NAT on some private network, but no doubt making it under a lower OSI level wou

Re: Bandwith limit/per user from mysql

2009-12-08 Thread partysoft
No, not every bit, but to limit somehow , per user how much he can use for download it's a simple mp3 service, not something fancy so i can even count per 1MB or so, or even a larger scale.. right now i'm counting every download, (with resume support and multiple connections) but if the user s

Re: Bandwith limit/per user from mysql

2009-12-08 Thread Sorin Manolache
On Tue, Dec 8, 2009 at 05:11, partysoft wrote: > > I am looking for a solution to limit the bandwith for the users of a site > that have access to some mp3 / subscription. I don't want to serve files > through PHP, but directly with some apache module.. > do i have to count every bit? or how this

Re: Bandwith limit/per user from mysql

2009-12-07 Thread Ray Morris
do i have to count every bit? You have to count every bucket, and do it carefully because there are some pitfalls you run into when you implement it in the real world. Be aware that the major browsers have recently changed so they will by default use many connections. Download agents which b