On 13 Feb 2018, at 00:11, Aki Tuomi aki.tuomi@dovecot.fi wrote:

doveadm -u "*mask*" makes no sense.

The “index” that was in the first line was dropped out of my further examples. But now where was there a “*mask*”.

what command are you trying to run?

# doveadm index -u “*@sqldomain.tld" "*” Error: User listing returned failure doveadm: Error: Failed to iterate through some users

That is, process all the users in sqldomain.tld and reindex all their mailboxes.

(As works without a wildcard for a single local user in the first line.)

-- SHERRI DOES NOT "GOT BACK" Bart chalkboard Ep. AABF07

On 2018-02-13 (13:44 MST), Aki Tuomi aki.tuomi@dovecot.fi wrote:

Check dovecot logs why user listing returned an error. Auth process is producing the error.

Thanks,

auth-worker(40200): Error: sql: Iterate query failed: Table 'postfix.users' doesn't exist

Which is accurate, the database does not contain a table postfix.users, and never has done.

But users on sql managed domains have no trouble logging in a nd I can use doveadm for individual users.

What should postfix.users contain?

driver = mysql connect = host=localhost dbname=postfix user=dovecot password=*password* default_pass_scheme = SHA256-CRYPT password_query = select password FROM mailbox where username ='%u' user_query = select 89 as uid, 89 as gid, concat('/usr/local/virtual/', maildir) as home FROM mailbox where username = '%u'

I don't see where dovecot is getting "postfix.users" since the structure of the database uses mailbox and the field username, as shown in the sql configuration file for dovecot above.

$ grep -ir "from users" /usr/local/etc/dovecot/

Only shows results from example-config files

In fact, checking the entire /usr/local/etc/ for that spring on shows it in various example configs (dovecot, pureftpd, and amavisd)

-- The trouble with being a god is that you've got no one to pray to.