similar to: feature request: pipe for custom quota dict queries

I have a question about using dict and quotas. I want dovecot to send quota queries to a custom dict server over a socket. I'm doing this because I can't do group quotas based on domain since a customer can have each of their users associated with different domains under a single account. I need to lookup the account ID and group based on that. I'm worried putting everything in mysql

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Sun, 5 Feb 2017, ygrishin-lists at mail2.ca wrote: > service dict { > unix_listener dict { > mode = 0660 > user = Debian-exim > group = Debian-exim > } > } > > dovecot-lda-erros.log: > ********************** > Feb 04 14:23:33 lda(testuser at XXX): Error: read(/var/run/dovecot/dict) failed: > Remote

Solved the problem, reporting back to the community. /etc/dovecot/dovecot-dict-sql-user.conf had been lacking dovecot group permissions. It was 700/root:root. However why it wasn't reported by Dovecot explicitly in the log -- the greatest mystery to me. Now, after deleting dovecot and all its packages via 'apt' and installing afresh makes "lacking permissions for the

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'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

Hello everyone, I've been working with the quota plugin, attempting to use the dict backend. It seems the sql dict class is not getting loaded. I dropped a couple lines in dict_class_lookup(dict.c) and it seems the only class that gets loaded is "proxy". Any idea how to get the sql driver to load in the quota/dict module? My authentication goes through the sql module and is working

Version: Dovecot 2.0rc3 Hi, I try to get the quota-warning.sh script working with quota/dict but I get some errors. The script looks like: #!/bin/sh PERCENT=$1 USER=$2 cat << EOF | /usr/lib/dovecot/dovecot-lda -d $USER -o "plugin/quota=dict:user::proxy::quota quota:noenforcing" From: quota at dlutt.de Subject: quota warning Your mailbox is now $PERCENT% full. EOF In 90-quota

Hi, I have created my own dict server (proxy:[<dict path>]:<destination dict>) to access a proprietary database. The dict server basically creates a listing socket on a separate thread and then waits for incoming requests with accept(handle, NULL, 0). When a request comes in (i.e., when accept returns the accepted socket fd), the request is handed over to a handler thread (from a

Since an upgrade to 2.0.1 from 1.2.x we're seeing this on (mostly) large mailboxes (Maildir) Sep 4 11:27:25 dovecot: dict: mysql: Connected to 192.168.dd.dd (accounts) ... Sep 4 11:27:46 kelly-a dovecot: lda(u1 at example.com):): msgid=<123 at xxx>: saved mail to INBOX Sep 4 11:27:47 dovecot: dict: Error: sql dict: commit failed: Not connected to database Sep 4 11:27:47 dovecot:

Hi! I'm trying to set up SQL based dict quota. The quota is working, gets updated but I had to configure really loose file permission to make it work: dovecot.conf: dict { quota = pgsql:/etc/dovecot/dovecot_dict-sql.conf } service dict { unix_listener dict { mode = 0660 group = vmail # sidenote: I noticed that writing the number equivalent # of 'vmail' here does not work.

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

Hi Actually I use quota. But I would like to use dict quota car with dict quota it is possible to view the used quota. But I do not understand the configuration off dict quota. if the quota is stored in mysql wich do I have to specify quota values in plugin section as chown in the dovecot web site? exemples: dict { quotadict = mysql:/etc/dovecot-dict-quota.conf } plugin { # v1.0: 10MB and

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'

Hi I have a mixed configuration for MAILDIR und MBOX accounts LDA is exim. For maildir exim writes a maildirsize file and I can see the IMAP contingent in my mailclient. But I can't find a solution for mbox. I tried dict with mysql, db, and pgsql - but notihing works for me. - db: a file is written but it seems to be empty: 1013 [mail] =db_dump-4.6 -p quota.db VERSION=3

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, 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 =

Hi, I'm trying to set Dovecot 2.0 with postgresql dict. It's kind of working but not as I'd like to. Dovecot expects to get a dedicated table for quota management. When I've run *doveadm quota recalc -A* I've noticed in the logs that Dovecot tries to run DELETE statements. Fortunately it didn't succeed as I've only given it SELECT and UPDATE permissions on the fields

Dear everyone, I am trying to get my Email set-up to work, and wonder if someone would shed some light onto this? Best regards, J. ------------------------------------------------------------------ Set-up is : postfix -> dovecot LDA -> mysql <- postfixadmin What works: postfix delivers to dovecot. postfixadmin is configured, and have created one domain test.info. What is

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

Hi, I have enabled quota dict with mysql following wiki http://wiki2.dovecot.org/Quota/Dict Everything work as expected. I just have a question about query used for updating quota usage. I already check the source file dict-sql.c but i still can't figure it out. I store user info in a mysql table where only left (user) part of an email address is stored with foreign id for domain conected