https://wiki.famille-ducret.fr/ 2026-06-04T19:25:43+00:00 https://wiki.famille-ducret.fr/ https://wiki.famille-ducret.fr/lib/tpl/dokuwiki/images/favicon.ico text/html 2023-09-28T12:26:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=admin-sys-utils&rev=1695904007&do=diff Se connecter avec le compte www-data su - www-data -s /bin/bash text/html 2024-02-12T15:28:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=bash&rev=1707751711&do=diff #!/bin/bash Stocker le résultat d'une commande var=$(ls /); echo $var; Fonctions function bonjour { # ne pas oublier espace avant { echo 'bonjour' } bonjour # appel de la fonction Fonction paramètres function ecrire { echo "$1 $2" } ecrire 'toto' 'tata' text/html 2023-09-28T12:26:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=commandes-courantes&rev=1695904007&do=diff Commandes courantes Décompresser un fichier tar tar xzf nom_du_fichier.tar.gz Compresser un fichier tar cvzf nom_archive.tgz mon_repertoire text/html 2023-09-28T12:26:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=divers-apache-redirect-ip&rev=1695904007&do=diff Dans le Vhost ErrorDocument 403 /maintenance.html <Directory /var/www/moodle-310> allow from 172.16.7.0/24 allow from 172.16.226.0/24 allow from 172.30.1.242 deny from all </Directory> Et bien sûr, mettre la page maintenance.html à la racine du serveur text/html 2023-09-28T12:26:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=divers-create-mysql&rev=1695904007&do=diff CREATE DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON database.* TO 'newuser'@'localhost'; Recharger les droits FLUSH PRIVILEGES; text/html 2023-09-28T12:26:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=divers-venv&rev=1695904007&do=diff Se connecter à la maison en python 3.5 source python-projects/python3-env/bin/activate text/html 2023-09-28T12:26:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=divers-www-data&rev=1695904007&do=diff su - www-data -s /bin/bash Ne pas oublier de se repositionner dans le bon repertoire text/html 2023-09-28T12:26:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=docker-commandes&rev=1695904007&do=diff Commandes Affiche toutes les images présentes docker images Chercher les images docker dans le repository qui contiennent “Debian” et qui ont au moins 10 étoiles docker search --stars=10 debian Télécharger l'image du repository en local text/html 2023-09-28T12:26:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=ead-annualisation&rev=1695904007&do=diff Exporter la liste des cours à dupliquer select id,shortname,fullname,visible from mdl_course where shortname LIKE '%[21-22]%' INTO OUTFILE '/tmp/export-courses.csv' FIELDS ENCLOSED BY '"' TERMINATED BY ';' ESCAPED BY '"' LINES TERMINATED BY '\r\n'; text/html 2023-09-28T12:26:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=ead-installation&rev=1695904007&do=diff mettre ssl a2enmod ssl Reécriture d'URL a2enmod rewrite Installer Shibboleth apt-get install libapache2-mod-shib a2enmod shib text/html 2023-09-28T12:26:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=ead-migration&rev=1695904007&do=diff EAD - Migration Shibboleth Installer Shibboleth apt-get install libapache2-mod-shib2 Editer fichier de config /etc/shibboleth/shibboleth2.xml Tester service shibd restart Dans /etc/apache2/sites-availables : <Directory /var/www/ead/moodle/auth/shibboleth/index.php> AuthType shibboleth ShibRequestSetting requireSession 1 Require valid-user </Directory> <Directory /var/www/ead/moodle/auth/shibboleth/logout.php> AuthType shibboleth ShibRequireSession Off … text/html 2023-09-28T12:26:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=eportfolio-installation&rev=1695904007&do=diff CREATE DATABASE mahara CHARACTER SET utf8mb4 CREATE USER 'mahara'@'localhost' IDENTIFIED BY 'A74f!7r'; GRANT ALL PRIVILEGES ON mahara.* TO 'mahara'@'localhost' IDENTIFIED BY 'A74f!7r'; Attention ne pas mettre de collation text/html 2023-09-28T12:26:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=eportfolio-todo&rev=1695904007&do=diff Paquet de lang text/html 2023-09-28T12:26:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=fazer&rev=1695904007&do=diff Fazer Monter Fazer mount -t cifs -o username=aducret,rw,iocharset=utf8,file_mode=0777,dir_mode=0777 //fazer2.univ-lemans.fr/prn$ /media/partage text/html 2024-02-23T16:29:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=git-commandes-courantes&rev=1708705764&do=diff GIT Installer dépot sur ordinateur "central" $ mkdir projet.git $ cd projet.git $ git --bare init Envoyer ses sources sur le depot distant $ cd cartographie $ git init $ git add . $ git commit -m 'premiere validation' $ git remote add origin root@adam.univ-lemans.fr:/home/prn.git $ git push origin master text/html 2023-09-28T12:26:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=git-commandes-gitlab&rev=1695904007&do=diff git commit -am “Commit du 09052022 Soir” git push -uf origin main text/html 2023-09-28T12:26:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=install-pip&rev=1695904007&do=diff Installer PIP Créer un environnement virtuel python3.6 -m venv env --without-pip Activer l'environnement virtuel source env/bin/activate Installer pip pour cet environnement curl https://bootstrap.pypa.io/get-pip.py | python3 text/html 2024-01-09T13:29:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=installation-serveur&rev=1704806988&do=diff Installer les clefs publiques Créer des alias /root/.bashrc Installer zip apt install zip apt install unzip Installer apache apt install apache2 Installer PHP apt -y install php php-common Installer principales librairies PHP apt -y install php-cli php-fpm php-json php-pdo php-mysql php-zip php-gd php-mbstring php-curl php-xml php-pear php-bcmath text/html 2025-10-09T15:24:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=jetty&rev=1760023471&do=diff Répertoire Jetty : /usr/share/jetty9/ redemarrer jetty : java -jar start.jar Liste des certifs : LC_ALL=C keytool -list -keystore /etc/jetty9/keystore text/html 2023-09-28T12:26:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=manip-text-ajout-fin-debut&rev=1695904007&do=diff text/html 2023-09-28T12:26:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=moodle-dump&rev=1695904007&do=diff mysqldump -uroot -paStr45?c moodle --max_allowed_packet=2048M --ignore-table=moodle.mdl_logstore_standard_log --ignore-table=moodle.mdl_notifications --ignore-table=moodle.mdl_question_attempts --ignore-table=moodle.mdl_question_attempt_step_data --ignore-table=moodle.mdl_question_attempt_steps> /home/backup-13042022.sql text/html 2023-09-28T12:26:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=moodle-moosh-install&rev=1695904007&do=diff Télécharger archive wget https://moodle.org/plugins/view.php?id=522 Dézipper et se placer dans le repertoire du zip ln -s $PWD/moosh.php /usr/bin/moosh unlink /usr/bin/moosh text/html 2024-03-22T12:20:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=moodle-nettoyage-requete&rev=1711110029&do=diff Cours qui n'existent plus mais referencés dans table des logs SELECT DISTINCT courseid FROM mdl_logstore_standard_log WHERE courseid NOT IN (SELECT DISTINCT id FROM mdl_course); Effacage des cours qui n'existent plus mais referencés dans table des logs text/html 2023-09-28T12:26:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=moodle-requete-doublons&rev=1695904007&do=diff Doublons SELECT id,COUNT(*) AS nbr_doublon,FROM_UNIXTIME(timecreated), username,lastname,firstname,auth FROM mdl_user GROUP BY trim(username) HAVING COUNT(*) > 1; text/html 2024-02-13T15:02:54+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=moodle-requete-fusion&rev=1707836574&do=diff Cours sans enseignants SELECT c.id,c.shortname,c.fullname,FROM_UNIXTIME(c.timecreated),FROM_UNIXTIME(c.timemodified) FROM mdl_course AS c WHERE (SELECT COUNT(mdl_role_assignments.id) FROM mdl_role_assignments INNER JOIN mdl_context ON mdl_role_assignments.contextid = mdl_context.id WHERE mdl_role_assignments.roleid = 3 AND mdl_context.contextlevel = 50 AND mdl_context.instanceid = c.id) = 0 ORDER BY c.timemodified ASC; text/html 2023-09-28T12:26:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=moodle-requete&rev=1695904007&do=diff Requêtes utiles Les cours sur lesquels est inscrit un utilisateur avec son rôle dans le cours SELECT c.id, c.shortname, c.fullname, u.id, u.username, u.firstname, u.lastname, r.shortname as 'role' From mdl_user as u join mdl_user_enrolments ue on ue.userid=u.id AND u.id=18434 join mdl_enrol en on ue.enrolid=en.id join mdl_role_assignments ra on u.id=ra.userid join mdl_role r on ra.roleid=r.id join mdl_context cx on cx.id = ra.contextid and cx.contextlevel = 50 JOIN mdl_course c ON c.id = cx… text/html 2023-09-28T12:26:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=mount-fazer&rev=1695904007&do=diff mount -t cifs fazer2.univ-lemans.fr/prn$ /media/ -o username=aducret,domain=CRI text/html 2024-11-18T14:12:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=probleme-proxy&rev=1731939158&do=diff Forcer à utiliser http au lieu de https: export https_proxy='<http://username:password@87.248.188.202:8080>' text/html 2024-02-23T16:03:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=sed&rev=1708704218&do=diff Remplacer “mdl_user” par “mdl_user1” sed -i -e "s/mdl_user/mdl_user1/g" /tmp/user-1.sql text/html 2025-10-09T15:22:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=start&rev=1760023353&do=diff * PRN * Moodle * Requêtes Utiles * Doublons * Fusion * Dump rapide * Moosh * Moosh Installation * Nettoyage * Requete * Umtice * EAD * Migration * Installation * Annualisation * Umotion * Divers * Eportfolio * Installation * Todo * Scenari server * Admin Sys * Utils * Fazer * Nouveau Serveur * Debian * Commandes courantes * Python * text/html 2023-09-28T12:26:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=umotion-divers&rev=1695904007&do=diff Redémarrer le service service uwsgi-pod restart text/html 2023-09-28T12:26:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=vim&rev=1695904007&do=diff i inserer avant le curseur A inserer fin de ligne dw efface à droite du mot d2w efface 2 mots dd efface la ligne compléte d$ effacer jusqu'a la fin de la ligne 2w se deplacer de 2 mots curseur en début 3e se deplacer de 3 mots curseur à la fin text/html 2024-06-18T14:28:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.famille-ducret.fr/doku.php?id=visual-code&rev=1718720923&do=diff sudo code --verbose --user-data-dir --no-sandbox