If an alias has multiple destinations, multiple records exist, due to
the nature of the database. address_list would then return the same
alias multiple times, which does not add any information, eats screen
space and is potentially confusing.
Therefore, we SELECT DISTINCTly from the alias table.
Signed-off-by: martin f. krafft <madduck@debian.org>
---
VirtualMailManager/common.py | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
There's a python script which grants permissions to your Dovecot and Postfixdatabase users...code-block::consoleuser@host:~$ python/path/to/vmm-0.6.0/pgsql/set-permissions.py-hUsage: set-permissions.py OPTIONSSet 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: postfixuser@host:~$ python/path/to/vmm-0.6.0/pgsql/set-permissions.py-a-H127.0.0.1-UvmmPassword: user@host:~$