MacPro: Difference between revisions

From Wreckroom
Jump to navigation Jump to search
 
(20 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=DaVinci Resolve (Studio)=
The [[MacPro]] is a MacOS server that hosts A/V editing software e.g., [[DaVinci Resolve (Studio)]] and [[DaVinci Resolve Project 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, 512GB NVMe storage, and 96GB RAM.
 
It's the only machine we know of that can edit 6K video and 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]]:
The [[MacPro]] is capable of 6K Video editing locally or remote via [[VNC]] over [[VPN]]:
Line 5: Line 13:
<code>vnc://username@resolve.wreckroom.nyc</code>
<code>vnc://username@resolve.wreckroom.nyc</code>


=[[DaVinci Resolve Server]]=
=[[DaVinci Resolve Project Server]]=
The [[MacPro]] hosts the [[DaVinci Resolve Server]] via [[PostgreSQL]].
The [[MacPro]] also hosts the [[DaVinci Resolve Server]] via [[PostgreSQL]].


=== Configuration File===
=== Configuration File===
Here is the location of the config:
Here is the location of the config:
<code>sudo vim /Library/PostgreSQL/13/data/pg_hba.conf</code>
<code>sudo vim /Library/PostgreSQL/13/data/pg_hba.conf</code>


Update the config as such:
For the initial configuration, update the config as such:


<syntaxhighlight>
<syntaxhighlight>
Line 28: Line 37:
====Restart Postgres====
====Restart Postgres====


Restart the postgres services via terminal to apply changes to config:
=====Big Sur=====
<code>sudo -u postgres /Library/PostgreSQL/13/bin/pg_ctl restart -D /Library/PostgreSQL/13/data</code>
<code>sudo -u postgres /Library/PostgreSQL/13/bin/pg_ctl restart -D /Library/PostgreSQL/13/data</code>


Line 33: Line 44:


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


Line 47: Line 59:
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
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
</syntaxhighlight>
</syntaxhighlight>
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 =
= Software Updates =
Line 60: Line 64:
We use [https://dortania.github.io/OpenCore-Legacy-Patcher/ OpenCore] to keep MacOS up-to-date and extend the life of this now vintage machine.
We use [https://dortania.github.io/OpenCore-Legacy-Patcher/ 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.
===Limitations===
 
*As a result, WiFi and Bluetooth no longer work as of OS X Catalina.

Latest revision as of 10:58, 22 February 2024

The MacPro is a MacOS server that hosts A/V editing software e.g., DaVinci Resolve (Studio) and DaVinci Resolve Project 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, 512GB NVMe storage, and 96GB RAM.

It's the only machine we know of that can edit 6K video and 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)[edit]

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

vnc://username@resolve.wreckroom.nyc

DaVinci Resolve Project Server[edit]

The MacPro also hosts the DaVinci Resolve Server via PostgreSQL.

Configuration File[edit]

Here is the location of the config:

sudo vim /Library/PostgreSQL/13/data/pg_hba.conf

For the initial configuration, 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[edit]

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

Big Sur[edit]

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

Daily Logs[edit]

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[edit]

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

Limitations[edit]

  • As a result, WiFi and Bluetooth no longer work as of OS X Catalina.
Retrieved from "https://wiki.wreckroom.nyc/index.php?title=MacPro&oldid=419"