williamdes

/**
 * @source https://github.com/errwischt/stacktrace-parser/blob/9b2d5b6114e7a3b3596f7092f0d1160738125374/src/stack-trace-parser.js
 * @copyright Copyright (c) 2014-2019 Georg Tavonius
 * @license MIT
 * This is the same code but only with removed parsing for all browsers or JS platforms else than NodeJS
 */
const StackTraceParser = {
    UNKNOWN_FUNCTION: '<unknown>',

    /**

williamdes

phpMyAdmin install/upgrade/reinstall (last released version)

Supports :

• install
• upgrade

Keeps your config !

TLDR / Short mode

Uses default arguments !

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

//FROM
//https://stackoverflow.com/a/34571089/5155484

typedef unsigned char uchar;
static const std::string b = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/";//=
static std::string base64_encode(const std::string &in) {
    std::string out;

    int val=0, valb=-6;
    for (uchar c : in) {

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/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

/**
 * Get fingerprint from a certificate in android.content.pm.Signature
 * @return String fingerprint that contains the SHA-256 digest
 */
private static String getFingerprint(android.content.pm.Signature ce){
    String certificate = "";
    InputStream input = new ByteArrayInputStream(ce.toByteArray());

    CertificateFactory cf = null;
    try {

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

#!/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"