Project Server - "Cannot Connect to Network Project Library"

Hey everyone,

I'm attempting to open my Resolve Project Server to the internet so that I can collaberate with a friend.

I've managed to set up Davinci Resolve Project Server 18.0.1 locally on my network. I have multiple project libraries and use them with remote rendering with no issue.

No matter what I try, I am unable to let my friends connect to my project server;

I've forwarded the port 5432 on my network and verified it is open



I have enabled Sharing on the database

I have disabled the firewall on the host machine (only during testing)

In postgresql.conf I have inserted at the bottom:

Code: Select all

listen_addresses = '*'

In pg_hba.conf i have:

Code: Select all

host all all 0.0.0.0/0 scram-sha-256

I am able to ping my host machine from my laptop off the network


When connecting from a remote machine using the public IP address of the server machine I get the following message immediately:
"Cannot Connect to Network Project Library"
"Please check for correct credentials and if the server is online and allows client connections."



Can anyone help?

[Dwaine Maggart]

Do note that any manual changes you make to pg_hba.conf will be removed the next time you share or unshare a Project Library with the Project Server app. You shouldn't make manual changes to pg_hba.conf if you want to use the Project Server app.

Also note that any manual changes you make to pg_hba.conf don't take effect until you restart PostgreSQL.

Are you using an access key file at the remote end to add the Project Library to the Remote Resolve? If so, is the IP address in the access key the same address that the remote system is accessing? If not, it will fail.

You mentioned you could ping the host machine from your laptop off the network. Can your friends remote Resolve system ping the host machine?

Also note that any manual changes you make to pg_hba.conf don't take effect until you restart PostgreSQL.

I restart the host machine after making any change to ensure it gets applied.

Are you using an access key file at the remote end to add the Project Library to the Remote Resolve? If so, is the IP address in the access key the same address that the remote system is accessing? If not, it will fail.

I noticed generating key files would enter the host machine's local address for "hostIPAddress" so I've conducted everything using the manual connect feature.


All systems have no issue pinging the host machine.

UPDATE:
I was able to connect uwing "posgres" as the dbUsername and "DaVinci" as the dbPassword

This thread is solved but now I have a new problem;

"postgres" and "DaVinci" are default usernames and passwords which is not ideal if the database is open to the web.

I am able to change the default password in pgAdmin

However, this does not allow me to open the Resolve Project Server application anymore as I recieve this error:


Am I able to change the default password while still being able to use the project server app?

[Dwaine Maggart]

Right.

The Project Server is hard coded to use postgres as the username and DaVinci as the password.

If that's not suitable for your use case, don't use the Project Server app to manage PostgreSQL, and Connect to Project Libraries manually on your Resolve clients, instead of using access keys.

Right.

The Project Server is hard coded to use postgres as the username and DaVinci as the password.

If that's not suitable for your use case, don't use the Project Server app to manage PostgreSQL, and Connect to Project Libraries manually on your Resolve clients, instead of using access keys.

I have about the same need and usecase here.
I am new to Resolve / project server and I am not very familiar with "networking / sysadmin" stuff. I'm trying to open my Project Server to the internet for remote collaboration.

Currently, my server can be accessed by all of my computer locally, on my network. I am Sharing DataBases using access key files between my systems.

But, opening the whole data base with the default credentials (Postgress / DaVinci / 5432 port) seems dangerous to me. To my understanding, this user is the superadmin of my Project Server and anybody could mess up the other database contained in it is they wish to.

So I just thought I would change the password for the postgress user in PGADMIN, and found that it broke the system.

I mean, why bother to manage users and login rights to a particular DB within the Project Server app for collaborators in this context?

How can I make a remote collaborators "Connect manually" to my project server instead of using an Access Keys file?

Sorry, I am obviously not understanding the system correctly, but it just looks to me that I am not in control regarding security and user access here. Can you clarify a bit?

Also, I stumbled upon a youtube Video titled "" this video recently. (dating from 2017 though).

"DaVinci Resolve Database Security" (I cannot post URL links in here just yet, it seams).

I think what this guy is talking about in his video is important, at first sight. But again ,I am not understanding the system totally.

@Dwaine Maggart,

I just installed DRPS18.5 and on first launch, it ask for Server name, Admin name & Password. So What I did was created a Admin: HJKADMIN & made a PWD. As like the other person, all net files / folders are accessable via the network. But when I try to access DRPS with IP, UN & PWD, I get "Cannot Connect to Network Project Library". So, How do I find what I need to change back to defauly UN/PWD so I can get to work?

Regards,
HaroldK

Hello,

I installed DRPS 18.5. After installation, I rebooted then ran the DRPS App. it asked for the following:
1. Server Name. I named it: Kingdom_Innovations_PS
2. Admin Name: HJKADMIN
3. PWD: I created one.
4. Project Library: I created one.

Next I enabled Network Connections, Authorized Configuration, then I went to my MAC and my Windows PCs opened DR App and tried to connect only to get the popular error message "Cannot Connect to Network Project Library"

Was it the UN/PWD I gave it? it so How do I find the file to change it back? if not ... What the heck (LOL)? I thought it would be a piece of cake out the box. seemed straight forward. Somebody help a brother out, I'll buy you coffee

[Dwaine Maggart]

Couple things:

1. The Resolve systems need to be on the same IP subnet as the system running Project Server.

2. On the Project Server, select the File menu at the top, then Network Interface. If there is more than 1 network interface, you need to select the one with the same subnet as the Resolve systems are on.

3. If all that looks OK, verify you can ping the Project Server computer from the Resolve computer, and visa versa.

4. If you can ping in both directions, if there are firewalls on either end, temporarily disable them, and see if that's causing the issue.

Is this the first time you are using Project Server?

On the Project Server app, you need to select the Project Library you want to share with the Resolve systems, select the Info icon on the right end, and make sure the Project Library Enabled slider is to the right, and red. Once you have that, select the gear icon, and select Export Access Key. Then drag that access key file into the Resolve system Network Project Manager area, to allow the Resolve system to connect to that project library on the Project Server.

Hi Dwaine,

Most of the things you describe I have done while i was waiting for a response. After reading the thread, I saw that the database is hard coded and must use the username & pwd it was intended. Which ... is not posted in the install guide. never-the-less, it's all good. I just need to know How I can set it back to default? The username & pwd was provided on the install 1st login but DRPS19, the tool bar is quite different as 17.

[Dwaine Maggart]

Yes, the Project Server interface changed substantially from 17 to 18. No major change from 18 to 19.

Unfortunately, the manual packaged with the installer is still the 17 manual, which is less than helpful.

However, the proper Project Server 18/19 setup guidance is in the Resolve reference manual.

For the Resolve 19 reference manual, that would start on page 3997: Using the DaVinci Resolve
Project Server Application

If you still have specific questions after giving that a read, let us know.

Hi,
I'm solving the same problem.
You mentioned that server and "client" should be on the same network - and it looks it is our problem.
From LAN, connection to server project is established without problem. Because clients PC and server are on the same subnet. (10.20.30.xx)
But we need establish connection from VPN. VPN subnet is different. (10.20.246.xxx)
How solve connection to project server from VPN/another subnet please?

Many thanks!!!

Tacud

[Dwaine Maggart]

Project Server app is just not designed to do that.

If you have to support systems on different subnets, you'll need to do it without the Project Server app and manually configure PostgreSQL as needed.

Hi, thanks.
I tried add IP addresses from VPN subnet to pg_hba.conf and after restart of Project server it works!

[Dwaine Maggart]

Just be aware that if you add any project libraries or enable or disable any project libraries using the Project Server app, it will re-write the pg_hba.conf file and eliminate any mods you've done to it.

I can successfully connect to the Project Server either on a 10.x.x.x. subnet on wifi network or using ethernet that is cable-connected between the two machines on a different subnet 192.168.x.x

But after launching a project I get a dialgoue telling me
"Cannot Enable Collaboration. Please ensure that the machines are not connected via VPN and that DaVinci Resolve is not being blocked by the system firewall.

Even if I turn off all firewalls, I get the same message.
I am not aware of any VPN on the networks.
Is there any documentation or guide to this aspect available?
I'm an editor but not much of an IT guru so struggling with this on tight deadline.

[Dwaine Maggart]

By not having all the systems on the same subnet, you are beyond our ability to support.

I do provide some guidance on troubleshooting this specific issue in this thread:

viewtopic.php?f=21&t=131547&hilit=%2BTest%2BNetConnection#p713013