Project Server in 14.1?

What does that "Project Server " do, we got with 14.1?

• Added support for a new Project Server application to manage a local PostgreSQL server on macOS and Windows

Ahhh, RTFM I guess

Ahhh, RTFM I guess :lol:

In this case, the manual would not help you.

This is RTFPR.

There's 2 features in this manager that I can't figure out:

Enable Sharing
Asks for authorization, but nothing happens when I click the button. I have no clue what this is even supposed to do.

Create Access Key (.resolvedbkey)
This creates an XML formatted file with the IP and credentials of the database, but there is no way to actually import this file in the actual Resolve application.

Create Access Key (.resolvedbkey)
This creates an XML formatted file with the IP and credentials of the database, but there is no way to actually import this file in the actual Resolve application.

You can drag and drop it to the project manager of Davinci resolve!!

UPDATE:

your pg_hba has to explicitly have 127.0.0.1 listed for the new Project Server to work on Windows at least..

I can't even get it to open, all that pops up is "DaVinci Resolve Project Server connection error. The PostgreSQL server is either not running or the password is incorrect". Running Postgres on Windows 10 Fall Creator's Update.

[Dwaine Maggart]

127.0.0.1 should never be removed. That's the local connection to the server.

If our past procedures for modifying pg_hba.conf are followed, we add a new line to the bottom of the file for allowing same subnet access to the server from remote systems.

But we leave the original 127.0.0.1 line in place, so things on the local system can connect, without having to use an explicit IP address. That's what the Project Server app requires to communicate with the server.

Are there any step-by-step instructions somewhere for setting this up?
I'm only used to disk, but I'm interested in moving to this workflow.

Why is it possible to set my own password when creating a database but it is not possible to specify it when the project server starts. Why the password should be "DaVinci"? Credentials user=postgres and password=DaVinci does not correspond to the logic of the best unsecure way of authentication which is user=user and password=password.

Dear developers, you either give the opportunity to set my own user and password.
Either keep honor distance from data protection and skip down to user=user and password=password. In this case, the user will clearly understand that the connection is not secure and will act accordingly.
Do not mislead people!

127.0.0.1 should never be removed. That's the local connection to the server.

If our past procedures for modifying pg_hba.conf are followed, we add a new line to the bottom of the file for allowing same subnet access to the server from remote systems.

But we leave the original 127.0.0.1 line in place, so things on the local system can connect, without having to use an explicit IP address. That's what the Project Server app requires to communicate with the server.

Thanks, Dwaine!

So do we need to enable and configure PostgreSQL through the terminal, as explained in the manual, in order to use this for managing the server? Or are we able to configure the whole thing through this GUI interface?

[Dwaine Maggart]

You WILL be able to set up shared databases using the Project Server, but not until the next Resolve point release. The current Project Server app has an issue in Enable Sharing area.

[Dwaine Maggart]

The 14.1.1 release Project Server Enable Sharing button now works.

[Peter Chamberlain]

To Recap.

On a new system that you plan to use as your Database Server, Mac Mini or PC, install DaVinci Resolve and in the install process select the 'Customise' option on the installer and then select PostgreSQL server. Deselect the panels installer.

Complete the install, restart.
Then go to the DaVinci Resolve Project Manager application in your applications folder. Start the app.
The DaVinci Resolve Project Manager will show you the default PostgreSQL database 'resolve' and you can make others if you wish. You can also see here the projects within the database once you make them, and make folders to manage them.

Select the 'Enable Sharing' icon and authorise sharing of the database.
You can now create an Access Key, select the icon, save the key to a shared location or to a thumb drive and move that key to each of the clients.
Drag the key on top of the Project Manager in Resolve for each of the clients who you wish to provide access to that Database.

That Resolve client is now connected to the database on the shared DB server. Do they same for others to collaborate on the same project.

Will it be possible to use both disk and PostgreSQL databases with the same install?

I'm wondering about the best way to bring the old projects from the disk database into the PostgreSQL database.

[Peter Chamberlain]

Yes you can use both. If you set up your PostGres DB in Resolve Project manager you can move projects to the other type of Database.

hello
is it possible to create a shared database on a non resolve used machine ? i mean, if i install posgres and resolve project server
i want to make a micro server exclusively for resolve databases (a linux one in best case)

@Frank Glencairn

We just install the normal Resolve package with the postgres option enabled and then create the initial DB using a license at first, I'm sure there is a way around that.

Once the initial DB is created we never re-license the DB server and admin it remotely as a headless unit.

does a linux version is planned ?
I want to build a micro PC to run resolve database and some for other softwares too so linux is the cheapest/best way to go

There's a problem with changing default Postgres database password. If I want to change db password on, first I have to disconnect all the databases manually, and then reconnect one by one. In this case Resolve works fine, but Project Server stops working ("The PostgreSQL server is either not running or the password is incorrect"). Seems like it is still looking for default password.
How do I correctly change default password for my Postgres database in Resolve?

Why is it possible to set my own password when creating a database but it is not possible to specify it when the project server starts. Why the password should be "DaVinci"? Credentials user=postgres and password=DaVinci does not correspond to the logic of the best unsecure way of authentication which is user=user and password=password.

Dear developers, you either give the opportunity to set my own user and password.
Either keep honor distance from data protection and skip down to user=user and password=password. In this case, the user will clearly understand that the connection is not secure and will act accordingly.
Do not mislead people!

Okay, so I have followed the instructions from the newest version of the manual, which does not mention "pg_hba.conf" or any of those things.

I want to enable a collaborative workflow on two computers, using one of them as the host. I run Windows 10 on both computers. I have done a clean install of Resolve Studio 14.3 on both computers with the newest version of PostgreSQL. Then I create a database with Resolve Project Server and enable sharing.

The access key I then create has no problem being imported in the Project Manager on the computer I used to create the database. However, when trying to import the access key on the other computer on the network, I get the error: "Failed to connect to the database, Please check log file for more details."

So.. am I doing anything wrong? Do I need to edit anything else, and if yes, where can I find a guide?

[Dwaine Maggart]

You don't need to Import the access key on the Host system, as it already has that database available.

When you create a database in the Project Server app, and then launch Resolve on that system, you should see that database sitting in the database area of the Project Manager window, if you have the databases exposed on the Project Manager window.

The database does not show up automatically in the project manager app. Even though I created the database on the same system with the Project Server app, I have to import it manually to the project manager.

However, my main problem is that I can't import the access key on other systems. Any thoughts?

[Dwaine Maggart]

My bad. I thought the Project Server would add it to the local db list, but it doesn't.

Using the access key does work though.

So if your access key isn't working on any system, we need to sort that out.

Can you PM me your access key file? I'm not sure you can do attachments in PMs. If not, put it on a file sharing site and send a link to it.

Thanks, I have sent you a PM.

Has a solution for this error been found? I'm having the same problem with adding the access key onto my second computer.

[Dwaine Maggart]

Verify you can ping the server computer from the Resolve client.

If that works, temporarily disable the firewall to see if that is causing the issue.

Firewall was causing the problem. Any way around this problem, setting some sort of rule?

The router I was using was creating issues, tried switching to a new router (for both machines). I can ping, but am back to the same issue with importing the database key (I made a new one)

[Dwaine Maggart]

If there is a firewall getting in the way, you indeed need to deal with that.

Windows and Mac firewall apps have methods for adding Resolve and PostgreSQL to the allowed list, so that they can work. The relevant port that needs to be open for PostgreSQL is 5432.

I got that...I'm able to ping my machine, but importing the resolvedbkey file is still failing immediately.

[Dwaine Maggart]

You mentioned earlier that the firewall was causing the issue. Implying that turning that off made it work? So I'm not sure where we are at.

I'm also having problem importing the resolvedbkey file. The first time I drag-and-drop it to the Projects window, nothing happens.

If I do it a second time, I'm having a popup error message saying: "New database cannot be created. Database "test" is in use.", where test is the name of the DB I'm trying to connect to.

error-resolve-connect-db.jpg (27.6 KiB) Viewed 1918 times

I'm running Davinci Resolve 14.3.0.014 and PostgreSQL 9.5 on both systems:

• Macbook Pro with Mac OS Sierra (the DBs server with the test DB has been created with DaVinci Resolve Project Server);
• Windows 10.

No firewall on the way.