davidalger

There is currently no pre-built package available for the php sodium ext currently. And due to the changes made to the EL 8 packaging system, IUS no longer plans to maintain any packages for EL 8 (alternate versions of packages such as PHP should eventually become available via additional module streams published in the AppStream repo) so it's not available via IUS either beyond EL 7.

Magento will fallback on sha256 for password hashes when sodium is unavailable:

public function getLatestHashVersion(): int
{
    if (extension_loaded('sodium') && defined('SODIUM_CRYPTO_PWHASH_ALG_ARGON2ID13')) {
        return self::HASH_VERSION_ARGON2ID13;
    }

return self::HASH_VERSION_SHA256;

davidalger

list listening ports

sudo lsof -nP -iTCP -sTCP:LISTEN
sudo netstat -plunt

flush DNS on Mojave

sudo killall -HUP mDNSResponder

immediately sleep displays

davidalger

Enable macOS Server Performance Mode

Performance mode changes the system parameters of your Mac. These changes take better advantage of your hardware for demanding server applications.

A Mac with macOS Server that needs to run high-performance services can turn on performance mode to dedicate additional system resources for server applications. Note, however, that performance mode can be enabled even without macOS Server being installed to achieve similar benifits for other high-performance services.

sudo nvram boot-args="serverperfmode=1 $(nvram boot-args 2>/dev/null | cut -f 2-)"
sudo reboot

Reference: https://support.apple.com/en-us/HT202528.

davidalger

#cloud-config
packages:
  - epel-release    # required for jq installation to succeed

write_files:
  - path: /usr/local/bin/mount-scratch-disks
    owner: root:root
    permissions: '0700'
    content: |
      #!/bin/bash

davidalger

Install Docker on Fedora

Ref: https://docs.docker.com/install/linux/docker-ce/fedora/

sudo dnf -y install dnf-plugins-core

sudo dnf config-manager \
  --add-repo \
  https://download.docker.com/linux/fedora/docker-ce.repo

davidalger

#!/usr/bin/env bash
# usage: put at /usr/local/bin/magento then call from anywhere within a magento 2 webroot
# 

dir="$(pwd)"
while [[ "$dir" != "/" ]]; do
    if [[ -x "$dir/bin/magento" ]]; then
        "$dir/bin/magento" "$@"
        exit $?
    fi

davidalger

SET @utc_offset = 6;

-- Orders Per Year --
SELECT period_date, CONCAT("UTC-", @utc_offset) AS utc_offset, order_count, gross_revenue, ROUND(gross_revenue / order_count, 2) AS gross_aov
FROM (
    SELECT
        COUNT(*) AS order_count,
        ROUND(SUM(base_grand_total), 2) AS gross_revenue,
        date_format(date_sub(o.created_at, INTERVAL @utc_offset HOUR), "%Y") AS period_date
    FROM sales_order o

davidalger

Where SSH is available, this is probably the more simple and definitely more secure option

• Create admin user on the server-side (root is typically dissallowed by default)

  useradd -G wheel davidalger
  passwd davidalger
  

• Connect from the client-side via SSH

davidalger

Setup memory log on php-fpm pool

1. Added the following to /usr/local/lib/strangecode_php_memory_log.php

    <?php
    function strangecode_php_memory_log()
    {
        $current = memory_get_usage() / 1024 / 1024;
        $peak = memory_get_peak_usage() / 1024 / 1024;
   

$uri = $_SERVER['REQUEST_URI'] ?? 'n/a';

davidalger

List evicted pods

kubectl get pods --all-namespaces -o json \
  | jq -r '.items[] | select(.status.reason == "Evicted") | "pod/\(.metadata.name) -n \(.metadata.namespace)"'

Delete evicted pods