I followed the above tutorial but using different version of postfix srpm ( version 2.4) with vda patch from http://postfix.wl0.org. I got the problem with quota. When i set quota field in users table with default value '10485760', i got error message, maildir delivery failed: user overdrawn his diskspace quota. Strangely, the user folder is empty. I aslo try to manually create maildirsize with size of 10485760, but the problem still occured. When i reset the value of quota field to 0, mail is delivered to user folder. Any help is appreciated. Tq.
Only small file with size less than 1KB. Anyway, I manage to get rid of the problem after follow exactly the setup in the howto, and now quota worked fine. Actualy, i only change the the sql query to suit my need as below and configure virtual_mailbox_base to /. I still need assistant to get my intended setup running fine with quota. I am trying to migrate from qmail-mysql to postfix-mysql, and i have users table with home field with absolute path in qmail-mysql setup. I try to stick with current design. This is my setup. I alter users table and create 'home' field. This field will refer to user's home folder with absolute path ( /home/test) I modified mysql query in /etc/postfix/mysql-virtual_mailboxes.cf to, query=select concat(home, '/') FROM users WHERE email='%s', and set virtual_mailbox_base = /. I don't know how to get rid of the variable and postfix refuse to start without this variable. So, i put / for that. With this setup, i face the problem with quota as posted before. I think it may be related to virtual_mailbox_base when the value is set to / and my sql query. How can i ignore this virtual_mailbox_base value, and tell postfix/vda not to append value to my home field ?. I try not change my home value ( get rid of first /) because i have internal program that refer to the home folder with absolute path. Do you have any suggestion to make my setup work. Tq.
