Christian Korneck christian-korneck

quick & dirty powershell query with appsmith

(WARNING - very insecure)

on windows worker (here on docker host):

webify powershell -c "Get-WmiObject -Class win32_processor | Select-Object -Property Caption, DeviceID, Manufacturer, MaxClockSpeed, Name, SocketDesignation | ConvertTo-Json -Compress"
2023/03/26 16:31:11 listening on :8080, proxying to powershell -c Get-WmiObject -Class win32_processor | Select-Object -Property Caption, DeviceID, Manufacturer, MaxClockSpeed, Name, SocketDesignation | ConvertTo-Json -Compress

Why?
- describe issue (motivation of the change)
  - describe error scenario ("as-is it throws unhandled exception on special characters").
  - introduce issue report (i.e. cite linter warnings)
  - describe shortcomings ("I'm unhappy with [...]: No timeouts, features like x are clumsy.")
- illustrate requirement
  - usage need ("x is only works on pre-Python 3.7, but we want to support all Python 3 versions")
  - out of date ("remove outdated property. x is no longer defined, but was still referenced in the docs")
  - runtime or dev env change ("API has changed, fixing the example")
describe objective

# we're on Ubuntu 20.04 on arm64
$ uname -a
...
Linux [...] 5.15.0 #40~20.04.1-Ubuntu [...] aarch64 [...]
...

# install build tools
$ apt-get -y update && apt-get -y install curl build-essential zlib1g-dev libncurses5-dev libgdbm-dev libnss3-dev libssl-dev libreadline-dev libffi-dev pkg-config
# install latest Go

# as demo data, let's use a copy of the alpine rootfs (which contains both binary and text files)
$ wget https://dl-cdn.alpinelinux.org/alpine/v3.18/releases/aarch64/alpine-minirootfs-3.18.0-aarch64.tar.gz
$ tar xf alpine-minirootfs-3.18.0-aarch64.tar.gz
$ ls
/bin
/etc
...

# make this dir a git repo and enable git-lfs

Podman error `setting value of extended attribute "security.ima" on "/catatonit": operation not permitted`:

example error message (when trying to run a k8s yaml as unpriv'ed user)

[user@host]$ podman kube play boom.yml
Error: building local pause image: building at STEP "COPY /usr/libexec/podman/catatonit /catatonit": storing "/usr/libexec/podman/catatonit": error during bulk transfer for copier.request{Request:"PUT", Root:"/", preservedRoot:"/home/opc/.local/share/containers/storage/overlay/ba320139a68ad5418cef299dd724dc9fc53737c8a3cba1ad9d30c3a25dfcca45/merged", rootPrefix:"/home/opc/.local/share/containers/storage/overlay/ba320139a68ad5418cef299dd724dc9fc53737c8a3cba1ad9d30c3a25dfcca45/merged", Directory:"/", preservedDirectory:"/home/opc/.local/share/containers/storage/overlay/ba320139a68ad5418cef299dd724dc9fc53737c8a3cba1ad9d30c3a25dfcca45/merged", Globs:[]string{}, preservedGlobs:[]string{}, StatOptions:copier.StatOptions{CheckForArchives:false, Excludes:[]string(nil)}, GetOptions:copier.GetOpt

I have a Windows 11 23H2 VM with a SATA boot disk running on virtmanager (KVM/Qemu) on Fedora 39 that I want to convert to a virtio disk.

in windows install virtio guest tools (download)
create cd drive and attach virtio iso (download)
shutdown vm
in virtmanager preferences, enable xml editing
in the vm disk settings, go to the xml tab, backup the existing xml and change it:

old:

A way to reboot into recovery mode (Windows boots into GUI with only minimal drivers loaded):

bcdedit /set "{current}" safeboot minimal
reboot. Machine will boot into recovery mode.
in recovery mode, disable it before rebooting: bcdedit /deletevalue "{current}" safeboot

virtio downloads (fedora / red hat signed): https://github.com/virtio-win/virtio-win-pkg-scripts/blob/master/README.md
- virtio guest tools: https://fedorapeople.org/groups/virt/virtio-win/direct-downloads/latest-virtio/virtio-win-guest-tools.exe
- virtio drivers iso: https://fedorapeople.org/groups/virt/virtio-win/direct-downloads/latest-virtio/virtio-win.iso
spice downloads: https://www.spice-space.org/download.html
- guest tools (required for dynamic gpu resultion): https://www.spice-space.org/download/windows/spice-guest-tools/spice-guest-tools-latest.exe
- spice virtviewer for windows: http://virt-manager.org/download
on download server: https://releases.pagure.org/virt-viewer

	@echo off
	setlocal

	REM batch script that executes the command that it received via STDIN
	REM (whitespaces should be working)

	for /f "tokens=*" %%i in ('find /v ""') do set MYCMD=%%i
	cmd.exe /c %MYCMD%
	set myerrorlevel=%errorlevel%

	# make a query at this point in time
	$ promtool query instant http://localhost:9090 '{job=~".+"}'
	up{instance="localhost:9090", job="prometheus"} => 1 @[1690724237.225]
	go_memstats_alloc_bytes{instance="localhost:9090", job="prometheus"} => 29046776 @[1690724237.225]
	...

	# query a metric for the time range between two Unix timestamp
	$ promtool query range --start 1690724700 --end 1690725307 --step 1m http://localhost:9090 \
	'go_memstats_alloc_bytes{job="prometheus"}'
	23215032 @[1690724700]

Christian Korneck christian-korneck

quick & dirty powershell query with appsmith

on windows worker (here on docker host):

Podman error setting value of extended attribute "security.ima" on "/catatonit": operation not permitted:

Podman error `setting value of extended attribute "security.ima" on "/catatonit": operation not permitted`: