Displaying 20 results from an estimated 9000 matches similar to: "SQL iterate_query"
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.
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
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 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>
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)"
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>,
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
2018 Nov 15
2
Quota in MySql Dict not recalculate automatic
Hi,
I have a working Installation with:
Ubuntu 16.04 LTS
Dovecot 2.2.22
MySql 5.7.24
Postfixadmin 3.2
Apache 2.4.18
Rainloop 1.12.1
I manage the E-Mail Accounts with postfixadmin in a MySql-DB.
Also I use quotas with Quota Backend postfixadmin-DB (dict).
Everything works fine.
Now I installed a new Server with the following Versions and
migrate the Configs to the new System.
Ubuntu 18.04 LTS
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 ..
2018 Nov 16
3
Antwort: Re: Quota in MySql Dict not recalculate automatic
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 /usr/local/bin/quota-warning.sh
# user = dovecot
user = vmail
unix_listener quota-warning {
user = vmail
group = vmail
mode = 0660
}
}
plugin {
2011 Oct 19
1
'doveadm quota get' dictionary SQL query ignores specified '@domain' part of username. bad config or bug?
Hi,
I'm setting up SQL quota usage in Dovecot2.
I've created a MAILBOX parameter table, 'PARAMS', that contains unique
<user>@<domain> pairs, with quota data.
mysql> select * from PARAMS;
+----+------------------------+------------+-------------+------------+
| ai | MAILBOX_user_domain | quota | quota_bytes | quota_msgs |
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>
2014 Aug 15
1
Server dovecot: auth: Warning: sql: Ignoring changed iterate_quer
Hello,?
I am having an issue with Dovecot. I am using Roundcube to access my mailboxes, which I have set up using ViMbAdmin.?
However when I go to the Roundcube, I get login Failed.?
So looking in the mail.log I can see the following:?
Aug 15 13:20:09 Server dovecot: auth: Warning: sql: Ignoring changed iterate_query in /etc/dovecot/dovecot-sql.conf.ext, because userdb sql not used. (If this
2018 Nov 15
0
Quota in MySql Dict not recalculate automatic
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
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
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
2019 Aug 10
2
What does `iterate_query` for SQL want as output?
>
> Did you check your logs?
>
that?s just it. There?s nothing in syslog (which is logging at mail.debug). Not just nothing useful, absolutely _nothing_ logged when I run that. All I see is this (printed, I presume to STDERR):
doveadm backup -D -A -R -f ssh -i id_rsa.dsync imap01.coyhile.com /opt/local/bin/doveadm dsync-server -A
Error: User listing returned failure
doveadm: Error:
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:
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