Hello,

Thanks. I've created a quota table as described in dovecot-dict sql configuration file and granted the mail user select, insert, update, and delete rights to that table, while the virtual_users table select rights only. I configured for the new table. Here's my config, have I got it? Are the columns now going to stay where I put them?

mysql> show create table virtual_users; +---------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table

                     |

+---------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | virtual_users | CREATE TABLE virtual_users ( id int(11) NOT NULL AUTO_INCREMENT, domain_id int(11) NOT NULL, user varchar(40) NOT NULL, password varchar(128) NOT NULL, quota bigint(20) NOT NULL DEFAULT '0', quota_messages int(11) NOT NULL DEFAULT '0', PRIMARY KEY (id), UNIQUE KEY UNIQUE_EMAIL (domain_id,user), CONSTRAINT virtual_users_ibfk_1 FOREIGN KEY (domain_id) REFERENCES virtual_domains (id) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 | +---------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)

mysql> show create table quota; +-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table

  |

+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | quota | CREATE TABLE quota ( username varchar(100) NOT NULL, bytes bigint(20) NOT NULL DEFAULT '0', messages int(11) NOT NULL DEFAULT '0', PRIMARY KEY (username) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 | +-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)

dovecot dictionary configuration

map { pattern = priv/quota/storage table = quota username_field = username value_field = bytes } map { pattern = priv/quota/messages table = quota username_field = username value_field = messages }

Thanks. Dave.

On 10/21/12, Daniel Parthey <daniel.parthey@informatik.tu-chemnitz.de> wrote:

David Mehler wrote:

...

Thanks, so if I understand what your saying the reason I'm getting the column update issues is Dovecot is reading from and writing to the quota and quota_messages columns in my virtual_users table?

My database user I believe only has select permissions on that table.

So, I either need another table and to adjust my dovecot-dict.sql file for that table, that's where Dovecot will write to, or two more columns in the virtual_users table?

Which way do you recommend?

I would recommend to create a new table for dovecot_usage where dovecot is granted write permission.

Regards Daniel