MacPro
Editing Rig
DaVinci Resolve
Video editing via resolve locally or remote via VNC:
vnc://username@resolve.wreckroom.nyc
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-256Note: 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
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.
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.