What does `iterate_query` for SQL want as output?

[Coy Hile]

> On Aug 10, 2019, at 10:55 AM, Aki Tuomi <aki.tuomi at open-xchange.com> wrote:
> 
> 
>> On 10/08/2019 15:51 Coy Hile via dovecot < dovecot at dovecot.org> wrote:
>> 
>> 
>>> 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: Failed to iterate through some users
>> dsync-local( hile at coyhile.com)<gCspG6m8Tl3bJQEAxHAMlw>: Error: read(remote) failed: EOF (version not received)
>> 
>> The last line makes sense given the earlier failure.
>> 
>> Should this log somewhere else besides syslog? And is there some way I can isolate and test _just_ the user iteration and enumeration code to prove out that the query is correct? Clearly, from output above, it should be.
>> 
>> Thanks,
>> -c
> 
> Can you try doveadm -Dv backup ... 
> 
> note the -Dv goes before backup
> 

Ok, that explains why I didn’t get anything useful as debug output. Right now, there’s only one user on either side (namely, me), so all of this seems to look sane to my (admittedly untrained) eye:

doveadm(hile at coyhile.com)<63392><>: Debug: auth USER input: hile at coyhile.com password=<hidden> home=/var/mail/vmail/coyhile.com/hile uid=1000 gid=1000
doveadm(hile at coyhile.com)<63392><>: Debug: Added userdb setting: plugin/password=<hidden>
doveadm(hile at coyhile.com): Debug: Effective uid=1000, gid=1000, home=/var/mail/vmail/coyhile.com/hile
doveadm(hile at coyhile.com): Debug: acl: No acl setting - ACLs are disabled
doveadm(hile at coyhile.com): Debug: Namespace inbox: type=private, prefix=, sep=, inbox=yes, hidden=no, list=yes, subscriptions=yes location=mdbox:~/mdbox
doveadm(hile at coyhile.com): Debug: fs: root=/var/mail/vmail/coyhile.com/hile/mdbox, index=, indexpvt=, control=, inbox=, alt=
doveadm(hile at coyhile.com): Debug: brain M: Namespace  has location mdbox:~/mdbox
doveadm(hile at coyhile.com): Debug: Namespace : Using permissions from /var/mail/vmail/coyhile.com/hile/mdbox: mode=0700 gid=default
Error: User listing returned failure
doveadm: Error: Failed to iterate through some users