Quota doesn't work

[chris82]

Hi there,

it's about the tutorial: Virtual Users + Domains With Postfix, Courier + MySQL (+SMTP-AUTH, SpamA, ClamAV) - i followed it without installing spam-filters.

Everything works fine, except that quota doesn't work. If i set the quota to 1 and send then an email to this mail account, the mail is normally delivered to the maildir.

same thing if i copy an email from another imap-mailbox to this mailbox: no quota error....

can anyone help me?

thank you
chris

[falko]

Please have a look at this thread: http://www.howtoforge.com/forums/showthread.php?t=2116

[chris82]

Thank you, i've read this thread but it didn't help me...

postconf | grep size gets:

berkeley_db_create_buffer_size = 16777216
berkeley_db_read_buffer_size = 131072
body_checks_size_limit = 51200
bounce_size_limit = 2000
header_size_limit = 102400
mailbox_size_limit = 102400000
message_size_limit = 10240000

Am i mixing up real system users and virtual users maybe? How can i tell postfix to use virtual_mailbox_limit_maps?

[falko]

Originally Posted by chris82

Am i mixing up real system users and virtual users maybe?

Is the recipient domain of your virtual user also listed in mydestination in /etc/postfix/main.cf?

[chris82]

Originally Posted by falko

Is the recipient domain of your virtual user also listed in mydestination in /etc/postfix/main.cf?

No, it is not:

mydomain = server193xxxxxxx.serverpool.info
myhostname = server193xxxxxxx.serverpool.info
mydestination = $myhostname, localhost.$mydomain, $mydomain

[falko]

Originally Posted by chris82

Everything works fine, except that quota doesn't work. If i set the quota to 1 and send then an email to this mail account, the mail is normally delivered to the maildir.

Are you sure you exceeded the quota of 1MB with this email?

Originally Posted by chris82

same thing if i copy an email from another imap-mailbox to this mailbox: no quota error....

You mean you copied the email on the command line with the cp command? This doesn't work!

[chris82]

Originally Posted by falko

Are you sure you exceeded the quota of 1MB with this email?

Hm, is it really 1 MB and not 1 KB or 1 Byte? I have 1 as value for the quota in the user-table for this email-account.

I changed now the database password in the mysql-virtual_mailbox_limit_maps.cf to a wrong password but i'm not getting any errors when i send a mail to this account.

If i e.g change the pwd to a wrong pwd in mysql-virtual_mailboxes.cf i get the error:

warning: connect to mysql server 127.0.0.1: Access denied for user 'provider_admin'@'localhost' (using password: YES)

Originally Posted by falko

You mean you copied the email on the command line with the cp command? This doesn't work!

No, i copied the email with IMAP to another folder. I have courier-imap. But that's not as important as the postfix quota.

[falko]

Originally Posted by chris82

Hm, is it really 1 MB and not 1 KB or 1 Byte? I have 1 as value for the quota in the user-table for this email-account.

It's 1 MB.

Originally Posted by chris82

I changed now the database password in the mysql-virtual_mailbox_limit_maps.cf to a wrong password but i'm not getting any errors when i send a mail to this account.

If i e.g change the pwd to a wrong pwd in mysql-virtual_mailboxes.cf i get the error:

warning: connect to mysql server 127.0.0.1: Access denied for user 'provider_admin'@'localhost' (using password: YES)

I'm not quite sure if I understand what you mean here...

[chris82]

Originally Posted by falko

It's 1 MB.


I'm not quite sure if I understand what you mean here...

Hi,

my mysql-virtual_mailbox_limit_maps.cf looks like:

user = provider_admin
password = mypasswd
dbname = provider
table = users
select_field = quota
where_field = email
hosts = 127.0.0.1

As password i've tried to enter a wrong value. So when postfix accesses this file and reads the quota, it should get in the mail-log a warning about the wrong database-password.
But i don't get any errors (i do get an error if i change the password e.g. from mysql-virtual_mailboxes.cf to a wrong one). So i think, postfix doesn't access this file. But why? Is it possible that it's not the patched version that is running but the old version?
Before i installed postfix + vda i've had an old version, installed via apt-get.

Do u understand me? Thank you very much for your help!

[falko]

Please post your /etc/postfix/main.cf.