search for: select_field

...ct { quotadict = mysql:/etc/dovecot/dovecot-dict-quota.conf } plugin { quota = dict:storage=10240 proxy::quotadict } and my dovecot-dict-quota.conf looks like the following, again from the Wiki: connect = host=127.0.0.1 dbname=mail user=<user> password=<passwd> table = quota select_field = current where_field = path username_field = username and my MySQL table is as follows: create table quota ( username varchar(255) not null, path varchar(255) not null, current integer, primary key (username, path) ); Now with this setup, the query for looking up the current quot...

...-dict-quota.conf line 1: Unknown setting: driver dovecot: Sep 24 18:43:16 Error: dict: Failed to initialize dictionary 'quotadict' etc/dovecot/dovecot-dict-quota.conf driver = mysql connect = host=localhost dbname=postfix user=postfix password=... default_pass_scheme = PLAIN table = quota select_field = current where_field = path username_field = username worked with 1.1.3 -- Best Regards MfG Robert Schetterer Germany/Munich/Bavaria

...derstand storage and messages as default parameters foer all users so this shouldnt be needed plugin { quota = proxy::quotadict } but this dont work as i expected an i also have problems with /etc/dovecot/dovecot-dict-quota.conf connect = host=localhost dbname=mails user=mailuser table = quota select_field = current where_field = path username_field = username i still have this quota field allready in db postfix table mailbox where username = '%u' it seems this is an old style sql query so i tried this connect = host=localhost dbname=postfix user=postfixadmin pass..... dbname = postfix tab...

...lows : .. 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: connect = host=xxxxx dbname=xxxxx user=xxxxx password=xxxxx table = quota select_field = current where_field = path username_field = username ----- I can connect to the database thru mysql prompt. dovecot version 1.0 rc5 -- azhar -- -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://dovecot.org/pipermail/dovecot/attachments/20070227/fdcd235e/...

...n: quota: dict:storage=10240 proxy::quota acl: vfile:/etc/dovecot/acls sieve: /var/mail/sieve/%d/%n.sieve dict: quota: pgsql:/etc/dovecot/dovecot-dict-quota.conf My /etc/dovecot/dovecot-dict-quota.conf: connect = host=localhost dbname=mail user=mail password=dovecot-passwort table = quota select_field = current where_field = path username_field = username My database table: CREATE TABLE quota ( username character varying(255) NOT NULL, path character varying(100) NOT NULL, "current" integer, CONSTRAINT quota_pkey PRIMARY KEY (username, path) ) WITH (OIDS=FALSE); ALTER TABLE q...

Hello all! I tried to add the expire-plugin to my dovecot-installation (CentOS-RPM: dovecot-1.1.1-2_76.el5) and followed the plugin-page from the WIKI (http://wiki.dovecot.org/Plugins/Expire). Unfortunately I have problems with the dictionary: --> dovecot: Aug 05 13:30:25 Error: dict: Unknown dict module: db dovecot: Aug 05 13:30:25 Error: dict: Failed to initialize dictionary

...cot.conf : ## Dictionary server settings dict { quota = mysql:/etc/dovecot/dict-quota.conf } ## Plugin settings plugin { # quota = 10 Mo quota = dict:storage=10240 proxy::quota } My dict-quota.conf doesn't change : connect = host=localhost dbname=dovecot user=dovecot table = quota select_field = current where_field = path username_field = username My dovecot.info file : dovecot: 2006-07-23 15:07:01 Info: IMAP(test): Effective uid=1019, gid=1019 dovecot: 2006-07-23 15:07:01 Info: IMAP(test): Loading modules from directory: /usr/lib/dovecot/modules/imap dovecot: 2006-07-23 15:07:01 Inf...

...AND active = '1' # If using client certificates for authentication, comment the above and uncomment the following #password_query = SELECT null AS password, '%u' AS user mysql_virtual_alias_maps.cf: user = sqluser password = sqlpasswd hosts = 127.0.0.1 dbname = mail #table = alias #select_field = goto #where_field = address #additional_conditions = and active = '1' query = SELECT goto FROM alias WHERE address='%s' AND active = '1' # dovecot -n # 1.0.7: /etc/dovecot.conf protocols: imaps pop3s ssl_listen(default): *:993 ssl_listen(imap): *:993 ssl_listen(pop3): *:9...

...%d/%n') as userdb_home, concat('maildir:/var/vmail/%d/%n') as userdb_mail, 150 as userdb_uid, 8 as userdb_gid from qry_dovecot where user = '%u' ### # file dovecot-sql-quota-dict.conf connect = host=db01.int.example.net dbname=db_mail user=quota password==******** table = quota select_field = current where_field = path username_field = username (don't wonder about the different database hosts. mx01 is a readonly slave from db01)

...uota2_rule FROM pop3 AS p, kunden AS k WHERE k.kunde = p.kunde AND CONCAT(p.account, '@', p.kunde) = '%u' (quota-values in kilobytes) /etc/dovecot/dovecot-dict-quota.conf: > connect = host=localhost dbname=confixx user=confixx password=p4ssw0rd > table = dovecot_quota > select_field = current > where_field = path > username_field = username /etc/dovecot/dovecot-dict-quota2.conf: > connect = host=localhost dbname=confixx user=confixx password=p4ssw0rd > table = dovecot_quota_shared > select_field = current > where_field = path > username_field = username...

...plugin. According to the wiki, the expire plugin "keeps an internal database (Berkeley DB or SQL)". I was wondering what fields in the mysql table are needed for expire to work. I assume it is setup is similar to the quota dict setup, so was just wondering what fields are required (i.e: select_field, where_field, username_field, for quota). Thanks -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 189 bytes Desc: not available URL: <http://dovecot.org/pipermail/dovecot/attachments/20080329/101570f8/attachm...

> Am 02.02.2015 um 18:07 schrieb Juan Bernhard: >> Hello list. I'm thinking to migrate the hole user db from system users >> to mysql. I already did it in a test environment, but something is >> annoying my OCD... I don't quote the variables username and password >> sent to the mysql server. I know, the mysql user that dovecot uses only >> has select

...otadict') as quota FROM mailbox WHERE username = '%u' AND active = '1' ###################### and my dovecot-dict-quota.conf ###################### driver = mysql connect = host=localhost dbname=postfix user=postfix password=12345 default_pass_scheme = MD5-CRYPT table = quota select_field = current where_field = path username_field = username ###################### When i try to login i see the following in my log file Feb 2 21:46:57 beasty dovecot: imap-login: Login: user=<j.hendriks at testserver.com>, method=PLAIN, rip=127.0.0.1, lip= 127.0.0.1, secured Feb 2 21:46:57...

...supported... I don't understand... My config about dict : ==== dovecot.conf ==== ... plugin { quota = dict:storage=10240 mysql:/etc/dovecot/dict-quota.conf } ====================== And my dict-quota.conf file : ==== connect = host=localhost dbname=dovecot user=dovecot table = quota select_field = current where_field = path username_field = username ==== I have created a "dovecot" database and a "dovecot" mysql user with all access on this db. I have created a "quota" table too and add this entry in this table : *------*----------*---------* * path * user...

.../var/vmail/%d/%n' as home, 'maildir:/var/vmail/%d/%n' as mail, 150 AS uid, 12 AS gid, concat('dirsize:storage=',quota) AS quota FROM mailbox WHERE username ='%u' AND active ='1' postfix: user = mail password = xxxx hosts = localhost dbname = mail table = mailbox select_field = CONCAT(domain,'/',maildir) where_field = username additional_conditions = and active = '1'

...= '%n' AND domain = '%d' user_query = SELECT home, uid, gid FROM mail_view_tmp WHERE account = '%n' AND domain = '%d' or account = '%u' /etc/dovecot-dict-quota.conf connect = host=localhost dbname=ingoBase user=dovecot password=dovecot table = mail_quota select_field = current where_field = path username_field = username Is there something wrong in my configuration or is this a bug in the version i am using ? Thanks in advance ! Andreas

...ovecot-dict-sql.conf } dovecot-dict-sql.conf sample i took from postfixadmin docs provided with package, also changed table to quota2 as suggested for dovecot 2: driver = mysql connect = host=localhost dbname=postfix user=postfix password=postfixadmin default_pass_scheme = MD5-CRYPT table = quota2 select_field = current where_field = path username_field = username my sql.conf i took it from tutorial on your wiki : LDA postfix postfixadmin: driver = mysql connect = host=localhost dbname=postfix user=postfix password=postfixadmin user_query = SELECT concat('/home/vmail/', maildir) as home, conc...

...en i setup plugin quota by quota = dict: mysql:/etc/quota-dict.conf i get the folowing error: deliver(zzzz at zzzz.zz): Unknown dict module: mysql deliver(zzzz at zzz.zz): dict quota: dict_init() failed quota-dict.conf: connect = host=localhost dbname=zzzz user=zzzz password=zzzz table = mailbox select_field = quota where_field = maildir username_field = username dovecot.conf: # 1.0.2: /etc/dovecot//dovecot.conf base_dir: /var/run/dovecot/ protocols: imap pop3 imaps pop3s ssl_disable: yes disable_plaintext_auth: no shutdown_clients: no login_dir: /var/run/dovecot//login login_executable(default): /usr...

...-----+ 14 rows in set (0.03 sec) dovecot.conf: dict { quotadict = mysql:/usr/local/etc/dovecot/dovecot-dict-quota.conf } plugin { quota = dict:storage=10240 proxy::quotadict } dovecot-dict-quota.conf: connect = host=localhost dbname=postfix user=postfix password=******* table = quota select_field = current where_field = path username_field = username dovecot.log gives: Oct 02 23:25:49 Info: imap-login: Login: user=<user at domain.net>, method=plain, rip=88.211.149.123, lip=10.0.0.4, TLS Oct 02 23:25:49 Info: IMAP(user at domain.net): Effective uid=125, gid=125 Oct 02 23:25:49 Inf...

...ct:storage=1024000: proxy::quotadict } from dovecot-sql.conf: user_query = SELECT 225 as uid, 225 as gid, mailbox_path as home, mailbox_path as mail, 'dirsize:storage=10240:messages=1000' as quota FROM transports WHERE email = '%u' dict-quota.conf: connect = ... table = quota_used select_field = quota_used_kb where_field = quota_type username_field = username_and_realm in mysql: describe quota_used; +--------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+--------------+------+-----+--...