Teamspeak server

If you want to host your own teamspeak server this can be done quite easily with a server and docker-compose. Here is the example I tried:

version: '3.1'
services:
  teamspeak:
    image: teamspeak
    restart: always
    ports:
      - 9987:9987/udp
      - 10011:10011
      - 30033:30033
    environment:
      TS3SERVER_DB_PLUGIN: ts3db_mariadb
      TS3SERVER_DB_SQLCREATEPATH: create_mariadb
      TS3SERVER_DB_HOST: db
      TS3SERVER_DB_USER: root
      TS3SERVER_DB_PASSWORD: tsmysqlpass
      TS3SERVER_DB_NAME: teamspeak
      TS3SERVER_DB_WAITUNTILREADY: 30
      TS3SERVER_LICENSE: accept
  db:
    image: mariadb
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: tsmysqlpass
      MYSQL_DATABASE: teamspeak

You will need a dns entry or the ip of the server to connect with your teamspeak client. With the client you can then add a password to protect the server. I didn’t find a docker config to set it.

ATTENTION: If you don’t secure the server with credentials it will be open for everybody.

Nextcloud fix installation

After some updates the installation/the database needs to be fixed. This can be done with the command line tool on a debian system where the installation belongs to the apache user www-data:

cd <installdir>
sudo -u www-data php occ db:add-missing-indices
sudo -u www-data php occ db:add-missing-columns

Resize mp4 with ffmpeg

Zoom didn’t want to accept a background video so I tried to find a way to shrink its size to 1080p. There is a simple command to do that with ffmpeg:

ffmpeg -i original.mp4 -vf scale=1920:1080 new_1080p.mp4

DaVinci Resolve 16 Linux mp4/h.264 encode/decode

DaVinci Resolve doesn’t support import or export of mp4 format on Linux. It is working on Windows 10, but I really don’t want to switch to boot into Windows for rendering.

So i looked around and found a workflow for using Resolve under Linux: ffmpeg is my tool of choice to change formats so that Resolve is able to load and write my videos.

My recordings from OBS are saved as mkv as proposed by an OBS warning in the recording settings.

mkv to mov

ffmpeg -i input.mkv -map 0:0 -map 0:1 -map 0:2 -vcodec dnxhd -acodec:0 pcm_s16le -acodec:1 pcm_s16le -s 1920x1080 -r 30000/1001 -b:v 36M -pix_fmt yuv422p -f mov output.mov

After converting the recording to the mov format DaVinci Resolve 16 is able to use the file with all audio tracks.

mp4 to mov

If I get videos from other sources most of the time its in mp4 format. With the following command I convert the mp4 to DaVinci Resolve usable mov:

ffmpeg -i input.mp4 -vcodec dnxhd -acodec pcm_s16le -s 1920x1080 -r 30000/1001 -b:v 36M -pix_fmt yuv422p -f mov output.mov

mov to mp4

In DaVinci Resolve 16 I export my videos with mov format and then convert them to youtube ready mp4 with this command:

ffmpeg -i input.mov -vf yadif -codec:v libx264 -crf 1 -bf 2 -flags +cgop -pix_fmt yuv420p -codec:a aac -strict -2 -b:a 384k -r:a 48000 -movflags faststart output.mp4

TLDR

DaVinci Resolve 16 does NOT support h.264 en-/decoding on Linux and you have to transcode your videos for example with ffmpeg as shown above. Transcoding is quite fast also on my 6 year old machine.

Windows ln style softlinks with mklink

You can use softlinks (linux: ln -s source target) under windows.

MKLINK [[/D] | [/H] | [/J]] Link Target

        /D      Creates a directory symbolic link.  Default is a file
                symbolic link.
        /H      Creates a hard link instead of a symbolic link.
        /J      Creates a Directory Junction.
        Link    Specifies the new symbolic link name.
        Target  Specifies the path (relative or absolute) that the new link
                refers to.

The example mklink /D jdk11 jdk-11.0.7.10-hotspot will create a softlink with name jdk11 to folder jdk-11.0.7.10-hotspot in the same directory.

Update

This page now also supports translations. I am going to try writing posts in English and German from now. Old pages won’t be translated unless somebody requests it.

How NOT to offer a product

Its quite common to offer freemium software with missing premium features but writing a paid product (without a free version at all) that targets to send personal data over a network and make users upgrade from the basic to pro version to at least have their private data encrypted is an absolute no-go in my opinion. I cut out the relevant part of the offer. Basic version is 29 and pro 39 USD.

Recharable batteries, AA and AAA

Will use only recharable batteries from now on:
– Varta rechargeable battery AA, ready to use, 1000mAh: https://amzn.to/3bQxJWz
– Varta rechargeable battery AAA, ready to use, 2600mAh: https://amzn.to/2y290Qp

Home Studio Setup

I just set up a new live-streaming/video-conferencing system for home office and I want to share my part list with you. If you decide to buy parts from my list please consider using my links which would support me a little bit.

Video

Sony Alpha 6400 with 18-135mm lens (for using it for photos too): https://amzn.to/35hstJ7
Sigma 16mm F1.4 DC DN Contemporary Lens (as webcam): https://amzn.to/3aAqksT
Micro HDMI to HDMI Cable (to connect with the capture card)
- 2m: https://amzn.to/2Y0IGR0 or 3m: https://amzn.to/2x9VTfn
Corsair Elgato Game Capture 4K60 Pro MK.2: https://amzn.to/2KwNndD
2x Godox LEDP260C video light: https://amzn.to/2S82Vsd
3x Manfrotto Element Monopod Alu (2x lights, 1x cam): https://amzn.to/3bG14mm
2x K & M 237 Table Clamp (mount lights): https://amzn.to/2zrnpWp
Tarion Reducing Threads (to put the lights on the stands): https://amzn.to/3bQBRpz
2x K & M 21918 Reducing thread (for table clamps to monopods, bottom of monopods have M8 threading): https://amzn.to/2KFMj6Z
Zacro Ball Head Tripod head (for mounting the cam on one monopod): https://amzn.to/2xZG5we (on the bottom I used a M8 screw to mount the cam monopod to the table)
Rollei C6i Carbon compact tripod (optional for taking photos): https://amzn.to/357huBU

Audio

Beyerdynamic DT 770 Headphones: https://amzn.to/2xXI8AM
Røde NT-1A microphone: https://amzn.to/3bDKG5H
Røde PSA1 articulated arm stand: https://amzn.to/3cZIBBF
Focusrite Scarlett 2i2 3rd Gen Audio Interface: https://amzn.to/2S9oQPN

change wordpress url in database

if you need to move wordpress to a new url then the following sql script will be handy (update the urls in it of course):

UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldurl', 'http://www.newurl') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'http://www.oldurl','http://www.newurl');

UPDATE wp_posts SET post_content = replace(post_content, 'http://www.oldurl', 'http://www.newurl');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.oldurl','http://www.newurl');

blog.coffeebeans.at

Solutions to everyday IT problems