Paul Fariello paulfariello
paulfariello
/ gist:f0b3469a79f536a005559b5b5d9fb5e9
Last active
October 27, 2021 09:02
OpenBSD 70 install on kimsufi
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| apt update | |
| apt install qemu | |
| wget -O /tmp/install70.iso https://cdn.openbsd.org/pub/OpenBSD/7.0/amd64/install70.iso | |
| qemu-system-x86_64 -hda /dev/sda -cdrom /tmp/install70.iso -curses -boot d |
paulfariello
/ ejabberd_mnesia_to_pgsql_new.sh
Created
January 21, 2019 13:30
Convert mnesia database to postgresql new schema
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/sh | |
| tables=$(grep "ADD COLUMN server_host" /usr/obj/ejabberd-18.06/sql/pg.new.sql | awk '{print $4}') | |
| domains="localhost example.org" | |
| for domain in $domains; do | |
| echo -n $domain: >&2 | |
| dump=$(mktemp /tmp/$domain.sql.XXXXXX) | |
| chown _ejabberd:_ejabberd $dump | |
| echo $dump >&2 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ### Keybase proof | |
| I hereby claim: | |
| * I am paulfariello on github. | |
| * I am paulfariello (https://keybase.io/paulfariello) on keybase. | |
| * I have a public key whose fingerprint is 56B1 766D 69E5 13DB 9E40 5BBB 672C DD20 31AA F49B | |
| To claim this, I am signing this object: |