[GH-ISSUE #1988] doveadm -A reports "User no longer exists" #1490

Closed
opened 2026-02-27 11:17:22 +03:00 by kerem · 4 comments
Owner

Originally created by @neonknight on GitHub (Jul 14, 2020).
Original GitHub issue: https://github.com/modoboa/modoboa/issues/1988

Impacted versions

  • Modoboa: 1.15.0
  • installer used: Yes
  • Webserver: Nginx

Steps to reproduce

doveadm search -A mailbox Trash savedbefore 14d

Current behavior

command prints info message:
doveadm(): Info: User no longer exists, skipping

Expected behavior

no bogus info/warning/error message should occur

Resolution suggestion:

default admin and other global admin users can be saved without email address, resulting in dovecot iterate_query resulting empty user:

MariaDB [modoboa]> SELECT username, email AS user FROM core_user;
+---------------------------+---------------------------+
| username                  | user                      |
+---------------------------+---------------------------+
| admin                     |                           |

This can be bypassed by altering the iterate_query in /etc/dovecot/dovecot-sql.conf.ext to require the email field to be set:
iterate_query = SELECT email AS user FROM core_user WHERE email != ''

Is this applicable or would this break other functionality?

Originally created by @neonknight on GitHub (Jul 14, 2020). Original GitHub issue: https://github.com/modoboa/modoboa/issues/1988 # Impacted versions * Modoboa: 1.15.0 * installer used: Yes * Webserver: Nginx # Steps to reproduce `doveadm search -A mailbox Trash savedbefore 14d` # Current behavior command prints info message: doveadm(): Info: User no longer exists, skipping # Expected behavior no bogus info/warning/error message should occur # Resolution suggestion: default admin and other global admin users can be saved without email address, resulting in dovecot iterate_query resulting empty user: ``` MariaDB [modoboa]> SELECT username, email AS user FROM core_user; +---------------------------+---------------------------+ | username | user | +---------------------------+---------------------------+ | admin | | ``` This can be bypassed by altering the iterate_query in /etc/dovecot/dovecot-sql.conf.ext to require the email field to be set: `iterate_query = SELECT email AS user FROM core_user WHERE email != ''` Is this applicable or would this break other functionality?
kerem 2026-02-27 11:17:22 +03:00
Author
Owner

@tonioo commented on GitHub (Sep 15, 2020):

@neonknight Can tell me how you created an admin without password?

<!-- gh-comment-id:692532839 --> @tonioo commented on GitHub (Sep 15, 2020): @neonknight Can tell me how you created an admin without password?
Author
Owner

@neonknight commented on GitHub (Sep 16, 2020):

s/password/email address/

my bad... I fixed the ticket.

<!-- gh-comment-id:693178465 --> @neonknight commented on GitHub (Sep 16, 2020): s/password/email address/ my bad... I fixed the ticket.
Author
Owner

@tonioo commented on GitHub (Oct 21, 2020):

@neonknight I think user query used to include such a filter but there was a problem with it. Unfortunately, I can't remember which one...

<!-- gh-comment-id:713593534 --> @tonioo commented on GitHub (Oct 21, 2020): @neonknight I think user query used to include such a filter but there was a problem with it. Unfortunately, I can't remember which one...
Author
Owner

@stale[bot] commented on GitHub (Dec 22, 2020):

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

<!-- gh-comment-id:749518327 --> @stale[bot] commented on GitHub (Dec 22, 2020): This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/modoboa-modoboa#1490
No description provided.