[GH-ISSUE #564] Docs: write about db role creation for mailboxes owner #537

Closed
opened 2026-02-27 11:12:16 +03:00 by kerem · 8 comments
Owner

Originally created by @rominf on GitHub (Jun 10, 2014).
Original GitHub issue: https://github.com/modoboa/modoboa/issues/564

When I launched manage.py handle_mailbox_operations from vmail (mailboxes owner) I got error:

OperationalError: FATAL:  role "vmail" does not exist

I fixed it by creating vmail user and granting all permissions to database modoboa (I don't know how much permission should I give).

Originally created by @rominf on GitHub (Jun 10, 2014). Original GitHub issue: https://github.com/modoboa/modoboa/issues/564 When I launched `manage.py handle_mailbox_operations` from `vmail` (mailboxes owner) I got error: ``` OperationalError: FATAL: role "vmail" does not exist ``` I fixed it by creating `vmail` user and granting all permissions to database `modoboa` (I don't know how much permission should I give).
kerem 2026-02-27 11:12:16 +03:00
Author
Owner

@tonioo commented on GitHub (Jun 11, 2014):

Before creating this role, have you checked if the vmail system user has read access to the settings.py file ?

<!-- gh-comment-id:45711814 --> @tonioo commented on GitHub (Jun 11, 2014): Before creating this role, have you checked if the vmail system user has read access to the settings.py file ?
Author
Owner

@rominf commented on GitHub (Jun 11, 2014):

Yes, I gave read permissions with setfacl and opened settings.py from vmail user to be sure.

<!-- gh-comment-id:45733533 --> @rominf commented on GitHub (Jun 11, 2014): Yes, I gave read permissions with `setfacl` and opened `settings.py` from `vmail` user to be sure.
Author
Owner

@rominf commented on GitHub (Jun 11, 2014):

Sorry, pressed other button.

<!-- gh-comment-id:45733559 --> @rominf commented on GitHub (Jun 11, 2014): Sorry, pressed other button.
Author
Owner

@tonioo commented on GitHub (Jun 11, 2014):

And have you tried using the way I posted in #563 ?

<!-- gh-comment-id:45733973 --> @tonioo commented on GitHub (Jun 11, 2014): And have you tried using the way I posted in #563 ?
Author
Owner

@rominf commented on GitHub (Jun 11, 2014):

Yep:

vmail@hostname:/etc/dovecot> /opt/modoboa/bin/python /srv/www/mail/manage.py handle_mailbox_operations
OperationalError: FATAL:  role "vmail" does not exist
<!-- gh-comment-id:45736925 --> @rominf commented on GitHub (Jun 11, 2014): Yep: ``` vmail@hostname:/etc/dovecot> /opt/modoboa/bin/python /srv/www/mail/manage.py handle_mailbox_operations OperationalError: FATAL: role "vmail" does not exist ```
Author
Owner

@tonioo commented on GitHub (Sep 27, 2016):

@rominf I still don't understand why you needed to create this role. Any command executed through manage.py uses the credentials configured in the settings.py file. What is/was the name of the user you configured ?

<!-- gh-comment-id:249887973 --> @tonioo commented on GitHub (Sep 27, 2016): @rominf I still don't understand why you needed to create this role. Any command executed through manage.py uses the credentials configured in the settings.py file. What is/was the name of the user you configured ?
Author
Owner

@rominf commented on GitHub (Sep 27, 2016):

Thank you for answer, @tonioo. That was 2 years ago, I don't remember the details. I think this issue is irrelevant.

<!-- gh-comment-id:249907188 --> @rominf commented on GitHub (Sep 27, 2016): Thank you for answer, @tonioo. That was 2 years ago, I don't remember the details. I think this issue is irrelevant.
Author
Owner

@tonioo commented on GitHub (Sep 27, 2016):

Sorry for the delay and thanks for your answer ;)

<!-- gh-comment-id:249928662 --> @tonioo commented on GitHub (Sep 27, 2016): Sorry for the delay and thanks for your answer ;)
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#537
No description provided.