ajout playbook creation site

[lhc/ansible.git] / mig_nuage_paillettes

diff --git a/mig_nuage_paillettes b/mig_nuage_paillettes
new file mode 100644 (file)
index 0000000..f1aa106
--- /dev/null
+++ b/mig_nuage_paillettes
@@ -0,0 +1,78 @@
+
+
+https://nicolaslang.fr/articles/migrer-la-bdd-nextcloud-de-mysql-vers-postgres
+
+gzip -d ARCHIVE_dump_bdd.gz
+
+préparation MYSQL
+DROP DATABASE pailleccambouis;
+CREATE DATABASE pailleccambouis;
+GRANT ALL PRIVILEGES ON *.* TO 'nextcloud' WITH GRANT OPTION;
+source /home/roms/ARCHIVE_dump_bdd;
+
+
+drop table oc_bbb_restrictions;
+drop table oc_bbb_room_shares;
+drop table oc_bbb_rooms;
+drop table oc_mail_accounts;
+drop table oc_mail_aliases;
+drop table oc_mail_attachments;
+drop table oc_mail_classifiers;
+drop table oc_mail_coll_addresses;
+drop table oc_mail_mailboxes;
+drop table oc_mail_messages;
+drop table oc_mail_recipients;
+
+mysql -u nextcloud -p pailleccambouis
+
+modif config.php avec localhost + dbuser nextcloud + dbpass Ckoideja
+
+sudo -u www-data ./console-7.4 db:convert-mysql-charset
+sudo -u www-data ./console-7.4 db:add-missing-columns
+sudo -u www-data ./console-7.4 db:add-missing-indices
+sudo -u www-data ./console-7.4 db:convert-filecache-bigint
+sudo -u www-data ./console-7.4 maintenance:mimetype:update-db
+sudo -u www-data ./console-7.4 maintenance:mimetype:update-js
+
+préparation PGSQL
+vim /etc/postgresql/11/main/pg_hba.conf 
+local  all             nextcloud                               peer
+CREATE USER nextcloud;
+ALTER USER nextcloud WITH PASSWORD 'Ckoideja';
+
+DROP DATABASE nextcloud;
+CREATE DATABASE nextcloud;
+
+ALTER DATABASE nextcloud OWNER TO nextcloud;
+GRANT ALL PRIVILEGES ON DATABASE nextcloud TO nextcloud;
+
+
+adduser nextcloud -disabled-login --disabled-password --home /opt/nuage --no-create-home --shell /bin/false --system
+adduser nextcloud postgres
+
+adduser nextcloud www-data
+sudo -u www-data ./console-7.4 db:convert-type --all-apps pgsql nextcloud localhost nextcloud
+certaines tables ne sont pas convertis donc perdus. Dire OK.
+
+
+
+unlink nextcloud
+sudo -u www-data ln -s /opt/source/nextcloud22/nextcloud/ nextcloud
+sudo -u www-data ./console-7.4 upgrade
+service php7.4-fpm reload
+
+
+sudo -u www-data ./console-7.4 db:add-missing-columns
+sudo -u www-data ./console-7.4 db:add-missing-indices
+sudo -u www-data ./console-7.4 db:add-missing-primary-keys
+
+
+migration:
+
+    autoriser site_pec_nuage a se connecter dans /etc/passwd
+    lancer un rsync depuis la vm vers ligatures dans un /tmp (ou tester un fichier dans le /data)
+    comparer les fichiers de conf
+    sudo -u php_pec_nuage ./console upgrade
+    test de la v26
+    update en v27
+