The only way I could get around this problem, is replace vdelivermail with maildrop, for all my domains, and configure it to run in delivery mode to read the vpopmail users from mysql database.
I also changed qmail-start command to pipe to the deliverquota program from courier-imap or courier-maildrop packages (compiled with quota support). This catches locally delivered messages that could escape the quota because of qmail-local's lack of maildirquota support (the maildir++ patch by bill shupp didn't help either). change your `qmail-start ./Maildir/` in /var/qmail/rc to: qmail-start | /usr/local/bin/deliverquota -w 90 ./Maildir Now time for maildrop: # wget http://aleron.dl.sourceforge.net/sourceforge/courier/courier-imap- 2.0.0.tar.bz2 # export HAVE_OPEN_SMTP_RELAY=1 # export DYNMYSQLLIBS="-L/usr/local/lib/mysql -lmysqlclient" ./configure --prefix=/usr/local --exec-prefix=/usr/local \ --without-authldap --without-authshadow \ --with-authvchkpw --without-authcram \ --sysconfdir=/usr/local/etc/courier-imap \ --datadir=/usr/local/share/courier-imap \ --libexecdir=/usr/local/libexec/courier-imap \ --enable-workarounds-for-imap-client-bugs \ --disable-root-check --without-authdaemon sed 's/#undef HAVE_OPEN_SMTP_RELAY/#define HAVE_OPEN_SMTP_RELAY 1/g' \ authlib/preauthvchkpw.c > preauthvchkpw.c.new mv authlib/preauthvchkpw.c authlib/preauthvchkpw.c.orig mv authlib/preauthvchkpw.c.new authlib/preauthvchkpw.c cd maildir make autoresponsequota.h make mailbot.h make maildirfilterconfig.h make maildirsharedrc.h make quotawarnmsg.h cd ../authlib make authchangepwdir.h make sbindir.h cd .. make install /usr/local/etc/maildropmysql.conf --------------------------------- # hostname - host name of your ldap server hostname mysql.hostname.com port 3306 database vpopmail dbuser vpopmail dbpw secret dbtable vpopmail #not used now #timeout 5 # default_uid - default uid (number only) to use incase uidnumber attribute not # found in users mysql entry default_uidnumber 500 # default_gid - default gid (number only) to use incase gidnumber attribute not # found in users ldap entry default_gidnumber 500 # MySQL Field definitions # # This section allows you to specify the actual attributes you # use in your Mysql record # # The example attribute mapping shown below is also the default # mapping used by maildrop in the case that any are missing # UID_FIELD - MySQL attribute which contains the users name (w or w/o domain) uid_field pw_email # UIDNUMBER_FIELD - MySQL attribute which contains the system uid to deliver # mail as uidnumber_field real_uid # GIDNUMBER_FIELD - MySQL attribute which contains the system gid to deliver # mail as gidnumber_field real_gid # MAILDIR_FIELD - MySQL attribute which contains the path to the users # custom maildir maildir_field pw_maildir # HOMEDIRECTORY_FIELD - MySQL attribute which contains the path to the users # home directory homedirectory_field pw_dir # QUOTA_FIELD - MySQL attribute which contains the users quota quota_field pw_shell # MYSQL_DEFAULT_STATUS_FIELD - MySQL attribute which could be created in the # MySQL entry to set whether or not the user is allowed to receive email on # this box.. # -- looks unused for now; but must be valid column ! (2001-11- 03) mailstatus_field pw_status # MYSQL_DEFAULT_WHERE_CLAUSE - This is optional ! # It can be set to any fixed string starting with keyword 'AND'. # It will then be appended to the WHERE clause of our query. where_clause "" ---------------------- Apply the attached patch to vpopmail-5.2.1 to enable it to share its mysql db with maildrop and also default to put "| maildrop -d" instead of vdelivermail in .qmail-default for new domains added with vadddomain It allows single and multi uid system. uids are also stored in mysql. check this for more information on the patch (especially if you have existing users you want to enable to use maildrop): http://www.mail-archive.com/[EMAIL PROTECTED]/msg14690.html this also allows putting a .mailfilter in any user's maildir and it will be processed by maildrop (ex. spam filters etc..) remove all existing maildirsize files in all users maildirs, and regenerate them for every user using the up-to-date maildirmake tool that comes with maildrop: maildirmake -q 10000000S,1000C ~vpopmail/domains/domain.com/user/Maildir this will recreate maildirsize with a quota of 10MB and 1000 message count limit. Make sure that after the patch you check that all the pw_shell fields (the quota field in vpopmail table) have the correct quota syntax like: 10000000S or 10000000S,1000C or else maildrop will not generate the maildirsize file if it doesn't exist for a user receiving a new mail message. After I done this, I haven't had the quota usage reporting negative or 0% when the user has mail. Hope this helps.... Best Regards, Tim Hasson Quoting Abdul Mahzeer <[EMAIL PROTECTED]>: > Tim, > > Thank you very much for your response, any advice you can give me is greatly > > appreciated. To answer your questions, first my vpopmail domain is located > locally on a ext3 filesystem. Secondly, when i telnet into my imap server > and do a "getquota ROOT" for my user it gives me an output of: > > a2 getquota ROOT > * QUOTA "ROOT" (STORAGE -166194 20480) > a2 OK GETQUOTA Ok. > > I hope this was the info you are looking for. This whole situation is very > bizarre to me. Once again thank you for all your help and I hope to hear > from you soon. > > Warm Regards, > > Abdul > > > >From: Tim Hasson <[EMAIL PROTECTED]> > >To: Abdul Mahzeer <[EMAIL PROTECTED]> > >Subject: Re: Vpopmail Problems > >Date: Wed, 15 Oct 2003 13:54:58 -0700 > > > >Hi Abdul, > > > >I'll try to answer your question tomorrow. I have a test today :) > > > >For now, some information would be helpful: > > > >1. do you also store your vpopmail domains on NFS, or is it on local disk > >partition (ext2/ext3/ufs etc..) > > > >2. For the user you mentioned, can you do the following from command line > >(to > >test if you are really getting negative values in the quota usage instead > >of a > >valid number - this is the case when user info returns 0% ) > > > ># telnet your.imap.server.host 143 > >login [EMAIL PROTECTED] hispassword > >getquota ROOT > > > >This information will greatly help. > > > >Tim > > > > > >Quoting Abdul Mahzeer <[EMAIL PROTECTED]>: > > > > > Tim, > > > > > > Sorry to bother you but just recently I've been experiencing similiar > > > maildirsize problems that you mentioned you were having on the vpopmail > > > mailing list. I'm running vpopmail 5.3.23 along with qmail 1.03. Also > >like > > > > > > you, I've just recently migrated from courier 1.6 to courier 2.0. When > >i do > > > > > > a "vuserinfo -Q [EMAIL PROTECTED]" on a user i get an output of 0%. But > > >I > > > know he has over 500 messages on a 20MB quota. Anyway from your post it > > > appears you had the same problem. Did you ever figure out what was > >causing > > > the problem? Any help on this would be greatly appreciated because i > >have > > > no clue. > > > > > > Regards, > > > > > > Abdul > > > > > > _________________________________________________________________ > > > Concerned that messages may bounce because your Hotmail account has > >exceeded > > > > > > its 2MB storage limit? Get Hotmail Extra Storage! > > > http://join.msn.com/?PAGE=features/es > > > > > > > > > > _________________________________________________________________ > Concerned that messages may bounce because your Hotmail account has exceeded > > its 2MB storage limit? Get Hotmail Extra Storage! > http://join.msn.com/?PAGE=features/es > > Respectfully, Tim Hasson Consultant, AiDA Systems (209) 639-2989 Voice
