tbnorth

Piwigo docker password reset

Most of the Piwigo password reset instructions assume you're familiar with MySQL or have access to phpAdmin. Here's how to reset a password in a docker deployment of Piwigo, without those assumptions.

1. Get the MD5 hash of the password you want to use

    echo -n password1234 | m5dsum

tbnorth

# compact docker ps
docker ps --format "table {{.ID}}\t{{.Image}}\t{{.Status}}\t{{.Names}}"

# *** START: MAINTENANCE ******************************

# remove non-running containers
docker rm $(docker ps -a -q -f status=exited -f status=dead)

# remove untagged images, selects column {2} (zero based) from lines starting with <none>
docker images | grep '^<none>' | sed -nE 's/^(\S+\s+){2}(\S+).*/\2/; p' | xargs docker image rm

tbnorth

# rebase "BRANCH" onto "MAIN", change these as needed
MAIN=main
BRANCH=tmp/docs

# should be no changed files before you start
[ -z "$(git status --porcelain --untracked-files=no)" ] || echo "Changed files in repo."
git checkout "$MAIN"
git pull
git checkout "$BRANCH" # before diff in case no local branch $BRANCH
git diff "$MAIN..$BRANCH"  # just to inspect

tbnorth

# "compound 'compound .compound but not <spac>compound or compounds
cexpr system("find PATH -name \\*.py | xargs grep -n [.\\'\\\"]compound\\\\b")

# get list of files from a broken session
sed -n '/^cd / p; /^badd / {s/^badd [^ ]* //; H}; $ {x; s/\n/ \\\n/g; p}' /path/to/sessionfile.vim
# some paths will be relative to a folder, this prints the command to cd to the folder first

tbnorth

# i3 config
bindsym XF86MonBrightnessUp exec /home/tbrown/bin/undim # increase screen brightness
bindsym XF86MonBrightnessDown exec /home/tbrown/bin/dim # decrease screen brightness
# /home/tbrown/bin/undim
LVL=$(cat /sys/class/backlight/intel_backlight/brightness)
LVL=$(((LVL+20)%648))
echo $LVL >/sys/class/backlight/intel_backlight/brightness
# dim as above but -20
# check /sys/class/backlight/intel_backlight/max_brightness for % term
# sudo chown a+rw /sys/class/backlight/intel_backlight/brightness

tbnorth

#! /usr/bin/env python
"""
Show git status of all files in folder recursively.

Looks at files git status ignores because they're in
folders with no tracked files.

Handles nested repos.
"""

tbnorth

backtick 1 60 60 date -d-1hour +%H:%M
caption always
caption string "%{gk}%-w%{= ky}%45>*%t%{-}%+w%<"
# leave the above in so install_env doesn't re-add it
caption string "%{gk}%1` %-w%{= ky}%45>%t%{-}%+w%<"

# screen bash
shell "/usr/bin/bash"

# bind ^a^c screen bash

tbnorth

# change these bits then run the script to generate the SQL, e.g.
#   <edit file>
#   <save file>
#   bash uniqify.sql.sh >fix_mytable.sql
# then execute the SQL line by line checking the results, preferably in
# a transaction you can roll back or a copy of the DB

# START OF THINGS TO CHANGE

# the table containing duplicates

tbnorth

"""
docstrings.py - show docstrings for .py files

Terry N. Brown terrynbrown@gmail.com Tue Aug 20 16:25:39 EDT 2019
"""

import argparse
import ast
import os
from functools import reduce

tbnorth

First thing you usually see is a message like this when you try and push:

TBrown02@LZ2626XTBROWN02 MINGW64 /r/conflictdemo2 (master)
$ git push
To https://github.com/tbnorth/conflictdemo.git
 ! [rejected]        master -> master (fetch first)
error: failed to push some refs to 'https://github.com/tbnorth/conflictdemo.git'
hint: Updates were rejected because the remote contains work that you do
hint: not have locally. This is usually caused by another repository pushing