Aquilenet

Sympa » Historique » Révision 3

Révision 2 (sacha, 21/06/2020 16:28) → Révision 3/4 (sacha, 23/06/2020 17:08)

# 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 
 ```