first reimport from platal

[platal.git] / upgrade / 0.9.1 / update.sh

diff --git a/upgrade/0.9.1/update.sh b/upgrade/0.9.1/update.sh
new file mode 100755 (executable)
index 0000000..4abb039
--- /dev/null
+++ b/upgrade/0.9.1/update.sh
@@ -0,0 +1,49 @@
+#!/bin/bash
+
+set -e
+
+if [ "$UID" != 0 ]; then
+    echo "has to be run as root"
+    exit 1
+fi
+
+
+
+###########################################################
+echo -n "stops mailman"
+/etc/init.d/mailman stop &>/dev/null
+echo .
+
+echo -n "now updates mailman to use new Bogofilter policy"
+./mailman_update.py | grep "ERROR" || echo .
+
+echo -n "copies new mails templates"
+cp -f ../../mailman/mails/*.txt /etc/mailman/fr/
+echo .
+
+echo -n "starts mailman"
+/etc/init.d/mailman start &>/dev/null
+echo .
+
+###########################################################
+echo -n "now drop x4dat.emploi_naf"
+echo 'drop table x4dat.emploi_naf;' | mysql -u root x4dat &>/dev/null || echo -n ": FAILED"
+echo .
+
+###########################################################
+echo -n "updating newsletter tables"
+mysql -u root x4dat < newsleter.sql &>/dev/null            || echo 'newsletter.sql FAILED'
+mysql -u root x4dat < newsleter_art.sql &>/dev/null || echo 'newsletter_art.sql FAILED'
+mysql -u root x4dat < newsleter_cat.sql &>/dev/null || echo 'newsletter_cat.sql FAILED'
+mysql -u root x4dat < newsleter_ins.sql &>/dev/null || echo 'newsletter_ins.sql FAILED'
+echo '.'
+
+###########################################################
+echo "ALL IS OK.
+
+don't forget to kill current mailman-rpc.py
+you shoul be able to run the new one only with :
+
+    ./mailman-rpc.py -f
+
+fork problems + SIGHUP handling have been solved."