(Source) A few steps: sudo apt-get install software-properties-common dirmngr wget -qO – https://mariadb.org/mariadb_release_signing_key.asc | sudo apt-key add – nano /etc/apt/sources.list.d/mariadb.list In mariadb.list we add the two below lines: deb [arch=amd64,i386,ppc64el] http://mirror.23media.de/mariadb/repo/10.4/debian stretch main deb-src http://mirror.23media.de/mariadb/repo/10.4/debian stretch main Then: apt-get update apt-get install mariadb-server
Étiquette : Niveau expert
Sharepoint REST API to index a column or delete a column and more…
Due to the 5,000 items threshold limitation it can become very frustrating to administrate Sharepoint. For example, if your list has more than 5,000 items, you cannot add an index, delete a lookup/people column, delete the list or the website, and more ! Hopefully some of the operations can be done with REST API, and […]
Create a self-signed certificate for localhost testing with IE11 and Webpack
Sources: https://stackoverflow.com/questions/44988163/create-self-signed-certificate-for-testing-localhost-and-have-it-accepted-by-the http://woshub.com/how-to-create-self-signed-certificate-with-powershell/ https://stackoverflow.com/questions/4691699/how-to-convert-crt-to-pem/4691749#4691749 https://webpack.js.org/configuration/dev-server/#devserver-https If you develop with Webpack under Windows and you want to open your localhost server in HTTPS with IE11 you may receive a message like : « Content was blocked because it was not signed by a valid security certificate. » Below I explain the steps to make it work with IE11: […]
Remove custom properties/metadata for an Office document [javascript]
I have this document library on Sharepoint where I have one custom column called Metadata and that is a lookup to another list on my Sharepoint. When the users download an Office document from this library and then re-upload it we could have the below error message: There is at least one lookup column that […]
How to delete a document locked by another user in Sharepoint using JavaScript
When you open a file from Sharepoint, it will receive a short term lock that will prevent others to change some properties on the file. This protection can be useful, but also very annoying, for example when the file is not closed properly, then the lock could stay « forever ». There are many posts on the […]
Create an Unpublished Content view for the masterpage galery [Sharepoint]
With Sharepoint 2013 I wanted an easy way to list of the pages in my masterpage galery that haven’t been published yet. You first need to Create a new view named Unpublished Content. You can sort by Name, and scroll down to the Folders settings and choose Show all items without folders. We now have […]
Capture HTTP(S) traffic from Android using a sniffer
I wanted to debug an Android app that uses HTTPS requests with a JSON API. Thanks to this article I’ve been able to use my Windows 10 computer to get all the network from my Android phone thru my local network and decode the HTTPS requests ! I’m going to summarize the steps from the […]
Mise à jour d’un serveur Kimsufi (OVH) depuis Debian 7.10 (Wheezy) vers Debian 8 (Jessie) [Linux]
Il faut régulièrement penser à mettre à jour son serveur Kimsufi. Je vais essayer d’expliquer brièvement les étapes à suivre pour cela. On va d’abord sauvegarder les données : mkdir /root/svg_special; cp -R /var/lib/dpkg /root/svg_special/; cp /var/lib/apt/extended_states /root/svg_special/; dpkg –get-selections « * » > /root/svg_special/dpkg_get_selection; cp -R /etc /root/svg_special/etc Ensuite il est conseillé d’utiliser screen pour pouvoir […]
Passer son serveur Apache en HTTPS avec Let’s Encrypt
Je vais expliquer les différentes étapes pour passer un serveur Apache en HTTPS grâce à Let’s Encrypt. Toutes les opérations vont se passer dans une console sur le serveur Linux en mode root. J’utilise ici une Debian 7.10 « Wheezy ». Je me suis aidé de cet article en anglais. Commencer par nettoyer le contenu […]
Mise à jour mysql 5.5 vers 5.6, sur Debian Wheezy
1) Nouveau repo On crée d’abord le fichier /etc/apt/sources.list.d/mysql.list avec les deux lignes ci-dessous : deb http://repo.mysql.com/apt/debian/ wheezy mysql-5.6 deb-src http://repo.mysql.com/apt/debian/ wheezy mysql-5.6 2) Clé publique du repo On crée un fichier mysql.key dans lequel on copie/colle la clé publique de mysql. Puis on l’ajoute à apt : apt-key add mysql.key 3) Export / Backup […]