MacPro

DaVinci Resolve Server

The MacPro hosts the DaVinci Resolve Server via PostgreSQL.

Configuration File

Here is the location of the config: sudo vim /Library/PostgreSQL/13/data/pg_hba.conf

Update the config as such:

# pg_hba.conf file has been edited by DaVinci Project Server. Hence, it is recommended to not edit this file manually.
# TYPE    DATABASE    USER    ADDRESS    METHOD
local    all    all    scram-sha-256
host    all    all    127.0.0.1/32    scram-sha-256
host    all    all    ::1/128    scram-sha-256
host all all 192.168.1.0/24 scram-sha-256
host all all 192.168.3.0/24 scram-sha-256

Note: You must add entries for hosting the WAN (e.g. 192.168.1.0/24) and the VPN (192.168.3.0/24). The VPN address will always need to be added, otherwise you will not be able to connect from VPN.

Restart Postgres

sudo -u postgres /Library/PostgreSQL/13/bin/pg_ctl restart -D /Library/PostgreSQL/13/data

Daily Logs

I was able to find the cause of the VPN not connecting by reviewing the logs: sudo ls /Library/PostgreSQL/13/data/log

Here was the output from the failed config:

resolve:~ Joshua$ sudo cat /Library/PostgreSQL/13/data/log/postgresql-2024-01-09_235442.log
2024-01-09 23:54:42.917 EST [55004] LOG:  starting PostgreSQL 13.4 on x86_64-apple-darwin, compiled by Apple clang version 11.0.3 (clang-1103.0.32.59), 64-bit
2024-01-09 23:54:42.918 EST [55004] LOG:  listening on IPv6 address "::", port 5432
2024-01-09 23:54:42.918 EST [55004] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2024-01-09 23:54:42.918 EST [55004] LOG:  listening on Unix socket "/tmp/.s.PGSQL.5432"
2024-01-09 23:54:42.940 EST [55006] LOG:  database system was shut down at 2024-01-09 23:54:42 EST
2024-01-09 23:54:42.948 EST [55004] LOG:  database system is ready to accept connections
2024-01-09 23:54:52.605 EST [55048] FATAL:  no pg_hba.conf entry for host "192.168.3.2", user "postgres", database "WSP INTERVIEWS", SSL off
2024-01-09 23:54:55.709 EST [55049] FATAL:  no pg_hba.conf entry for host "192.168.3.2", user "postgres", database "WSP INTERVIEWS", SSL off

File:MacPro.png

Classic Mac Pro

The MacPro is a server that hosts a variety of services like the DaVinci Resolve Server.

Born in 2012 and still a formidable machine. It has been upgraded with a dual hex-core (12-core) Xeon Processors, 1TB NVMe storage, and 96GB RAM.

It can edit 6K video and it can still burn CD-ROMs!

For security, there is no port forwarding to the device; it can only be accessed via SSH or VNC over VPN.

Remote Desktop

DaVinci Resolve

Video editing via resolve locally or remote.

Hosting

Software Updates

We use OpenCore to keep MacOS up-to-date and extend the life of this now vintage machine.

As a result, WiFi and Bluetooth no longer work as of OS X Catalina.