Project

General

Profile

Actions

Chapter 9 of the dmz-web documentation · headings are numbered like the cheat sheets · index: Wiki

Version history of dmz-web-podman-cheatsheet.md (this wiki's single-file source) and the scripts in dmz-web-deploy. Git tags: cheatsheet-<version>.

9.1 Cheat sheet

Version Date Status Commit / tag Changes
1.26 2026-11-04 Latest commit:5e845b6 · cheatsheet-1.26 PF app 1.1.16: accounts (Midas, DenizBank, Binance …) on every line; Midas Kripto statements; moves between Midas accounts and from your own PF accounts are transfers; a holding's Total return counts the cash it was paid from; withholding and fees from the cash are costs; linked trades take the statement's quantity. pf-upgrade.sh 1.3 (--pull=newer), pf-install.sh 1.17, pf-mgmt-cheatsheet.md 1.20, host cheat sheet 1.26. Image: Debian security updates, pip pinned. Schema: transactions.account, source value cost
1.25 2026-11-03 Superseded commit:ec2cb64 · cheatsheet-1.25 PF app 1.1.15: Midas statements (USD and TL accounts as cash accounts in PF, trades paid from that cash, dividends and reinvestments as Midas booked them, hand-typed trades linked, holdings and cash checks), server messages in Turkish, By group lines on the wealth chart, period percentage over the money at work, prices refreshed every 15 minutes with their day, tax withheld by market. pf-install.sh 1.16, pf-mgmt-cheatsheet.md 1.19, host cheat sheet 1.25. Schema: source value broker, six columns; new package pypdf
1.24 2026-11-03 Superseded commit:ef2c95b · cheatsheet-1.24 PF app 1.1.14: Gain by group under the wealth chart (same period buttons; share of wealth, price part, gain with the currency, currency effect), deposit renewals are internal transfers (Money invested no longer inflated), funds published with price 0 no longer break risk / analysis (Request failed on the Portfolio page), Turkish dotted İ in symbols, .IS symbols are stocks. pf-upgrade.sh 1.2, pf-install.sh 1.15, pf-mgmt-cheatsheet.md 1.18, host cheat sheet 1.24. No schema change
1.23 2026-11-03 Superseded commit:8d62289 · cheatsheet-1.23 PF app 1.1.13: one currency on the trade form (the instrument's currency comes from the price source), market price in the chosen currency, refetch / conversion when the currency or date changes, prices rounded to 8 decimals; costs at the rate of their own day (and the exact amount paid when typed in the display currency), currency effect, Bonus (received free: income, not money paid in), currency correction of an instrument; languages (English, Turkish; strings.csv) and the administrators' Labels page. pf-install.sh 1.14, pf-mgmt-cheatsheet.md 1.17, tools/build-release.sh 1.1, host cheat sheet 1.23. Schema: table ui_labels, columns users.language, transactions.paid_currency / paid_amount, source value bonus
1.22 2026-11-02 Superseded commit:25d3ebb · cheatsheet-1.22 PF app 1.1.12: the login survives a reload (HttpOnly refresh cookie with rotation, 12 h idle / 7 days, every login ends on log out, password / 2FA change, reset, deactivation; schema: table auth_refresh, column users.sessions_valid_after). deploy-publish.sh 1.6: plan first (repo, notes, checksums, wiki, PF upgrade dry run, tidy), one question, then everything including the PF upgrade; amends: for corrected notes; commit:@@TAG:…@@ in wiki pages. pf-upgrade.sh 1.1 (sha256 from releases/CHECKSUMS.txt, pg_dump notice named, old tarballs moved out of /root, TimescaleDB restore in the rollback lines). New tools/build-release.sh. pf-install.sh 1.13, pf-mgmt-cheatsheet.md 1.16, host cheat sheet 1.22; notes of 1.20 and 1.21 corrected. The running 1.5 script installs 1.6 itself (no manual step)
1.21 2026-11-02 Superseded commit:2f1d8ca · (no tag: the host cheat sheet stayed 1.20) PF app 1.1.11: Price currency selector on the Trades form and the holding Edit row, Get market price in the chosen currency; pf-mgmt-cheatsheet.md 1.15. Its pf-install.sh was a stale 1.2 copy, refused by deploy-publish.sh (the repo kept 1.12); the app was installed with pf-upgrade.sh (unit commit 002a480)
1.20 2026-11-02 Superseded commit:5aa1102 · cheatsheet-1.20 PF app 1.1.10 (remove an unused instrument and change its type, BTC as crypto opens BTC-USD, statement preview warns about hand-typed lines inside the period, left-aligned weight labels; no schema change) and deploy-publish.sh 1.5 (package sha256 printed and checked with -s, release notes copied to releases/, releases/CHECKSUMS.txt); host cheat sheet 1.20, Git_Workflow §3.1.7; pf-install.sh 1.12, pf-mgmt-cheatsheet.md 1.14; notes of releases 1.13–1.19 in the repo. A newer script inside a package is installed by the running one; for 1.4 → 1.5 one manual install (see releases/Release-1.20-and-PF-1.1.10.md)
1.19 2026-11-01 Superseded commit:a6e532a · cheatsheet-1.19 PF app 1.1.9: About window (version in the top bar), "Connection timeout: please try later" message, Market study fixed for Turkish funds (TEFAS has no high/low: ATR error); pf-install.sh 1.11, pf-mgmt-cheatsheet.md 1.13. No schema change
1.18 2026-10-31 Superseded commit:ee0055f · cheatsheet-1.18 PF app 1.1.8: bank statement import (overnight-sweep and term-deposit accounts; .xlsx, .xls, .csv), Interest by month with the yearly rate in the account's currency and in USD, price currency on trades, crypto symbols tried as -USD, price-source calls retried when the connection drops; pf-install.sh 1.10, pf-mgmt-cheatsheet.md 1.12. Schema: 2 new columns on transactions (back up first); new dependency xlrd
1.17 2026-10-31 Superseded commit:fc0af9e · cheatsheet-1.17 pf-install.sh 1.9 (app image 1.1.7), which release 1.16 did not carry because its version header still read 1.8. No other change
1.16 2026-10-31 Superseded commit:a42cd30 · cheatsheet-1.16 PF app 1.1.7: deposits with yearly rate and days, automatic interest and renewal at maturity, dollar-pegged currencies (QAR, SAR, AED, ...), Update balance; pf-mgmt-cheatsheet.md 1.11. Schema: 3 new columns on transactions (back up first)
1.15 2026-10-31 Superseded commit:a8bd5b2 · cheatsheet-1.15 deploy-publish.sh --status (§3.1.7; deploy-publish.sh 1.4): read-only overview of what is published, installed and waiting, incl. the PF image in the unit and the running one. No application change
1.14 2026-10-31 Superseded commit:56ebe4d · cheatsheet-1.14 PF app 1.1.6: interactive Market study (price, RSI, MACD on one axis; per-day read-out with the rules, score and suggestion of that day; your trades on the price line; how-to-read guide), coloured trend labels; pf-install.sh 1.8, pf-mgmt-cheatsheet.md 1.10
1.13 2026-10-31 Superseded commit:8e53cb8 · cheatsheet-1.13 New §5.7: as-web (command or shell as websvcmaster from the root shell) and pf-upgrade.sh (PF application upgrade in one asked-step-by-step run); deploy-publish.sh 1.3 knows both; pf-mgmt-cheatsheet.md 1.9. No application change
1.12 2026-10-31 Superseded commit:3c2ff84 · cheatsheet-1.12 PF app 1.1.5: Holding page with a My position card, amounts in the asset's own currency, explained unrealized/realized P/L, left-aligned description columns; pf-install.sh 1.7, pf-mgmt-cheatsheet.md 1.8
1.11 2026-10-31 Superseded (never committed on its own — shipped inside 1.12) · cheatsheet-1.11 Every heading numbered (chapter, section, subsection: 3, 3.1, 3.1.7) in the cheat sheets and the wiki pages; wiki index with a Chapter column, a chapter line and an automatic table of contents on the long pages; the Git chapter letters A to F are now 3.1.2 to 3.1.7; PF is chapter 8, Releases chapter 9; cross-references updated; the Health Check page carries the go-live checklist (6.1). pf-install.sh 1.6, pf-mgmt-cheatsheet.md 1.7. No application change.
1.10 2026-10-31 Superseded commit:438872a · cheatsheet-1.10 PF app 1.1.4: splits and bonus issues from Yahoo (trades stay as entered, counted in today's share unit; administrator page Splits), grouped Positions/Holdings tables with separators, hover/tap readout on charts, Edit on the holding page, All-period percentage fixed, market-suggested basket no longer drifts; pf-install.sh 1.5, pf-mgmt-cheatsheet.md 1.6. New table asset_splits, new column users.ideal_basket_base.
1.9 2026-10-31 Superseded (never committed on its own — shipped inside 1.10) · cheatsheet-1.9 PF app 1.1.3: browser Back stays inside the app (no logout), Delete on the holding page, Trades history by year with filters, commissions shown separately, sortable Positions and analysis tables, exchange-rate fallbacks (QAR), fixes; pf-install.sh 1.4, pf-mgmt-cheatsheet.md 1.5. No schema change.
1.8 2026-10-31 Superseded commit:7a11ee0 · cheatsheet-1.8 PF app 1.1.2: ideal basket and market-suggested basket, deposits and interest, holding pages, dividend check, 9-digit shares, fund/ETF type, trade form with Total and market price, administrator currency list; WordPress: what updates where; Operations: database engines and version upgrades; pf-install.sh 1.3, pf-mgmt-cheatsheet.md 1.4.
1.7 2026-10-29 Superseded commit:c494d3e · cheatsheet-1.7 PF app 1.1.1: web GUI (first-run administrator page, roles, QR 2FA), total wealth with currency switch and period chart, holdings analysis with buy/hold/sell suggestions, admin-assignable e-mail recovery; pf-install.sh 1.2; pf-mgmt-cheatsheet.md 1.3.
1.6 2026-10-29 Superseded commit:586161e · cheatsheet-1.6 PF: full application (login + 2FA, transactions, dividend reinvestment, market data, indicators, rebalancing hints) instead of the starter; pf-install.sh 1.1 (--app-src); pf-mgmt-cheatsheet.md 1.2 (wiki page PF).
1.5 2026-10-29 Superseded (never committed on its own — shipped inside 1.6) · cheatsheet-1.5 New stack PF: overview row, own sheet pf-mgmt-cheatsheet.md (wiki page PF), pf-install.sh; §6 "Before go-live checklist"; deploy-publish.sh 1.2.
1.4.1 2026-10-26 Superseded commit:072d94a · cheatsheet-1.4.1 Handled packages/files move to /root/deploy-done/; deploy-publish.sh 1.1.1.
1.4 2026-10-26 Superseded (never committed on its own — shipped inside 1.4.1) · cheatsheet-1.4 Git §F for the release package: deploy-publish.sh 1.1 takes one dmz-web-release-<version>.zip (files, wiki/, RELEASE, SHA256SUMS), verifies and publishes it, moves it to /root/deploy-done/.
1.3 2026-10-26 Superseded (never committed on its own — shipped inside 1.4) · cheatsheet-1.3 Git §F: deploy-publish.sh 1.0 — files from /root to repo with version checks, commit/tag via deploy-commit.sh, wiki zip → Redmine REST API, handled files moved to /root/deploy-done/.
1.2.2 2026-10-26 Superseded (never committed on its own — shipped inside 1.3) · cheatsheet-1.2.2 Snipe-IT "Image versions and upgrades": pinned v8.8.3 + MariaDB digest, no GUI upgrade, six-step upgrade/rollback, unit-file comment rule.
1.2.1 2026-10-26 Superseded commit:7118d9b · cheatsheet-1.2.1 Snipe-IT mail test (General Settings → Test Email, tinker alternative), 2026-10-26 result (internal delivered, external 451 4.4.4 ATTR5, cause open); Troubleshooting Q&A.
1.2 2026-10-25 Superseded commit:84a9a24 · cheatsheet-1.2 New Troubleshooting chapter; 8181 admin subnets and live-vs-repo Network= warning; Snipe-IT chapter (install script, pre-flight, SMTP relay); Snipe-IT 500 / password_resets Q&A.
1.1.1 2026-10-25 Superseded commit:af01c01 · cheatsheet-1.1.1 deploy-commit.sh 1.1: credential guard narrowed to key = literal (prose/comments no longer trip it), -y override documented.
1.1 2026-10-25 Superseded (not committed — superseded by 1.1.1 before push) Git §C/E: deploy-commit.sh (root, .sh) replaces the manual commit/push cycle and deploy-push — commits as websvcmaster, guards against staged credentials, pushes as root, tags, chowns .git; script kept in repo under root-bin/.
1.0.1 2026-10-25 Superseded (not committed — superseded by 1.1 before push) Git §C/E: root pushes only via deploy-push wrapper (push + chown .git back to owner); two new recovery entries (COMMIT_EDITMSG permission denied, "Everything up-to-date" after a missed commit).
1.0 2026-10-25 Superseded commit:ce3e6e1 · cheatsheet-1.0 First versioned release. Restructured by stack (NPM + LE, WordPress, Redmine, Snipe-IT, common ops, health check); git procedure rewritten with per-user steps and recovery list; health-check loop reads Description=<App> -- <domain>; replaces unversioned podman-wordpress-cheatsheet_6.md.

Bump the version on every content change (patch: fixes/typos, minor: new section or procedure, major: restructuring), mark the previous row Superseded, commit together with the change it documents.

9.2 Scripts

Script Version Date Status Commit Notes
root-bin/deploy-commit.sh 1.2 2026-10-26 Latest commit:84a9a24 credential guard ignores code references (os.environ[..], getenv(..), obj.method(..))
root-bin/deploy-commit.sh 1.1 2026-10-25 Superseded commit:af01c01 credential guard narrowed to key = literal; -y override
root-bin/deploy-commit.sh 1.0 2026-10-25 Superseded (not committed) first version: commit as websvcmaster, push as root, tag, chown
snipeit-install.sh 1.1 2026-10-25 Latest commit:c4fb222 (1.1 content), commit:84a9a24 From/Reply-To always set (unset placeholder gave HTTP 500), SMTP preset to the Exchange Online relay; still defaults to :latest image — pass --app-image
root-bin/deploy-publish.sh 1.6 2026-11-02 Latest commit:25d3ebb plan first, one question, then repo, checksums, wiki, tidy and the PF upgrade; -Y, -P; amends:; commit:@@TAG:…@@; older zips tidied
root-bin/deploy-publish.sh 1.5 2026-11-02 Superseded commit:5aa1102 package sha256 printed and checked (-s), a newer script in the package is installed and used at once, release notes to releases/, releases/CHECKSUMS.txt
root-bin/deploy-publish.sh 1.4 2026-10-31 Superseded commit:a8bd5b2 --status: read-only overview of what is published, installed and waiting
root-bin/deploy-publish.sh 1.3 2026-10-31 Superseded commit:8e53cb8 ITEMS: as-web and pf-upgrade.sh
root-bin/as-web 1.0 2026-10-31 Latest commit:8e53cb8 run a command or a shell as websvcmaster from the root shell (rootless environment set up)
root-bin/pf-upgrade.sh 1.3 2026-11-04 Latest commit:5e845b6 the build pulls the newest base image of the same tag (--pull=newer): the image's Debian and Python fixes come with every upgrade
root-bin/pf-upgrade.sh 1.2 2026-11-03 Superseded commit:ef2c95b dump named pf_db-<date>_<time>-before-<version>.dump (a second upgrade on the same day overwrote the first); the rollback text names that dump
root-bin/pf-upgrade.sh 1.1 2026-11-02 Superseded commit:25d3ebb sha256 from releases/CHECKSUMS.txt, known pg_dump notice named, superseded tarballs moved to deploy-done, rollback lines with the TimescaleDB restore
tools/build-release.sh 1.1 2026-11-03 Latest commit:8d62289 -a <pf-app tarball>: the app's strings.csv checked against the page, tarball sha256 in pf-app.sha256
tools/build-release.sh 1.0 2026-11-02 Superseded commit:25d3ebb builds the release zip; stops on a file older than the published one (the 1.21 mistake), an unchanged version with changed content, a changed note not in AMENDS
root-bin/pf-upgrade.sh 1.0 2026-10-31 Superseded commit:8e53cb8 PF application upgrade (backup, build, unit, commit, restart site-pf only), asks before each step, -n dry run
root-bin/deploy-publish.sh 1.2 2026-10-29 Superseded commit:586161e publishes pf-install.sh and pf-mgmt-cheatsheet.md too
root-bin/deploy-publish.sh 1.1.1 2026-10-26 Superseded commit:072d94a done folder renamed to /root/deploy-done/
root-bin/deploy-publish.sh 1.1 2026-10-26 Superseded (never committed on its own — shipped inside 1.1.1) release package (zip + RELEASE + SHA256SUMS), safe unpack, checksum check; wiki read from a directory
root-bin/deploy-publish.sh 1.0 2026-10-26 Superseded (never committed on its own — shipped inside 1.1) first release: loose files + wiki zip → repo, commit/tag, Redmine REST, tidy
pf-install.sh 1.17 2026-11-04 Latest commit:5e845b6 app image 1.1.16 (schema: transactions.account, source value cost, added by the app); --build pulls the newest base image
pf-install.sh 1.16 2026-11-03 Superseded commit:ec2cb64 app image 1.1.15 (schema: source value broker, six columns, added by the app; new package pypdf)
pf-install.sh 1.15 2026-11-03 Superseded commit:ef2c95b app image 1.1.14 (no schema change)
pf-install.sh 1.14 2026-11-03 Superseded commit:8d62289 app image 1.1.13 (schema: table ui_labels, columns users.language, transactions.paid_currency / paid_amount, source value bonus; added by the app)
pf-install.sh 1.13 2026-11-02 Superseded commit:25d3ebb app image 1.1.12 (schema: table auth_refresh, column users.sessions_valid_after, added by the app)
pf-install.sh 1.12 2026-11-02 Superseded commit:5aa1102 app image 1.1.10 (no schema change)
pf-install.sh 1.11 2026-11-01 Superseded commit:a6e532a app image 1.1.9 (no schema change)
pf-install.sh 1.10 2026-10-31 Superseded commit:ee0055f app image 1.1.8 (schema: 2 new columns, added by the app; new dependency xlrd)
pf-install.sh 1.9 2026-10-31 Superseded commit:fc0af9e app image 1.1.7 (schema: 3 new columns, added by the app)
pf-install.sh 1.8 2026-10-31 Superseded commit:56ebe4d app image 1.1.6 (no schema change)
pf-install.sh 1.7 2026-10-31 Superseded commit:3c2ff84 app image 1.1.5 (no schema change)
pf-install.sh 1.6 2026-10-31 Superseded (never committed on its own — shipped inside 1.12) cross-reference to the numbered PF sheet (section 8.5); app image 1.1.4 unchanged
pf-install.sh 1.5 2026-10-31 Superseded commit:438872a app image 1.1.4 (new table asset_splits, new column users.ideal_basket_base)
pf-install.sh 1.4 2026-10-31 Superseded (never committed on its own — shipped inside 1.5) app image 1.1.3 (no schema change)
pf-install.sh 1.3 2026-10-31 Superseded commit:7a11ee0 app image 1.1.2, history entry, commented PF_SUGGEST_MAX_TILT line in the unit
pf-install.sh 1.2 2026-10-29 Superseded commit:c494d3e app image 1.1.1, first-run GUI "Next" text, commented SMTP lines
pf-install.sh 1.1 2026-10-29 Superseded commit:a18ea51 full application: --app-src instead of --init-app, image tag 1.1.0, start period 90 s
pf-install.sh 1.0 2026-10-29 Superseded (never committed on its own — shipped inside 1.1) PF stack installer (two networks, TimescaleDB, NPM wiring with live-vs-repo guard)
pf-mgmt-cheatsheet.md 1.20 2026-11-04 Latest commit:5e845b6 app 1.1.16: accounts, Midas Kripto, transfers, per-holding return, costs (§8.5.9), endpoints, rollback
pf-mgmt-cheatsheet.md 1.19 2026-11-03 Superseded commit:ec2cb64 app 1.1.15: Midas statements (§8.5.9), server messages, By group, percentage, prices every 15 minutes, tax by market
pf-mgmt-cheatsheet.md 1.18 2026-11-03 Superseded commit:ef2c95b app 1.1.14: gain by group (§8.5.1), renewals as internal transfers, days without a price, group split (§8.5.8)
pf-mgmt-cheatsheet.md 1.17 2026-11-03 Superseded commit:8d62289 app 1.1.13: one currency, costs at their days' rates, bonus, currency correction (§8.5.8), languages and Labels (§8.5.1), endpoints
pf-mgmt-cheatsheet.md 1.16 2026-11-02 Superseded commit:25d3ebb app 1.1.12: staying logged in (§8.5.1), auth/refresh, auth/logout; upgrade from deploy-publish.sh, rollback 1.1.12 → 1.1.11, restore over pf_db (§8.3)
pf-mgmt-cheatsheet.md 1.15 2026-11-02 Superseded commit:2f1d8ca app 1.1.11: Price currency selector (§8.5.2)
pf-mgmt-cheatsheet.md 1.14 2026-11-02 Superseded commit:5aa1102 app 1.1.10: instrument remove / type, statement preview warning (§8.5.2, §8.5.4)
pf-mgmt-cheatsheet.md 1.13 2026-11-01 Superseded commit:a6e532a app 1.1.9: About window, upgrade commands for 1.1.9
pf-mgmt-cheatsheet.md 1.12 2026-10-31 Superseded commit:ee0055f app 1.1.8: statement import, Interest by month, price currency (§8.5.4), rollback note
pf-mgmt-cheatsheet.md 1.11 2026-10-31 Superseded commit:a42cd30 app 1.1.7: deposits (§8.5.4), rollback note
pf-mgmt-cheatsheet.md 1.10 2026-10-31 Superseded commit:56ebe4d app 1.1.6: Market study (§8.5.2), upgrade rollback note; no schema change
pf-mgmt-cheatsheet.md 1.9 2026-10-31 Superseded commit:8e53cb8 §8.3.1 points to pf-upgrade.sh; no application change
pf-mgmt-cheatsheet.md 1.8 2026-10-31 Superseded commit:3c2ff84 app 1.1.5: My position card, own-currency amounts, explained P/L, left-aligned description columns
pf-mgmt-cheatsheet.md 1.7 2026-10-31 Superseded (never committed on its own — shipped inside 1.12) numbered headings as chapter 8 of the documentation (8.1 to 8.5.7), cross-references updated; no application change
pf-mgmt-cheatsheet.md 1.6 2026-10-31 Superseded commit:438872a app 1.1.4: splits and bonus issues (§8.5.5), grouped tables, hover readout on charts, Edit on the holding page, All-period percentage, market-suggested basket fix, upgrade steps for 1.1.4
pf-mgmt-cheatsheet.md 1.5 2026-10-31 Superseded (never committed on its own — shipped inside 1.6) app 1.1.3: Back button, Delete on holding page, Trades history by year with filters, commissions, sortable tables, tarball 1.1.3 upgrade steps (health wait, root-only commands)
pf-mgmt-cheatsheet.md 1.4 2026-10-31 Superseded commit:7a11ee0 app 1.1.2: ideal basket, deposits and interest, holding pages, dividend check, 9-digit shares, fund/ETF type, Total and market price in the trade form, administrator currency list, upgrade check commands
pf-mgmt-cheatsheet.md 1.3 2026-10-29 Superseded commit:c494d3e web GUI, roles, first run, e-mail recovery, wealth chart, holdings analysis, upgrade from tarball
pf-mgmt-cheatsheet.md 1.2 2026-10-29 Superseded commit:a18ea51 application, DRIP rules, users/2FA, endpoints (1.1: installer-based procedure; 1.0 was an uncommitted draft)
pf-mgmt-cheatsheet.md 1.1 2026-10-29 Superseded (never committed on its own — shipped inside 1.2) PF stack sheet around pf-install.sh
check-sites.sh 1.0 2026-10-25 Latest commit:ce3e6e1 (+x in commit:af01c01) first versioned release; Description=.* -- sed; --version/--help

9.3 Repository history

Not kept by hand — see the project's Repository tab (all revisions, diffs, tags) and Activity. Initial import: commit:cc4880f.

Redmine link syntax used above: commit:<hash> → commit page, source:path → file at HEAD, source:path@<hash> → file at that revision, e.g. source:dmz-web-podman-cheatsheet.md@cheatsheet-1.0.

Updated by Redmine Admin 2 days ago · 22 revisions