similar to: Error: read(/var/run/dovecot/dict-server) failed: Remote disconnected

Dear all, Is it possible to perform dict lookups with a SQL backend, without specifying the username_field in the SQL query? I am using the dict to retrieve a Sieve script. My dict configuration looks like this: map { pattern = priv/sieve/data/$id table = sieve_scripts username_field = email value_field = data fields { id = $id } } I don't want to specify the username

Keywords: dovecot, dict, quota, postgre sql, broken pipe, remote disconnected Having Dovecot 2.2.22 (fe789d2) with Postgre SQL 9.5 (9.5.5-0ubuntu0.16.04) as the backend. I do not understand why quota service is not working, not seeing it as a configuration error at least. My quotas are DICT/SQL based. OS: Ubuntu 16.0.4.1 32-bit (Linux XXX 4.4.0-59-generic #80-Ubuntu SMP Fri Jan 6 17:36:54

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 =

Op 4/28/2017 om 10:58 AM schreef Alessio Cecchi: > Hi, > > I have setup the latest Dovecot and Sieve with dict in order to read > rules from MySQL and works fine: > > sieve_before = dict:proxy::sieve;name=activesql;bindir=~/.sieve-bin > > dict { > sieve = mysql:/etc/dovecot/dovecot-dict-sieve-sql.conf.ext > } > > # cat

Hello, While experimenting with the sqlite backend, I noticed a big vacuum wrt its use for a quota dict. This is thus an opportunity to share a solution I managed to devise after some trials and errors and a (very quick and unscientific) look at the code. And also the opportunity to ask the community to check for possible flaws. Yes, nothing comes for free... ;-) TIA, Axel This is the SQL

Hi, I have setup the latest Dovecot and Sieve with dict in order to read rules from MySQL and works fine: sieve_before = dict:proxy::sieve;name=activesql;bindir=~/.sieve-bin dict { sieve = mysql:/etc/dovecot/dovecot-dict-sieve-sql.conf.ext } # cat /etc/dovecot/dovecot-dict-sieve-sql.conf.ext connect = host=10.1.1.1 dbname=dovecot user=dovecot password=Ciao map { pattern =

Testing using the mysql dict for quota storage (dovecot-2.0.12-2_127.el5), and ran into a couple issues. First is a permissions issue: dovecot: lmtp(26786, dude at test.tld): Error: net_connect_unix(/var/run/dovecot/dict) failed: Permission denied (euid=5000(<unknown>) egid=5000(<unknown>) missing +r perm: /var/run/dovecot/dict, euid is not dir owner) The file

Hi, I want to write a plugin that uses JavaScript and I am wondering how to put the static content, i.e. the JavaScript, in place? I read the documentation I found ( http://wiki.rubyonrails.org/rails/pages/Plugins and links) and looked at the listed plugins. One thing I found was that subversion seems to be a prerequisite for providing or even installing plugins. Is that right? The other thing

Hi Timo, quota dict seems to be broken with 1.2.alpha1 MAP(robert at schetterer.com): read(/var/run/dovecot/dict-server) failed: Remote disconnected dovecot: Sep 24 18:43:16 Error: dict: Error in configuration file /etc/dovecot/dovecot-dict-quota.conf line 1: Unknown setting: driver dovecot: Sep 24 18:43:16 Error: dict: Failed to initialize dictionary 'quotadict'

Hello list, perhaps someone can guide me, finding out what's going wrong in the following scenario (Active Directory , Samba 3.0.20b same with 3.0.28a): CHILD1.CONTOSO.COM <-trusts-> CONTOSO.COM <-trusts->CHILD2.CONTOSO.COM | | | User: CHILD1\testtest | Samba

Hi, I wanted to migrate a mailserver from cyrus to dovecot. The new setup was using postfixadmin let the domain admins configure the hostet domains. To view the used quota in postfixadmin the usage of the quota dict backend is required. I have configured it according to the wiki but everytime I connect I get a sucessfully login and then every next command hangs. It seems to me, that the dict

when I enabled quota plugin the following error occured : net_connect_unix(/usr/local/var/run/dovecot/dict-server) failed: Permission denied Any ideas? My config are as follows : .. dict { #quota = mysql:/etc/dovecot-dict-quota.conf quotadict = mysql:/usr/local/etc/dovecot-dict-quota.conf } .. quota = dict:storage=81920:messages=5000 proxy::quotadict /usr/local/etc/dovecot-dict-quota.conf:

Hello all, I'm sure this has been covered somewhere before, but my googlefu is not up to the challenge. Basically, I'm trying to configure quota plugin to use a dictionary service (specifically proxy with mysql) so that I can store the quota usage in a database and use that information in a lookup for postfix to reject mail if over quota. I'm doing this because postfix+avamis+dovecot

I've been mucking about, experimenting with the expire plugin and using a dictionary. I've got the iteration query working when I do a normal expunge using: doveadm expunge -A mailbox "INBOX.Trash" savedbefore 1w and expunging works as expected. However, I've got over 12,000 accounts on this server, so I was hoping using the expire plugin to could help out. I've

Thanks for your answer, Timo! :) I send to you my configoration for reproducing. Please, follow the link, because configuration is a very big, there will be more easy to read and understand My configuration Dovecot 2.2.19 <http://www.heypasteit.com/clip/28CW> Below the same my configuration Dovecot 2.2.19 here. BEGIN of configuration --------------------- # doveconf -n # 2.2.19:

Hi all, I've run into an issue with in-place mailbox format conversions between mdbox and maildir and wondered if someone could assist. When using dsync to convert a mailbox, the conversion loses a mailbox GUID and produces a warning. This behavior seems to have been introduced between version 2.2.31 and 2.2.32. See below for the full debug output from both versions followed by the dovecot

Hello, I try to use dict for quota... But it's impossible :) I have this error message : === dovecot.err === dovecot: 2006-07-23 03:00:47 Error: IMAP(myuser): Unknown dict module: mysql =================== But, mysql is supported... I don't understand... My config about dict : ==== dovecot.conf ==== ... plugin { quota = dict:storage=10240 mysql:/etc/dovecot/dict-quota.conf }

Hello all I am trying to get quota working with dict and mysql but i get an error. This is my dovecot.conf file ( relevant part ) i hope ;-) ###################### protocol imap { listen = *:143 imap_client_workarounds = delay-newmail outlook-idle netscape-eoh tb-extra-mailbox-sep imap_max_line_length = 65536 mail_plugins = quota imap_quota } protocol pop3 { listen = *:110

I am trying setting up at virtual domain with quota using postfix and dovecut. But I can't get the quota to work, every time I try sending a mail the following queries is run on the database. SELECT home, uid, gid FROM mail_view_tmp WHERE account = 'dummy' AND domain = 'example.com' SELECT current FROM mail_quota WHERE path = 'quota/storage' AND username =

Hi there! I get a lot of errormessages. My dovecot is: dovecot-core 2:2.3.2.1-1~stretch from Debian stable. I found this: https://www.dovecot.org/list/dovecot/2013-July/091648.html So the bug came back... The Log is attached Thanks Jakob -------------- next part -------------- Sep 11 19:18:37 mymail dovecot[29916]: