OpenBSD

FullBGP at Home

did you always wanted to have a fullbgp table at home once ? Over your DSL / CM / LTE or whatever connection ? here a little howto :) Setup VM Install a VM with OpenBSD. Add 1 CPU, 1 GB RAM, 20 GB Disk, nothing special Check our Upstream Provider Check the Page from Lukasz and spend him a Beer if you ever meet him. Edit your Config set the router-id to your Public IP.

OpenBSD 6.8

will be released in Nov 2020 … expect an update during this time :) sha256: de21329ae3787e6300e7da3896ae5c26357ca2263723f5cf9c95d90a2debcc4d

Tunnel IPv4 over IPv6

let’s do the opposite. you have some ipv6 connectifity and need to transport ipv4 Host A (IPv6 only) root@hosta ~# ifconfig vio0 vio0: flags=208843<UP,BROADCAST,RUNNING,SIMPLEX,MULTICAST,AUTOCONF6> mtu 1500 lladdr 56:00:02:e7:9d:e5 index 1 priority 0 llprio 3 groups: egress media: Ethernet autoselect status: active inet6 fe80::5400:2ff:fee7:9de5%vio0 prefixlen 64 scopeid 0x1 inet6 2a05:f480:1400:7b6:a9e0:6a15:217:cc5c prefixlen 64 autoconf pltime 604627 vltime 2591827 inet6 2a05:f480:1400:7b6:446d:acb7:5fe4:450f prefixlen 64 autoconf autoconfprivacy pltime 86046 vltime 172537 root@hosta ~# i3 IPv4: !

Tunnel IPv6 over IPv4

let’s assume you need ipv6 connectifity somewhere … You can use some Tunnelbrokers or your run OpenBSD on your Boxes and want todo it on your own. Here some hints. Server with DualStack you need a Maschine out in the Internet which is DualStacked stoege@dualstack$ i3 IPv4: 11.22.33.44 IPv6: 2001:db8:100::100 Host with IPv4 only stoege@ipv4 host ~# i3 IPv4: 55.66.77.88 IPv6: !NETWORK and you want to bring IPv4 to the second host

Wireguard on (current | 6.8 and higher )

Wireguard on OpenBSD OpenBSD added wg to the Kernel a while ago … why not have a look into and do some speedtests … ? Setup CLIENT1 — WireGuard — CLIENT2 and running tcpbench between Client1 and Client2 Fireup VMs Stage 3 VM’s on my litte Proxmox Server (Intel NUC) host nic ip wg nic ip Client1 em0 192.168.108.7 wg0 10.0.0.1 WireGuard em0 192.

Bigdata

How to Process Large Files … ? Large is a variable Term, 700 GB is large for me, while it could be a small peace for others. Assuming you need to count the lines … this simple Task can take minutes ! Size [user@host /tmp]$ du -sh bigfile 745G bigfile Wordcount -> 10 min if you need to count the lines, use the wordcount command and you get the exact number … but you have to wait for minutes, depending in your disk subsystem and the file size of course

Git

Some Git Commands Merge two Repos “merge unrelated histories” git pull origin master --allow-unrelated-histories git push git pull ### Find deleted File git log --diff-filter=D --summary commit abcecadce91af3814662fa6a04d0f12e361f0574 Date: Sun May 31 23:19:59 2020 +0200 update delete mode 100644 master/sed.tcpdump commit 81ae58d70c27d02eb2f65beed4fe0b571073f087 Date: Fri May 29 16:06:14 2020 +0200 update Restore deleted File git checkout 81ae58d70c27d02eb2f65beed4fe0b571073f087 sed.tcpdump Remove Sensitive Data https://help.github.jp/enterprise/2.11/user/articles/removing-sensitive-data-from-a-repository/ git filter-branch --force --index-filter \ 'git rm --cached --ignore-unmatch .

OpenBSD 6.7

OpenBSD 6.7 appeared today OpenBSD has two new releases every year. historically, on 1. Mai and 1. November. With a few small execptions in the past Check Wikipedia so, then latest OS appeared today: OpenBSD 6.7 Perform a Full Upgrade (incl. X Stuff) sysupgrade -r Run the Script (on your own risk !) doas su - mkdir /root/bin ftp -o /root/bin/upgrade_to_67.sh https://puffy.nolink.ch/scripts/upgrade_to_67.sh chmod 740 /root/bin/upgrade_to_67.sh # /root/bin/upgrade_to_67.sh or use some custom Script (just Xbase and not other X Stuff) doas su - mkdir /root/bin cat <<'EOF' > /root/bin/upgrade_to_67.

OpenBSD Add Storage

you’ve got a maschine and you’re running out of disk space. attach a new disk like this: # fdisk -i sd1 Note: Substitue sd1 for your disk. ... # disklabel -E sd1 > p m > a a > quit # newfs sd1a # mkdir /data # mount /dev/sd1a /data/ and make permament in /etc/fstab sha256: a46795646adfce7e60b87c10e0cf9146e356855ecc8b4b1aeae6f4027e00c8d1

Sqlite

Do you like SQLite ? just started using it a bit more often … https://www.sqlitetutorial.net/ Query sqlite3 /path/to/db “select date,time,ip from table where ip=‘1.2.3.4’ limit 100; .schema show the database schema and indexes sqlite> .schema CREATE TABLE attack( "date" TEXT, "time" TEXT, "ip" TEXT, "asnr" TEXT, "ascountry" TEXT, "asdesc" TEXT, "port" TEXT, "proto" TEXT, "server" TEXT, "type" TEXT, "method" TEXT, "pass" TEXT, "user" TEXT, "ver" TEXT ); CREATE UNIQUE INDEX id on attack(date,time,ip,user,pass); Insert INSERT INTO table (column1,column2 ,.