search for: iterate_query

..."ls /var/mail" would be a list of domains. But I keep seeing empty mailboxes being created at this level. Having corrected a few other errors I *hope* I've found the last one - but if I'm right I believe the docs need updating: The examples given for SQL userdb's include: iterate_query = SELECT userid AS username, domain FROM users So this means the username is returned for *both* the username and domain. Even if I'm wrong as to the cause of my own troubles this can't be right. It just can't. Or am I mistaken? So, given that the complete address is used as the use...

Hi dovecot-comminity, can't get iterate_query working. doveadm cannot find mail_location which comes from userdb query. dovecot itself works fine with sql. Whats wrong? please help: [root at glen exim]# /opt/dovecot/bin/doveadm search -A mailbox Trash savedbefore 90d doveadm(uwe at mitmachnet.de): Error: user uwe at mitmachnet.de: Initializa...

...password ------------------+-------------+------------------------------------------------------------------------------------------------------- hile at coyhile.com | coyhile.com | [REDACTED] (1 row) Naively, I?d expect something this to work for the iteration query: iterate_query = SELECT username, domain FROM users But, when I do that, I end up doveadm backup -D -A -R -f ssh -i id_rsa.dsync imap01.coyhile.com /opt/local/bin/doveadm dsync-server -A doveadm(hile at coyhile.com@coyhile.com): Info: User no longer exists, skipping [root at 81716ec5-bca4-6d53-ed81-bd1a55d46b...

Hi, Going by the "static userdb" example? on this page (https://wiki.dovecot.org/VirtualUsers#homedirs), tried to achieve a similar setup in conjunction with pgsql for passdb. However I get an error "auth: Warning: sql: Ignoring changed iterate_query in /etc/dovecot/local_sql_users.conf, because userdb sql not used. (If this is intentional, set userdb_warning_disable=yes)" Does this mean the following is not a valid config ? Or at least I will not be able to achieve iteration ? mail_location = maildir:/foobar/mail/%d/%n/Maildir passdb {...

Hi, I have got iterate_query defined in dovecot-sql.conf.ext. However when I run a command like: doveadm search -A BEFORE 10d I receive an error message (Failed to iterate ...) There is an error message in a log file too: Error: Trying to iterate users, but userdbs don't support it The problem is that monitoring a datab...

In the shell: ,doveadm(root): Error: User listing returned failure,doveadm: Error: Failed to iterate through some users In the log: dovecot: auth: Error: sql: Iterate query failed: Table 'mail.users' doesn't exist (using built-in default iterate_query: SELECT username, domain FROM users) Why is dovecot trying to "select username, domain from users" when the "service auth" is setup to "select homedir, maildir, sieve_dir, from MAILBOXES.... the same with the password query except for selecting password from mail.mailb...

...-+-------------+------------------------------------------------------------------------------------------------------- >> hile at coyhile.com | coyhile.com | [REDACTED] >> (1 row) >> >> Naively, I?d expect something this to work for the iteration query: >> >> iterate_query = SELECT username, domain FROM users >> >> >> But, when I do that, I end up >> >> doveadm backup -D -A -R -f ssh -i id_rsa.dsync imap01.coyhile.com /opt/local/bin/doveadm dsync-server -A >> doveadm(hile at coyhile.com@coyhile.com): Info: User no longer exists...

...> ------------------+-------------+------------------------------------------------------------------------------------------------------- > hile at coyhile.com | coyhile.com | [REDACTED] > (1 row) > > Naively, I?d expect something this to work for the iteration query: > > iterate_query = SELECT username, domain FROM users > > > But, when I do that, I end up > > doveadm backup -D -A -R -f ssh -i id_rsa.dsync imap01.coyhile.com /opt/local/bin/doveadm dsync-server -A > doveadm(hile at coyhile.com@coyhile.com): Info: User no longer exists, skipping > [root at...

...="_blank">https://wiki.dovecot.org/VirtualUsers#homedirs)</a>, tried to achieve a similar setup in conjunction with pgsql for passdb. </div> <div> <br> </div> <div> However I get an error "auth: Warning: sql: Ignoring changed iterate_query in /etc/dovecot/local_sql_users.conf, because userdb sql not used. (If this is intentional, set userdb_warning_disable=yes)" </div> <div> <br> </div> <div> Does this mean the following is not a valid config ? Or at least I will not be able to a...

...t; > Hi, > > > > Going by the "static userdb" example? on this page (https://wiki.dovecot.org/VirtualUsers#homedirs), tried to achieve a similar setup in conjunction with pgsql for passdb. > > > > However I get an error "auth: Warning: sql: Ignoring changed iterate_query in /etc/dovecot/local_sql_users.conf, because userdb sql not used. (If this is intentional, set userdb_warning_disable=yes)" > > > > Does this mean the following is not a valid config ? Or at least I will not be able to achieve iteration ? > > > > mail_location = maildi...

...s { username = $user mailbox = $mailbox } } dovecot: auth: Error: mysql: Query failed, retrying: Table 'mail.users' doesn't exist Aug 26 05:16:24 server1 dovecot: auth: Error: sql: Iterate query failed: Table 'mail.users' doesn't exist (using built-in default iterate_query: SELECT username, domain FROM users) Why isn't the expire dict trying to use the defined working mysql auth instead of using the built-in default? The howto doesn't say how to override this, at wiki2.dovecot.org, and I didn't know the expire dict wanted to lookup the mailbox table;...

...</div> <div> (1 row) </div> <div> <br> </div> <div> Naively, I’d expect something this to work for the iteration query: </div> <div> <br> </div> <div> iterate_query = SELECT username, domain FROM users </div> <div> <br> </div> <div> <br> </div> <div> But, when I do that, I end up </div> <div> <br> </div> <div>...

...onnected (pid=17728) Aug 31 10:03:35 cartman2 dovecot: auth: Debug: auth client connected (pid=17736) Aug 31 10:03:35 cartman2 dovecot: auth: Debug: auth client connected (pid=17732) any clues? -- View this message in context: http://old.nabble.com/doveadm-expunge--A-mailbox-Trash-savedbefore-30d-iterate_query-LDAP-tp29580393p29580393.html Sent from the Dovecot mailing list archive at Nabble.com.

...se the following command: doveadm expunge -A mailbox Junk savedbefore 28d I get: doveadm(root): Error: User listing returned failure In the mail log file it says: dovecot: auth-worker(18549): Error: sql: Iterate query failed: Table 'system.users' doesn't exist (using built-in default iterate_query: SELECT username, domain FROM users) However this is setup: dovecot-sql.conf: iterate_query = SELECT username AS user FROM accounts though I have had to comment the following from dovecot.conf: #iteratedb { # args = /usr/local/etc/dovecot/dovecot-sql.conf # driver = sql #} because it errors o...

<!doctype html> <html> <head> <meta charset="UTF-8"> </head> <body> <div> <br> </div> <blockquote type="cite"> <div> On 10/08/2019 15:51 Coy Hile via dovecot < <a href="mailto:dovecot@dovecot.org">dovecot@dovecot.org</a>> wrote: </div> <div>

On 17/05/2020 10:43, Laura Smith wrote: > Because I wanted to avoid storing uid/gid/home in the database ? I use: user_query = "SELECT 'vmail' AS uid, 'vmail' AS gid, allow_nets, '*:storage=' || quota || 'M' AS quota_rule FROM mailbox WHERE username = '%n' AND domain = '%d';" ... uid and gid are not stored in my database but are

Hi, in the past I set up a master/master replication through TCP using dovecot 2.2.10 on both servers and everything is running fine, I filter the users to replicate using the iterate_query on file dovecot-sql.con.ext; now I want to set up a new replication between two new servers running dovecot 2.2.32 but the replicator service tries to replicate every user on my database even when the iterate_query is correctly set up and the command "doveadm user '*' " shows only...

Hello. Used 2.2.rc3. Try LDAP search: # ldapsearch -LLL -D "uid=dovecot,ou=Services,o=m" -b "ou=C,o=m" -w 1 -s subtree "(objectClass=mailUser)" mail dn: uid=test,dc=m.u,ou=C,o=m mail: test at m.u dn: uid=basov,dc=m.u,ou=C,o=m mail: basov at m.u mail: wow at m.u dn: uid=postmaster,dc=m.u,ou=C,o=m mail: postmaster at m.u dn: uid=ogo,dc=rest.com,ou=C,o=m mail: ogo

Am 22.04.20 um 09:41 schrieb Stefan G. Weichinger: > iterate_query = SELECT username as user FROM mailbox Ok, we enabled the 2 users and they synced (after a restart of one dovecot, btw). What irritates me: on the new server I find less files in /home/vmail than on the old server. So something is skipped or so. I try to compare now ..

Hello, I've been trying to set up replication, Server A is dovecot 2.2.32 (upgrade from 2.0.9) and Server B is dovecot 2.2.10, I use mysql as userdb, I don't want to replicate every user on my database only especific users so I set my iterate_query on dovecot-sql.conf.ext file; my problem: doveadm replication is not "reading" my iterate_query, it tries to replicate every user. Diagnosis: - I removed iterate_query from dovecot-sql.conf.ext, on the log file I can see the doveadm replication is still trying to replicate. - doveadm us...