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?