Aquilenet

# Sympa

## DNS

penser pour les nouveaux site à mettre en entrée DNS:

```

listes.$domain CNAME listes.aquilenet.fr.

listes.$domain MX mail.aquilenet.fr.

```

## Script de migration de Kolter 

``` shell

#!/bin/sh

RSYNC_OPTS="-av --delete-after -e 'ssh -p 55555'"

echo "Stopping sympa"

systemctl stop sympa

echo "Syncing files..."

rsync -av --delete-after -e 'ssh -p 55555' 185.233.100.1:/var/lib/sympa/wwsarchive/ /var/lib/sympa/arc/

rsync -av --delete-after -e 'ssh -p 55555' 185.233.100.1:/var/lib/sympa/expl/listes.aquilenet.fr/ /var/lib/sympa/list_data/listes.aquilenet.fr/

rsync -av --delete-after -e 'ssh -p 55555' 185.233.100.1:/var/lib/sympa/expl/listes.girondix.net/ /var/lib/sympa/list_data/listes.girondix.net/

rsync -av --delete-after -e 'ssh -p 55555' 185.233.100.1:/var/lib/sympa/expl/listes.ressourceries.org/ /var/lib/sympa/list_data/listes.ressourceries.org/

rsync -av --delete-after -e 'ssh -p 55555' 185.233.100.1:/var/lib/sympa/bounce/ /var/lib/sympa/bounce/

sed -i -r 's/, attention, i/. I/' /var/lib/sympa/list_data/listes.aquilenet.fr/asso/config

#echo -n "Creating /etc/mail/sympa/aliases..."

#

#echo "## List aliases used for the sympa mailing-list manager" > /etc/mail/sympa/aliases

#

#egrep 'status.+open' /var/lib/sympa/list_data/*/*/config | \

#    cut -d '/' -f 6,7 | \

#    tr '/' ' ' | \

#    while read dom list ; do

#        echo -n "${list}@${dom} "

#        /usr/lib/sympa/bin/alias_manager.pl add "${list}" "${dom}"

#    done

#echo

#

#chmod 644 /etc/mail/sympa/aliases

#chown sympa:sympa /etc/mail/sympa/aliases

#newaliases

echo "Droping tables..."

echo 'DROP TABLE IF EXISTS admin_table, bulkmailer_table, bulkspool_table, conf_table, exclusion_table, inclusion_table, list_table, logs_table, netidmap_table, notification_table, one_time_ticket_table, session_table, stat_counter_table, stat_table, subscriber_table, user_table; ' \

    | mysql -u sympa --password="xx" sympa

echo "Restoring database..."

ssh -p 55555 185.233.100.1 "mysqldump -u sympa --password=zz sympa" | mysql -u sympa --password="yy" sympa

echo "6.1.23" > /etc/sympa/data_structure.version

echo "Upgrading Sympa internals (health check)"

su -l sympa -s /bin/sh -c "/usr/lib/sympa/bin/sympa.pl --health_check"

echo "Upgrading Sympa internals (upgrade)"

su -l sympa -s /bin/sh -c "/usr/lib/sympa/bin/sympa.pl --upgrade"

echo "Move messages stored in database to filesystem (if required)"

su -l sympa -s /bin/sh -c "/usr/share/sympa/bin/upgrade_bulk_spool.pl" || true

echo "Move messages sent through the web interface to the new formalism (if required)"

su -l sympa -s /bin/sh -c "/usr/share/sympa/bin/upgrade_send_spool.pl"

echo "Version"

cat /etc/sympa/data_structure.version

echo "Re-Starting sympa"

systemctl restart sympa

echo "Re-Starting sympa WWS"

systemctl restart wwsympa

exit 0

```