How to Set Up a DaVinci Resolve Shared Database

How to Set Up a DaVinci Resolve Shared Database

March 14, 2013
Dan Moran C.S.I.

Learn how to set up a DaVinci Resolve shared database in this step-by-step tutorial using the Command-Line interface.


Setting Up a DaVinci Resolve Shared Database: Step-by-step

Intro

Do you struggle to move projects from Resolve to Resolve. Use memory sticks, constantly exporting projects or just don’t know how to move projects around?

Opening up your resolve to database sharing will change your life. At my company we have 4 Resolves and within 3 clicks I can open up any project from any machine and work on it. Even machines that are rendering!

This will work on the Mac, Linux and Windows platforms, I am using the Mac version for this tip.

This is a slightly more advanced course but I’ve tried to break it down into as many stages as possible to make it clear and easy to follow for you guys.

Important Notes

Please Back Up Your Database Before Trying This!!

If you need any help backing up please see the tutorial I created on backing up here:

[button title=”Resolve Backups” color=”red” size=”mega” link=”http://mixinglight.com/color-tutorial/resolve-backups-3-strategies/” in_new_tab=”false” icon=””]

You will need the full version of DaVinci Resolve to use the shared database functionality.

You will also need to make sure that you are using the PostGres database instead of the Disk database as it is the PostGres database server that will allow you to speak to one Resolve from another. Once you are happy with this its time to get sharing!

Prepare to Share

Setting up a shared database in Resolve can be quite a scary prospect but in reality can be a quick and easy process and provides you with great return on convenience and timesaving.

This is the most confusing part of the whole process. We will need to use Terminal to edit a file called “pg_hba.conf”

This file decides if your database will allow in external computers.

Here is the extra fun bit. You can’t access this file using finder or edit it using notepad as it is locked to protect the database from getting damaged. The only way in is to use the Terminal, change to root user and use the VI Editor.

I know the last sentence just dropped a lot of heavy words so I’m going to break it down a little further.

Enable the Root User

The Root user is an Access All Areas pass to your system. It lets you tell the OS “I’m the boss let me do what I want!” you will need to enable this on your system. The best place to go for this is Apple Support they have a guide on how to enable the root user on all recent os versions.

Opening Terminal and switching to the root user

You will need to change to your root user to gain access to the Postgres folder so lets start by changing user :

In your terminal type in the command

[infobox closable=”false” color=”red”]su[/infobox]

It will then ask you for the root user password hopefully you know this and if not please follow the steps from the link above, type it in and press return

You should then see the command line has changed from your username to

[infobox closable=”false” color=”red”]sh-3.2.#[/infobox]

Congratulations you are now the root user!

Finding The Configuration File

Now that we are the root user lets navigate to the folder containing the pg_hba.conf file

The file will be at the path :  /Library/PostgreSQL/8.4./data

The easiest way to get to this folder is to use the following command

[infobox closable=”false” color=”red”]cd /Library/PostgreSQL/8.4./data[/infobox]

To make sure you are in the right folder type in the command

[infobox closable=”false” color=”red”]ls[/infobox]

You should then see something like this

ls_result

Editing The Configuration File

This section is easier than you think but I’m sure not many people have used the VI editor before so it best to do this section slowly and carefully.

Lets open the configuration file. Use the following command

[infobox closable=”false” color=”red”]vi pg_hba.conf[/infobox]

You will notice that you have now opened the conf file and can read the text inside. The good news is you can ignore all of it and scroll down to the very bottom! To scroll down use the arrow key to move the curser all the way to the bottom of the text until you see the line.

#IPv4 local connections

host all all 127.0.0.1/32 mdf

VI_1

All we need to do is change the section

127.0.0.1/32  to 0.0.0.0/0

This will change the permissions from allowing local only to any IP address.

To do this use the following steps :

[infobox closable=”false” color=”red”]Push the A key[/infobox]

This will activate insert mode and allow you to type.

Change 127.0.0.1/32  to 0.0.0.0/0

[infobox closable=”false” color=”red”]Push the ESC key[/infobox]

This will accept the change.

[infobox closable=”false” color=”red”]Push the : key[/infobox]

You will then see : appear down the bottom of the terminal

[infobox closable=”false” color=”red”]Push the W key[/infobox]

[infobox closable=”false” color=”red”]Push the Return key[/infobox]

You should see the message “pg_hba.conf” written appear.

Now lets exit the VI editor

[infobox closable=”false” color=”red”]Push the : key[/infobox]

[infobox closable=”false” color=”red”]Push the q key[/infobox]

Hit return and that will close the vi editor

Thats it!

Checking Back Your Change

To make sure our change has been written correctly run the following command :

[infobox closable=”false” color=”red”]cat pg_hba.conf[/infobox]

You should see your newly edited line  0.0.0.0/00 applied. If so close the terminal you are finished!

Connecting to your database

Launch Resolve

On the login screen open the database manager this is the stack of disks icon in the bottom right of the login page.

You then need to open the drop down menu which is the four lines icon in the top right of the manager and click connect.

This will open your connect menu.

Connect_Machine

The label field is what name the database will appear under when browsing from your current Machine. We normally label ours with names and numbers like Resolve_1 and Resolve_2 for the main grading suites and Resolve_Assist_1 and Resolve_Assist_2 for our conforming mac systems.

The Host field is where you enter the IP address of the machine you are connecting too which in my case is 5.0.45.110

The DB name field needs to match the name of the database you are connecting to it is normally “resolve” by default but if you have multiple databases you need to check the name of the database you are connecting to and then enter it here.

Click Connect Database.

You are now connected!

Connected

Browsing Remote Databases

Once you have your databases connected you can browse and import remote projects.

To do this click the globe icon in the bottom left of the project list.

Select the machine you would like to browse from the drop down menu.

You can then view, sort and open projects.

This is probably some of the most difficult steps I have ever written so congratulations on getting all the way to here and earning your new shared database system!

-Dan

 

Comments