User listing returned failure with -A
First, I archive the old messages in the INBOX on my list account
# doveadm -Dv move -u kremels@kreme.com Archive mailbox INBOX BEFORE 90d Debug: Loading modules from directory: /usr/local/lib/dovecot/doveadm Debug: Skipping module doveadm_acl_plugin, because dlopen() failed: /usr/local/lib/dovecot/doveadm/lib10_doveadm_acl_plugin.so: Undefined symbol "acl_user_module" (this is usually intentional, so just ignore this message) Debug: Skipping module doveadm_expire_plugin, because dlopen() failed: /usr/local/lib/dovecot/doveadm/lib10_doveadm_expire_plugin.so: Undefined symbol "expire_set_lookup" (this is usually intentional, so just ignore this message) Debug: Skipping module doveadm_quota_plugin, because dlopen() failed: /usr/local/lib/dovecot/doveadm/lib10_doveadm_quota_plugin.so: Undefined symbol "quota_user_module" (this is usually intentional, so just ignore this message) Debug: Module loaded: /usr/local/lib/dovecot/doveadm/lib10_doveadm_sieve_plugin.so Debug: Skipping module doveadm_fts_plugin, because dlopen() failed: /usr/local/lib/dovecot/doveadm/lib20_doveadm_fts_plugin.so: Undefined symbol "fts_filter_filter" (this is usually intentional, so just ignore this message) Debug: Skipping module doveadm_mail_crypt_plugin, because dlopen() failed: /usr/local/lib/dovecot/doveadm/libdoveadm_mail_crypt_plugin.so: Undefined symbol "mail_crypt_user_get_public_key" (this is usually intentional, so just ignore this message) doveadm(kremels@kreme.com)<64937><>: Debug: auth USER input: kremels@kreme.com uid=89 gid=89 mail_location=maildir:/usr/local/virtual/kremels@kreme.com/Maildir mail=maildir:/usr/local/virtual/kremels@kreme.com/Maildir home=/usr/local/virtual/kremels@kreme.com/ doveadm(kremels@kreme.com)<64937><>: Debug: Added userdb setting: mail=maildir:/usr/local/virtual/kremels@kreme.com/Maildir doveadm(kremels@kreme.com)<64937><>: Debug: Added userdb setting: mail_location=maildir:/usr/local/virtual/kremels@kreme.com/Maildir doveadm(kremels@kreme.com): Debug: Effective uid=89, gid=89, home=/usr/local/virtual/kremels@kreme.com/ doveadm(kremels@kreme.com): Debug: Namespace inbox: type=private, prefix=, sep=, inbox=yes, hidden=no, list=yes, subscriptions=yes location=maildir:/usr/local/virtual/kremels@kreme.com/Maildir doveadm(kremels@kreme.com): Debug: maildir++: root=/usr/local/virtual/kremels@kreme.com/Maildir, index=, indexpvt=, control=, inbox=/usr/local/virtual/kremels@kreme.com/Maildir, alt= doveadm(kremels@kreme.com): Debug: Mailbox Archive: Mailbox opened because: move doveadm(kremels@kreme.com): Debug: Mailbox INBOX: Mailbox opened because: move
OK. that went well, how about all users now?
# doveadm -Dv move -A Archive mailbox INBOX BEFORE 90d Debug: Loading modules from directory: /usr/local/lib/dovecot/doveadm Debug: Skipping module doveadm_acl_plugin, because dlopen() failed: /usr/local/lib/dovecot/doveadm/lib10_doveadm_acl_plugin.so: Undefined symbol "acl_user_module" (this is usually intentional, so just ignore this message) Debug: Skipping module doveadm_expire_plugin, because dlopen() failed: /usr/local/lib/dovecot/doveadm/lib10_doveadm_expire_plugin.so: Undefined symbol "expire_set_lookup" (this is usually intentional, so just ignore this message) Debug: Skipping module doveadm_quota_plugin, because dlopen() failed: /usr/local/lib/dovecot/doveadm/lib10_doveadm_quota_plugin.so: Undefined symbol "quota_user_module" (this is usually intentional, so just ignore this message) Debug: Module loaded: /usr/local/lib/dovecot/doveadm/lib10_doveadm_sieve_plugin.so Debug: Skipping module doveadm_fts_plugin, because dlopen() failed: /usr/local/lib/dovecot/doveadm/lib20_doveadm_fts_plugin.so: Undefined symbol "fts_filter_filter" (this is usually intentional, so just ignore this message) Debug: Skipping module doveadm_mail_crypt_plugin, because dlopen() failed: /usr/local/lib/dovecot/doveadm/libdoveadm_mail_crypt_plugin.so: Undefined symbol "mail_crypt_user_get_public_key" (this is usually intentional, so just ignore this message) Error: User listing returned failure
doveadm: Error: Failed to iterate through some users
Ok, so I try the following:
# cd /usr/local/virtual && for i in *; do doveadm move -u $i Archive mailbox INBOX BEFORE 90d; done
And that works fine.
Everything is the same up until the Error but since nothing else is logged, where do I go from here?
-- There are strange things done in the midnight sun/By the men who moil for gold; The Arctic trails have their secret tales/That would make your blood run cold; The Northern Lights have seen queer sights,/But the queerest they ever did see Was the night on the marge of Lake Lebarge/ When I cremated Sam McGee
On 19.6.2019 5.44, @lbutlr via dovecot wrote:
First, I archive the old messages in the INBOX on my list account
# doveadm -Dv move -u kremels@kreme.com Archive mailbox INBOX BEFORE 90d Debug: Loading modules from directory: /usr/local/lib/dovecot/doveadm Debug: Skipping module doveadm_acl_plugin, because dlopen() failed: /usr/local/lib/dovecot/doveadm/lib10_doveadm_acl_plugin.so: Undefined symbol "acl_user_module" (this is usually intentional, so just ignore this message) Debug: Skipping module doveadm_expire_plugin, because dlopen() failed: /usr/local/lib/dovecot/doveadm/lib10_doveadm_expire_plugin.so: Undefined symbol "expire_set_lookup" (this is usually intentional, so just ignore this message) Debug: Skipping module doveadm_quota_plugin, because dlopen() failed: /usr/local/lib/dovecot/doveadm/lib10_doveadm_quota_plugin.so: Undefined symbol "quota_user_module" (this is usually intentional, so just ignore this message) Debug: Module loaded: /usr/local/lib/dovecot/doveadm/lib10_doveadm_sieve_plugin.so Debug: Skipping module doveadm_fts_plugin, because dlopen() failed: /usr/local/lib/dovecot/doveadm/lib20_doveadm_fts_plugin.so: Undefined symbol "fts_filter_filter" (this is usually intentional, so just ignore this message) Debug: Skipping module doveadm_mail_crypt_plugin, because dlopen() failed: /usr/local/lib/dovecot/doveadm/libdoveadm_mail_crypt_plugin.so: Undefined symbol "mail_crypt_user_get_public_key" (this is usually intentional, so just ignore this message) doveadm(kremels@kreme.com)<64937><>: Debug: auth USER input: kremels@kreme.com uid=89 gid=89 mail_location=maildir:/usr/local/virtual/kremels@kreme.com/Maildir mail=maildir:/usr/local/virtual/kremels@kreme.com/Maildir home=/usr/local/virtual/kremels@kreme.com/ doveadm(kremels@kreme.com)<64937><>: Debug: Added userdb setting: mail=maildir:/usr/local/virtual/kremels@kreme.com/Maildir doveadm(kremels@kreme.com)<64937><>: Debug: Added userdb setting: mail_location=maildir:/usr/local/virtual/kremels@kreme.com/Maildir doveadm(kremels@kreme.com): Debug: Effective uid=89, gid=89, home=/usr/local/virtual/kremels@kreme.com/ doveadm(kremels@kreme.com): Debug: Namespace inbox: type=private, prefix=, sep=, inbox=yes, hidden=no, list=yes, subscriptions=yes location=maildir:/usr/local/virtual/kremels@kreme.com/Maildir doveadm(kremels@kreme.com): Debug: maildir++: root=/usr/local/virtual/kremels@kreme.com/Maildir, index=, indexpvt=, control=, inbox=/usr/local/virtual/kremels@kreme.com/Maildir, alt= doveadm(kremels@kreme.com): Debug: Mailbox Archive: Mailbox opened because: move doveadm(kremels@kreme.com): Debug: Mailbox INBOX: Mailbox opened because: move
OK. that went well, how about all users now?
# doveadm -Dv move -A Archive mailbox INBOX BEFORE 90d Debug: Loading modules from directory: /usr/local/lib/dovecot/doveadm Debug: Skipping module doveadm_acl_plugin, because dlopen() failed: /usr/local/lib/dovecot/doveadm/lib10_doveadm_acl_plugin.so: Undefined symbol "acl_user_module" (this is usually intentional, so just ignore this message) Debug: Skipping module doveadm_expire_plugin, because dlopen() failed: /usr/local/lib/dovecot/doveadm/lib10_doveadm_expire_plugin.so: Undefined symbol "expire_set_lookup" (this is usually intentional, so just ignore this message) Debug: Skipping module doveadm_quota_plugin, because dlopen() failed: /usr/local/lib/dovecot/doveadm/lib10_doveadm_quota_plugin.so: Undefined symbol "quota_user_module" (this is usually intentional, so just ignore this message) Debug: Module loaded: /usr/local/lib/dovecot/doveadm/lib10_doveadm_sieve_plugin.so Debug: Skipping module doveadm_fts_plugin, because dlopen() failed: /usr/local/lib/dovecot/doveadm/lib20_doveadm_fts_plugin.so: Undefined symbol "fts_filter_filter" (this is usually intentional, so just ignore this message) Debug: Skipping module doveadm_mail_crypt_plugin, because dlopen() failed: /usr/local/lib/dovecot/doveadm/libdoveadm_mail_crypt_plugin.so: Undefined symbol "mail_crypt_user_get_public_key" (this is usually intentional, so just ignore this message) Error: User listing returned failure
doveadm: Error: Failed to iterate through some users
Ok, so I try the following:
# cd /usr/local/virtual && for i in *; do doveadm move -u $i Archive mailbox INBOX BEFORE 90d; done
And that works fine.
Everything is the same up until the Error but since nothing else is logged, where do I go from here?
Your userdb does not support listing, check dovecot logs, the error will not be reported by doveadm.
Aki
On 19 Jun 2019, at 00:42, Aki Tuomi via dovecot <dovecot@dovecot.org> wrote:
Your userdb does not support listing, check dovecot logs, the error will not be reported by doveadm.
sqlpool(mysql): Query failed, retrying: Table 'postfix.users' doesn't exist
Well, that is true, there is no users table, the table is ‘mailbox’ and the field is ‘username'
Any way yo tell doveadm what to look for?
-- *** AgentSmith sets mode: +m
On 19 Jun 2019, at 08:33, Aki Tuomi via dovecot <dovecot@dovecot.org> wrote:
Dovecot uses auth process to collect users, so maybe look at your iterate query? https://wiki.dovecot.org/AuthDatabase/SQL#User_iteration
Yeah, didn’t have one of those. ¯\_(ツ)_/¯
iterate_query = select username from mailbox
Seem to have sorted that out, thank you.
-- The Nixon I remembered was absolutely humorless; I couldn't imagine him laughing at anything except maybe a paraplegic who wanted to vote Democratic but couldn't quite reach the lever on the voting machine.
- Hunter S Thompson
participants (2)
-
@lbutlr
-
Aki Tuomi