Wreckroom - User contributions [en]

Web Server

2026-04-28T21:55:42Z

192.168.1.1:

= Synology Site Management =

Both sites are hosted on '''mainsqueeze''' (Synology) behind NGINX Reverse Proxy, served over 443.

{| class="wikitable"
! Site !! Local Port !! Directory
|-
| [https://wreckroom.nyc wreckroom.nyc] || <code>localhost:3000</code> || <code>/volume2/wreckroom.nyc/wreckroom.nyc</code>
|-
| [https://justinbjur.com justinbjur.com] || <code>localhost:3001</code> || <code>/volume2/justinbjur.com/justinbjur.com</code>
|}

== Updating Site Content ==
# Make changes locally and commit to GitHub
# SSH into mainsqueeze: <code>ssh guernica@wreckroom.nyc</code>
# Navigate to the site and pull:
## <code>cd /volume2/wreckroom.nyc/wreckroom.nyc</code> (or justinbjur.com)
## <code>git pull</code>
# Restart pm2: <code>sudo pm2 restart wreckroom.nyc</code> (or justinbjur.com)

== PM2 ==
'''PM2''' is a process manager that keeps both Next.js apps alive on the server.

=== Current Processes ===
{| class="wikitable"
! Name !! Command
|-
| <code>wreckroom.nyc</code> || <code>npm run start</code>
|-
| <code>justinbjur.com</code> || <code>npm run start</code>
|}

=== After a Synology Reboot ===
PM2 should auto-resume if <code>pm2 save</code> was run. If not, restart manually:
# <code>cd /volume2/wreckroom.nyc/wreckroom.nyc</code>
# <code>sudo pm2 start npm --name "wreckroom.nyc" -- run start</code>
# <code>cd /volume2/justinbjur.com/justinbjur.com</code>
# <code>sudo pm2 start npm --name "justinbjur.com" -- run start</code>
# <code>sudo pm2 save</code>

=== Troubleshooting ===
If a site is down and pm2 shows an error, delete and restart that process:
# <code>sudo pm2 delete wreckroom.nyc</code>
# <code>sudo pm2 start npm --name "wreckroom.nyc" -- run start</code>
# <code>sudo pm2 save</code>

== Certificates ==
If you modify a certificate's FQDN, you '''must''' also update the reverse proxy entry.

'''Control Panel → Login Portal → Advanced → Reverse Proxy'''

Update the hostname there — without this step the site will not resolve correctly even after migrating the cert. This has cost half a day before, don't skip it.

MacPro

2024-02-22T15:58:53Z

192.168.1.1: /* Restart Postgres */

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

<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:
=====Big Sur=====
<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.

WRNY

2024-02-06T03:13:02Z

192.168.1.1: /* Sorting and Categorizing: */

=Categories=

===[[Roots]]===

Associated Element: EARTH

GENRE MOST COMMON: Hip-hop / R&b

IS CLASSIFIED BY MUSIC THAT PULLS STRONGLY FROM SOURCE INSPIRATIONS OF SOUL, RNB, JAZZ, BLUES AND OTHER EARLY MUSICAL STYLES

===[[Hearth]]===

Associated Element: FIRE

GENRE MOST COMMON: SINGER SONGWRITER / FOLK

IS CLASSIFIED BY MUSIC THAT WORKS TO BE IN SERVICE OF THE STORY. CAMPFIRE MUSIC, FOLK AND ANYTHING THAT FEELS LIKE IT’S MADE TO HIT THE HEART

===[[The Edge]]===

Associated Element: AIR

GENRE MOST COMMON: ROCK / INDIE / ALTERNATIVE

IS CLASSIFIED BY MUSIC THAT IS MUSICALLY INTENSE OR INSPIRED BY A REBELLIOUS SPIRIT. INNOVATIVE AND GENRE-DEFYING FITS THIS CATEGORY.

===[[The Wave]]===

Associated Element: WATER

GENRE MOST COMMON: CONTEMPORARY POP MUSIC

IS CLASSIFIED BY MUSIC THAT IS FOCUSED ON CURRENT TRENDS AND MUSICAL APPROACHES

=WRNY Radio Media Content Management=

These categories are arranged in time blocks and include selected performances from artists that have performed at Safe and Sound Studios.

==Process for Managing Media Content==

===[[Media Access]]:===

Acquire media access and log into the WRNY Resolve folder.

===Uploading Performances:===

Upload new performance audio and video from Safe and Sound Showcases, Daylight Sessions, or other performances at Safe and Sound Studios.

Ensure media is uploaded with correct [[File Naming Conventions|naming conventions]] into new bin within the project.

===Sorting and Categorizing:===

From the sorting timeline, separate each track.

Dictate the start and stop times for each song accurately.

Drag and categorize each track into the appropriate category:

[[Roots]]

[[Hearth]]

[[The Edge]]

[[The Wave]]

===Final Step:===

Notify Corey once the sorting and categorizing process is complete. Corey will then curate the music within the block.

WRNY

2024-02-06T03:12:33Z

192.168.1.1: /* The Wave */

=Categories=

===[[Roots]]===

Associated Element: EARTH

GENRE MOST COMMON: Hip-hop / R&b

IS CLASSIFIED BY MUSIC THAT PULLS STRONGLY FROM SOURCE INSPIRATIONS OF SOUL, RNB, JAZZ, BLUES AND OTHER EARLY MUSICAL STYLES

===[[Hearth]]===

Associated Element: FIRE

GENRE MOST COMMON: SINGER SONGWRITER / FOLK

IS CLASSIFIED BY MUSIC THAT WORKS TO BE IN SERVICE OF THE STORY. CAMPFIRE MUSIC, FOLK AND ANYTHING THAT FEELS LIKE IT’S MADE TO HIT THE HEART

===[[The Edge]]===

Associated Element: AIR

GENRE MOST COMMON: ROCK / INDIE / ALTERNATIVE

IS CLASSIFIED BY MUSIC THAT IS MUSICALLY INTENSE OR INSPIRED BY A REBELLIOUS SPIRIT. INNOVATIVE AND GENRE-DEFYING FITS THIS CATEGORY.

===[[The Wave]]===

Associated Element: WATER

GENRE MOST COMMON: CONTEMPORARY POP MUSIC

IS CLASSIFIED BY MUSIC THAT IS FOCUSED ON CURRENT TRENDS AND MUSICAL APPROACHES

=WRNY Radio Media Content Management=

These categories are arranged in time blocks and include selected performances from artists that have performed at Safe and Sound Studios.

==Process for Managing Media Content==

===[[Media Access]]:===

Acquire media access and log into the WRNY Resolve folder.

===Uploading Performances:===

Upload new performance audio and video from Safe and Sound Showcases, Daylight Sessions, or other performances at Safe and Sound Studios.

Ensure media is uploaded with correct [[File Naming Conventions|naming conventions]] into new bin within the project.

===Sorting and Categorizing:===

From the sorting timeline, separate each track.

Dictate the start and stop times for each song accurately.

Drag and categorize each track into the appropriate category:

[[Urban]]

[[Singer Songwriter]]

[[Alternative]]

[[Pop]]

===Final Step:===

Notify Corey once the sorting and categorizing process is complete. Corey will then curate the music within the block.

WRNY

2024-02-06T03:12:10Z

192.168.1.1: /* The Edge */

=Categories=

===[[Roots]]===

Associated Element: EARTH

GENRE MOST COMMON: Hip-hop / R&b

IS CLASSIFIED BY MUSIC THAT PULLS STRONGLY FROM SOURCE INSPIRATIONS OF SOUL, RNB, JAZZ, BLUES AND OTHER EARLY MUSICAL STYLES

===[[Hearth]]===

Associated Element: FIRE

GENRE MOST COMMON: SINGER SONGWRITER / FOLK

IS CLASSIFIED BY MUSIC THAT WORKS TO BE IN SERVICE OF THE STORY. CAMPFIRE MUSIC, FOLK AND ANYTHING THAT FEELS LIKE IT’S MADE TO HIT THE HEART

===[[The Edge]]===

Associated Element: AIR

GENRE MOST COMMON: ROCK / INDIE / ALTERNATIVE

IS CLASSIFIED BY MUSIC THAT IS MUSICALLY INTENSE OR INSPIRED BY A REBELLIOUS SPIRIT. INNOVATIVE AND GENRE-DEFYING FITS THIS CATEGORY.

===[[The Wave]]===

Associated Element: WATER
GENRE MOST COMMON: CONTEMPORARY POP MUSIC
IS CLASSIFIED BY MUSIC THAT IS FOCUSED ON CURRENT TRENDS AND MUSICAL APPROACHES

=WRNY Radio Media Content Management=

These categories are arranged in time blocks and include selected performances from artists that have performed at Safe and Sound Studios.

==Process for Managing Media Content==

===[[Media Access]]:===

Acquire media access and log into the WRNY Resolve folder.

===Uploading Performances:===

Upload new performance audio and video from Safe and Sound Showcases, Daylight Sessions, or other performances at Safe and Sound Studios.

Ensure media is uploaded with correct [[File Naming Conventions|naming conventions]] into new bin within the project.

===Sorting and Categorizing:===

From the sorting timeline, separate each track.

Dictate the start and stop times for each song accurately.

Drag and categorize each track into the appropriate category:

[[Urban]]

[[Singer Songwriter]]

[[Alternative]]

[[Pop]]

===Final Step:===

Notify Corey once the sorting and categorizing process is complete. Corey will then curate the music within the block.

WRNY

2024-02-06T03:12:01Z

192.168.1.1: /* Hearth */

=Categories=

===[[Roots]]===

Associated Element: EARTH

GENRE MOST COMMON: Hip-hop / R&b

IS CLASSIFIED BY MUSIC THAT PULLS STRONGLY FROM SOURCE INSPIRATIONS OF SOUL, RNB, JAZZ, BLUES AND OTHER EARLY MUSICAL STYLES

===[[Hearth]]===

Associated Element: FIRE

GENRE MOST COMMON: SINGER SONGWRITER / FOLK

IS CLASSIFIED BY MUSIC THAT WORKS TO BE IN SERVICE OF THE STORY. CAMPFIRE MUSIC, FOLK AND ANYTHING THAT FEELS LIKE IT’S MADE TO HIT THE HEART

===[[The Edge]]===

Associated Element: AIR
GENRE MOST COMMON: ROCK / INDIE / ALTERNATIVE
IS CLASSIFIED BY MUSIC THAT IS MUSICALLY INTENSE OR INSPIRED BY A REBELLIOUS SPIRIT. INNOVATIVE AND GENRE-DEFYING FITS THIS CATEGORY.

===[[The Wave]]===

Associated Element: WATER
GENRE MOST COMMON: CONTEMPORARY POP MUSIC
IS CLASSIFIED BY MUSIC THAT IS FOCUSED ON CURRENT TRENDS AND MUSICAL APPROACHES

=WRNY Radio Media Content Management=

These categories are arranged in time blocks and include selected performances from artists that have performed at Safe and Sound Studios.

==Process for Managing Media Content==

===[[Media Access]]:===

Acquire media access and log into the WRNY Resolve folder.

===Uploading Performances:===

Upload new performance audio and video from Safe and Sound Showcases, Daylight Sessions, or other performances at Safe and Sound Studios.

Ensure media is uploaded with correct [[File Naming Conventions|naming conventions]] into new bin within the project.

===Sorting and Categorizing:===

From the sorting timeline, separate each track.

Dictate the start and stop times for each song accurately.

Drag and categorize each track into the appropriate category:

[[Urban]]

[[Singer Songwriter]]

[[Alternative]]

[[Pop]]

===Final Step:===

Notify Corey once the sorting and categorizing process is complete. Corey will then curate the music within the block.

WRNY

2024-02-06T03:11:44Z

192.168.1.1: /* Roots */

=Categories=

===[[Roots]]===

Associated Element: EARTH

GENRE MOST COMMON: Hip-hop / R&b

IS CLASSIFIED BY MUSIC THAT PULLS STRONGLY FROM SOURCE INSPIRATIONS OF SOUL, RNB, JAZZ, BLUES AND OTHER EARLY MUSICAL STYLES

===[[Hearth]]===

Associated Element: FIRE
GENRE MOST COMMON: SINGER SONGWRITER / FOLK
IS CLASSIFIED BY MUSIC THAT WORKS TO BE IN SERVICE OF THE STORY. CAMPFIRE MUSIC, FOLK AND ANYTHING THAT FEELS LIKE IT’S MADE TO HIT THE HEART

===[[The Edge]]===

Associated Element: AIR
GENRE MOST COMMON: ROCK / INDIE / ALTERNATIVE
IS CLASSIFIED BY MUSIC THAT IS MUSICALLY INTENSE OR INSPIRED BY A REBELLIOUS SPIRIT. INNOVATIVE AND GENRE-DEFYING FITS THIS CATEGORY.

===[[The Wave]]===

Associated Element: WATER
GENRE MOST COMMON: CONTEMPORARY POP MUSIC
IS CLASSIFIED BY MUSIC THAT IS FOCUSED ON CURRENT TRENDS AND MUSICAL APPROACHES

=WRNY Radio Media Content Management=

These categories are arranged in time blocks and include selected performances from artists that have performed at Safe and Sound Studios.

==Process for Managing Media Content==

===[[Media Access]]:===

Acquire media access and log into the WRNY Resolve folder.

===Uploading Performances:===

Upload new performance audio and video from Safe and Sound Showcases, Daylight Sessions, or other performances at Safe and Sound Studios.

Ensure media is uploaded with correct [[File Naming Conventions|naming conventions]] into new bin within the project.

===Sorting and Categorizing:===

From the sorting timeline, separate each track.

Dictate the start and stop times for each song accurately.

Drag and categorize each track into the appropriate category:

[[Urban]]

[[Singer Songwriter]]

[[Alternative]]

[[Pop]]

===Final Step:===

Notify Corey once the sorting and categorizing process is complete. Corey will then curate the music within the block.

WRNY

2024-02-06T03:11:33Z

192.168.1.1:

=Categories=

===[[Roots]]===

Associated Element: EARTH
GENRE MOST COMMON: Hip-hop / R&b
IS CLASSIFIED BY MUSIC THAT PULLS STRONGLY FROM SOURCE INSPIRATIONS OF SOUL, RNB, JAZZ, BLUES AND OTHER EARLY MUSICAL STYLES

===[[Hearth]]===

Associated Element: FIRE
GENRE MOST COMMON: SINGER SONGWRITER / FOLK
IS CLASSIFIED BY MUSIC THAT WORKS TO BE IN SERVICE OF THE STORY. CAMPFIRE MUSIC, FOLK AND ANYTHING THAT FEELS LIKE IT’S MADE TO HIT THE HEART

===[[The Edge]]===

Associated Element: AIR
GENRE MOST COMMON: ROCK / INDIE / ALTERNATIVE
IS CLASSIFIED BY MUSIC THAT IS MUSICALLY INTENSE OR INSPIRED BY A REBELLIOUS SPIRIT. INNOVATIVE AND GENRE-DEFYING FITS THIS CATEGORY.

===[[The Wave]]===

Associated Element: WATER
GENRE MOST COMMON: CONTEMPORARY POP MUSIC
IS CLASSIFIED BY MUSIC THAT IS FOCUSED ON CURRENT TRENDS AND MUSICAL APPROACHES

=WRNY Radio Media Content Management=

These categories are arranged in time blocks and include selected performances from artists that have performed at Safe and Sound Studios.

==Process for Managing Media Content==

===[[Media Access]]:===

Acquire media access and log into the WRNY Resolve folder.

===Uploading Performances:===

Upload new performance audio and video from Safe and Sound Showcases, Daylight Sessions, or other performances at Safe and Sound Studios.

Ensure media is uploaded with correct [[File Naming Conventions|naming conventions]] into new bin within the project.

===Sorting and Categorizing:===

From the sorting timeline, separate each track.

Dictate the start and stop times for each song accurately.

Drag and categorize each track into the appropriate category:

[[Urban]]

[[Singer Songwriter]]

[[Alternative]]

[[Pop]]

===Final Step:===

Notify Corey once the sorting and categorizing process is complete. Corey will then curate the music within the block.

Web Server

2024-01-30T15:28:19Z

192.168.1.1: /* Updating Copy to Website */

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

=Updating Copy to Website=
# Commit changes on GitHub
## app/page.js (replace text in the <code><Card /></code> components
## app/components/layout/Mission.js
# in terminal, execute
## <code>ssh userName@wreckroom.nyc</code>
## <code>cd /volume1/wreckroom.nyc/wreckroom.nyc</code>
## <code>git pull</code>
## <code>sudo pm2 delete all</code>
## <code>sudo pm2 start "npm run dev" -- start</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>cd /volume1/wreckroom.nyc/wreckroom.nyc</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.

If having trouble running npm run start due to fonts or other issues try
<code>sudo pm2 start "npm run dev" -- start</code>

==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-30T15:26:24Z

192.168.1.1: /* Making Changes to Website */

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

=Updating Copy to Website=
# Commit changes on GitHub
## app/page.js (replace text in the <code><Card /></code> components
## app/components/layout/Mission.js
# ssh into wreckroom
## <code>cd /volume1/wreckroom.nyc/wreckroom.nyc</code>
## <code>git pull</code>
## <code>sudo pm2 delete all</code>
## <code>sudo pm2 start "npm run dev" -- start</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>cd /volume1/wreckroom.nyc/wreckroom.nyc</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.

If having trouble running npm run start due to fonts or other issues try
<code>sudo pm2 start "npm run dev" -- start</code>

==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-30T15:21:03Z

192.168.1.1:

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

=Making Changes to Website=

==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>cd /volume1/wreckroom.nyc/wreckroom.nyc</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.

If having trouble running npm run start due to fonts or other issues try
<code>sudo pm2 start "npm run dev" -- start</code>

==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-30T15:20:12Z

192.168.1.1: /* 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>cd /volume1/wreckroom.nyc/wreckroom.nyc</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.

If having trouble running npm run start due to fonts or other issues try
<code>sudo pm2 start "npm run dev" -- start</code>

==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 :)

Wreckroom

2024-01-18T03:46:08Z

192.168.1.1:

[[Wreckroom]] is an Independent Record Label focused on innovative and groundbreaking music.

=Strategy=
===[[Executive Summary]]===
===[[Road Map Q1-Q2 2024]]===

=Media Verticals=
Media Verticals are the different broad categories of content we focus on.

===[[Performance Series]]===
A Safe and Sound Showcase, Daylight Sessions all fall under these categories. Usually a performance video piece that lives on YouTube.

===[[Interviews]]===
Short form content pieces that either feed into the performance series or create a short form entertainment piece from artists we’ve worked with.

===[[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 [[Media 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]]!

====[[Transferring Local Database to Davinci Resolve Project Server]]====
If you have a project that has been edited locally and needs to be transferred to the Resolve server!

====[[Ensuring Media Accessibility]]====
Steps to create media accessible remotely as well as relink media in projects!

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

Web Server

2024-01-17T22:38:21Z

192.168.1.1:

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.

If having trouble running npm run start due to fonts or other issues try
<code>sudo pm2 start "npm run dev" -- start</code>

==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-17T22:38:10Z

192.168.1.1: /* 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.

If having trouble running npm run start due to fonts or other issues try
sudo pm2 start "npm run dev" -- start

==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 :)

Executive Summary

2024-01-17T19:06:24Z

192.168.1.1: /* Executive Summary: Wreckroom Independent Record Label */

== Wreckroom Independent Record Label ==

Wreckroom is a dynamic and forward-looking independent record label, focused on revolutionizing the music industry. Our mission is to develop emerging artists into significant acts, with a particular emphasis on digital platforms.

=== Core Focus ===

• Our strategy centers on nurturing a select group of artists, aiming to elevate at least one to a 7-figure music act within three years.
• This involves a heavy release schedule (12 songs per year), production of high-quality music videos, and a strong digital presence, particularly on Spotify and YouTube.

=== Unique Approach ===

• Wreckroom blends extensive digital media promotion with a commitment to high-quality music production.
• This dual strategy is designed to maximize digital visibility and engagement while maintaining artistic integrity.

=== Revenue Streams ===

• Our revenue model encompasses direct streaming income from platforms like Spotify and Apple Music.
• Indirect revenue streams include artist and label YouTube channels, featuring performance series, 24-hour radio broadcasts, and private industry sessions.
• Ad views and partnerships on YouTube channels form a significant part of our revenue.
• The label also offers a curated newsletter, enhancing community engagement and industry relationships.

=== Touring and Supplementary Services ===

• Beyond digital content, we plan to develop a touring revenue model after the second album release of our key artists.
• Supplementary services offered include production work, studio time, and marketing services, ensuring holistic artist support.

=== Financial Forecast ===

• Our financial forecast predicts a significant increase in revenue across various channels, with a focus on growing streaming numbers and YouTube viewership.
• Detailed revenue projections include artist streams, label YouTube revenue, partnerships, and studio services, setting a trajectory for substantial growth by 2030.

== Wreckroom Revenue Forecast (2025-2030) ==

UniFi

2024-01-17T13:47:02Z

192.168.1.1: /* Adoption */

= Network Topology =

https://app.diagrams.net/#G11IoJb1M7YoS0FUSj-TjkHPVlAgNTu0S4

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

==Adopting Devices==
When migrating networks, you will need to SSH into the devices and enable broadcasting for new adoption.

====WAP (Wi-Fi Access Points)====
<syntaxhighlight>
ssh admin@192.168.1.30
</syntaxhighlight>

====Kitchen UAC Pro====
Some newer devices need additional options and will throw a nasty error if not done this way:

<syntaxhighlight>
ssh -o HostKeyAlgorithms=+ssh-rsa,ssh-dss admin@192.168.1.100
</syntaxhighlight>

=== Adoption ===

After you SSH into the device you wish to adopt, you can set signal to the device to be adopted by the new gateway:

<syntaxhighlight>set-inform http://192.168.1.1:8080/inform</syntaxhighlight>

UniFi

2024-01-17T13:46:40Z

192.168.1.1: /* WAP (Wi-Fi Access Points) */

= Network Topology =

https://app.diagrams.net/#G11IoJb1M7YoS0FUSj-TjkHPVlAgNTu0S4

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

==Adopting Devices==
When migrating networks, you will need to SSH into the devices and enable broadcasting for new adoption.

====WAP (Wi-Fi Access Points)====
<syntaxhighlight>
ssh admin@192.168.1.30
</syntaxhighlight>

====Kitchen UAC Pro====
Some newer devices need additional options and will throw a nasty error if not done this way:

<syntaxhighlight>
ssh -o HostKeyAlgorithms=+ssh-rsa,ssh-dss admin@192.168.1.100
</syntaxhighlight>

=== Adoption ===

After ssh, you can set signal to the device to be adopted by the new gateway:

<syntaxhighlight>set-inform http://192.168.1.1:8080/inform</syntaxhighlight>

UniFi

2024-01-17T13:46:33Z

192.168.1.1: /* Kitchen UAC Pro */

= Network Topology =

https://app.diagrams.net/#G11IoJb1M7YoS0FUSj-TjkHPVlAgNTu0S4

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

==Adopting Devices==
When migrating networks, you will need to SSH into the devices and enable broadcasting for new adoption.

====WAP (Wi-Fi Access Points)====
<code>
ssh admin@192.168.1.30
</code>

====Kitchen UAC Pro====
Some newer devices need additional options and will throw a nasty error if not done this way:

<syntaxhighlight>
ssh -o HostKeyAlgorithms=+ssh-rsa,ssh-dss admin@192.168.1.100
</syntaxhighlight>

=== Adoption ===

After ssh, you can set signal to the device to be adopted by the new gateway:

<syntaxhighlight>set-inform http://192.168.1.1:8080/inform</syntaxhighlight>

UniFi

2024-01-17T13:46:25Z

192.168.1.1: /* Adoption */

= Network Topology =

https://app.diagrams.net/#G11IoJb1M7YoS0FUSj-TjkHPVlAgNTu0S4

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

==Adopting Devices==
When migrating networks, you will need to SSH into the devices and enable broadcasting for new adoption.

====WAP (Wi-Fi Access Points)====
<code>
ssh admin@192.168.1.30
</code>

====Kitchen UAC Pro====
Some newer devices need additional options and will throw a nasty error if not done this way:

<code>
ssh -o HostKeyAlgorithms=+ssh-rsa,ssh-dss admin@192.168.1.100
</code>

=== Adoption ===

After ssh, you can set signal to the device to be adopted by the new gateway:

<syntaxhighlight>set-inform http://192.168.1.1:8080/inform</syntaxhighlight>

UniFi

2024-01-17T13:46:06Z

192.168.1.1: /* Adopting Devices */

= Network Topology =

https://app.diagrams.net/#G11IoJb1M7YoS0FUSj-TjkHPVlAgNTu0S4

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

==Adopting Devices==
When migrating networks, you will need to SSH into the devices and enable broadcasting for new adoption.

====WAP (Wi-Fi Access Points)====
<code>
ssh admin@192.168.1.30
</code>

====Kitchen UAC Pro====
Some newer devices need additional options and will throw a nasty error if not done this way:

<code>
ssh -o HostKeyAlgorithms=+ssh-rsa,ssh-dss admin@192.168.1.100
</code>

=== Adoption ===

After ssh, you can set signal to the device to be adopted by the new gateway:

<code>set-inform http://192.168.1.1:8080/inform</code>

UniFi

2024-01-17T13:45:49Z

192.168.1.1: /* Adopting Devices */

= Network Topology =

https://app.diagrams.net/#G11IoJb1M7YoS0FUSj-TjkHPVlAgNTu0S4

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

==Adopting Devices==
When migrating networks, you will need to SSH into the devices and enable broadcasting for new adoption.

====WAP (Wi-Fi Access Points)====
<code>
ssh admin@192.168.1.30
</code>

====Kitchen UAC Pro====
Some newer devices need additional options and will throw a nasty error if not done this way:

<code>
ssh -o HostKeyAlgorithms=+ssh-rsa,ssh-dss admin@192.168.1.100
</code>

After ssh, you can set signal to the device to be adopted by the new gateway:

<code>set-inform http://192.168.1.1:8080/inform</code>

UniFi

2024-01-17T13:45:16Z

192.168.1.1: /* Network Topology */

= Network Topology =

https://app.diagrams.net/#G11IoJb1M7YoS0FUSj-TjkHPVlAgNTu0S4

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

===Adopting Devices===
When migrating networks, you will need to SSH into the devices and enable broadcasting for new adoption.

====WAP (Wi-Fi Access Points)====
<code>
ssh admin@192.168.1.30
</code>

====Kitchen UAC Pro====
Some newer devices need additional options and will throw a nasty error if not done this way:

<code>
ssh -o HostKeyAlgorithms=+ssh-rsa,ssh-dss admin@192.168.1.100
</code>

After ssh, you can set signal to the device to be adopted by the new gateway:

<code>set-inform http://192.168.1.1:8080/inform</code>

UniFi

2024-01-17T13:45:06Z

192.168.1.1: /* Adopting Devices */

= Network Topology =

https://app.diagrams.net/#G11IoJb1M7YoS0FUSj-TjkHPVlAgNTu0S4

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

===Adopting Devices===
When migrating networks, you will need to SSH into the devices and enable broadcasting for new adoption.

====WAP (Wi-Fi Access Points)====
<code>
ssh admin@192.168.1.30
</code>

====Kitchen UAC Pro====
Some newer devices need additional options and will throw a nasty error if not done this way:
<code>
ssh -o HostKeyAlgorithms=+ssh-rsa,ssh-dss admin@192.168.1.100
</code>

After ssh, you can set signal to the device to be adopted by the new gateway:

<code>set-inform http://192.168.1.1:8080/inform</code>

MacPro

2024-01-16T00:27:12Z

192.168.1.1:

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

<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.

Media Server

2024-01-12T23:58:23Z

192.168.1.1: /* PC */

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@media.wreckroom.nyc/wreckroom</code>

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

== PC ==
In File Explorer, click '''This PC''' and then '''XXXXX'''.

<code>\\username@media.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-12T23:58:10Z

192.168.1.1: /* PC */

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@media.wreckroom.nyc/wreckroom</code>

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

== PC ==
In File Explorer, click '''This PC''' and then '''Connect to Server'''.

<code>\\username@media.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-12T23:57:28Z

192.168.1.1: /* PC */

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@media.wreckroom.nyc/wreckroom</code>

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

== PC ==
In File Explorer, click '''This PC''' and then ''Connect to Server'''.

<code>\\username@media.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-12T23:57:22Z

192.168.1.1: /* Mac */

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@media.wreckroom.nyc/wreckroom</code>

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

== PC ==
In File Explorer, click '''This PC''' and then ''Connect to Server'''.

<code>s\\username@media.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

VPN

2024-01-12T23:56:23Z

192.168.1.1: /* Meida Server */

A [[VPN]] is a virtual private network which allows remote users to access resources (files, audio, video and DaVinci Resolve projects) on another person organizations local network, over the internet.

Once connected to the VPN it is like your are at [[Wreckroom]] studios.

=Access=

To setup a [[VPN]] Connection reach out to Justin for the login credentials.

===[[Media Server]]===

Once you are connected to the [[VPN]] you would connect to the wreckroom drive via the [[Media Server]].

===[[DaVinci Resolve Server]]===
If you are working on editing within a DaVinci Resolve project click [[DaVinci Resolve Server | here]].

Wreckroom

2024-01-11T02:26:03Z

192.168.1.1: /* Runway */

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

=Strategy=
===[[Road Map Q1-Q2 2024]]===

=Media Verticals=
Media Verticals are the different broad categories of content we focus on.

===[[Performance Series]]===
A Safe and Sound Showcase, Daylight Sessions all fall under these categories. Usually a performance video piece that lives on YouTube.

===[[Interviews]]===
Short form content pieces that either feed into the performance series or create a short form entertainment piece from artists we’ve worked with.

===[[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 [[Media 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-11T02:25:50Z

192.168.1.1: /* Road Map */

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

=[[Runway]]=
===[[Road Map Q1-Q2 2024]]===

=Media Verticals=
Media Verticals are the different broad categories of content we focus on.

===[[Performance Series]]===
A Safe and Sound Showcase, Daylight Sessions all fall under these categories. Usually a performance video piece that lives on YouTube.

===[[Interviews]]===
Short form content pieces that either feed into the performance series or create a short form entertainment piece from artists we’ve worked with.

===[[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 [[Media 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-11T02:25:29Z

192.168.1.1: /* Road Map Q1-Q2 2024 */

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

=[[Road Map]]=
===Q1-Q2 2024===

=Media Verticals=
Media Verticals are the different broad categories of content we focus on.

===[[Performance Series]]===
A Safe and Sound Showcase, Daylight Sessions all fall under these categories. Usually a performance video piece that lives on YouTube.

===[[Interviews]]===
Short form content pieces that either feed into the performance series or create a short form entertainment piece from artists we’ve worked with.

===[[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 [[Media 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-11T02:25:14Z

192.168.1.1: /* Road Map Q1-Q2 2024 */

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

=[[Road Map Q1-Q2 2024]]=

=Media Verticals=
Media Verticals are the different broad categories of content we focus on.

===[[Performance Series]]===
A Safe and Sound Showcase, Daylight Sessions all fall under these categories. Usually a performance video piece that lives on YouTube.

===[[Interviews]]===
Short form content pieces that either feed into the performance series or create a short form entertainment piece from artists we’ve worked with.

===[[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 [[Media 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-11T02:25:03Z

192.168.1.1: /* Road Map Q1-Q2 2024 */

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

===[[Road Map Q1-Q2 2024]]===

=Media Verticals=
Media Verticals are the different broad categories of content we focus on.

===[[Performance Series]]===
A Safe and Sound Showcase, Daylight Sessions all fall under these categories. Usually a performance video piece that lives on YouTube.

===[[Interviews]]===
Short form content pieces that either feed into the performance series or create a short form entertainment piece from artists we’ve worked with.

===[[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 [[Media 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!

Road Map Q1-Q2 2024

2024-01-11T02:23:45Z

192.168.1.1: /* Q1: Detailed Roadmap (January - March) */

== Q1: Detailed Roadmap (January - March) ==

* Monday, Wednesday, and Friday are upload days for YouTube & TikTok

=== January ===
* '''13th:''' Miette Hope DS Release.
* '''20th:''' Studio Upgrade Complete (Unifi Network and Synology Storage).
* '''25th:''' Onboarding Forms Completion for DS, WRNY, STUDIO, PARTNERSHIPS.
* '''29th:''' Website Launch with Studio Promo.

=== February ===
* '''2nd:''' Recording "You Make a Home" with Sheena and Adam.
* '''17th:''' Live Studio Performance (Potential Artist: Rachel Rose).
* '''16th/23rd:''' Sixsun Single Release.
* Regular Social Media Updates.

=== March ===
* '''1st:''' Launch of WRNY 24hr YouTube Radio. This will feature a continuous stream of curated music and live sessions, aimed at creating a unique space for music enthusiasts.
* '''2nd/9th:''' Recording 6 Daylight Sessions.
* '''15th:''' Sixsun Single Release.
* Regular Content Posting.

== Highlights: Q2 (April - June) ==

=== April ===
* '''Newsletter Launch:''' Mid-April launch aimed at building a community with updates on releases, events, and exclusive content.
* '''Production Partnership with 57Grand:''' Produce media and content for 57’s highly sought after community events.
* '''Showcase Sponsorships:''' Securing Groover, 10DC as sponsors for showcase Series. 20k Goal
* '''Short Documentary Negotiations:''' Re-Launch Contract for Belief Lab documentary.
* '''Live Studio Performance:''' Hosting a private performance event with industry leaders.
* '''Remote Editor Onboarding:''' Establishing workflow for remote editing in key Demographic
* '''WRNY ROCKDAFAQOUT Launch:''' Introduction of an alt-pop channel on WRNY with Key Tastemaker

=== May ===
* '''Wreckroom Listening Party:''' Album Performance and listening party for Sixsun Album.
* '''Showcase Series Kickoff:''' Beginning of a 4-5 part showcase series.
* '''Daylight Sessions Shooting:''' Producing 6 new Daylight sessions.
* '''Documentary Filming:''' Starting the documentary shoot.
* '''First Media Client Onboarding:''' Expanding services to external clients.
* '''Music Video''' For Adam Knight's "You Make a Home."

=== June ===
* '''Second Showcase:''' Continuing the showcase series.
* '''Live Studio Performances:''' Hosting events with industry professionals.
* '''Media Client Expansion:''' Onboarding additional SMB Media clients.
* '''Documentary Continuation:''' Documentary shoot progress.
* '''Studio Booking Goal:''' Aiming for 5 days a month booking.
* '''Merchandise Launch:''' Sixsun Vinyl and Wreckroom T-Shirt launch

=== Notes: ===

MacPro

2024-01-10T08:15:05Z

192.168.1.1: /* DaVinci Resolve (Studio) */

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

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

=[[DaVinci Resolve 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>

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

<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.

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

MacPro

2024-01-10T08:14:55Z

192.168.1.1:

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

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

=[[DaVinci Resolve 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>

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

<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.

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

MacPro

2024-01-10T08:13:57Z

192.168.1.1:

The [[MacPro]] is a MacOS 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]].

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

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

<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.

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

MacPro

2024-01-10T08:13:41Z

192.168.1.1:

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]].

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

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

<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.

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

MacPro

2024-01-10T08:13:28Z

192.168.1.1: /* Daily Logs */

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

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

<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.

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

MacPro

2024-01-10T08:13:02Z

192.168.1.1: /* Daily Logs */

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

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

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

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 [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.

MacPro

2024-01-10T08:12:47Z

192.168.1.1: /* Configuration File */

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

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

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

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 [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.

MacPro

2024-01-10T08:12:37Z

192.168.1.1: /* DaVinci Resolve Server */

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

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

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

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 [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.

MacPro

2024-01-10T08:12:10Z

192.168.1.1: /* Daily Logs */

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

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

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

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 [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.

MacPro

2024-01-10T08:11:53Z

192.168.1.1: /* DaVinci Resolve (Studio) */

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

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

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

[[File:MacPro.png|400px|thumb|right|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]].

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

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

MacPro

2024-01-10T08:11:44Z

192.168.1.1: /* DaVinci Resolve (Studio) */

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

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

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

[[File:MacPro.png|400px|thumb|right|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]].

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

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

MacPro

2024-01-10T08:11:14Z

192.168.1.1: /* DaVinci Resolve (Studio) */

=DaVinci Resolve (Studio)=

Video editing via resolve locally or remote via [[VNC]] over [[VPN]]:

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

=[[DaVinci Resolve 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>

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

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

[[File:MacPro.png|400px|thumb|right|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]].

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

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

MacPro

2024-01-10T08:10:58Z

192.168.1.1: /* Editing Rig */

=DaVinci Resolve (Studio)=

Video editing via resolve locally or remote via [[VNC]]:

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

=[[DaVinci Resolve 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>

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

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

[[File:MacPro.png|400px|thumb|right|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]].

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

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

MacPro

2024-01-10T08:10:40Z

192.168.1.1: /* DaVinci Resolve */

=Editing Rig=

Video editing via resolve locally or remote via [[VNC]]:

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

=[[DaVinci Resolve 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>

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

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

[[File:MacPro.png|400px|thumb|right|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]].

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

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