pretorh’s gists

pretorh / basic.md

Created January 25, 2016 15:46

Setup live arch vm

General setup of live arch VM

Setup on VM

Boot the vm, select x86 / x86_64 and enter
start ssh daemon:
- systemctl start sshd
change the root password
- passwd

Setup ssh

pretorh / Teamcity Postgres migration (mac).md

Last active November 8, 2023 12:57

Summary of steps required to migrate Teamcity database to a Postgres db on mac

Teamcity references (follow these/updated versions, use below as summary)

The steps are based on zsh history, so there might me some missing.

Directory locations

TeamCity Data Directory

/private/var/root/.BuildServer

pretorh / Listing watched files on kodi (xbmc).md

Last active May 23, 2022 16:58

Listing watched files on kodi (xbmc)

To list the full path of all watched files that are still accessable: (assuming the sql query was saved to list-watched-files.sql)

sqlite3 ~/.kodi/userdata/Database/MyVideos90.db < list-watched-files.sql | xargs -L 1 -I filename ls "filename" 2>/dev/null

Explanation

Get the list of watched files from the Kodi database

Kodi uses sqlite databases, located in ~/.kodi/userdata/Database/. The video database is MyVideosXX.db, where XX is the version (MyVideos90.db on OSMC on 2015-05-09)

pretorh / keybase.md

Created October 7, 2014 16:54

Keybase proof

I hereby claim:

I am pretorh on github.
I am pretorh (https://keybase.io/pretorh) on keybase.
I have a public key whose fingerprint is F7D8 8A0A 1F78 A572 8E6D BBA7 A676 D9AF 5767 085D

To claim this, I am signing this object: