MacPro

The MacPro is a MacOS server that hosts A/V editing software e.g., DaVinci Resolve Studio and DaVinci Resolve Server.

Born in 2012 and still a formidable machine in the year of our lord 2024! 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.

DaVinci Resolve (Studio)

The MacPro is capable of 6K Video editing locally or remote via VNC over VPN:

vnc://username@resolve.wreckroom.nyc

DaVinci Resolve Server

The MacPro hosts the DaVinci Resolve Server via PostgreSQL.

Configuration

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

Restart the postgres services via terminal to apply changes to config:

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

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.