Displaying 20 results from an estimated 6000 matches similar to: "quota in SQL and static userdb"
2009 Nov 22
1
quota dict
Hello,
i'm using dict quota stored in mysql (/etc/dovecot/dovecot-dict-quota.conf):
connect = host=localhost dbname=vmail user=dovecot password=
# CREATE TABLE quota (
# username varchar(100) not null,
# bytes bigint not null default 0,
# messages integer not null default 0,
# primary key (username)
# );
map {
pattern = priv/quota/storage
table = quota
username_field =
2009 Nov 05
4
deliver_log_format ignored
Hello,
seems that LDA ignores deliver_log_format (still log with format:
"msgid=%m: %$")
# 1.2.6: /etc/dovecot/dovecot.conf
# OS: Linux 2.6.31 x86_64 Debian squeeze/sid xfs
log_path: /var/log/dovecot/error.log
info_log_path: /var/log/dovecot/info.log
log_timestamp: %Y-%m-%d %H:%M:%S
protocols: none
listen: none
disable_plaintext_auth: no
login_dir: /var/run/dovecot/login
2010 Jan 25
3
sieve or another vacation/autoreply
Hello,
i'm trying to do some delivery notification for each incoming address.
Problem is that sieve vacation has :days but minimum value is 1 eg
period in which addresses
are kept and are not responded to - but that is not that i want.
Is there other extension (in devel ???) or some other way (lda using
procmail or maildrop) how to implement my request ? (Before migration
we used qmail +
2013 Sep 08
2
Postfixadmin/MySQL/Dovecot 2 and quota
Hi all,
I'm setting up a new email server based on the softwares list below:
* Postfix
* Dovecot 2.0.9
* MySQL
* Postfixadmin 2.3.6
My current problem is I'm unsure whether quota feature is well
configured or not.
In order to test and validate, I use Roundcubemail GUI which provides
percentage of the space used by the mailbox (quota should be applied per
mailbox).
Here, my
2012 Oct 11
1
iterate_query does not use userdb - mail_location not found
Hi dovecot-comminity,
can't get iterate_query working. doveadm cannot find mail_location
which comes from userdb query. dovecot itself works fine with sql.
Whats wrong? please help:
[root at glen exim]# /opt/dovecot/bin/doveadm search -A mailbox Trash savedbefore 90d
doveadm(uwe at mitmachnet.de): Error: user uwe at mitmachnet.de: Initialization failed:
2010 Feb 12
2
sieve vacation
Hello,
scenario:
OK 1. created vacation script (see below)
OK 2. send message from user at anotherdomain.tld to user at domain.tld =>
got auto vacation response (2010-02-11T19:42:13)
OK 3. send message from user at anotherdomain.tld to user at domain.tld =>
no response (is ok because ":days 1" settings) (2010-02-11T19:47:46)
BAD 4. send message from anotheruser at
2017 Sep 11
1
Per-user quota (passwd)
Hi.
But there is one problem...
protocol lda {
mail_plugins = " quota autocreate sieve quota"
plugin {
quota = dict:user::file:/var/vmail/glu_vrem/%u/.quotausage
}
}
protocol imap {
mail_plugins = " quota autocreate autocreate imap_quota"
plugin {
autocreate = INBOX
autocreate2 = Sent
autocreate3 = Trash
autocreate4 = Drafts
autocreate5 =
2011 Jun 02
2
Custom sql query for keeping quota with dict-sql
Hello!
I'd like to setup quota for for virtualusers, i'm using both maildir++
and mdbox as storage, and i'm using postgresql to keep users.
I'm keeping all users data in one table:
[...]
login text NOT NULL,
domain text,
password text,
quota_mb integer NOT NULL DEFAULT 0
[... other columns ...]
i'd like to keep present quota in such two columns:
quota_dict_bytes integer NOT
2017 Jun 29
2
Per-user quota (passwd)
Oh you have multiple db's, I missed that.
Remove auth_username_format, and instead
userdb {
args = /etc/imap.passwd username_format=%Ln
driver = passwd-file
override_fields = home=/var/vmail/glu_vrem/%u
}
On 29.06.2017 14:35, Evgeniy Korneechev wrote:
> with auth_username_format = %Ln:
>
> Jun 28 14:43:41 auth: Debug: master in: USER 1 iivanov.ia at example.com
2011 Jun 24
2
Please help with Quota dict mysql configuration
Hello
So what i have:
centos 5.6
postfix 2.3.3
dovecot 2.0.13
postfixadmin 2.3.3
roundcube 0.5.3
All general things are working right now i can send receive email with
ssl connections etc...
Now i'm trying to configure additional options like quota and some
other plugins like sieve, trash, expire and deleted-to-trash.
Configuration of quota is on first place. I have read wiki regarding
quota
2017 Sep 12
1
dovecot Digest, Vol 173, Issue 28 (INTERNAL)
Hi,
It is quite easy.
I use a client (thunderbird or windows live mail) set it up to use starttls on standard port 110. Logon and just do a list on the mailbox. The fatal error occurred when I logoff.
Arvid
-----Original Message-----
From: dovecot [mailto:dovecot-bounces at dovecot.org] On Behalf Of dovecot-request at dovecot.org
Sent: 11. september 2017 14:57
To: dovecot at dovecot.org
2008 Apr 08
5
temporary disable account
Hello,
is there some way how to disable temporarily account or access to
files. I need to backup with tar, but there is problem when tar is
reading and some file changed (with --ignore-failed-read it continues
but archive is not created and without --ignore-failed-read it fails).
Some accounts are huge ;( Need something like qmail sticky bit or
world writable directory - qmail is not delivering
2009 Nov 06
1
scenario with one lda and 4 imapds/pop3ds
Hello,
i want to create following scenario:
one dovecot using ONLY LDA (using sql )
# 1.2.6: /etc/dovecot/dovecot.conf
# OS: Linux 2.6.31 x86_64 Debian squeeze/sid xfs
log_path: /var/log/dovecot/error.log
info_log_path: /var/log/dovecot/info.log
log_timestamp: %FT%T%z
protocols: none
listen: none
disable_plaintext_auth: no
login_dir: /var/run/dovecot/login
login_executable:
2017 Feb 01
2
Dovecot auth-worker error after cram-md5 auth
This is debug log files in syslog:
Feb 1 07:10:25 vps342401 dovecot: auth: Debug: client passdb out:
CONT#0112#011PDAxODg3ODIzMTUwMzgxNzMuMTQ4NTkyOTQyNUB2cHMzNDI0MDEub3ZoLm5ldD4=
Feb 1 07:10:26 vps342401 dovecot: auth: Debug: client in: CONT<hidden>
Feb 1 07:10:26 vps342401 dovecot: auth-worker(27069): Debug: sql(
do_not_reply at example.com,12.173.211.32): query: SELECT email as user,
2014 Oct 12
2
Dovecot domain quota
I have dovecot version 2.1.7 and I have quota configured as:
-----------------------------------
dict {
quota_domain = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext
}
mail_plugins = quota
protocol imap {
mail_plugins = quota quota imap_quota
}
plugin {
quota = dict:domain:%d:proxy::quota_domain
quota_rule = *:storage=1M
quota_rule2 = Trash:storage=+100M
}
2008 Feb 26
3
multiple ip and ssl
Hello,
is possible in some way use on each ip address different certificate
(for imap, for pop3). There are options like (but that is not enough
for me):
protocol imap {
listen = *:10143
ssl_listen = *:10943
..
}
protocol pop3 {
listen = *:10100
..
}
I have server for 4 domains (each has own ip address), so i need bind
one ip address to one domain to one certificate(each certificate
2017 Sep 12
1
dovecot Digest, Vol 173, Issue 28 (INTERNAL)
Hi,
I enabled rawlog.
Everything seems to be OK but the dovecot-log shows a fatal error and core dump. (created a core file)
Arvid
Rawlog in
<<<
STAT
>>>
<<<
LIST
>>>
<<<
UIDL 1
>>>
<<<
UIDL
>>>
<<<
QUIT
>>>
Rawlog out
<<<
+OK Logged in.
>>>
<<<
+OK 22 17589388
2010 Sep 21
1
Quota value *not* getting over written by ldap attr value, help ?
Hi,
I am having trouble with the quota plugin with deliver. In the auth logs, I
see that dovecot is able to get the attribute value just fine:
***
Sep 21 17:49:30 dawnone dovecot: auth(default): ldap(cot,127.0.0.1): result:
uid(user)=cot uidNumber(userdb_uid)=1011 gidNumber(userdb_gid)=1011
homeDirectory(userdb_home)=/home/cot
mailQuotaSize(userdb_quota_rule=*:bytes=%$)=*:bytes=1000000
***
But
2010 Mar 11
3
IMAP proxy configuration
i know dovecot can act as IMAP and POP3 proxy ..... but i'm having
a hard time configuring it. Actually i'm using a simple dovecot
configuration with virtual users stored on MySQL. My dovecot-sql.conf is
pretty simple:
[root at correio dovecot]# cat dovecot-sql.conf
driver = mysql
connect = host=localhost dbname=DATABASE user=USERNAME password=PASSWORD
default_pass_scheme = PLAIN
#
2017 Feb 01
2
Dovecot auth-worker error after cram-md5 auth
I always restart dovecot after change config. ;) Sure, I commented out
added two lines by me, restarted dovecot and here it is:
# 2.2.9: /etc/dovecot/dovecot.conf
# OS: Linux 3.13.0-100-generic x86_64 Ubuntu 14.04.5 LTS
auth_mechanisms = plain login cram-md5
listen = *,[::]
log_timestamp = "%Y-%m-%d %H:%M:%S "
mail_max_userip_connections = 100
mail_plugins = " quota"