Skip to content

Instantly share code, notes, and snippets.

View clemlesne's full-sized avatar

Clémence Lesné clemlesne

View GitHub Profile
@clemlesne
clemlesne / gist:804e26c1ff06184dc04328b39b20cc87
Created December 19, 2017 15:00
Change root password with MariaDB
To begin, stop the database service and check the service status:
------------- SystemD -------------
# systemctl stop mariadb
------------- SysVinit -------------
# /etc/init.d/mysqld stop
Next, start the service with --skip-grant-tables:
------------- SystemD -------------
@clemlesne
clemlesne / tips.md
Last active March 19, 2019 15:25
Proper permissions for web server's directory

First, fix the owners :

sudo chgrp -R www-data .

Then, fix the access permissions :

For read-only folders :

sudo find . -type f -exec chmod 0460 {} \;
@clemlesne
clemlesne / pod-dummy.yaml
Created May 20, 2021 08:43
Dommy Kubernetes pod
apiVersion: v1
kind: Pod
metadata:
name: dummy
labels:
env: test
spec:
containers:
- name: dummy
image: busybox
@clemlesne
clemlesne / wipe-timestream.sh
Last active August 2, 2021 10:35
Wipe AWS Timestream database plus tables
#!/bin/sh
#
# Wipe all tables contained into a AWS Timestream database.
# Usage: wipe-timestream.sh -d [my-db]
#
# TODO: Iterate through the AWS pagination for getting more than 20 tables per script exec
#
usage() {
@clemlesne
clemlesne / import-notion.py
Last active December 21, 2022 15:28
Import Google Keep notes to Notion
import csv
import gkeepapi
import keyring
import os
import re
import urllib.request
import uuid
from datetime import datetime
from notion.block import PageBlock, TextBlock, TodoBlock, BulletedListBlock, NumberedListBlock, ImageBlock

Keybase proof

I hereby claim:

  • I am clemlesne on github.
  • I am clemlesne (https://keybase.io/clemlesne) on keybase.
  • I have a public key ASBlF7TJcpKNuCwtGSzT_bXPdby5s6-pseUdgxO1N-XS5go

To claim this, I am signing this object:

#!/bin/bash
set -e
ARCH_AMD64="${ARCH_AMD64:-x64}"
ARCH_ARM32="${ARCH_ARM32:-arm}"
ARCH_ARM64="${ARCH_ARM64:-arm64}"
SYS_ARCH="$(arch)"
if [[ $SYS_ARCH == x86_64 ]]; then
@clemlesne
clemlesne / aks_log_consumption.md
Last active July 20, 2023 14:57
Extract Azure Monitor consumption by Azure Kubernetes Service Pod labels

Run this command against your Azure Monitor logs:

ContainerLog
  | where TimeGenerated >= ago(360d)
  | project TimeGenerated, ContainerID, _BilledSize
  | lookup kind=leftouter (
      KubePodInventory
        | where TimeGenerated >= ago(360d)
 | sort by TimeGenerated desc
@clemlesne
clemlesne / openai.svg
Created August 31, 2023 08:49
OpenAI SVG icon
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@clemlesne
clemlesne / strip.py
Created September 18, 2023 17:05
Takes a raw string of HTML and removes all HTML tags, Markdown tables, and line returns.
from typing import Optional
import re
import html
def sanitize(raw: Optional[str]) -> Optional[str]:
"""
Takes a raw string of HTML and removes all HTML tags, Markdown tables, and line returns.
"""
if not raw: