PostgreSQL 9.5.4-1 install fail

Get answers to your questions about color grading, editing and finishing with DaVinci Resolve.
  • Author
  • Message
Offline
User avatar

Igor Riđanović

  • Posts: 1596
  • Joined: Thu Jul 02, 2015 5:11 am
  • Location: Los Angeles, Calif.

PostgreSQL 9.5.4-1 install fail

PostWed Apr 11, 2018 12:30 am

The PostgreSQL 9.5.4-1 bundled with Resolve 14.3 and 15 Beta 1 Windows versions fails to install when the security policy for passwords is strict.

We have a domain wide security policy mandated by the studios where passwords are required to have certain length and structure. The installer supplies "DaVinci" as the password argument for the newly created "postgres" user to the postgresql-9.5.4-1-windows_x64.exe installer :

Code: Select all
--servicepassword DaVinci


But "DaVinci" does not meet the minimal requirements and Windows 10 aborts creation of the "postgres" user. You can refer to the excerpt from the ResolveInstallLog.txt below.

We can not alter the domain password policy. The workaround is to temporarily disconnect from the domain, install Resolve, and join the domain again.

However, it would be easier if the default password were more complex, or if there was a way for end users to edit the installation script that contains the password string.

2018-04-10 11:40:42 -- Executable: C:\Users\editor\AppData\Local\Temp\{DD43BA6D-EC6C-4F90-8348-D57FE5ED9267}\postgresql-9.5.4-1-windows_x64.exe
2018-04-10 11:40:42 -- Additional command-line parameters: --mode unattended --unattendedmodeui minimal --servicepassword DaVinci --superpassword DaVinci --superaccount postgres --serviceaccount postgres --debuglevel 4 --locale "English, United States"
2018-04-10 11:40:42 Executing: C:\Users\editor\AppData\Local\Temp\{DD43BA6D-EC6C-4F90-8348-D57FE5ED9267}\postgresql-9.5.4-1-windows_x64.exe --mode unattended --unattendedmodeui minimal --servicepassword DaVinci --superpassword DaVinci --superaccount postgres --serviceaccount postgres --debuglevel 4 --locale "English, United States"
2018-04-10 11:41:08 --- Component 'postgresql-9.5.4-1-windows_x64.exe (PostgreSQL 9.5.4-1): DIALOG CLOSED
2018-04-10 11:41:08 Component 'postgresql-9.5.4-1-windows_x64.exe' return code 1 (0x1).
2018-04-10 11:41:08 *** Component 'postgresql-9.5.4-1-windows_x64.exe' (PostgreSQL 9.5.4-1): ERROR - Error executing 'postgresql-9.5.4-1-windows_x64.exe' (PostgreSQL 9.5.4-1): 1 (0x1)
2018-04-10 11:41:08 --- Component 'postgresql-9.5.4-1-windows_x64.exe (PostgreSQL 9.5.4-1)' FAILED: Error executing 'postgresql-9.5.4-1-windows_x64.exe' (PostgreSQL 9.5.4-1): 1 (0x1)
2018-04-10 11:42:15 --- Component 'postgresql-9.5.4-1-windows_x64.exe (PostgreSQL 9.5.4-1): FAILED, ABORTING
2018-04-10 11:42:15 *** Failed to install one or more components, reloading components (reload_on_error).
www.metafide.com - DaVinci Resolve™ Apps
Offline

DakotaHoosier

  • Posts: 1
  • Joined: Mon Jun 18, 2018 2:21 pm
  • Real Name: Tim Sherrill

Re: PostgreSQL 9.5.4-1 install fail

PostMon Jun 18, 2018 5:24 pm

Did you get this fixed for your install? I'm having the same problem and looking for the next step.
Offline

Darryl

  • Posts: 136
  • Joined: Sat May 05, 2018 12:07 am
  • Real Name: Darryl Severn

Re: PostgreSQL 9.5.4-1 install fail

PostSat Jul 07, 2018 3:27 am

I think this is a bug somewhere in the install process, either BMD or Windows. I have the same issue, and I got around it by installing PostgreSQL independently of Resolve, with the same user ID and password. No issues at all with the install even in a domain with complexity requirements on the password. but a bit of work in the Project Manager in Resolve to switch over from local database to the PostgreSQL db. Early days, but I have installed v10 of PostgreSQL and can't see any issues with that.
Darryl Severn
The Videoverse by Darbeth
Livestreaming, Conferences, Info & Education, Events

Kit:
BMPCC 4K, Studio Cam 4K Pro, ATEM Mini Extreme ISO, Resolve Studio
DJI Inspire 2, Panasonic HCPV100,
Behringer XR16, Sennheiser XSW
Offline

Peter Chamberlain

Blackmagic Design

  • Posts: 13875
  • Joined: Wed Aug 22, 2012 7:08 am

Re: PostgreSQL 9.5.4-1 install fail

PostThu Jul 12, 2018 6:11 am

Darryl, interesting that you have v10 working. Please note its not currently tested or formally supported as yet so id be keen to hear of issues when you have them.
DaVinci Resolve Product Manager
Offline

stephan.hassenpflug

  • Posts: 1
  • Joined: Tue Nov 10, 2020 10:32 am
  • Real Name: Stephan Hassenpflug

Re: PostgreSQL 9.5.4-1 install fail

PostTue Nov 10, 2020 10:34 am

Hi Together,

this issue still exist. I tried with version 17 and 16.
I also unplugged my laptop from the internet...
Still same error message.

Rgds
Stephan
Offline

Phil86

  • Posts: 1
  • Joined: Sat Feb 06, 2021 12:00 am
  • Real Name: Philip McGeehan

Re: PostgreSQL 9.5.4-1 install fail

PostSat Feb 06, 2021 12:12 am

I've just installed it and had this issue (followed by another issue, but that's a different post).

You don't need to disconnect from the internet - you need to remove your machine from the domain (in my case I was using a laptop from work) and log into it as a local admin, then do the install, then you can re-join the domain again.

I've read since, you can just install Postgre from their site before you install DaVinci, but didn't try that.
Offline

Danfree

  • Posts: 1
  • Joined: Thu Jan 21, 2021 3:38 am
  • Real Name: Dan Freeberg

Re: PostgreSQL 9.5.4-1 install fail

PostMon Feb 08, 2021 2:26 am

Stephan -

I am experiencing the same problem. I contacted Da Vinci support and they said to talk to people on the forum.

This sucks.
Offline
User avatar

SavvyMatthew

  • Posts: 7
  • Joined: Sun Jul 18, 2021 2:47 am
  • Location: Orlando, FL
  • Real Name: Matthew

Re: PostgreSQL 9.5.4-1 install fail

PostSun Jul 18, 2021 2:53 am

So I had the same issue, there is a group policy that needs to be disabled temporarily to allow the install see the attached picture below. Make sure to turn it back on after install. ( Note once you click apply and ok its applied)

BMCC-Password Complexity.png
Screenshot of GPO for Install.
BMCC-Password Complexity.png (72.96 KiB) Viewed 1403 times
- Matthew Clark
nuinteractive.com

Return to DaVinci Resolve

Who is online

Users browsing this forum: Bing [Bot], gebarnett, panos_mts, peeceful, Shrinivas Ramani, Tom Stites and 194 guests