doc/web/source/pgsql_set_permissionspermissions.rst
author "martin f. krafft" <madduck@debian.org>
Tue, 07 Aug 2012 21:53:41 +0000
changeset 582 605f8c115711
parent 579 be0906181a10
child 626 f151defe7078
permissions -rw-r--r--
Due to the UNION query in address_list, the assumption that the list of gids received from the database would be continuous does not hold. To prevent addresses for domains with multiple entry types from being listed, it is necessary to check the list of domain gids for every entry. Signed-off-by: martin f. krafft <madduck@debian.org> --- VirtualMailManager/common.py | 4 +--- 1 file changed, 1 insertion(+), 3 deletions(-)

There's a python script which grants permissions to your Dovecot and Postfix
database users.

.. code-block:: console

 user@host:~$ python /path/to/vmm-0.6.0/pgsql/set-permissions.py -h
 Usage: set-permissions.py OPTIONS
 
 Set permissions for Dovecot and Postfix in the vmm database.
 
 Options:
   -h, --help            show this help message and exit
   -a, --askpass         Prompt for the database password.
   -H HOST, --host=HOST  Hostname or IP address of the database server. Leave
                         blank in order to use the default Unix-domain socket.
   -n NAME, --name=NAME  Specifies the name of the database to connect to.
                         Default: mailsys
   -p PASS, --pass=PASS  Password for the database connection.
   -P PORT, --port=PORT  Specifies the TCP port or the local Unix-domain socket
                         file extension on which the server is listening for
                         connections. Default: 5432
   -U USER, --user=USER  Connect to the database as the user USER instead of
                         the default: root
   -D USER, --dovecot=USER
                         Database user name of the Dovecot database user.
                         Default: dovecot
   -M USER, --postfix=USER
                         Database user name of the Postfix (MTA)  database
                         user. Default: postfix
 user@host:~$ python /path/to/vmm-0.6.0/pgsql/set-permissions.py -a -H 127.0.0.1 -U vmm
 Password: 
 user@host:~$