> On Feb 15, 2016, at 11:43 AM, Terry Barnum <terrydop at gmail.com>
wrote:
>
> I'm trying to get doveadm to backup all users to a local drive without
any luck.
>
> $ sudo doveadm backup -A /Volumes/mail_bak/mailstore_backup/
> Error: User listing returned failure
> doveadm: Error: Failed to iterate through some users
>
> The doveadm-backup man page has the instruction to make sure the iterate
query matches the database layout but I'm not sure what that means.
>
> If the user_query in dovecot-sql.conf.ext looks like this, what should the
iterate_query look like?
>
> user_query = \
> SELECT '/opt/local/virtual/%d/%n/mail' as home, \
> 'maildir:/opt/local/virtual/%d/%n/mail' as mail, 501 as uid, \
> 501 as gid, concat("*:storage=", quota) AS quota \
> FROM mailbox WHERE username = "%u" AND active = "1"
>
> # Query to get a list of all usernames.
> iterate_query = SELECT username AS user FROM users
I didn't see my original email show up on the mailing list so I'm
resending. To recap, is it possible to backup all users to a local drive with
doveadm?
Thanks,
-Terry
Terry Barnum
digital OutPost
Carlsbad, CA
http://www.dop.com
800/464-6434