Signum / ispmail-bookworm-ansible

Ansible playbook to set up a mail server as described in the ISPmail guide at workaround.org
MIT License
26 stars 6 forks source link

Iterate query on dovecot-sql.conf.ext #9

Closed FredMa01 closed 1 month ago

FredMa01 commented 1 month ago

The command : expunge -A mailbox Trash savedbefore 180d returned the error : Error: auth-master: userdb list: User listing returned failure doveadm: Error: Failed to iterate through some users

The doveadm -A command uses the iterate_query, which must return username and domain for each user.

You must therefore add the line : iterate_query = SELECT email AS user FROM virtual_users at the end of /etc/dovecot/dovecot-sql.conf.ext

This line should be added here on line 153: ispmail-bookworm-ansible/roles/ispmail-dovecot/templates/dovecot-sql.conf.ext.j2 This is also indicated here: https://workaround.org/ispmail-bookworm/setting-up-dovecot/

Fred