templates/default/dovecot-dict-sql.conf.ext.erb
# Generated by Chef
# This file is commonly accessed via dict {} section in dovecot.conf
<% unless @conf['dict_sql']['connect'].nil? -%>
connect = <%= DovecotCookbook::Conf.value(@conf['dict_sql']['connect']) %>
<% else -%>
#connect = host=localhost dbname=mails user=testuser password=pass
<% end -%>
# CREATE TABLE quota (
# username varchar(100) not null,
# bytes bigint not null default 0,
# messages integer not null default 0,
# primary key (username)
# );
<% if @conf['dict_sql']['maps'].kind_of?(Array) -%>
<% @conf['dict_sql']['maps'].each do |map| -%>
<%= DovecotCookbook::Conf.map(map) %>
<% end -%>
<% else -%>
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
}
# CREATE TABLE expires (
# username varchar(100) not null,
# mailbox varchar(255) not null,
# expire_stamp integer not null,
# primary key (username, mailbox)
# );
map {
pattern = shared/expire/$user/$mailbox
table = expires
value_field = expire_stamp
fields {
username = $user
mailbox = $mailbox
}
}
<% end -%>