Displaying 20 results from an estimated 116 matches for "iterate_queri".
Did you mean:
iterate_query
2019 Oct 24
1
SQL iterate_query
I've been hunting some ghost mailboxes - and I *think* I found the source.
I use the complete email address as the username, and store such in a
database. The storage structure is location=/var/mail/%d/%n. Not unusual
I think.
So all I *should* see from "ls /var/mail" would be a list of domains.
But I keep seeing empty mailboxes being created at this level. Having
corrected a
2012 Oct 11
1
iterate_query does not use userdb - mail_location not found
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: Initialization failed:
2019 Aug 09
2
What does `iterate_query` for SQL want as output?
Hi all,
In an earlier thread, https://dovecot.org/pipermail/dovecot/2019-August/116694.html I got a lot of useful help about migration. On my older host, everything was static; on the newer host, I?m storing user information in Postgres. usernames are of the form <login at REALM>, say ?hile at coyhile.com? as basically a Kerberos principal, and authentication and individual lookups work.
2020 May 17
2
iterate_query with static userdb ?
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)"
2011 Oct 24
1
iterate_query not working
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 database server shows that dovecot does
not try to execute any query. What
2010 Aug 27
2
doveadm expunge -A mailbox Trash savedbefore 30d
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
2019 Aug 09
2
What does `iterate_query` for SQL want as output?
> On Aug 9, 2019, at 3:45 PM, Aki Tuomi <aki.tuomi at open-xchange.com> wrote:
>
>
>> On 09/08/2019 22:16 Coy Hile via dovecot <dovecot at dovecot.org> wrote:
>>
>>
>> Hi all,
>>
>> In an earlier thread, https://dovecot.org/pipermail/dovecot/2019-August/116694.html I got a lot of useful help about migration. On my older host, everything
2019 Aug 09
0
What does `iterate_query` for SQL want as output?
> On 09/08/2019 22:16 Coy Hile via dovecot <dovecot at dovecot.org> wrote:
>
>
> Hi all,
>
> In an earlier thread, https://dovecot.org/pipermail/dovecot/2019-August/116694.html I got a lot of useful help about migration. On my older host, everything was static; on the newer host, I?m storing user information in Postgres. usernames are of the form <login at REALM>,
2020 May 17
0
iterate_query with static userdb ?
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<div>
<br>
</div>
<blockquote type="cite">
<div>
On 17/05/2020 12:34 Laura Smith <<a href="mailto:n5d9xq3ti233xiyif2vp@protonmail.ch">n5d9xq3ti233xiyif2vp@protonmail.ch</a>> wrote:
2020 May 17
2
iterate_query with static userdb ?
On Sunday, 17 May 2020 10:38, Aki Tuomi <aki.tuomi at open-xchange.com> wrote:
> > On 17/05/2020 12:34 Laura Smith <n5d9xq3ti233xiyif2vp at protonmail.ch> wrote:
> >
> > 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
2010 Aug 26
0
Table mail.users doesn't exist (using built-in default iterate_query: SELECT username, domain FROM users)
connect = host=127.0.0.1 user=mail password=thecorrectpass dbname=mail
map {
pattern = shared/expire/$user/$mailbox
table = mail.expires
value_field = expire_stamp
fields {
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
2019 Aug 10
0
What does `iterate_query` for SQL want as output?
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<div>
<br>
</div>
<blockquote type="cite">
<div>
On 09/08/2019 23:01 Coy Hile via dovecot <
<a href="mailto:dovecot@dovecot.org">dovecot@dovecot.org</a>> wrote:
</div>
<div>
2010 Aug 31
1
doveadm expunge -A mailbox Trash savedbefore 30d iterate_query LDAP
hi everyone
after doing this in shell
#/usr/local/dovecot-2.0.1/bin/doveadm expunge -u tmihal mailbox INBOX
savedbefore 1d
everything is working as it should but ...
#/usr/local/dovecot-2.0.1/bin/doveadm expunge -A mailbox INBOX savedbefore
1d
doveadm(root): Error: userdb list: Disconnected unexpectedly
doveadm: Error: Failed to iterate through some users
#cat /etc/dovecot2/dovecot-ldap.conf
tls
2012 Aug 31
1
dovecotadm error
When I use 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:
2019 Aug 10
0
What does `iterate_query` for SQL want as output?
<!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>
2020 May 17
0
iterate_query with static userdb ?
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
2017 Oct 23
2
master/master replications v. 2.2.32
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
2013 Apr 02
1
LDAP: error with iterate_query
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
2020 Apr 22
5
replication newbie: some beginner questions
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 ..
2017 Oct 25
0
Replication Issue
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.