search for: username_field

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 though, as t...

...ing at migrating all the user mail from the old server to the new and building a new sql database.? All I see is: dovecot-dict-sql.conf.ext: connect = host=/var/lib/mysql/mysql.sock dbname=postfix user=postfix password=$Postfix_Database_Password map { pattern = priv/quota/storage table = quota2 username_field = username value_field = bytes } map { pattern = priv/quota/messages table = quota2 username_field = username value_field = messages } what is actually done with this table? thanks -------------- next part -------------- An HTML attachment was scrubbed... URL: <https://dovecot.org/pipe...

...l;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 = priv/sieve/name/$script_name table = user_sieve_scripts username_field = username value_field = id fields { script_name = $script_name } } map { pattern = priv/sieve/data/$id table = user_sieve_scripts username_field = username value_field = script_data fields { id = $id } } But when I update the rules in...

...he old >> server to the new and building a new sql database.? All I see is: >> >> dovecot-dict-sql.conf.ext: connect = host=/var/lib/mysql/mysql.sock >> dbname=postfix user=postfix password=$Postfix_Database_Password map { >> pattern = priv/quota/storage table = quota2 username_field = username >> value_field = bytes } map { pattern = priv/quota/messages table = quota2 >> username_field = username value_field = messages } >> >> >> what is actually done with this table? >> >> thanks >> >> >> >> >> > dict-...

...uota-domain.conf } plugin { quota = dict:user::proxy::quotadict quota2 = dict:domain:%d:proxy::quota_domain } and the dovecot-quota-domain.conf looks like this : connect = host=xxx dbname=xxx user=xxxx password=xxxx map { pattern = priv/quota/storage table = domain_quota username_field = domain value_field = used_quota } map { pattern = priv/quota/messages table = domain_quota username_field = domain value_field = messages } The problem is that the dictionary table gets updated only with the first mailbox informations (quota and messages for the first mailbox...

...ta.conf (tried to do with with a single SED, but it was getting messy) finally: cat <<EOF>/etc/dovecot/dovecot-dict-sql.conf.ext || exit 1 connect = host=localhost dbname=postfix user=postfix password=$Postfix_Database_Password map { pattern = priv/quota/storage table = quota2 username_field = username value_field = bytes } map { pattern = priv/quota/messages table = quota2 username_field = username value_field = messages } EOF Please let me know if I missed something here. Thanks On 03/17/2017 09:08 AM, Robert Moskowitz wrote: > Just to level-set, I am using Cento...

...mysql database. To access those quotas for dovecot, I have the following script: cat <<EOF>/etc/dovecot/dovecot-dict-quota.conf || exit 1 connect = host=localhost dbname=postfix user=postfix password=$Postfix_Database_Password map { pattern = priv/quota/storage table = quota2 username_field = username value_field = bytes } map { pattern = priv/quota/messages table = quota2 username_field = username value_field = messages } EOF Where $Postfix_Database_Password is an env variable in my install howto. I am setting up quota plugins as follows: sed -i "/#mail_plugins...

Hello all, I have a problem with my mail configuration and I don`t know how to resolve this error (listed bellow): deliver(mymail at testtest.ro): Nov 11 09:07:54 Error: Internal quota calculation error dovecot: Nov 11 09:07:54 Error: dict: /etc/dovecot/dovecot-dict-quota.conf: 'username_field' missing dovecot: Nov 11 09:07:54 Error: dict: Failed to initialize dictionary 'quota1' deliver(mymail at testtest.ro): Nov 11 09:07:54 Error: read(/var/run/dovecot/dict-server) failed: Remote disconnected deliver(mymail at testtest.ro): Nov 11 09:07:54 Error: Internal quota calculation...

...ve" } protocol imap { mail_plugins = " quota imap_quota" } ################ root at postfix:/etc/dovecot# cat dovecot-dict-sql-domain.conf |grep -v "#" connect = host=XXXXX dbname=mail user=test password=test map { pattern = priv/quota/storage table = domains username_field = domain value_field = quota } map { pattern = priv/quota/messages table = domains username_field = domain value_field = quota_messages } map { pattern = shared/expire/$user/$mailbox table = expires value_field = expire_stamp fields { username = $user mailbox...

...obably something simple but apparantly i'm failing to see it :) Hope someone can help. ------------- dovecot --version 2.3.2.1 (0719df592) cat dovecot-quota-clone-sql.conf.ext connect = **** map { pattern = priv/quota/storage table = virtual_users value_field = usage_in_bytes username_field = email } map { pattern = priv/quota/messages table = virtual_users value_field = messages username_field = email } # 2.3.2.1 (0719df592): /etc/dovecot/dovecot.conf # OS: Linux 3.10.0-862.11.6.el7.x86_64 x86_64 CentOS Linux release 7.5.1804 (Core) nfs4 # Hostname: imap01.ltmail.dk au...

...39;, quota) as quota_rule FROM mailbox WHERE username = '%u' AND active = '1' and dovecot-dict-sql.conf.ext: connect = host=/var/lib/mysql/mysql.sock dbname=postfix user=postfix password=$Postfix_Database_Password map { ??? pattern = priv/quota/storage ??? table = quota2 ??? username_field = username ??? value_field = bytes } map { ??? pattern = priv/quota/messages ??? table = quota2 ??? username_field = username ??? value_field = messages } thanks

...========= #driver = mysql connect = "host=/var/lib/mysql/mysql.sock user=<user> password=<pass> dbname=<db>" # User's private keys map { pattern = priv/$mailboxid/vendor/vendor.dovecot/pvt/crypt/privkeys/$digest table = virtual_users_cryptokeys_priv_dict username_field = email value_field = key_contents fields { mailbox_id = $mailboxid key_digest = $digest } } map { pattern = priv/$mailboxid/vendor/vendor.dovecot/pvt/server/vendor/vendor.dovecot/pvt/crypt/privkeys/$digest table = virtual_users_cryptokeys_priv_server_dict username_fi...

...uld be applied per mailbox). Here, my dovecot configuration: dovecot.conf: dict { quotadict = mysql:/etc/dovecot/dovecot-dict-quota.conf } dovecot-dict-quota.conf: connect = host=localhost dbname=postfix user=postfix password=postfix map { pattern = priv/quota/storage table = quota2 username_field = username value_field = bytes } map { pattern = priv/quota/messages table = quota2 username_field = username value_field = messages } dovecot-sql.conf.ext: driver = mysql connect = host=localhost dbname=postfix user=postfix password=postfix default_pass_scheme = PLAIN-MD5 pass...

...quota } plugin { quota = dict:domain:%d:proxy::quota_domain quota_rule = *:storage=1M quota_rule2 = Trash:storage=+100M } ----------------------------------- /etc/dovecot/dovecot-dict-sql.conf.ext: ----------------------------------- map { pattern = priv/quota/storage table = quota_dict username_field = domain value_field = bytes } map { pattern = priv/quota/messages table = quota_dict username_field = domain value_field = messages } map { pattern = shared/expire/$user/$mailbox table = expires value_field = expire_stamp fields { username = $user mailbox = $mailbox } }...

...vecot-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 quota appears in the MySQL logs as: SELECT curr...

...dovecot-LDA (apart from the exim configuration, which is explained quite clearly in wiki)? 2. Autocreation of mail folders Is it possible somehow to automatically create folders (like Trash, Sent-mail etc.)? 3. quota and its dict file. map { pattern = priv/quota/storage table = popbox username_field = username value_field = bytes } map { pattern = priv/quota/messages table = quota username_field = username value_field = messages } First - what is the "username_field" here? I'm running multiple domains, so will it be just username at domain? And - if so - is it pos...

...029 | 1111 | +---------------------------+-----------+----------+ The record for john at domain.com finaly reaches the quota limit - and even removing all emails does not help. My /etc/dovecot/dovecot-dict-quota.conf looks like this: map { pattern = priv/quota/storage table = quota username_field = username value_field = bytes } map { pattern = priv/quota/messages table = quota username_field = username value_field = messages } And my question is: what is used as "username"? Always the username given wher user logs in? Is there a way to provide some dictionary to...

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

...onf 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, concat('maildir:/home/vmail/', maildir)...

...service quota-status { client_limit = 1 executable = quota-status -p postfix inet_listener { port = 10024 } } userdb { args = /etc/dovecot/dovecot-sql.conf driver = sql } /etc/dovecot/dovecot-dict-sql-user.conf connect = ... map { pattern = priv/quota/storage table = quota username_field = username value_field = bytes } map { pattern = priv/quota/messages table = quota username_field = username value_field = messages } /etc/dovecot/dovecot-dict-sql-domain.conf connect = map { pattern = priv/quota/storage table = quota_domain username_field = domain value_field...