1 There's a python script which grants permissions to your Dovecot and Postfix

     2 database users.

     3 

     4 .. code-block:: console

     5 

     6  user@host:~$ python /path/to/vmm-0.6.0/pgsql/set-permissions.py -h

     7  Usage: set-permissions.py OPTIONS

     8  

     9  Set permissions for Dovecot and Postfix in the vmm database.

    10  

    11  Options:

    12    -h, --help            show this help message and exit

    13    -a, --askpass         Prompt for the database password.

    14    -H HOST, --host=HOST  Hostname or IP address of the database server. Leave

    15                          blank in order to use the default Unix-domain socket.

    16    -n NAME, --name=NAME  Specifies the name of the database to connect to.

    17                          Default: mailsys

    18    -p PASS, --pass=PASS  Password for the database connection.

    19    -P PORT, --port=PORT  Specifies the TCP port or the local Unix-domain socket

    20                          file extension on which the server is listening for

    21                          connections. Default: 5432

    22    -U USER, --user=USER  Connect to the database as the user USER instead of

    23                          the default: root

    24    -D USER, --dovecot=USER

    25                          Database user name of the Dovecot database user.

    26                          Default: dovecot

    27    -M USER, --postfix=USER

    28                          Database user name of the Postfix (MTA)  database

    29                          user. Default: postfix

    30  user@host:~$ python /path/to/vmm-0.6.0/pgsql/set-permissions.py -a -H 127.0.0.1 -U vmm

    31  Password: 

    32  user@host:~$ 

    33