Wreckroom - User contributions [en]

MacPro

2024-01-10T10:04:30Z

Josh: /* DaVinci Resolve Project Server */

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, 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]]:

<code>vnc://username@resolve.wreckroom.nyc</code>

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

=== Configuration File===
Here is the location of the config:

<code>sudo vim /Library/PostgreSQL/13/data/pg_hba.conf</code>

For the initial configuration, update the config as such:

<syntaxhighlight>
# 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
</syntaxhighlight>

'''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:

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

=== Daily 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>

Here was the output from the failed config:
<syntaxhighlight>
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
</syntaxhighlight>

= Software Updates =

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.

===Limitations===

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

MacPro

2024-01-10T10:04:03Z

Josh:

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, 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]]:

<code>vnc://username@resolve.wreckroom.nyc</code>

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

=== Configuration File===
Here is the location of the config:

<code>sudo vim /Library/PostgreSQL/13/data/pg_hba.conf</code>

For the initial configuration, update the config as such:

<syntaxhighlight>
# 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
</syntaxhighlight>

'''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:

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

=== Daily 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>

Here was the output from the failed config:
<syntaxhighlight>
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
</syntaxhighlight>

= Software Updates =

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.

===Limitations===

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

DaVinci Resolve Project Server

2024-01-10T10:03:17Z

Josh:

The [[DaVinci Resolve Server]] is a dedicated server which hosts all Resolve projects at [[Wreckroom]].

=Introduction=
This guide is designed to assist you in connecting to the [[DaVinci Resolve Server]]. It's important to note that this server is distinct from the [[Media Server]].

=Prerequisites=
You must be running '''DaVinci Resolve 18.5''' or '''DaVinci Resolve Studio''' '''18.5''' ''or higher''.

Ensure you are connected to the [[Media Server]] and have access to all the files in the <code>wreckroom</code> disk.

=Step-by-Step Guide=
Accessing the DaVinci Project Library through the [[DaVinci Resolve Server]]:

===Network Setting:===
Begin by being on the network setting in the main open folder when you start the software.

===Add Project Library:===
Within this section, you have two primary actions: 'Connect' and 'Create'.

===Connect (For Existing Projects):===
If you need to access an already established project (e.g., remote access from a different location):

Click 'Add Project Library', then go to the 'Connect' tab.

Here, you can access pre-made folders, such as WSP INTERVIEWS, created on '''resolve.wreckroom.nyc'''

By selecting 'Connect', you will onboard all the projects, including those for future months (e.g., December 2023).
Create (For New Projects):

===Create (For New Projects):===

To create a new folder for projects that haven't been done before (e.g., daylight session, showcase, or a completely new project):

Go under the 'Create' tab after selecting 'Add Project Library'.

Name the new folder, adhering to the naming conventions (preferably in all caps).

Crucial: Set the location to '''resolve.wreckroom.nyc''' to ensure that the new project library is created on the Resolve server.

=Conclusion=

By following these steps, you can effectively log into the [[DaVinci Resolve Server]] and manage your projects. If you encounter any issues or have questions, please don't hesitate to reach out for support.

MacPro

2024-01-10T10:02:55Z

Josh: /* DaVinci Resolve Server */

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, 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]]:

<code>vnc://username@resolve.wreckroom.nyc</code>

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

=== Configuration File===
Here is the location of the config:

<code>sudo vim /Library/PostgreSQL/13/data/pg_hba.conf</code>

For the initial configuration, update the config as such:

<syntaxhighlight>
# 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
</syntaxhighlight>

'''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:

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

=== Daily 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>

Here was the output from the failed config:
<syntaxhighlight>
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
</syntaxhighlight>

= Software Updates =

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.

===Limitations===

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

Web Server

2024-01-10T09:12:02Z

Josh: /* PM2 */

The Synology hosts [https://wreckroom.nyc https://wreckroom.nyc] over 443 using a NGINX Reverse Proxy via <code>localhost:3000</code>.
==PM2==

'''PM2''' is a process manager that serves the [https://en.wikipedia.org/wiki/Npm npm] NextJS App [https://wreckroom.nyc https://wreckroom.nyc]

Upon restarting the Synology, you will to restart PM2 in <code>/volume1/wreckroom.nyc/wreckroom</code> by following these steps:

#End all processes: <code>sudo pm2 delete all</code>.
#Start the [https://en.wikipedia.org/wiki/Npm npm] process using '''PM2''': <code>sudo pm2 start npm -- start</code>.

If you are having issues with '''PM2''' process manager serving the NextJS app (when <code>sudo npm run start</code> works fine), use the above steps as well.

==Certificates==
If you make changes to a Certificate's FQDN, in addition to migrating the certificate, you ''must'' go to Control Panel / Login Portal / Advanced / Reverse Proxy. The hostname must be changed there for everything to work properly! This took half a day to figure out last time, hope it saves you some time in the future :)

Web Server

2024-01-10T09:11:32Z

Josh: /* PM2 */

The Synology hosts [https://wreckroom.nyc https://wreckroom.nyc] over 443 using a NGINX Reverse Proxy via <code>localhost:3000</code>.
==PM2==

'''PM2''' is a process manager that serves the [https://en.wikipedia.org/wiki/Npm npm] NextJS App [https://wreckroom.nyc https://wreckroom.nyc]

Upon restarting the Synology, you will to restart PM2 in <code>/volume1/wreckroom.nyc/wreckroom</code> by following these steps:

#End all processes: <code>sudo pm2 delete all</code>.
#Start the [https://en.wikipedia.org/wiki/Npm npm] process using '''PM2''': <code>sudo pm2 start npm -- start</code>.

If you are having issues with '''PM2''' process manager serving the NextJs app (when <code>sudo npm run start</code> works fine), use the above steps as well.

==Certificates==
If you make changes to a Certificate's FQDN, in addition to migrating the certificate, you ''must'' go to Control Panel / Login Portal / Advanced / Reverse Proxy. The hostname must be changed there for everything to work properly! This took half a day to figure out last time, hope it saves you some time in the future :)

Synology

2024-01-10T09:11:03Z

Josh: /* SMB File Server */

The Synology is a Network Attached Storage (NAS) and Linux Server that runs many different processes that are essential to [[Wreckroom]].

=Public=

===[[MediaWiki]]===
Uses MariaDB 10 and MediaWiki applications.

===[[Web Server]]===
NGINX reverse proxy runs wreckroom.nyc over 443/3000.

==Private==
===[[Media Server]]===
Serves files behind the [[VPN]].

2024-01-10T08:30:47Z

Josh: /* UniFi */

Welcome! Here is the place for everything you need to know about [[Wreckroom]].

=Media Verticals=
JK: What is a media vertical?

===[[Performance Series]]===
What is this?

===[[Interviews]]===
What is that?

===[[WRNY]]===

WRNY a 24 hour Youtube Radio Station, featuring all the artists that we have hand selected to perform at [[Safe & Sound Studios]].

=Access=
You can access Wreckroom remotely via [[VPN]] or onsite. You will need to mount the [[SMB File Server]] to access the media and [[DaVinci Resolve Project Server]] for video editing.
==Remote Access==
===[[VPN]]===

If you are working from home, connect to the [[VPN]] to access Wreckroom media files and storage ''remotely''.

==Media Access==
Regardless of if you are at home or in the studio, you can access the Wreckroom servers:

===[[Media Server]]===
Connect to [[Wreckroom]]'s vast media library.

====[[File Naming Conventions]]====
Learn about how files on the server are to be named! TL;DR ALL CAPS

== Project Access ==

===[[DaVinci Resolve Project Server]]===
A Network Server to edit files remotely in resolve

====[[Creating Proxies in Resolve Server]]====
Learn how creating proxy media on the [[Media Server]] helps speed up performance over the [[DaVinci Resolve Project Server]]!

=Help=

===[https://www.mediawiki.org/wiki/Cheatsheet Wiki Syntax Cheatsheet]===

= Network Administration =

===[[Synology]]===
The Synology is a Network Attached Storage (NAS) and Linux Server that runs many different processes that are essential to [[Wreckroom]].

===[[MacPro]]===
The MacPro runs the [[DaVinci Resolve Server]] and hosts [[OBS]] for [[WRNY]].

===[[UniFi]]===
We have a 2.5G network...LFG!

Wreckroom

2024-01-10T08:30:28Z

Josh: /* UniFi */

Synology

2024-01-10T08:29:58Z

Josh: /* OpenVPN */

The Synology is a Network Attached Storage (NAS) and Linux Server that runs many different processes that are essential to [[Wreckroom]].

==Public==
===[[VPN | OpenVPN]]===
Runs on TCP port 1194 hosted on [[UniFi | UniFi Network]].

===[[MediaWiki]]===
Uses MariaDB 10 and MediaWiki applications.

===[[Web Server]]===
NGINX reverse proxy runs wreckroom.nyc over 443/3000.

==Private==
===[[SMB File Server]]===
Serves files behind the [[VPN]].

Synology

2024-01-10T08:29:33Z

Josh: /* OpenVPN */

The Synology is a Network Attached Storage (NAS) and Linux Server that runs many different processes that are essential to [[Wreckroom]].

==Public==
===[[VPN | OpenVPN]]===
Runs on TCP port 1194 hosted on [[UniFi Network | UniFi]].

===[[MediaWiki]]===
Uses MariaDB 10 and MediaWiki applications.

===[[Web Server]]===
NGINX reverse proxy runs wreckroom.nyc over 443/3000.

==Private==
===[[SMB File Server]]===
Serves files behind the [[VPN]].

2024-01-10T08:23:53Z

Josh: /* Directory Structure */

The [[Media Server]] is used to host videos, audio, and any media capture involved with wreckroom in a centralized location that is accessible remotely via [[VPN]].

=Connect=
[[Media Server | SMB]] (Server Message Block) is a web protocol used to share files over a computer network.

== Mac ==
In Finder, press <code>Command + K</code> to bring up '''Connect to Server'''.

<code>smb://username@resolve.wreckroom.nyc/wreckroom</code>

Where '''username''' is your username provided by Justin and your password was provided via email.

=Directory Structure=

===[[File Naming Conventions]]===
Learn about how files on the server are to be named! TL;DR ALL CAPS

Media Server

2024-01-10T08:23:39Z

Josh:

2024-01-10T08:16:46Z

Josh: /* Audio & Video Editing */

Welcome! Here is the place for everything you need to know about [[Wreckroom]].

=Media Verticals=

===[[Performance Series]]===

===[[Interviews]]===

===[[WRNY]]===

WRNY a 24 hour Youtube Radio Station, featuring all the artists that we have hand selected to perform at [[Safe & Sound Studios]].

=Media and Project Access=
You can access Wreckroom remotely via [[VPN]] or onsite. You will need to mount the [[SMB File Server]] to access the media and [[DaVinci Resolve Server]] for video editing.
==Remote Access==
===[[VPN]]===

If you are working from home, connect to the [[VPN]] to access Wreckroom media files and storage ''remotely''.

==Media Access==
Regardless of if you are at home or in the studio, you can access the Wreckroom servers:

===[[SMB File Server]]===
Contains all [[Wreckroom]] media.

====[[File Naming Conventions]]====
:Learn about how files on the server are to be named! TL;DR ALL CAPS

== Project Access ==

===[[DaVinci Resolve Project Server]]===
:A Network Server to edit files remotely in resolve

====[[Creating Proxies in Resolve Server]]====

=Help=

===[https://www.mediawiki.org/wiki/Cheatsheet Wiki Syntax Cheatsheet]===

= Network Administration =

===[[Synology]]===
The Synology is a Network Attached Storage (NAS) and Linux Server that runs many different processes that are essential to [[Wreckroom]].

===[[MacPro]]===
The MacPro runs the [[DaVinci Resolve Server]] and hosts [[OBS]] for [[WRNY]].

===[[UniFi]]===
The network setup we uses 2.5G LFG!