--- tags: go.epfl.ch title: go.epfl.ch → MEP 29.04.2021 --- # go.epfl.ch MEP 29.04.2021 Quelques notes et checklist pour la mise en production de go.epfl.ch du 29 avril 2021. ## Préparation - [x] Créer un Change et un Outage. * [CHG0040419](https://epfl.service-now.com/nav_to.do?uri=change_request.do?sys_id=947916221be3a81056c1ebd9bb4bcb00) * [OUT0006179](https://epfl.service-now.com/nav_to.do?uri=cmdb_ci_outage.do?sys_id=031a16a61be3a81056c1ebd9bb4bcbe2) - [x] Merger la branche "audit-sécurité" - [x] Fixer les dumps de la DB + crontab (à checker après la nuit du 22 au 23) - [-] (NOGO) Merger une version "Beta" des tests dusks - [ ] (en cours) Nettoyer les branches - [x] Twitter bot - [x] Ajouter les cliques dans l'API - [x] A discuter: quelles seraient les opérations pour mettre en prod "react" (build, etc.) => just npm install && just npm run production - [x] CHANGELOG / RELEASES_NOTES - [x] Changer les messages pour "hidden" → parler du channel Telegram - [x] Ajouter Greg dans /about - [x] BUG: /admin-php/ change alias → hidden ne fonctionne pas. - [x] Refaire un jeu de test - [x] Taille disque VM → est-ce qu'on a déjà une extension ? Si oui le monter pour BACKUPS https://confluence.epfl.ch:8443/display/EXHEB/Increase+a+Linux+Physical+Volume+Size+after+the+disk+size+has+been+changed+without+any+reboot - [x] Message d'annonce ? - [x] Backuper la VM avant !!! - [x] Numéro de version ## A faire et à tester en prod - [x] Enlever la duplication du userID 1: `DELETE FROM users WHERE id=1 and email='gregory.charmier@epfl.ch'` - [x] Vérifier que les redirections cut.epfl.ch et short.epfl.ch fonctionnent avec les adaptations dans Traefik - [ ] Checker si le E2EM fonctionne (e.g. downer postgres pour 5 minutes) ## Après la mise en prod - [x] Tagguer une version - [x] Enlever/fermer le change et l'outage - [x] Écrire aux utilisateurs ? - [x] Remercier HouHou ! - [x] Filer le rapport d'audit à Loïc ## Préparation du CHANGELOG https://gitlab.com/epfl-idevfsd/go-epfl/-/blob/b4009802abb865d8fae1c855f7d30f53de84d128/CHANGELOG.md 382c553 - Merge branch 'feature/final-try-react' into 'master' (ponsfrilus) 4aa8fd5 - Merge branch 'janitor/update-nginx-prometheus-exporter' into 'master' (ponsfrilus) f3556c7 - [update] prometheus-nginx-exporter update (Nicolas Borboën) dca04d8 - Merge branch 'master' into feature/final-try-react (Nicolas Borboën) cb65ff0 - [fix] Hidden checkbox in admin alias edition (Nicolas Borboën) 5d2416e - [feature] add "no-flags" info + formatting (Nicolas Borboën) 0f6325d - [feature] complete users list (Nicolas Borboën) db98202 - [feature] filter HTTP status code from API (Nicolas Borboën) bfa99f1 - [feature] add admin's home link (Nicolas Borboën) 25b2ce7 - [feature] filter alias without owners (Nicolas Borboën) ca62e7f - [feature] filter on aliases' owner (Nicolas Borboën) 1573b2a - [css] Update svg icon (Nicolas Borboën) 11b7d4d - [fix] full list of aliases when admin (hidden) (Nicolas Borboën) 933c63a - [ocd] (Nicolas Borboën) c1324fd - [feature] filter on «status» query string (Nicolas Borboën) d061ae5 - [fix] allow more path in admin route for react (Nicolas Borboën) a43a1e0 - [feature] split admin pages (Nicolas Borboën) 3860825 - Merge branch 'feature/final-try-react' of gitlab.com:epfl-idevfsd/go-epfl into feature/final-try-react (Grégory Charmier) caeb972 - [fix] check if token is null (Grégory Charmier) 2a841e9 - [update] Update npm packages (Nicolas Borboën) ec5efe0 - [feature] Laravel Admin is accessible to /admin-php (Grégory Charmier) 1dd7dfe - [clean] delete unused method (Grégory Charmier) 086d7ea - Merge branch 'master' into feature/final-try-react (Grégory Charmier) 67b8e14 - Merge branch 'fix/58-tootltip-popover' into 'master' (GregLeBarbar) 0cd16da - Merge branch 'feature/76-hits-details-in-API' into 'master' (GregLeBarbar) 1ade308 - [clean] Delete an unused file (Grégory Charmier) 42c16a2 - [config] Prettier to format js files (Grégory Charmier) 9056243 - [feature] Admin REST API improved (Grégory Charmier) 23fe907 - [feature] Admin backend reactified (Grégory Charmier) b51d097 - [fix] popover (Nicolas Borboën) 4538097 - [feature] add CSV exporter (Nicolas Borboën) aa1dca1 - [fix] add alias_id and go_url in LogResource (Nicolas Borboën) 5f643c5 - [refactor] Alias details in API (Nicolas Borboën) 29382bf - [refactor] API's clicks endpoint (Nicolas Borboën) 2772904 - [FT.] Add logs details in API (getClicks) (Nicolas Borboën) 81db16c - [HotFix] Truncated URL in profile (Nicolas Borboën) 9ede28b - [config] Define tabulations number for php and js (Grégory Charmier) bc46567 - [feature] Several improvements to the Rest API (Grégory Charmier) d54d474 - [feature] Several improvements to the admin area in React (Grégory Charmier) 3b14bb4 - [fix] Fix postgres version (Grégory Charmier) c2fe2d5 - Merge branch 'fix/100_useragents' into 'master' (ponsfrilus) ff83f1b - [fix] Hidden useragents now return `unknown` (Nicolas Borboën) b9438c6 - Merge branch 'fix/102_escape_dot_in_blacklist' into 'master' (ponsfrilus) 07088a6 - [fix] Dots and others specials chars was interpretated in the regex (Nicolas Borboën) 7a85c99 - Merge branch 'feature/telegram' into 'master' (ponsfrilus) bff1039 - [fix] Use HTML instead of Markdown (Nicolas Borboën) d0c8c47 - Merge branch 'security/audit-clean' into 'master' (ponsfrilus) d60e3df - [security] Ensure that redirect_uri has not been forged (Grégory Charmier) 9945336 - [security] encodeURI within datatable (Nicolas Borboën) da933fe - [security] limit the alias's allowed chars (Nicolas Borboën) 48d6cd8 - [security] fix alias length to 84 chars (Nicolas Borboën) 8cebc57 - [security] API token improvements (Grégory Charmier) a7266eb - [security] Hide PHP version in headers... (Nicolas Borboën) e60cd73 - [security] Use Secure Cookie by default (Nicolas Borboën) 04901f2 - [security] HSTS headers (Nicolas Borboën) 79c61ae - Merge branch 'fix/73-truncate-url' into 'master' (SaphireVert) e56f47d - [fix] avoid to spam the channel in not needed (Nicolas Borboën) bba0a0f - [fix] add `clear-compiled` to dumbfix (Nicolas Borboën) b259304 - [feature] Manage loading in User Blacklist (Grégory Charmier) 1167bd7 - [featue] add 'react-js-pagination' 'react-router-dom' 'jest' libraries (Grégory Charmier) a291cef - [feature] Add a temp template for react dev (Grégory Charmier) 4d8d807 - [test] Configure jest (Grégory Charmier) 94a12e5 - [feature] Extend API REST (Grégory Charmier) 150b664 - [feature] Implement Admin backoffice (Grégory Charmier) 47bafb8 - [feature] Makes it possible to work together React Router and Laravel Router (Grégory Charmier) 677b7d5 - [fix] truncated urls for profile's views (saphirevert) cb37924 - [update] postgresql to 13 in dev and workspace (Nicolas Borboën) 8bce7cd - [fix] cut.epfl.ch and short.epfl.ch redirection (Nicolas Borboën) ### What's New ? * Admins's backoffice rewritten in [React](https://reactjs.org/) * Fonts * TTL / Hidden popover * New API endpoints : * /clicks/{alias} → * /clicks/csv/{alias} → * go_twitter bot * Security fixes * E2EM ### Facts 97 new commits 1fdcf34 #98 Fix the search params → nombre de fichier ajouter, nombre de commits ? → stats nouveau liens/alias depuis la dernière mise à jour ? → stats globales ? ### Details ### What's next ? ### History commands from go-qual 2003 cd go-qual.epfl.ch 2004 ll 2005 git status 2006 git branch 2007 git diff 2008 git status 2009 git restore . 2010 git status 2011 rm docker/docker-compose-qual.yml.orig 2012 rm docker/nginx/ssl/ -rf 2013 git fetch 2014 git pull 2015 git fetch 2016 git checkout feature/final-try-react 2017 docker ps 2018 just down 2019 just pull 2020 just compose pull 2021 just build 2022 docker ps 2023 just fix-perms 2024 just up 2025 docker ps 2026 ll 2027 cd docker/monitoring 2028 cd ../ 2029 ls 2030 vim docker-compose-qual.yml 2031 just compose pull 2032 just up 2033 docker ps 2034 vim docker-compose-qual.yml 2035 just up 2036 docker ps 2037 just down uo 2038 just down up 2039 just npm i 2040 just npm run production 2041 just npm dumbfix 2042 just dumbfix 2043 git status 2044 git diff 2045 history TODO: update NPM in workspace ![](https://i.imgur.com/Il1FGFp.png) Recherche 404 dans les flags de l'admin montre des 503