On 13 Feb 2018, at 00:11, Aki Tuomi <aki.tuomi at 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
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<div>
<br>
</div>
<blockquote type="cite">
<div>
On 13 February 2018 at 22:31 "@lbutlr" <
<a
href="mailto:kremels@kreme.com">kremels@kreme.com</a>>
wrote:
</div>
<div>
<br>
</div>
<div>
<br>
</div>
<div>
On 13 Feb 2018, at 00:11, Aki Tuomi <
<a
href="mailto:aki.tuomi@dovecot.fi">aki.tuomi@dovecot.fi</a>>
wrote:
</div>
<blockquote type="cite">
<div>
doveadm -u "*mask*" makes no sense.
</div>
</blockquote>
<div>
The “index” that was in the first line was dropped out of my further
examples. But now where was there a “*mask*”.
</div>
<div>
<br>
</div>
<blockquote type="cite">
<div>
what command are you trying to run?
</div>
</blockquote>
<div>
# doveadm index -u “
<a
href="mailto:*@sqldomain.tld">*@sqldomain.tld</a>"
"*”
</div>
<div>
Error: User listing returned failure
</div>
<div>
doveadm: Error: Failed to iterate through some users
</div>
<div>
<br>
</div>
<div>
That is, process all the users in sqldomain.tld and reindex all their
mailboxes.
</div>
<div>
<br>
</div>
<div>
(As works without a wildcard for a single local user in the first line.)
</div>
<div>
<br>
</div>
<div>
<br>
</div>
<div>
--
</div>
<div>
SHERRI DOES NOT "GOT BACK" Bart chalkboard Ep. AABF07
</div>
</blockquote>
<div>
<br>
</div>
<div>
Check dovecot logs why user listing returned an error. Auth process is
producing the error.
</div>
<div class="io-ox-signature">
---
<br>Aki Tuomi
</div>
</body>
</html>
On 2018-02-13 (13:44 MST), Aki Tuomi <aki.tuomi at 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.