Postfixadmin

apt-get install postfixadmin

Fix:
1. /etc/postfixadmin/dbconfig.inc.php
$dbtype=mysqli

2. Fehler:bei https://gehrdener.de/postfixadmin/setup.php?debug=1
DEBUG INFORMATION:
Invalid query: Invalid default value for 'created'


Fix:
Strict Mode off:

Erstelle

/etc/mysql/conf.d/disable_strict_mode.cnf

Inhalt:

sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

service mysql restart

Alias definieren in /etc/main.cf

 virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_alias_maps.cf

Inhalt:

hosts = localhost
user = [DBUSER]
password = [PASSWORD]
dbname = [DBNAME]
query = SELECT goto FROM alias WHERE address='%s' AND active = '1'

Virtuelle Domänen

Main.cf: 

virtual_alias_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf

In der mysql-virtual_domains.cf  

query = SELECT domain FROM domain WHERE domain='%s' AND backupmx = '0' AND active = '1'