First, I archive the old messages in the INBOX on my list account # doveadm -Dv move -u kremels at 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 at kreme.com)<64937><>: Debug: auth USER input: kremels at kreme.com uid=89 gid=89 mail_location=maildir:/usr/local/virtual/kremels at kreme.com/Maildir mail=maildir:/usr/local/virtual/kremels at kreme.com/Maildir home=/usr/local/virtual/kremels at kreme.com/ doveadm(kremels at kreme.com)<64937><>: Debug: Added userdb setting: mail=maildir:/usr/local/virtual/kremels at kreme.com/Maildir doveadm(kremels at kreme.com)<64937><>: Debug: Added userdb setting: mail_location=maildir:/usr/local/virtual/kremels at kreme.com/Maildir doveadm(kremels at kreme.com): Debug: Effective uid=89, gid=89, home=/usr/local/virtual/kremels at kreme.com/ doveadm(kremels at kreme.com): Debug: Namespace inbox: type=private, prefix=, sep=, inbox=yes, hidden=no, list=yes, subscriptions=yes location=maildir:/usr/local/virtual/kremels at kreme.com/Maildir doveadm(kremels at kreme.com): Debug: maildir++: root=/usr/local/virtual/kremels at kreme.com/Maildir, index=, indexpvt=, control=, inbox=/usr/local/virtual/kremels at kreme.com/Maildir, altdoveadm(kremels at kreme.com): Debug: Mailbox Archive: Mailbox opened because: move doveadm(kremels at 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 at 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 at kreme.com)<64937><>: Debug: auth USER input: kremels at kreme.com uid=89 gid=89 mail_location=maildir:/usr/local/virtual/kremels at kreme.com/Maildir mail=maildir:/usr/local/virtual/kremels at kreme.com/Maildir home=/usr/local/virtual/kremels at kreme.com/ > doveadm(kremels at kreme.com)<64937><>: Debug: Added userdb setting: mail=maildir:/usr/local/virtual/kremels at kreme.com/Maildir > doveadm(kremels at kreme.com)<64937><>: Debug: Added userdb setting: mail_location=maildir:/usr/local/virtual/kremels at kreme.com/Maildir > doveadm(kremels at kreme.com): Debug: Effective uid=89, gid=89, home=/usr/local/virtual/kremels at kreme.com/ > doveadm(kremels at kreme.com): Debug: Namespace inbox: type=private, prefix=, sep=, inbox=yes, hidden=no, list=yes, subscriptions=yes location=maildir:/usr/local/virtual/kremels at kreme.com/Maildir > doveadm(kremels at kreme.com): Debug: maildir++: root=/usr/local/virtual/kremels at kreme.com/Maildir, index=, indexpvt=, control=, inbox=/usr/local/virtual/kremels at kreme.com/Maildir, alt> doveadm(kremels at kreme.com): Debug: Mailbox Archive: Mailbox opened because: move > doveadm(kremels at 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 at 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