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@REALM>, say ‘[email protected]’ as basically a Kerberos principal, and
authentication and individual lookups work.
My `users` table looks thus:
mail=> \d users
Table "public.users"
Column | Type | Modifiers
----------+------+-----------
username | text | not null
domain | text | not null
password | text | not null
mail=>
and contains, as an example:
username | domain |
password
------------------+-------------+-------------------------------------------------------------------------------------------------------
[email protected] | 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([email protected]@coyhile.com): Info: User no longer exists, skipping
[root@81716ec5-bca4-6d53-ed81-bd1a55d46b4f /tmp]#
Note the extra “@coyhile.com” in there.
Thanks,
—
Coy Hile
[email protected]
