Python upgrade venv python binary/version
karlopython3 -m venv --upgrade /opt/venv/
Git use different ssh key once
export GIT_SSH_COMMAND="ssh -o IdentitiesOnly=yes -i ~/.ssh/id_rsa_blah" git push
TASK ERROR: zfs error: could not find any snapshots to destroy; check snapshot names.
Try this: pct delsnapshot 2087 vzdump -force It will give an error but will remove snap from GUI
Upgrade postgresql cluster from 13 to 15
apt list --installed | grep postg pg_dropcluster 15 main --stop pg_upgradecluster 13 main service postgresql@13-main stop service postgresql@15-main start pg_lsclusters pg_dropcluster 13 main apt-get purge postgresql-13 postgresql-client-13
Elasticsearch start fail on debian 11 after install from ES repos
This guide helped me a lot: https://techviewleo.com/install-elastic-stack-elk-8-on-ubuntu/ After first installing with this parameter: export ES_SKIP_SET_KERNEL_PARAMETERS=true && apt-get install elasticsearch I then used the linked guide. Important parts: sudo vim /etc/elasticsearch/elasticsearch.yml…
Apache2 (apache) forward https headers
RequestHeader set "X-Forwarded-Proto" expr=%{REQUEST_SCHEME} RequestHeader set "X-Forwarded-SSL" expr=%{HTTPS}
Postgres read long lines (wrap text)
\pset format wrapped
Install `strings` command in debian/linux
That's a difficult one to search for. To get the strings command working in Debian 11 / Linux, for example in your bash scripts, install the binutils package!
Add new dmraid to debian11
Note to self:
Indent HTML using tidy
for my own reference: tidy -indent --indent-spaces 2 --quiet --tidy-mark no --wrap 0 --drop-empty-elements no base.html > newbase.html
Github what repos have you contributed to (graphql)
https://docs.github.com/en/graphql/overview/explorer { viewer { repositoriesContributedTo(first: 100, contributionTypes: ) { totalCount nodes { nameWithOwner } } } }
Debian VM as GW routing through VPN (tun) with nftables
My LAN interfaces are ens3/ens8/ens9. VPN tunnel set up using openvpn, gets dev tun0. NFTables config file /etc/nftables.conf (do not forget to enable the nftables services): flush ruleset table inet…
Guacamole broken (Creation of WebSocket tunnel to guacd failed)
Today my guacamole broke. Fixed by putting in guacd settings in the connection settings in guacamole itself. Had to explicitly add ::1 and port 4822 (in my case).
mount LVM2_member
vgscan vgchange -ay srv25centos mount /dev/mapper/srv25centos-root /mnt/srv25
List all ansible facts (facter puppet)
ansible srv46.karloluiten.nl -m ansible.builtin.setup
Mount raw ovirt / kvm disk
losetup -f -P root.img osetup -l mount -o ro /dev/loop* /mnt/
Linux remove last newline from file
perl -pi -e 'chomp if eof' macaroon newline remove
nc in powershell (test remote open port/tcp)
Test-NetConnection -Port 80 -InformationLevel "Detailed" -ComputerName example.com
Simple wireshark filter host+port
ip.src == 10.1.72.1 and tcp.port == 12228
Excel return text right of last occurrence of string
=TRIM(RIGHT(SUBSTITUTE(A1;" ";REPT(" ";LEN(A1)));LEN(A1)))
Update RHEL/CentOS from local repo (iso/cd)
sudo -i mount -o loop /tmp/*77*.iso /mnt cat > /etc/yum.repos.d/cd.repo [cd] name=cd baseurl=file:///mnt/ enabled=1 gpgcheck=0 #[PRESS enter and CTRL-d] yum clean all; rm -rf rm -rf /var/cache/yum; yum makecache fast…
Pihole CORS problems
Fix: edit /var/www/html/admin/scripts/pi-hole/php/auth.php add your host names to AUTHORIZED_HOSTNAMES array
Move cygwin to different disk, including services
Stop all services, log out other users, in process explorer, add command line column, stop all in old pathIn cygwin, go to /cygdrive, cp -vR c/cygwin* d/mount -m > /usr/bin/mountCommands.bat…
ubnt / ubiquiti edgerouter passwordless login ssh keys
ubnt@er4gw:~$ configure [edit] ubnt@er4gw# set system login user ubnt authentication public-keys lb7 type ssh-rsa [edit] ubnt@er4gw# set system login user ubnt authentication public-keys lb7 key AAAA****3tfv0vaEUl ubnt@er4gw# commit ubnt@er4gw# exit…
Convert m4b to mp3 on Centos/Fedora using ffmpeg
for m4b in *.m4b; do ffmpeg -i $m4b -acodec libmp3lame -ar 22050 ${m4b}.mp3; done
AWK print longest line in file
awk '{ if (length($0) > max) {max = length($0); maxline = $0} } END { print maxline }' YOURFILE
Outlook unblock “unsafe” attachments
Regedit, find: Outlook 2007 [HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Outlook\Security] Outlook 2010 [HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Outlook\Security] Outlook 2013 [HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Outlook\Security] Outlook 2016, Outlook 2019 and Office 365 [HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Outlook\Security] Level1Remove string Value .cer;.exe;.xxx for the stuff you want to unblock.
NPM (node) install fail as root
Do not install as root, or use --unsafe-perm
Windows “File is open in another program” (lsof in windows)
First get handle: https://docs.microsoft.com/en-us/sysinternals/downloads/handle Run handle once without searching for anything, to accept license. Run in a CMD AS ADMIN: handle64.exe > output.txt . Find the file you want. Then…