postfix myysql quota

[40esp]

postfix is not applying quota given in mysql.

I followed this guide:http://howtoforge.com/virtual-users-...-mysql-fedora8

everything works great now, except for quota!
I made sure i followed the guide and i built and packaged postfix like the guide said to patch postfix to allow quota.

well I set the default quota, and It says unlimitted quota, according to my roundcube webmail installation.

postfix reads users and domains from mysql, but not quota.

how do i fix this?

[40esp]

heres the tail end of my postfix main.cnf

myhostname = 71-13-92-138.static.bycy.mi.charter.com
mynetworks = 127.0.0.0/8
virtual_alias_domains =
virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf
virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf
virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf
virtual_mailbox_base = /home/vmail
virtual_uid_maps = static:5000
virtual_gid_maps = static:5000
smtpd_sasl_auth_enable = yes
broken_sasl_auth_clients = yes
smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_unauth_destination
smtpd_use_tls = yes
smtpd_tls_cert_file = /etc/postfix/smtpd.cert
smtpd_tls_key_file = /etc/postfix/smtpd.key
transport_maps = proxy:mysql:/etc/postfix/mysql-virtual_transports.cf
virtual_create_maildirsize = yes
virtual_mailbox_extended = yes
virtual_mailbox_limit_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailbox_limit_maps.cf
virtual_mailbox_limit_override = yes
virtual_maildir_limit_message = "The user you are trying to reach is over quota."
virtual_overquota_bounce = yes
proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps $virtual_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps $recipient_canonical_maps $relocated_maps $transport_maps $mynetworks $virtual_mailbox_limit_maps
content_filter = amavis:[127.0.0.1]:10024
receive_override_options = no_address_mappings

[falko]

Any errors in your mail log?

[40esp]

where and how exactly do i get to that log?

[40esp]

/var/log/maillog shows no errors.

[falko]

I'm not sure where Roundcube gets the quota information from. But you can test if quota is working by simply sending an email that is bigger than the space that is left for the recipient account.

[40esp]

i just got the quota report email that came with the howto.

DAILY QUOTA REPORT:

----------------------------------------------
| % USAGE | ACCOUNT NAME |
----------------------------------------------

--



nothing is showing. no numbers, nothing. and i have quota setup for the email.

[falko]

You might have to modify the /usr/local/sbin/quota_notify script, as shown on http://www.howtoforge.com/virtual-us...ubuntu-7.10-p5

[luchs3]

does the setup script normally ask for the mysql server when it updates a System?

[falko]

What setup script?