Only one cron file is there in squish "/usr/local/squish/squish.
Main Topics
Browse All TopicsI am using Squid on Fedora Core 8 with Squish. Everything is working fine with user authentication and quotas. Only problem is if some user exceeds the daily quota and gets squished. Squish resets the quota only at 12pm the following day. Hence, the users are blacked out from internet for almost half the working day.
I need to reconfigure Squish to reset the quotas at 6am instead of 12pm. Could you plz help me with this.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
I'm sorry - I've downloaded squish sources, and it's probably cron unrelated.
It looks, that squish just parses squid logfiles and blocks users automatically. Cron is just for parsing squid logfiles (every 5 minutes by default).
Strange part is what you are saying about quota resetting at 12pm - it should be IMHO at 12am. Do you have proper time/timezone set on your server? Does the squid/squish uses this time/timezone setting, or does it change locally (ie. in squid init script)?
Ok. I am having another doubt.
Users can able to continue the downloading files after the quota exceeds but they not able to browse. After the current download completed they not able to download or browse the net. The main problem is if the user download any large files means (eg 1GB file) after the quota execeeds also downloading files are not terminated it still continue.
Is there any settings in squish to terminate the download once the quota exceeds.
This is one of the issues with squish - user can start downloading some big file, and even if he reaches his/her quota during this download, he/she can successfully download it to the end.
From squish FAQ (http://www.ledge.co.za/so
Q. Can I download a file bigger than my daily quota?
A. Just do it. You'll get squished when the download completes, but don't
worry about that. Being squished does not affect downloads currently in
progress, unless the connection is interrupted.
1. Theoretically you can interrupt downloads every x minutes, so that user has to renew downloading - but it can be very annoying for users (even if they can renew transfers from the moment that transfers were interrupted). I wouldn't do that.
2. I found two more, but I know nothing about them, so you should try them by yourself:
http://sourceforge.net/pro
http://sourceforge.net/pro
In Both the link i am not able to download packages. Kindly check it.
http://sourceforge.net/pro
http://sourceforge.net/pro
I tried to download both - just downloaded first one (alfred). Unfortunately, I can't download quotasquid - there are no files at sourceforge :/ I can't find it with google also. So - this is probably dead project.
As for alfred, try one of these:
http://mesh.dl.sourceforge
http://voxel.dl.sourceforg
http://transact.dl.sourcef
But - I read more than just entry message about alfred. Although there was information that "Alfred, OpenSource Internet Software, is a collection of utilities that bring Quota support to SQUID.", it looks, that it's not you were looking for - it's probably some netware module to authenticate users :(
So, I'm afraid you have no other option - just squish.
Ok. This the last doubt. I have configure delay pool in squid to restrict download speed for particular file extension like .exe, .iso etc... I have restrict download speed by using the LDAP user name. Delay pool is working fine. The problem is when the squish quota exceeds the delay pool is not working. Users can able to download files at full speed. If the quota not execeeds means delay pool working fine.
Kindly see my squid code
acl ldapauth proxy_auth REQUIRED
acl SQUISHLOC dst adminlinux
acl SQUISHED1 proxy_auth -i "/etc/squid/squished"
# acl SQUISHED2 ident "/etc/squid/squished"
acl SQUISHED3 src "/etc/squid/squished"
# Error info that says you're squished
#deny_info ERR_QUOTA_EXCEEDED SQUISHED1
deny_info http://192.168.1.14/squish
# deny_info http://adminlinux/squish/?
#deny_info ERR_QUOTA_EXCEEDED SQUISHED3
deny_info http://192.168.1.14/squish
# HTTP access controls for squish
http_access allow SQUISHLOC
http_access deny SQUISHED1
# http_access deny SQUISHED2
http_access deny SQUISHED3
delay_pools 1
delay_class 1 1
delay_parameters 1 1000/1000
acl our_networks src 192.168.1.0/24
acl DelayDownload url_regex -i "/etc/delaydownload"
delay_access 1 allow DelayDownload
http_access allow ldapauth !SQUISHED1
<<<<<<So, if user reaches his/her quota he/she is able to download anything?
If user's reaches his quota he can able to download files at full speed. If user's quota not reaches means user can able to download files with 1.5 kbps speed.
That would mean, that squish doesn't work at all - such user should not be able to download anything, right?
<<<<<<So, if user reaches his/her quota he/she is able to download anything?
If user's reaches his quota he can able to download files at full speed. If user's quota not reaches means user can able to download files with 1.5 kbps speed.
<<<<<<That would mean, that squish doesn't work at all - such user should not be able to download anything, right?
such users can able to download files @ full speed.
Hi oklit
I found a solution to reset the squish quota manually.
This is my solution.
1) After installing squish. Copy this file userdb.stor from /var/lib/squish/ to /backup
2) Turn off the squid auto start by using this command chkconfig squid off
3) Add the below lines to a shell script file and execute the shell script at a specific time using cron
/etc/init.d/squid stop #Stop the squid proxy
rm /var/log/squid/access.log #Removing access.log file.
rm /var/lib/squish/userdb.sto
cp /backup/userdb.stor /var/lib/squish/ #Copying userdb.stor to squish quota directory.
/usr/sbin/squid #Start the squid now
Business Accounts
Answer for Membership
by: oklitPosted on 2009-02-16 at 04:31:27ID: 23649114
There is probably some cronjob, which is run at 12pm which zeros users' quotas. Change this to 6am, and that's all.