Differences

This shows you the differences between two versions of the page.

--- onny:notizen [2022/05/30 22:24] – 10.25.0.100
+++ onny:notizen [2024/05/22 12:10] (current) – [batch convert images] 10.250.0.1
@@ Line 1: / Line 1: @@
-===== ArchLinux =====
+===== bash =====
-==== system ====
-set extra capabilities for process
-<code bash>
-sudo setcap 'CAP_NET_BIND_SERVICE=+ep' /usr/bin/maddy
-</code>
-directory permissions
-<code bash>
-namei -l /mnt/external/audio
-</code>
-use acl to grant permission to files for specific user
-<code bash>
-setfacl -R -m u:maddy:rX /etc/ssl/example.org.crt /etc/ssl/example.org.key
-</code>
-pgrep get process pid by process name
-<code bash>
-$ pgrep sw3
-</code>
-set system time
-<code bash>
-timedatectl set-time "2014-05-26 11:13:54"
-</code>
-==== packaging ====
-git checkout aur package
-<code bash>
-git clone ssh://aur@aur.archlinux.org/pkgbase.git
-</code>
-=== commands ===
-update checksums inplace
-<code bash>
-updpkgsums
-</code>
-building a package in a clean dev chroot, path for pacman conf ''/usr/share/devtools/pacman-extra.conf''
-<code bash>
-cd <package-patch>
-ls PKGBUILD
-extra-x86_64-build # -c for cleaning up chroot. ~/chroot/root is a btrfs subvolume and has to be removed with btrfs!
-extra-x86_64-build -- -I ~/packages/foobar/foobar-2-1-any.pkg.tar.xz
-</code>
-advanced chroot with own packages preinstalled
-<code bash>
-mkdir ~/chroot
-export CHROOT=$HOME/chroot
-mkarchroot $CHROOT/root base-devel
-arch-nspawn $CHROOT/root pacman -Syu # updating it
-makechrootpkg -r $CHROOT -I package-1.0-1-i686.pkg.tar.xz # -c for clean chroot
-# repackage: makechrootpkg -r /home/onny/chroot -- -R
-</code>
-cheap python virtualenv
-<code bash>
-mkdir path
-ln -s /usr/bin/python2 path/python
-export PATH="$srcdir/path:$PATH"
-</code>
-abs deprecated, using asp
-<code bash>
-asp export linux
-</code>
-=== PKGBUILD ===
-Installation von Lizenzdateien:
-<code bash>
-install -D "LICENSE.txt" "${pkgdir}/usr/share/licenses/${pkgname}/LICENSE"
-</code>
-Installation von Systemd-Units:
-<code bash>
-install -Dm644 "${srcdir}/btlive.service" "${pkgdir}/usr/lib/systemd/system/btlive.service"
-</code>
-Installation von Docs:
-<code bash>
-install -Dm644 README.md "$pkgdir/usr/share/doc/$pkgname/README.md"
-</code>
-Installation von Tmpfiles:
-<code bash>
-install -Dm644 "wallace/wallace.tmpfiles.d.conf" "${pkgdir}/usr/lib/tmpfiles.d/wallace.conf"
-</code>
-Installation von Libs:
-<code bash>
-install -m644 libdouble-conversion.so.0.0.0* "${pkgdir}/usr/lib/"
-</code>
-do not strip binary files
-<code>
-options=('!strip')
-</code>
-Installation von ausführbare Dateien:
-<code bash>
-install -Dm755 shareLinkCreator "${pkgdir}/usr/bin/sharelinkcreator"
-</code>
-Nginx/Apache Template-Dateien:
-<code bash>
- if [[ -n $(which httpd 2> /dev/null) ]]; then
-   backup=('etc/httpd/conf/extra/owncloud.conf')
- fi
- package(){
-   # install apache .conf file if apache is installed
-   if [[ -n $(which httpd 2> /dev/null) ]]; then
-      install -d  $pkgdir/etc/httpd/conf/extra
-      install -m 644 $srcdir/owncloud.conf  $pkgdir/etc/httpd/conf/extra/
-   fi
- }
-</code>
-Zielname der Quelldatei ändern:
-<code bash>
-source=("$pkgname-$pkgver.tar.gz::https://gitlab.com/gitlab-org/gitlab-ce/repository/archive?ref=v${pkgver}")
-</code>
-Architekturabhängige Build-Anweisung
-<code bash>
- build() {
-   cd "${srcdir}/oclHashcat"
-   if [[ "$CARCH" = "x86_64" ]]; then
-     make cudaHashcat64.bin
-   else
-     make cudaHashcat32.bin
-   fi
-   make nv_all
- }
-</code>
-pkgver git
-<code bash>
- pkgver() {
-   cd "mail"
-   #git describe --long | sed 's/\([^-]*-g\)/r\1/;s/-/./g'
-   git log -1 --format=%cd.%h --date=short|tr -d -
- }
-</code>
-Common install file example
-<code bash>
-post_install() {
-  mkdir /var/lib/zabbix
-  getent group lool > /dev/null || groupadd -r lool > /dev/null
-  getent passwd lool > /dev/null || useradd lool > /dev/null
-  chown -R lool:lool /var/cache/loolwsd \
-                     /opt/lool/child-roots
-}
-post_remove() {
-   userdel -rf lool
-   groupdel lool
-}
-</code>
-in pkgbuild reference
-<code bash>
-install="libreoffice-online-bin.install"
-</code>
-=== aurutils ===
-install packages into build container
-<code bash>
-arch-chroot /var/lib/aurbuild/x86_64/root pacman -S git
-pacman --root=/var/lib/aurbuild/x86_64/root -S git
-</code>
-add gpg key into build container
-<code bash>
-sudo -u aur gpg --recv-keys EB774491D9FF06E2
-</code>
-rebuild prebuild package and add to custom AUR repo
-<code bash>
-fakepkg webkitgtk2
-sudo -u aur repo-add /var/cache/pacman/aur/aur.db.tar /tmp/webkitgtk2-3:2.4.11-16-x86_64.pkg.tar.xz
-cp /tmp/webkitgtk2-3:2.4.11-16-x86_64.pkg.tar.xz /var/cache/pacman/aur
-</code>
-==== bluetooth ====
-Example session ''bluetoothctl''
-<code bash>
-# bluetoothctl
-[bluetooth]# default-agent
-[bluetooth]# scan on
-[bluetooth]# pair 00:12:34:56:78:90
-[bluetooth]# connect 00:12:34:56:78:90
-</code>
-==== usefull stuff ====
-pipe stderr to stdout
-<code bash>
-command 2>&1 >/dev/null | grep 'something'
-</code>
-pipe stderr and stdout both to a file
-<code bash>
-command &> error_log
-</code>
-locate pacnew files
-<code bash>
-find /etc -regextype posix-extended -regex ".+\.pac(new|save)" 2> /dev/null
-</code>
-or search entire disk
-<code bash>
-find / -regextype posix-extended -regex ".+\.pac(new|save)" 2> /dev/null
-</code>
-=== swapfile on btrfs ===
-<code bash>
-swapfile=$(losetup -f) #free loop device
-truncate -s 8G /swap   #create 8G sparse swap file
-losetup $swapfile /swap #mount file to loop
-mkswap  $swapfile
-swapon  $swapfile
-</code>
-search library availability in system, print file paths
-<code bash>
-ldconfig -p | grep blas
-</code>
-==== systemd nspawn (container) ====
-<code bash>
-pacman -S arch-install-scripts
-btrfs subvol create /var/lib/container/archlinux-base
-mkdir /etc/systemd/nspawn
-pacstrap /var/lib/container/archlinux-base base base-devel
-systemctl enable --now systemd-networkd systemd-resolved
-systemd-nspawn --boot -nD /var/lib/machines/archlinux-nextcloudcli --template=/var/lib/container/archlinux-base
-systemctl start systemd-nspawnd@archlinux-nextcloudcli
-machinectl shell root@archlinux-nextcloudcli /bin/bash -c "systemctl enable --now systemd-networkd systemd-resolved"
-</code>
-quit / exit / kill container: Hold ''Ctrl'' press '']'' three times
-==== systemd service ====
-set environment
-<file - /etc/systemd/system/piradio.service>
-[Unit]
-Description=PiRadio
-After=network-online.target
-After=bluetooth.service
-[Service]
-Environment="XDG_RUNTIME_DIR=/run/user/1001"
-Type=simple
-User=piradio
-WorkingDirectory=/usr/lib/piradio
-ExecStartPre=/bin/sleep 5
-ExecStart=/usr/lib/piradio/piradio
-Restart=on-abort
-[Install]
-WantedBy=multi-user.target
-WantedBy=network-online.target
-</file>
-===== kernel =====
-grep kernel config running system
-<code bahs>
-zcat /proc/config.gz | grep VDSO
-</code>
-===== fish =====
-unset history
-<code>
-fish --private
-</code>
-===== bash =====
 lzma hado compression and extraction
 <code bash>
@@ Line 331: / Line 87: @@
 chmod +x $FILE
 $FILE "$@"
-</code>
-==== sed ====
-Mit sed inplace eine Zeile zu einer Datei hinzufügen:
-<code bash>
-sed -i '9i#include <algorithm>' liboffsetfinder64/vmem.cpp
-</code>
-add to end of file
-<code bash>
-sed -i -e '$aretry $@' retry.sh
-</bash>
-Comment out specific line matching a string
-<code bash>
-sudo sed -e '/pam_securetty.so/ s/^#*/#/' -i delugecontainer/etc/pam.d/login
-</code>
-comment out multiple lines / range
-<code bash>
-sed -i "28,33 s/# *//" autogen.sh
-</code>
-regex parse value of xml tags
-<code bash>
-sed -n 's/.*<id>\(.*\)<\/id>.*/\1/p' myfile.txt
-</code>
-delete multiple lines
-<code bash>
-sed -i '2,3d;5d;8d' file
 </code>
-insert line after match
-<code bash>
-sed  '/\[option\]/a Hello World' input
-</code>
 ==== grep ====
 regex match group
@@ Line 388: / Line 115: @@
 fd --type f -e doc -e docx -e pdf -i gabriel -x cp --backup=t {} /tmp/gabriel/
 </code>
-==== rg ====
-filter file type
+find filenames unallowed characters
 <code bash>
-rg GPIO_CFG_2MA -g '*.h'
+fd '[^A-Z a-züö@0-9._-]' remote/200_Archiv/CP_Dont_Touch
 </code>
-search file containing multiple strings/words
-<code bash>
-rg -lU --multiline-dotall 'strictDeps.*onny|onny.*strictDeps' pkgs
-</code>
-==== curl ====
-post data
-<code bash>
-curl --data "UserId=eb8c2ec5352843d3a16ca11c26d3551c&Name=lolorollo&api_key=a5dc4e***9c9e0a***3" "https://turbotux.de/Playlists?UserId=eb8c2ec5352843d3a16ca11c26d3551c&Name=lolorollo&api_key=a5***d***9e0***3"
-</code>
-download and extract archive
-<code bash>
-curl http://wordpress.org/latest.tar.gz | tar xvz
-</code>
-set host header
-<code bash>
-torify curl --header "Host: http.pi" blog.project-insanity.org
-</code>
-==== tcpdump ====
-specific ports
-<code bash>
-tcpdump -i eth0 -q '(tcp port 80) or (tcp port 443)' -A
-</code>
-exclude specific host
-<code bash>
-tcpdump -i eth0 -q '(ip or ip6) and (tcp port 80) or (tcp port 443) and not host ifconfig.co' -A
-</code>
 ==== patching ====
 === appling ===
@@ Line 439: / Line 137: @@
 </code>
+==== xargs ====
+<code>
+fd . | xargs -I {} rm "{}"
+</code>
 ===== rsync =====
 custom ssh port
@@ Line 463: / Line 166: @@
 </file>
 ===== networking =====
-netcat
-<code bash>
-netcat -l 4444
-</code>
-<code bash>
-netcat playground.pi 4444
-</code>
 ==== nftables ====
 <code bash>
@@ Line 511: / Line 207: @@
 iptables -t nat -A OUTPUT -p tcp --dport 2222 -j DNAT --to 192.168.1.2:22
 </code>
-</code>
-==== ip ====
-set address
-<code bash>
-ip address add dev usb0 172.16.42.1/24
-ip link set usb0 up
-</code>
-route command example
-<code bash>
-ip route add 192.168.1.0/24 dev eth0
-ip route add default via 192.168.1.1
-</code>
-flush addresses
-<code bash>
-ip addr flush dev enp8s0
-</code>
-remove interface
-<code bash>
-ip link delete br0
-</code>
-delete address
-<code bash>
-ip addr del 192.168.178.20/24 dev eth0
-</code>
-show only specific interface
-<code bash>
-ip a show wg0
 </code>
-change mtu
-<code bash>
-ip link set dev eth0 mtu 1400
-</code>
 ==== dnsmasq ====
 minimal hostapd and dnsmasq config
@@ Line 596: / Line 261: @@
 compression
 <code bash>
-convert -density 200x200 -units PixelsPerInch -compress jpeg -quality 70 in.pdf out.pdf
+gm convert -density 200x200 -units PixelsPerInch -compress jpeg -quality 70 in.pdf out.pdf
 </code>
 lossless merge
@@ Line 632: / Line 297: @@
 ffmpeg -i Kawamata\ -\ La\ passage\ des\ chaises.mkv -vf subtitles=Kawamata\ -\ La\ passage\ des\ chaises.mkv -acodec copy -preset:v ultrafast Kawamata\ -\ La\ passage\ des\ chaises.mp4
 </code>
-==== batch convert images ====
-<code bash>
-for i in *.jpeg; convert -resize 30% $i (string replace jpeg jpg $i); end
-</code>
 ==== lossless mp3 merge ====
 <code bash>
@@ Line 652: / Line 314: @@
 </code>
 ===== security =====
+==== web discovery ====
+=== photon ===
+<code>
+photon -u test.example.org
+</code>
 ==== lynis ====
@@ Line 667: / Line 337: @@
 ==== wfuzz ====
 <code bash>
-torify wfuzz -c --hc 404 -w /opt/wfuzz/wordlist/general/megabeast.txt http://www.leeel.de/FUZZ
+wfuzz -c --hc 404 -w /opt/wfuzz/wordlist/general/megabeast.txt http://www.leeel.de/FUZZ
-torify wfuzz -c --hc 404,403 -w /opt/wfuzz/wordlist/general/admin-panels.txt -w /opt/wfuzz/wordlist/general/extensions_common.txt http://www.leeel.de/FUZZFUZ2Z
+wfuzz -c --hc 404,403 -w /opt/wfuzz/wordlist/general/admin-panels.txt -w /opt/wfuzz/wordlist/general/extensions_common.txt http://www.leeel.de/FUZZFUZ2Z
 </code>
 Preparing data for LFI scan
@@ Line 683: / Line 353: @@
     * https://github.com/maurosoria/dirsearch
   * wifite wifi auditing tool
+sec tools
+  * dirbuster
+  * https://mitmproxy.org/
+  * **tiger** - system sec scanner
+  * sub domain evaluation
+    * https://github.com/kpcyrd/sn0int
+    * https://github.com/OWASP/Amass
+    * subfinder (passive, external sources)
+  * vhost scanning
+    * https://github.com/codingo/VHostScan
+  * bettercap - wifi network
+  * iodine dns tunnel https://code.kryo.se/iodine/
+  * command searchsploit in exploitdb
+  * NixOS for Pentesting Overview https://github.com/NixOS/nixpkgs/issues/81418
 ===== chromium / chrome =====
@@ Line 690: / Line 376: @@
 </code>
 ===== docker =====
-Short example
+Pull
 <code bash>
- sudo systemctl start docker
+docker pull ubuntu:22.04
- gpasswd -a onny docker
+docker pull rootlogin/nextcloud:develop
- docker run -d -p 80:80 rootlogin/nextcloud
- docker run -v /home/onny/projects/nextcloud-app-radio:/opt/nextcloud/apps/radio -d --name nextcloud -p 80:80 rootlogin/nextcloud
 </code>
+Run
+<code bash>
+docker run -td ubuntu:22.04
+</code>
+Executing
+<code bash>
+docker exec -it ffffdfdfsdfsdfsfsffsdfs /bin/bash
+</code>
+Nextcloud
+<code bash>
+docker run -d -p 80:80 rootlogin/nextcloud
+docker run -v /home/onny/projects/nextcloud-app-radio:/opt/nextcloud/apps/radio -d --name nextcloud -p 80:80 rootlogin/nextcloud
+</code>
 Debugging it
 <code bash>
@@ Line 702: / Line 404: @@
  docker exec -i -t e326cbb922aa /bin/bash # exec new shell running container
 </code>
 Pull from repository
 <code>
@@ Line 712: / Line 415: @@
  docker run -i -t e326cbb922aa /bin/bash
 </code>
-Pull specific tagged image
-<code bash>
-docker pull rootlogin/nextcloud:develop
-</code>
 Build from Dockerfile
 <code>
@@ Line 739: / Line 439: @@
 docker system prune -a
 </code>
-docker stop all container
-<code bash>
-docker stop (docker ps -a -q)
-</code>
 prevent from auto start
 <code bash>
 docker update --restart=no client-iaro_db_1
@@ Line 919: / Line 617: @@
 git remote set-url origin gitlab@http-new.pi:onny/web-wikidict.git
 </code>
-tagging
-<code bash>
-git tag -a v0.1 -m 'whackspace wordpress theme init'
-</code>
 merge commits from a remote repository
 <code bash>
 git fetch https://github.com/rfc2822/davdroid.git master
@@ Line 1018: / Line 714: @@
 git commit --allow-empty -m 'run tests again'
 git push --set-upstream USERNAME mynewbranch
-</code>
-change message of last git commit
-<code bash>
-git commit --amend
 </code>
 force push, remove latest commit of remote repository (origin)
@@ Line 1048: / Line 740: @@
 git commit --all --amend --no-edit
 git rebase --continue
-</code>
-add co-author / co-authors to commit
-<code bash>
-git commit --amend
-# Add line: Co-authored-by: name <name@example.com>
 </code>
 ===== yum =====
@@ Line 1135: / Line 821: @@
 </code>
   * check spamminess of email server: https://www.mail-tester.com/
-  * manual imap login
-openssl imaps login
-<code>
-openssl s_client -connect mail.sexypump.de:993 -crlf
-A login cypherpunk cypherpunk
-</code>
-get quota
-<code>
-a GETQUOTAROOT INBOX
-</code>
-get msg count of folder
-<code>
-a LIST INBOX *
-* LIST (\HasChildren) "." INBOX
-* LIST (\HasNoChildren \UnMarked) "." "INBOX.Deleted Messages"
-* LIST (\HasNoChildren \UnMarked) "." "INBOX.Sent Messages"
-* LIST (\HasNoChildren \UnMarked \Trash) "." INBOX.Trash
-* LIST (\HasNoChildren \UnMarked \Sent) "." INBOX.Sent
-* LIST (\HasNoChildren \UnMarked) "." INBOX.Notes
-* LIST (\HasNoChildren \UnMarked \Junk) "." INBOX.Junk
-* LIST (\HasNoChildren \UnMarked \Drafts) "." INBOX.Drafts
-* LIST (\HasNoChildren \UnMarked) "." INBOX.AntiSpam
-a OK List completed (0.001 + 0.000 secs).
-a SELECT INBOX
-</code>
 send smtp mail
 <code>
@@ Line 1257: / Line 919: @@
 ngrep -q -W byline "search" host www.google.com and port 80
 </code>
-  * sec
-    * https://mitmproxy.org/
-    * **tiger** - system sec scanner
-    * sub domain evaluation
-      * https://github.com/kpcyrd/sn0int
-      * https://github.com/OWASP/Amass
-      * subfinder (passive, external sources)
-    * vhost scanning
-      * https://github.com/codingo/VHostScan
-    * bettercap - wifi network
-    * iodine dns tunnel https://code.kryo.se/iodine/
-    * command searchsploit in exploitdb
   * sys
     * **usbtop**
@@ Line 1352: / Line 1002: @@
 apply changes to system
-<code bash>
+<code>
-nixos-rebuild switch
+sudo nixos-rebuild switch --flake '/etc/nixos#joes-desktop'
+sudo nixos-rebuild boot --flake '/etc/nixos#joes-desktop' # raspi specific
 </code>
@@ Line 1511: / Line 1162: @@
 <code bash>
+cd nixpkgs
+nix build -f ./. python310Packages.baserow
+nix build -f ./. nodePackages.hyperpotamus
 nix-build -E 'with import <nixpkgs> { }; callPackage ./default.nix { nodejs = pkgs."nodejs-10_x"; }'
-nix-build -E 'with import /home/onny/projects/nixpkgs {}; nodePackages.hyperpotamus'
 nix-build -E 'with import /home/onny/nixpkgs { }; libsForQt5.callPackage ./pkgs/applications/office/shelf/default.nix {}'
 </code>
@@ Line 1523: / Line 1177: @@
 </code>
-quick launch program
+run program
 <code bash>
-nix run nixpkgs.electrum --command electrum
+nix run nixpkgs#electrum -- --help
+nix run github:TheZombie1999/nixpkgs#upscaly
+nix shell nixpkgs#hash-slinger --command tlsa --create example.org
 </code>
@@ Line 1553: / Line 1209: @@
 <code>
-let
+nixpkgs.config.packageOverrides = pkgs: rec {
+  unstable = import unstableTarball { };
-  # FIXME
+  opensnitch = unstable.opensnitch;
-  unstableTarball =
+};
-    fetchTarball
-      https://github.com/NixOS/nixpkgs/archive/nixos-unstable.tar.gz;
-in
-{
-  disabledModules = [ "programs/firejail.nix" ];
-  imports = [
-    "${fetchTarball "https://github.com/NixOS/nixpkgs/archive/nixos-unstable.tar.gz"}/nixos/modules/services/security/opensnitch.nix"
-    /home/onny/projects/nixpkgs2/nixos/modules/services/networking/create_ap.nix
-  ];
-  nixpkgs.config.packageOverrides = pkgs: rec {
-    unstable = import unstableTarball { };
-    opensnitch = unstable.opensnitch;
-  };
-  #services.opensnitch.enable = true;
 </code>
@@ Line 1605: / Line 1244: @@
     '';
   });
-</code>
-use local src / source
-<code>
-  src = "/home/onny/projects/linux-wifi-hotspot";
-  dontUnpack = true;
-  unpackPhase = ''cp -r --no-preserve=mode $src/* .'';
 </code>
@@ Line 1622: / Line 1252: @@
 </code>
-package overlay and override attributes
+fetchpatch array
 <code>
-  nixpkgs.overlays = [
+patches = map fetchpatch [
-    (self: super: {
+  /* This patch is currently necessary for the unit test suite to run correctly.
-      foo2zjs = (import (builtins.fetchTarball {
+   * See https://www.mail-archive.com/klee-dev@imperial.ac.uk/msg03136.html
-        url =
+   * and https://github.com/klee/klee/pull/1458 for more information.
-          "https://github.com/onny/nixpkgs/archive/foo2zjs.tar.gz";
+   */
-        sha256 = "0dsix1vp4canialzj4rp51i35lhdk28yndnnj62i0brzlng7jdrk";
+  #{
-      }) {} ).foo2zjs;
+  #  name = "fix-gtest";
-      wordpress = super.wordpress.overrideAttrs (oldAttrs: rec {
+  #  sha256 = "F+/6videwJZz4sDF9lnV4B8lMx6W11KFJ0Q8t1qUDf4=";
-        # Remove default plugins and themes
+  #  url = "https://github.com/klee/klee/pull/1458.patch";
-        installPhase = oldAttrs.installPhase + ''
+  #}
-          rm -r $out/share/wordpress/wp-content/plugins/*
-          rm -r $out/share/wordpress/wp-content/themes/*
-        '';
-      });
-    })
-  ];
-</code>
-fetchpatch
+  # This patch fixes test compile issues with glibc 2.33+.
+  #{
-<code>
+  #  name = "fix-glibc-2.33";
-  patches = [
+  #  sha256 = "PzxqtFyLy9KF1eA9AAKg1tu+ggRdvu7leuvXifayIcc=";
-    ./no-hardcode-fw.diff
+  #  url = "https://github.com/klee/klee/pull/1385.patch";
+  #}
-    # Support HBPL1 printers https://www.dechifro.org/hbpl/
-    ./hbpl1.patch
-    # Fix "Unimplemented paper code" error for hbpl1 printers
-    # https://github.com/mikerr/foo2zjs/pull/2
-    (fetchpatch {
-      url = "https://patch-diff.githubusercontent.com/raw/mikerr/foo2zjs/pull/2.patch";
-      sha256 = "0lvbryw6ymh0ahwkhqsgmjimg5saa8b1xnxmyyjxrbi3l3a6fbvy";
-    })
-  ];
 </code>
@@ Line 1676: / Line 1288: @@
 <code bash>
 QEMU_NET_OPTS="hostfwd=tcp::8080-:80" NIX_PATH=nixpkgs=/home/onny/projects/nixpkgs nixos-shell vm-invoiceplane.nix
+sudo -E QEMU_NET_OPTS="hostfwd=tcp::80-:80" NIX_PATH=nixpkgs=/home/onny/projects/nixpkgs nixos-shell vm-invoiceplane.nix
 </code>
@@ Line 1737: / Line 1350: @@
 <code>
 { lib
-, mkDerivation
+, stdenv
 , fetchFromGitLab
 , cmake
@@ Line 1747: / Line 1360: @@
 }:
-mkDerivation rec {
+stdenv.mkDerivation rec {
   pname = "pdfmixtool";
   version = "1.0.2";
@@ Line 1977: / Line 1590: @@
 }
 </code>
+packaging java / jar file
+<code>
+  installPhase = ''
+    mkdir -p $out/{bin,lib}
+    cp ${src}/briar-desktop.jar $out/lib/
+    makeWrapper ${openjdk}/bin/java $out/bin/briar-desktop \
+      --add-flags "-jar $out/lib/briar-desktop.jar"
+  '';
+</code>
 ==== nixops ====
@@ Line 2031: / Line 1656: @@
 fatlabel /dev/sdb1 "mystick"
 </code>
 resize extX partition
 <code bash>
 sfdisk -l /dev/sdb
@@ Line 2116: / Line 1743: @@
 </code>
-===== avahi =====
-discover local services
-<code bash>
-avahi-browse --all --ignore-local --resolve --terminate
-</code>
 ===== curlftpfs =====
 <code bash>
@@ Line 2270: / Line 1893: @@
 </code>
-===== cups =====
-list printers
+===== qemu =====
+booting armv7 alpinelinux
+<code bash>
+# download kernel and stuff from here http://dl-cdn.alpinelinux.org/alpine/edge/releases/armv7/netboot/
+qemu-system-arm -M virt -m 512M -cpu cortex-a15 -kernel vmlinuz-lts -initrd initramfs-lts -append "console=ttyAMA0 ip=dhcp alpine_repo=http://dl-cdn.alpinelinux.org/alpine/edge/main/" -nographic
+</code>
+===== postgresql =====
+list all databases
+<code bash>
+sudo -u postgres psql
+# \l
+</code>
+drop database
+<code bash>
+sudo -u postgres psql
+# drop database gitlabhq_production;
+# drop database gitlabhq_production WITH (FORCE);
+</code>
+list tables
+<code bash>
+sudo -u postgres psql
+# \c gitlabhq_production
+# \dt
+</code>
+create and delete user
 <code>
-$ lpstat -p -d
+DROP ROLE gitlab;
-printer Dell_1250c is idle.  enabled since Tue 28 Dec 2021 09:44:59 AM UTC
+CREATE USER gitlab WITH PASSWORD 'test123';
-printer Dell_1250c_USB is idle.  enabled since Tue 28 Dec 2021 09:44:59 AM UTC
 </code>
-print file
+grant permissions
 <code>
-lp -d Dell_1250c_USB -o fit-to-page -o media=A4 scared_cat.png
+ALTER USER gitlab SUPERUSER;
+CREATE DATABASE gitlabhq_production OWNER gitlab;
+ALTER DATABASE gitlabhq_production OWNER TO gitlab;
 </code>
-list jobs
+dump database
 <code>
-$ lpstat
+pg_dump -U gitlab gitlabhq_production > /tmp/gitlab.pgsql
-Dell_1250c_USB-2        root            340992   Tue 28 Dec 2021 09:57:08 AM UTC
 </code>
-cancel job
+dump all
 <code>
-cancel 1
+pg_dumpall > /tmp/dump_file_name.tar
 </code>
-===== qemu =====
+import database
+<code>
-booting armv7 alpinelinux
+psql# CREATE DATABASE gitlabhq_production;
-<code bash>
+psql -U gitlab gitlabhq_production < gitlab.pgsql
-# download kernel and stuff from here http://dl-cdn.alpinelinux.org/alpine/edge/releases/armv7/netboot/
-qemu-system-arm -M virt -m 512M -cpu cortex-a15 -kernel vmlinuz-lts -initrd initramfs-lts -append "console=ttyAMA0 ip=dhcp alpine_repo=http://dl-cdn.alpinelinux.org/alpine/edge/main/" -nographic
 </code>

Project-Insanity

Site Tools

Differences

Page Tools