similar to: MySQL table for use with dict et quota

currently dovecot dict is CREATE TABLE IF NOT EXISTS `quota` ( `username` varchar(100) COLLATE latin1_general_ci NOT NULL, `bytes` bigint(20) NOT NULL DEFAULT '0', `messages` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`username`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; there is not field that says how much quota each user have, so one cant

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'm having trouble getting the quota plugin to work with deliver. The quota in the database is not getting set. I am using dovecot-1.0-rc15. This server is not yet in production. Some values below are because I'm trying to test with the simplest possible case, and some because it's reading from a different database. Also, I noticed that "dovecot -n" doesn't display any

Hi! I have a question about the dictionary quota :storage and :messages values in MySql quota table. How to interpret the following values? Why some values are negative? Are the values relative to something? I would like to write a simple php application to check the user quota but I don't know how to interpret this: mysql> select * from quota;

Hello, I'm running dovecot 2.2 and wanting to get quotas going. I've got the plugins loaded appropriately and am wanting to configure a dictionary backend to talk to my mysql database. I've got a single database called mail which has all the mail-related items in it. One table is for virtual users which postfix uses. It looks like this: CREATE TABLE `virtual_users` ( `id` int(11)

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 all : mysql mailbox below : CREATE TABLE `mailbox` ( `username` varchar(255) NOT NULL DEFAULT '', `uid` varchar(255) NOT NULL DEFAULT '', `password` varchar(255) NOT NULL DEFAULT '', `clearpwd` varchar(128) NOT NULL DEFAULT '', `name` varchar(255) NOT NULL DEFAULT '', `mailhost` varchar(255) NOT NULL DEFAULT '', `maildir`

Hello, I've had a look through past messages and I think this has been brought up but I'm not sure what the outcome of it was. I'm trying to use quotas with a MySQL dict backend. I am using Dovecot version 1.0.rc6-1 from the Debian Testing package on a x86 machine. My dovecot.conf file has the following entries which I took from the Wiki: dict { quotadict =

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

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 }

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

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'

dict quota is known to have this problem that it is not always updated on time. You should use quota count with quota_clone plugin instead (might require upgrade). Please remember to change password for mysql user pfadmin, as you accidentically sent it to the list. Aki > On 15 November 2018 at 20:52 SUnsin at gv-bayern.de wrote: > > > > > Hi, > > I have a working

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I have ACL-dict-postgres trouble again. Eventually a session does not update the ACL dictionary no longer. I execute (for testing) this script: for a in $(seq 1 ${1-4}); do echo 3-$a deleteAcl Junk dvtest1 sleep 30 echo 3-$a SetAcl Junk dvtest1 kxilrsc sleep 30

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

Hello again :), I try to use dictionary proxy server to replace my precedent configuration (direct use of dict in plugin quota). Before, i have this configuration in my dovecot.conf : ## Dictionary server settings dict { } ## Plugin settings plugin { # quota = 10 Mo quota = dict:storage=10240 mysql:/etc/dovecot/dict-quota.conf } And after, to use proxy, I have this configuration in my

It should work, I have to check why it's not working. Aki On 16.11.2018 11.47, SUnsin at gv-bayern.de wrote: > With quota count and quota_clone it works, but can I use noenforcing > with quota count? > > quota = count:User quota:noenforcing > > When I test this config, I receive no quota-warning E-Mail: > > service quota-warning { > ? executable = script

Hi List, I of present dovecot 1.1.10 use it, and test dict quota backend and mysql. However, I am troubled so that it is IMAP4, and behavior when mysql fell is different from POP3. I become the error in Copy of Mail in IMAP4, but do not become the error in DELE of the POP3. Therefore I think that contradiction happens in database and real storage when mysql fell. I want an error to do it at the

Hello, I'm running Dovecot on a FreeBSD system with Postfix in a virtual user setup, with Mysql. I am trying to understand the quota configuration. I've got a Mysql database with an accounts table with a quota field. I've also got two other tables one quota (currently has nothing in it an empty set), and quota2 messages and bytes which has one entry. My goal is to have different

Hello, I would like to ask for advice on the following things: I have sieve scripts stored in mysql, work for LDA and imapd correctly. When I try to connect using the client managesieve (Roungcube plugin managesieve with Thunderbird addon sieve), i receive the following error: Oct 3 19:04:50 mail dovecot: managesieve(11044167): Debug: sieve: include: sieve_global_dir is not set; it is