File update_mta

Last commit: Tue Sep 27 00:47:06 2016 +0200	dankert	Transport-Tabelle muss auch die Domains der Aliases enthalten.


     1 #!/bin/bash
     2 
     3 CONFIG=/etc/default/ispconfig
     4 
     5 if [ ! -f $CONFIG  ]; then
     6     echo "File $CONFIG not found"
     7     exit 4;
     8 fi
     9 
    10 source $CONFIG
    11 
    12 
    13 # Datenbank
    14 function sql {
    15     sql=$1
    16     mysql -u $MYSQL_USER -p$MYSQL_PASSWORD -se "$sql" $MYSQL_DATABASE
    17 }
    18 
    19 
    20 
    21 function create_map {
    22     mapfile=$MTA_CONFIG_DIR/$1
    23     sql=$2
    24     echo "# AUTO-GENERATED BY $0 - DO NOT CHANGE!" > $mapfile
    25     sql "$sql"|while read key value; do
    26 	echo $key $value >> $mapfile
    27     done
    28     echo "" >> $mapfile
    29     
    30     # Adding to SCM
    31     hg -R $MTA_CONFIG_DIR add $mapfile
    32     
    33     # Compile Postfix map
    34     /usr/sbin/postmap $mapfile
    35 }
    36 
    37 
    38 last_mail_modified=`sql "select unix_timestamp(max(modified)) FROM (select modified from mailbox union all select modified FROM alias) as modified"`
    39 last_file_modified=`stat --format %Y $MTA_CONFIG_DIR/transport`
    40 
    41 if [ ! "$last_mail_modified" -gt "$last_file_modified" ]; then
    42     exit 0; # all up to date, nothing to do.
    43 fi
    44 
    45 
    46 
    47 create_map transport        "select distinct domain,'virtual:' from alias where active=1"
    48 create_map aliases          "select address,goto from alias where active=1"
    49 create_map sender           "select concat(local_part,'@',domain),concat(local_part,'@',domain) from mailbox where active=1"
    50 create_map virtualforward   "select '# n/a','' from mailbox where active=1"
    51 create_map accounts         "select concat(local_part,'@',domain) , concat(maildir,'/') from mailbox where active=1"
    52 create_map accountsmap      "select concat(local_part,'@',domain) , concat(local_part,'@',domain) from mailbox where active=1"
    53 
    54 # Ablehnen: Deaktivierte Mailboxen und deaktivierte Aliases
    55 create_map recipient_reject "select concat(local_part,'@',domain), 'REJECT' from mailbox where active=0 union select address,'REJECT' from alias where active=0"
    56 
    57 hg -R $MTA_CONFIG_DIR diff
    58 hg -R $MTA_CONFIG_DIR commit -u `whoami` -m "Updating Postfix configuration"
    59 
    60 postfix reload



Download update_mta


History
Tue, 27 Sep 2016 00:47:06 +0200	dankert	Transport-Tabelle muss auch die Domains der Aliases enthalten.
Wed, 24 Feb 2016 21:30:16 +0100	dankert	Update in das SCM
Mon, 22 Feb 2016 22:32:54 +0100	dankert	Initiale Version seit der Umstellung auf Datenbank-gebriebene Konfiguration