williamdes

#!/bin/sh

# Source: https://gist.github.com/williamdes/7a63ba6af24ea91edaf988ba8078b0fa

set -eu

if [ -z "${1:-}" ]; then
  echo "Missing the domain name to add"
  echo "Use: ~/add-cert.sh mynewdomain.tld"
  echo "To add multiple domains you can use: ~/add-cert.sh \"mynewdomain.tld -d www.mynewdomain.tld\""

williamdes

PHP Socket client server example

With this example you will be able to use modern PHP code and have multiple clients connected.

The code is inspired and sourced from the of the posted notes here.

If you CTRL-C stopped the server, run the script twice. The first time will clean up the left over socket. Or just remove the socket file before starting the server.

There is a "magic" command (STOP) in the code to stop the server, you can easily remove it.

williamdes

How to use

$ docker compose -f acmesh.yaml up -d

.env

ACME_HOME_DIR=./acme.sh

williamdes

Signing a key

NB: to list keys: gpg --list-keys

If you have the key, delete it

gpg --delete-key keyIDhereReplaceMe

Fetch it

gpg --keyserver keys.gnupg.net --recv-keys keyIDhereReplaceMe

williamdes

-- Comments from: https://marmelab.com/blog/2017/01/09/sirene-import-sql.html
CREATE TABLE sirene_data (
    `siren` INT(9) UNSIGNED NOT NULL COMMENT "Identifiant de l’entreprise",
    `nic` SMALLINT(5) UNSIGNED NOT NULL COMMENT "Numéro interne de classement de l'établissement",
    `siret` BIGINT(10) UNSIGNED NOT NULL PRIMARY KEY COMMENT "Identifiant de l’entreprise",
    `statutDiffusionEtablissement` ENUM('O') NOT NULL COMMENT "Statut de diffusion de l’établissement",
    `dateCreationEtablissement` VARCHAR(10) NOT NULL COMMENT "Date de création de l’entreprise",
    `trancheEffectifsEtablissement` ENUM('NN', '00', '01', '02', '03', '11', '12', '21', '22', '31', '32', '41', '42', '51', '52', '53') NOT NULL COMMENT "Tranche d’effectif salarié de l’établissement",
    `anneeEffectifsEtablissement` VARCHAR(4) NOT NULL COMMENT "Année de validité de la tranche d’effectif salarié de l’établissement",
    `activitePrincipaleRegistreMetiersEtablissement` VARCHAR(6) NOT NULL COMMENT "Activité exercée par l’artisan 

williamdes

#!/bin/bash

# git: Having a branch/tag with the same name (error: dst refspec matches more than one.)
# run git branch --all and use a text editor to create a batch of commands
git tag -m "[imported from branch]" --force --sign "release/2019-09-10-1" $(git show-ref --hash "refs/remotes/origin/release/2019-09-10-1")

# https://markhneedham.com/blog/2013/06/13/git-having-a-branchtag-with-the-same-name-error-dst-refspec-matches-more-than-one/

# Delete ref from remote
git push origin :"refs/heads/release/2019-09-10-1"

williamdes

Keybase proof

I hereby claim:

• I am williamdes on github.
• I am williamdes (https://keybase.io/williamdes) on keybase.
• I have a public key whose fingerprint is C4D9 1FDF CEF6 B4A3 C653 FD78 90A0 EF1B 8251 A889

To claim this, I am signing this object:

williamdes

phpMyAdmin install/upgrade/reinstall (last released version)

Supports :

• install
• upgrade

Keeps your config !

TLDR / Short mode

Uses default arguments !

williamdes

#!/bin/sh
export PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin":$PATH
#echo $PATH
INPUT_PORTS="22,21,20,80,443,3306,8006"
FORWARD_PORTS="3306,80,443,8080"
cd /sbin/
echo "[IpTables] Reset..."
sleep 1
iptables -F
iptables -X

williamdes

#!/bin/bash

#
# Docker OR OPENVPN rules
#

#Reset rules
iptables -F
iptables -X
iptables -t nat -F