Hello, I got problem with setting quota from mysql for local users. In database are only information with quota. Password are store in passwd/shadow.
My database have only simple info like in wiki description. Table created with:
CREATE TABLE quota ( username varchar(100) not null, bytes bigint not null default 0, messages integer not null default 0, primary key (username) );
In dovecot.conf like in description is:
dict { quotadict = mysql:/etc/dovecot-dict-sql.conf }
plugin { # v1.2 + SQL: quota = dict:user::proxy::quotadict # v1.2 + file: quota = dict:user::file:%h/Maildir/dovecot-quota
quota_rule = *:storage=10M:messages=1000 }
File dovecot-dict-sql.conf has:
# v1.2+ only: connect = host=localhost dbname=mails user=sqluser password=sqlpass 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 }
With corrected values about databasename, user and password.
Where should to add information about sql query when autorization is not via myqsl (only shadow/password). There are in description info about additional file with user_query: dovecot-mysql.conf. Can anybody know how it should it look like and where to add it in config?